Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    227

    Unanswered: big problem with listener

    hi,
    I've installed oracle 8.1.7 server with 2 istances
    IMM1
    IMM2
    IMM2 run correctly, but when I started IMM1 I get this error:
    ORA-12541:TNS:NO LISTENER

    If I stop and restart the listener IMM1 run correctly again, but when I change connect IMM1 run down again.

    I run this query:
    SELECT SID, SERIAL#, USERNAME, STATUS
    FROM V$SESSION

    when IMM1 is up the STATUS is INACTIVE

    listener.ora:

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = srvimm)(PORT = 1521))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = C:\oracle\ora81)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = imm1)
    (ORACLE_HOME = C:\oracle\ora81)
    (SID_NAME = imm1)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = imm2)
    (ORACLE_HOME = C:\oracle\ora81)
    (SID_NAME = imm2)
    )
    )

    The status of listener is:

    LSNRCTL> status
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=srvimm)( PORT=1521)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Produc
    tion
    Start Date 22-NOV-2002 12:43:58
    Uptime 0 days 2 hr. 55 min. 12 sec
    Trace Level off
    Security OFF
    SNMP OFF
    Listener Parameter File C:\oracle\ora81\network\admin\listener.ora
    Listener Log File C:\oracle\ora81\network\log\listener.log
    Services Summary...
    PLSExtProc has 1 service handler(s)
    imm1 has 1 service handler(s)
    imm1 has 2 service handler(s)
    imm2 has 1 service handler(s)
    imm2 has 3 service handler(s)
    The command completed successfully

    Someone could help me???

    Thanks
    Raf

  2. #2
    Join Date
    Sep 2002
    Location
    ITALY
    Posts
    53

    Re: big problem with listener

    Originally posted by raf
    hi,
    I've installed oracle 8.1.7 server with 2 istances
    IMM1
    IMM2
    IMM2 run correctly, but when I started IMM1 I get this error:
    ORA-12541:TNS:NO LISTENER

    If I stop and restart the listener IMM1 run correctly again, but when I change connect IMM1 run down again.
    Someone could help me???

    Thanks
    Raf
    To check for you issues we need to know how is configured you CLIENT (tnsnames), and the init files of the two instances.

    bye
    Franco Ceotto
    SIPTI srl
    OnSite Services
    9i OCP DBA, Performance Engineer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •