Home » Infrastructure » Windows » Oracle9.2.0.1 Error (Oracle9.2.0.1, Win XP)
Oracle9.2.0.1 Error [message #291663] Sat, 05 January 2008 14:55 Go to next message
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.
  • Attachment: oracle9.2.txt
    (Size: 1.79KB, Downloaded 1513 times)
Re: Oracle9.2.0.1 Error [message #291665 is a reply to message #291663] Sat, 05 January 2008 15:02 Go to previous message
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
Previous Topic: Create a Batch File[merged topic]
Next Topic: oracle software
Goto Forum:
  


Current Time: Fri Mar 29 01:49:08 CDT 2024