Oracle 10g Listener Set up on windows

I have installed Oracle Database on windows NT, But i am not able to bring the listener up
 there is  a 9i database with its listener. so i got this 9i listener down and cleared the registry
and rebooted the windows server. So there is no 9i listener now on the server

weird thing is  when i am trying to bring the 10g listener up the previous 9i logs are getting updated.
I have set the ORACLE_SID  and ORACLE_HOME and PATH so that they reflect new 10g parameters

Here are the listener.ora and tnsnames file

******************************************Listener File**************************************
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = E:\oracle\ora10g2)
      (PROGRAM = extproc)
      (ADDRESS = (PROTOCOL = TCP)(HOST = *******)(PORT = 1521)(IP = FIRST))
      (ADDRESS = (PROTOCOL = TCP)(HOST = ********(PORT = 1521)(IP = FIRST))

  (ADDRESS = (PROTOCOL = TCP)(HOST = *********)(PORT = 1521))
****** =
    (ADDRESS = (PROTOCOL = TCP)(HOST =********)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST =********)(PORT = 1521))
       (CONNECT_DATA =
      (SERVICE_NAME = ****)

Here are  the steps i am following to get the 10g listener up on command prompt

set ORACLE_SID=****  (new 10g sid)
set ORACLE_HOME=****(new 10g home)
PATH=%ORACLE_HOME%\bin;%PATH%  (new 10ghome\bin)
set TNS_ADMIN=%ORACLE_HOME%\network\admin  (10g network admin)

lsnrctl start LISTENER

LSNRCTL for 32-bit windows: version - Production on 09-NOV-2008 19:00:23

Copy right (c) 1991, 2005, Oracle. All rights reserved

starting  tnslsnr: please wait ....

TNS-12560: TNS: protool adapter error

-- so this is the error i am getting "TNS-12560: TNS:protool adapter error"

when i look at SQL NET log i see the following error

Fatal NI connect error 12541, connecting to:
 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=********)(Port=1521))(CONNECT_DATA=(SID=******)(CID=(PROGRAM=oracle10 _home\perl\5.8.3\bin\MSWin32-x86-multi-thread\perl.exe)(HOST=*********)(USER=SYSTEM))))

 TNS for 32-bit Windows: Version - Production
 Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version - Production
  Time: 09-NOV-2008 19:25:54
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12541
    TNS-12541: TNS:no listener
    ns secondary err code: 12560
    nt main err code: 511
    TNS-00511: No listener
    nt secondary err code: 61
    nt OS err code: 0

Let me know what the solution can  be to bring the listener up


Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

You can create  a new listener by using Oracle "Net configuration assistance" just make sure 9i listener is not using default port (in order words) select different port#.

You can use 1 listener to connect to Oracle9i and Oracle10g database using 1521 default port number. There is no need to create additional listener. See Oracle documentation on Network Management.

Here is the link:

Good luck!

reddysrAuthor Commented:
Thanks for the note mohammadzahid,

I tried to configure a new listener using NETCA as you have suggested
again i specified the 10g env from command prompt and invoked NETCA from command prompt itself

the GUI tool  says that the net configuration is completed  but here is what it shows on the command prompt

Oracle Net Services Configuration:
Configuring Listener: LISTENER
default local naming configuration complete
listener configuration complete
Oracle net listener Startup:
    Running Listener control:lsnrctl start LISTENER
LISTENER not Started because another listener may aleady be up

But.. There is no listener up, I  have deleted the registry for the listener
and another wierd this is the NETCA is creating it new tnsnames and listener.ora files in the previous 9i

The logs are getting updated in


i still can understand why 9i  files systems are updated when i set the environment to 10g in the command prompt

is it because of the registry which is overriding my 10g settings for the envinronment?
let me know, thanks for the help

Did you run "Net configuration assistance" from 10g home or from 9i home. I am assuming you have 2 separate folders (1 for 9i and other for 10g installation)?

Try issuing commands for listener from the command line that will give you more detail on what is going on with the listener configuration.


2. LSNRCTL> help

3. LSNRCTL> status  
reddysrAuthor Commented:
The system level environment variables must be unset

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Networking

From novice to tech pro — start learning today.