tns

Oracle - What TNS Names file am I using?

Sometimes I get Oracle connection problems because I can't figure out which tnsnames.ora file my database client is using. What's the best way to figure this out? ++happy for various platform solutions. ...

Oracle ORA-12154: TNS: Could not resolve service name Error?

I am a SQL Server user . I am on a project that is using oracle (which I rarely use) I need to create an ODBC connection so I can access the some data via MS Access I have a application on my machine called oraHome90. It seems to allow a configuration of something called a listener in a “net configuration utility”, I think that a “Loca...

Oracle TNS names not showing when adding new connection to sqldeveloper

Hello, I'm trying to connect to an oracle database with sqldeveloper. I've installed the .Net oracle drivers and placed the tnsnames.ora file at C:\Oracle\product\11.1.0\client_1\Network\Admin. I'm using the following format in tnsnames.ora. dev = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.XXX.XXX)(PORT = XXXX)...

Oracle ProC ORA-12547

I'm working on re-compiling some proC code that no one currently at my company has ever compiled. . . It's compiling OK, but when I copy it to the production server and run it I'm getting Oracle error ORA-12547 (TNS: lost contact) Any ideas? ...

tns not resolving correctly through webservice

Hi all, 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 connect identifier specified" error. However when I log onto the said server i am ...

What is a TNS:listener in the Context of Oracle?

Borderline ServerFault question, but figured I'd try here first since I've had luck with Oracle questions in the past. I'm trying to connect to an oracle database from PHP, and I'm getting the following error. ORA-12505: TNS:listener does not currently know of SID given in connect descriptor This is the error that PHP reports, and th...

Oracle: API for dealing with TNS file?

Is there an API that will read a TNS file and present it in some easy-to-use data structure? I would like to get a list of all my TNS entries. This works but is not particularly elegant! grep '^[a-zA-Z].*=' /etc/tnsnames.ora | sed 's/[ =].*//' ...

Connection Error:Oracle.DataAccess.Client.OracleException ORA-12170

This has taken many hours of mine. I have to get this .Net app to run on an XP system. Someone seems to have messed up some files so conn.Open() in the C# is causing this error: Connection Error:Oracle.DataAccess.Client.OracleException ORA-12170: TNS:Connect timeout occurred at Oracle.DataAccess.Client.OracleException.HandleErrorHe...

What is the difference between "ORA-12571: TNS packet writer failure" and "ORA-03135: connection lost contact"?

I am working in an environment where we get production issues from time to time related to Oracle connections. We use ODP.NET from ASP.NET applications, and we suspect the firewall closes connections that have been in the connection pool too long. Sometimes we get an "ORA-12571: TNS packet writer failure" error, and sometimes we get "O...

ODBC Oracle Connection error from MS Access

Hi Everyone- I currently support an MS Access database that has linked connections using the Microsoft ODBC Driver for Oracle. I can connect to the current linked tables without any issues, but we are required for security reasons to change the password on the account accessing the Server. I have changed the password successfully but...

Any solution for Oracle TNS inefficiencies (many roundtrips, latency) from a Java app?

I was looking at a very slow SQL query (originating from a Java app using Hibernate deployed in JBoss 5.1). This particular query returned about 10K records but still took 40s or more. I ended up sniffing the traffic with the database (wireshark has a dissector for TNS) and found something unexpected. When data was coming from the serve...