Home » SQL & PL/SQL » Client Tools » SQL PLUS connect (ORACLE 10G)
SQL PLUS connect [message #277786] Wed, 31 October 2007 09:46 Go to next message
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
Michel Cadot
Messages: 65143
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.

Previous Topic: How to find out some informations ?
Next Topic: hostdef extension doesn't exist error
Goto Forum:

Current Time: Fri Aug 18 17:14:40 CDT 2017

Total time taken to generate the page: 0.30354 seconds