Oracle 10g Listener Set up on windows

Posted on 2008-11-09
Last Modified: 2013-12-19
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


Question by:reddysr
    LVL 11

    Expert Comment

    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!


    Author Comment

    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

    LVL 11

    Expert Comment

    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.

    1. C:> LSNRCTL

    2. LSNRCTL> help

    3. LSNRCTL> status  

    Accepted Solution

    The system level environment variables must be unset

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    We recently endured a series of broadcast storms that caused our ISP to shut us down for brief periods of time. After going through a multitude of tests, we determined that the issue was related to Intel NIC drivers on some new HP desktop computers …
    Are you one of those front-line IT Service Desk staff fielding calls, replying to emails, all-the-while working to resolve end-user technological nightmares? I am! That's why I have put together this brief overview of tools and techniques I use in o…
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now