| SQL PLUS connect [message #277786] |
Wed, 31 October 2007 09:46  |
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  |
 |
Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
