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
Messages: 1
Registered: January 2008
Junior Member
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 Go to previous message
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:

lsnrctl status
Previous Topic: Create a Batch File[merged topic]
Next Topic: oracle software
Goto Forum:

Current Time: Mon May 16 16:15:26 CDT 2022