SQL PLUS connect [message #277786] |
Wed, 31 October 2007 09:46 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
rgkarreman
Messages: 1 Registered: October 2007 Location: Hoofddorp, Netherlands
|
Junior Member |
|
|
I've installed Oracle 10g express on my computer. I'm able to start the listener and database, and also login into the database. However when I try to login with sqlplus or with pl/sql developer, I get the following message: ORA-12154 TNS: could not resolve the connect identifier specified.
I set the following msdos system variables: ORACLE_HOME=<directory name>, and ORACLE_SID=<sid>.
Also with the ORACLE HOME SELECTOR, when starting this up, I get the message: "unable to determing Oracle home information from the registry. Primary oracle home unchanged."
In the registry I set ORACLE_HOME and ORACLE_SID with the save values as the msdos system variables. I also set TNS_ADMIN to the directory as set in the ORACLE_HOME, but then with the following additions: NETWORK\ADMIN.
I would greatly appreciate any help in resolving this problem.
|
|
|
Re: SQL PLUS connect [message #277792 is a reply to message #277786] |
Wed, 31 October 2007 11:04 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68658 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
You don't need to use any connect identifier to connect to a local database.
Leave this field empty.
Regards
Michel
|
|
|