aspose file tools
The moose likes Oracle/OAS and the fly likes ORA-12154 Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Reply Bookmark "ORA-12154" Watch "ORA-12154" New topic
Author

ORA-12154

Skip Cole
Ranch Hand

Joined: Jan 05, 2001
Posts: 163
A very strange issue.
I had the Oracle 8.17 client on this machine, and I put Oracle 9i (the best and final database) on it as well.
Now I can't connect to the local 9i databases I have created! I keep getting ORA-12154: TNS:could not resolve service name
I can connect to one of the databases thru sqlplus.exe (ran at a command line), but I can't connect using sqlplusw.exe (the SQLPlus window that we all know and love).
I've tinkered and tinkered, but can't get this to work. Any ideas?
Skip


If you love me, you will visit docs.opensimplatform.org
(FYI, Getting it tattooed on is a bit much.)
Nigel Browne
Ranch Hand

Joined: May 15, 2001
Posts: 673
Please post your tnsnames.ora and your listener.ora files. It is in these files that the problem exists.
 
 
subject: ORA-12154
 
Threads others viewed
ORA-12154: TNS:could not resolve the connect identifier specified
ORA-12154
Oracle Client for OCI Driver type
Oracle driver expeption
Forms&Reports 6i for WindowsNT refused connection to Personal Oracle 8i for Win2000
IntelliJ Java IDE