| Oracle9.2.0.1 Error [message #291663] |
Sat, 05 January 2008 14:55  |
palla_sridhar
Messages: 1
Registered: January 2008
|
Junior Member |
|
|
Hi!
I'm new to this forum and this is my first Q ..
I installed Oracle9.2 on WinXP.
I started Listener and DB services in Windows Services.
Their status is STARTED.
But when i start Listener manually, i get the following errors.
-------------------
LSNRCTL> start listener
Starting tnslsnr: please wait...
Service OracleOraHome92TNSListener already running.
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 1056: Unknown error
----------------------------
I get TNS - 12560 error when i try to login using scott/tiger in SQLPlus.
I searched the forums and internet and couldn't find any solution..
Can anyone help me with this error or anyone guide me to a clean installation on XP for Oracle9.2..
I've Java1.5, Eclipse 3.3, Tomcat 6.0 also installed.
I'm attaching the listener.ora, tnsnames.ora, sqlnet.ora files in 1 file.
Thanks in advance.
|
|
|
|
| Re: Oracle9.2.0.1 Error [message #291665 is a reply to message #291663] |
Sat, 05 January 2008 15:02  |
 |
ebrian
Messages: 2794
Registered: April 2006
|
Senior Member |
|
|
Are you trying to start the listener AFTER you have started it through Windows services?
What is the output of the following:
echo %ORACLE_SID%
echo %ORACLE_HOME%
lsnrctl status
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
