tnsnames

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. ...

What options are available for connecting to a Microsoft SQL Server database from an Oracle database?

At the moment I pull data from remote MS SQL Server databases using custom-built JDBC connectors. This works fine but doesn't feel like the way to do it. I feel I should be able to put a JDBC connection string into tnsnames on the server and have it "just work". I've looked around a little for this functionality but it doesn't seem to b...

What exactly is the deal with oracle connection identifiers separated by a period

I've been wondering this for a while but since it hasn't come up much I've left it in the 'mysterious wizardy' column. It seems to me that there is some sort of relationship between a connection identifier like ABC and ABC.DEFG and I don't quite get what it is. For example, a machine I was setting up just now I was having problems with...

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)...

Hinky Oracle Connection (TNSNAMES.ora Help)

We recently changed physical DB's, new servers, new locations, same database schema and data and since the change over, whenever we try to connect directly to the DB in our own desktop type applications about half of the time we get this error: SQL*Loader-704: Internal error: ulconnect: OCIServerAttach[0] ORA-12545: Connect failed becau...

My oracle listner to shuts itself down, what could be happening?

I am setting up a VM to try to duplicate our production environment so I can do deployment tests. The VM is VMWare Server running Windows Server 2003 with Oracle 10g. I am connecting to oracle through a tnsnames connection identifier. I got it up and running once, copied the VM files and thought everything was peachy. But now am enco...

Parsing tnsnames.ora in Visual C# 2008

Hi all, How I parse tnsnames.ora file using Visual C# (Visual Studio 2008 Express edition) to get the tnsnames ? For instance, my tnsnames.ora file contains ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = shaman)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) BILL = ...

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

Hi 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= (description= (address= (protocol=tcp) (host=myhost2.mydoma...

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 ...

Commandline to modify tnsnames.ora

Is there a command line utility to modify the tnsnames.ora file for the oracle client? [EDIT] I'm looking for something similar to odbcconf.exe (for editing ODBC connection on windows) to modify the tnsnames.ora file. [EDIT2] I'm using MSBUILD from my automated build script. The MSBuild Community Tasks Project has an AddTnsName task t...

Use tnsnames.ora in Oracle SQL Developer

I am evaluating Oracle SQL Developer. My tnsnames.ora is populated, and a tnsping to a connection defined in tnsnames.ora works fine. Still, SQL Developer does not display any connections. Oracle SQL Developer Soars mentions, that if you have Oracle client software and a tnsnames.ora file already installed on your machine, Oracle S...

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...

ORA-12154: TNS:could not resolve the connect identifier specified

I am trying to connect to oracle 11g installed on Linux EL 5 and and getting the following error SQL> connect sys/password@ud06 as sysdba ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor my listener.ora under network/admin is as follows LISTENER= (DESCRIPTION= (ADDRESS_LIST= ...

How to specify Java Option (System Property) for embedded Tomcat while running Grails App?

Specifically, I want to have my grails app under development to connect to an Oracle db defined by an tnsnames.ora file. I have the tnsnames.ora file located in c:\drivers\Network\ on my PC. When I run the grails app via "grails run-war", the db connection string defined in the tnsnames.ora file doesn't seem to be picked up: grails p...

How to resolve "TNS-12520 TNS:listener could not find available handler for requested type"?

I have brand new MacBook Pro (Mac OS 10.6.3) and installed Oracle's SQLDeveloper. After doing so, I set the connection and was connecting just fine. But after an hour or so I got "TNS-12520 TNS:listener could not find available handler for requested type". I wonder how can I fix it? ...

How to use Data Pump (expdp and impdp) commands from Oracle without tnsnames.ora file

I want to be able to run expdp and impdp onto a machine by directly specifying the connection parameters instead of a tns name that resides in tnsnames.ora. Is this possible? ...

ODAC & C# - TNS: Connect timeout occurred - Connecting only through VS2005 debugger.

I am new to Oracle, and there is an issue I am facing. When I run the application from IDE - Visual Studio 2005, The database connection is established smoothly, but when I run an installed version of the app, the DB connection fails and I get a TNS: Connect timeout occurred error. I tried with SQLNET.ORA and similar solutions found onl...

Parsing tnsnames.ora using regex...

I am attempting to pull some information from my tnsnames file using regex. I started with the following pattern: MYSCHEMA *? = *?[\W\w\S\s]*\(HOST *?= *?(?<host>\w+\s?)\)\s?\(PORT *?= *?(?<port>\d+)\s?\)[\W\w\S\s]*\(SERVICE_NAME *?= *?(?<servicename>\w+)\s?\) which worked fine when MYSCHEMA was the only schema in the file, but when t...

How to use tnsnames.ora in Grails DataSource?

I'm trying to connect to a load-balanced virtual host specified in tnsnames.ora in my Grails application in DataSource.groovy, with no luck - it (obviously) throws an "Unknown Host Specified" exception. The tnsnames entry looks like this someServiceName = (DESCRIPTION_LIST = (FAILOVER=ON) (LOAD_BALANCE=ON) (DESCRIPTION = ...