| unable to connect to database [message #576773] |
Thu, 07 February 2013 18:55  |
lg123
Messages: 225
Registered: August 2008
|
Senior Member |
|
|
Hi,
In one machine I have windows xp with Oracle 11.2.0.2 database installed and I am able to connect to the database using both sql developer and sql plus.
In another machine I have windows 7. I installed Oracle client 11.2.0.1, then using Net configuration tool, I installed both listener.ora and tnsnames.ora files.
Now, I want to connect to the database which is installed on windows xp from windows 7 using the oracle client. When I tried to connect, I got the following error :
ERROR:
ORA-12560: TNS:protocol adapter error
In order to rectify the above error, I was making sure that ORACLE_HOME AND ORACLE_SID were properly set in the regedit file (under HKEY_LOCAL_MACHINE > SOFTWARE > ORACLE). The ORACLE_HOME was set properly. But I found ORACLE_SID missing. So I added ORACLE_SID environment variable in the registry and re-tried connecting to the database. But I am not able to connect. What else should I do in order to connect?
|
|
|
|
|
|
|
|
| Re: unable to connect to database [message #576779 is a reply to message #576776] |
Thu, 07 February 2013 22:10  |
lg123
Messages: 225
Registered: August 2008
|
Senior Member |
|
|
Thanks. I deleted the listener.ora file as you said since I am trying to connect to the database via oracle client. I included the database name while connecting, like this :
C:>sqlplus sys/password@db as sysdba
and I was able to connect.
|
|
|
|
|
|
|
|
| Re: unable to connect to database [message #578637 is a reply to message #578633] |
Sat, 02 March 2013 11:50 |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:set ORACLE_HOME=C:\oraclexe\app\oracle\product\11.2.0\server\bin\ORACLE.EXE XE
ORACLE_HOME is a directory, it is the one you gave when you installed Oracle software.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
