Stack Overflow
Stack Overflow

Questions tagged [tnsnames]

The Oracle `tnsnames.ora` is a client site configuration file with database server connection details.

The Oracle tnsnames.ora is a client site configuration file with database server connection details. It contains the database name, server name, and connection protocol.

257 questions
0
votes
3 answers

tns not resolving correctly through webservice

I realise there are some similar questions on here already but I couldn't see one that matched my problem so I'm afraid I had to ask a new question. I have a webservice running on a server, which is throwing a ORA-12154: TNS:could not resolve the…
chillysapien
  • 2,256
  • 1
  • 26
  • 42
0
votes
2 answers

Unable to connect to Oracle db in EC2 Linux box from SQL Developer. TNS Listener error

I created an EC2 linux box with: Oracle Database 11.2.0.1 64-bit Standard Edition One (ami-31739c58). Instance is running fine. I can connect to box from my personal computer using ssh (terminal in Mac OS Lion) by typing: ssh -i predikto1.pem…
user1967231
  • 1
  • 1
0
votes
1 answer

parse tnsnames.ora using grep to extract hostname minus the domain

I have tnsnames.ora file like DB_CONNECTION1= (description= (address= (protocol=tcp) (host=myhost1.mydomain.com) (port=1234) ) (connect_data= (sid=ABCD) (sdu=4321) ) DB_CONNECTION2= …
Edwards
  • 181
  • 2
  • 7
0
votes
1 answer

Automatic tnsnames.ora cleanup

I've been working on a script to delete an environment including the Oracle db. I've got everything working except for automating the cleanup of tns entries. I was originally thinking it would be easy enough with regexp but since I've noticed…
user1401967
  • 51
  • 2
  • 4
0
votes
0 answers

Point to different TNSNAMES.ORA file that tnsping is using

I have two Oracle Client installed in my machine. One is Oracle 11g another one is ORACLE 8.1. I was trying to connect Business Objects to Oracle 8.1, but it fails as while connecting through TNS entries it is alwas hitting the Oracle 11G's TNS…
Subhamoy
  • 116
  • 5
  • 21
0
votes
1 answer

ora-12154 issue when connecting with instant-client

I am running Oracle 11g on Windows Server 2008R2. I have a client application(Zabbix) running elsewhere that is trying to connect to it. The client machine…
mvd
  • 2,596
  • 2
  • 33
  • 47
0
votes
1 answer

Connection error in java website. Tnsping shows that the service is running

I have a java website application running in windows 7 which uses oracle database for its functionalities. The database has default SID name orcl. When I use tnsping, I can see that the orcl service is active. Also most of the application is working…
user1439090
  • 792
  • 5
  • 12
  • 33
0
votes
1 answer

Connect to db through TOAD when LDAP.ora does not exist and tnsnames.ora does not have the tns entry

I was able to connect to TOAD using a db schema name that was not defined in my tnsnames.ora. I got the explanation here: TOAD connects despite the db name not being present in tnsnames.ora But now, I need to give the db connection credentials to a…
Victor
  • 16,609
  • 71
  • 229
  • 409
0
votes
1 answer

TOAD connects despite the db name not being present in tnsnames.ora

I went in TOAD and put in the TNS name for a db that was supplied to me by the DBA. I also put in the user and password and it connected fine. My confusion is that the tnsnames.ora file does not have any entry corresponding to that db name. So how…
Victor
  • 16,609
  • 71
  • 229
  • 409
0
votes
1 answer

Visual studio 2010 ODAC Oracle ORA-12154

I can connect to remote Oracle db using Oracle SQL Developer after tuning TNSNAMES.ora. I can also connect to remote Oracle db using export import vizard in SQL server. When do tnsping sourcename on command prompt, I get the correct response. This…
user219628
  • 3,755
  • 8
  • 35
  • 37
0
votes
1 answer

How to use different Service name in the Oracle JDBC long TNSNAME style URL with multiple servers

I have a problem when I try to connect DB server with JDBC long TNSNAME style URL. We have two Oracle cluster servers. And here is my TNSNAME style URL. jdbc:oracle:thin:@(DESCRIPTION= (LOAD_BALANCE=ON)(FAILOVER=ON)(ADDRESS_LIST= …
phyerbarte
  • 199
  • 3
  • 12
-1
votes
1 answer

How to format oracle connection string and output query to file

I am trying to connect to a oracle database, query it, and send results to a txt file. When I run my statement, this shows in the .txt file: In reality, it should be values from my sql script. Here is the string i am…
mali_the
  • 25
  • 1
  • 8
-1
votes
2 answers

How to write a regular expression to replace only the HOST name in the tnsnames.ora using powershell

(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ora))) I want to replace the HOST name with a new value using powershell, Thank you
mellifluous
  • 2,345
  • 2
  • 29
  • 45
-1
votes
2 answers

tnsnames.ora is way too hard to configure

I have a tnsnames.ora and PL/SQL Developer. I want to make PL/SQL Developer establish a connection based on tnsnames.ora. What I read was that it is expected that tnsnames.ora would be found in $ORACLE_HOME/(...) but I don't have any Oracle product…
Z.Szymon
  • 337
  • 1
  • 13
-1
votes
1 answer

Why I have to use tnsnames.ora in Oracle SQL Developer to connect some database

when I log on some oracle database, I can connect without tnsnames.ora. However, when I try to log on some other database, it reject because of TNS:connection timeout. What is changed? What does TNS file do? Why I have to have this ora file? Thank…
elifekiz
  • 1,456
  • 13
  • 26
1 2 3
…
17
18