| SQL developer detecting wrong TnsName file [message #306660] |
Sat, 15 March 2008 10:29  |
oraclewannabe
Messages: 25
Registered: January 2008 |
Junior Member |
|
|
Hi i used to run Oracle9i database,
Recently, i install an Oracle 10g database
Then due to some tidy up reason, i remoeve all my current db connections from my SQL developer and try to create new ones using my current 9i tnsnames.
However when ever i choose the tnsname option in SQL dveloper, i saw the list that belongs to 10g which contain nothing as i has setup nothing in the tnsname files of 10g yet.
So what can i do to let SQL developer detect my old tnsname in oracle9i network folder instead of the 10g one.
I have try to look at my system environment variable it is as shown as below
c:\DevSuiteHome_1\OUIHome2\bin;c:\DevSuiteHome_1\jdk\jre\bin\classic;c:\DevSuiteHome_1\jdk\jre\bin;c:\DevSuiteHome_1\jdk\jre\bin\clie nt;c:\DevSuiteHome_1\jlib;c:\DevSuiteHome_1\bin;c:\DevSuiteHome_1\jre\1.4.2\bin\client;c:\DevSuiteHome_1\jre\1.4.2\bin;C:\oracle\prod uct\10g\bin;c:\oracle\product\9.2\db\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\oracle\product\10.2.0\db_1\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\QuickTime\QTSystem\
All my oracle path are set to the bin folder, how does SQL developer detect my my new 10g tnsname file
through registry ?
Any gurus guide me pls ? i need to revert back to my 9i tns name file.
thanks
|
|
|
| Re: SQL developer detecting wrong TnsName file [message #306661 is a reply to message #306660 ] |
Sat, 15 March 2008 10:36  |
anacedent
Messages: 5027
Registered: July 2005
Location: surf meets turf in SoCal |
Senior Member |
|
|
|
You can simply COPY the tnsnames.ora file from the V9 directory on top of the V10 tnsnames.ora file.
|
|
|
| Re: SQL developer detecting wrong TnsName file [message #317909 is a reply to message #306660 ] |
Sun, 04 May 2008 20:16 |
TheSingerman
Messages: 16
Registered: April 2008
Location: Brighton, Michigan |
Junior Member |
|
|
(You said Registry, so I assume you are using some version of Windows):
Define an environment variable named TNS_ADMIN (cam be done in the registry or in some control panel wizard -- can't remember exactly where, and I'm not booting out of Linux just to find out).
Set that variable to be wherever you want your tnsnames.ora file to be. Make it a fully qualified directory name (start with C: or D: or whatever you use).
Then, all your Oracle clients will use this tnsnames.ora file: 9i, 10g, whatever. Once you are certain that it is working (always test) you can delete the surplus tnsnames.ora files.
|
|
|
]
Members
Search
Help
Register
Login
Home
