big problem with listener
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: big problem with listener

  1. #1
    Join Date
    Jul 2002
    Posts
    228

    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
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Use net8 utility to test the IMM1.
    and/or do connect user/pwd@IMM1
    Last edited by Tarry; 11-26-2002 at 10:11 AM.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  3. #3
    Join Date
    Jul 2002
    Posts
    228
    I tested IMM1 with net8 but I get same error ORA-12541 but if I stop and restart listener IMM1 run correctly with net8

    Regards
    Raf

  4. #4
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Can you post the details of your tnsnames file as well.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  5. #5
    Join Date
    Jul 2002
    Posts
    228
    tnsnames.ora:

    INST1_HTTP =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = srvimm)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = SHARED)
    (SERVICE_NAME = imm2)
    (PRESENTATION = http://admin)
    )
    )


    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

    IMM2 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = srvimm)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = imm2)
    )
    )

    IMM1 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = srvimm)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = imm1)
    )
    )

    Regards
    Raf

  6. #6
    Join Date
    Jul 2002
    Posts
    228
    sqlnet.ora

    Fatal NI connect error 12541, connecting to:
    (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=srvimm)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=imm1)(CID=( PROGRAM=C:\Programmi\Quest Software\TOAD\TOAD.exe)))

    VERSION INFORMATION:
    TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
    Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - Production
    Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - Production
    Time: 26-NOV-2002 09:25:24
    Tracing not turned on.
    Tns error struct:
    nr err code: 0
    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

  7. #7
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    Do you mean that you get TNS-12541 whenever you connect to IMM2? What is the status of the LISTENER after failure? What appear in $ORACLE_HOME\network\log\listener.log?
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

  8. #8
    Join Date
    Jul 2002
    Posts
    228
    listener.log

    Il file dei parametri di sistema C:\oracle\ora81\network\admin\listener.ora
    Messaggi di log registrati in C:\oracle\ora81\network\log\listener.log
    Informazioni di traccia registrate in C:\oracle\ora81\network\trace\listener.trc
    Il livello di traccia attuale 0

    Ascolto su: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srvimm)(PORT=1521)))
    Ascolto su: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
    TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
    26-NOV-2002 17:54:35 * service_register * imm2 * 0
    26-NOV-2002 17:54:35 * service_register * imm1 * 0
    26-NOV-2002 17:54:38 * (CONNECT_DATA=(SERVICE_NAME=imm2)(CID=(PROGRAM=C:\Programmi\ACAD2000\acad.exe)(HOST=A_ROB)(USER=afm1 ))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.50.97)(PORT=1582)) * establish * imm2 * 0
    26-NOV-2002 17:54:43 * (CONNECT_DATA=(SERVICE_NAME=imm2)(CID=(PROGRAM=C:\Programmi\ACAD2000\acad.exe)(HOST=A_ROB)(USER=afm1 ))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.50.97)(PORT=1584)) * establish * imm2 * 0
    26-NOV-2002 17:54:59 * (CONNECT_DATA=(SERVICE_NAME=imm1)(CID=(PROGRAM=C:\Programmi\ACAD2000\acad.exe)(HOST=A_ROB)(USER=afm1 ))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.50.97)(PORT=1588)) * establish * imm1 * 0

    TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Production on 26-NOV-2002 17:55:09

    (c) Copyright 1998 Oracle Corporation. All rights reserved.

    Il file dei parametri di sistema C:\oracle\ora81\network\admin\listener.ora
    Messaggi di log registrati in C:\oracle\ora81\network\log\listener.log
    Informazioni di traccia registrate in C:\oracle\ora81\network\trace\listener.trc
    Il livello di traccia attuale 0

    Ascolto su: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srvimm)(PORT=1521)))
    Ascolto su: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
    TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
    26-NOV-2002 17:55:17 * (CONNECT_DATA=(SERVICE_NAME=imm1)(CID=(PROGRAM=C:\Programmi\ACAD2000\acad.exe)(HOST=A_ROB)(USER=afm1 ))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.50.97)(PORT=1590)) * establish * imm1 * 0
    26-NOV-2002 17:55:21 * (CONNECT_DATA=(SERVICE_NAME=imm1)(CID=(PROGRAM=C:\Programmi\ACAD2000\acad.exe)(HOST=A_ROB)(USER=afm1 ))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.50.97)(PORT=1592)) * establish * imm1 * 0
    26-NOV-2002 17:56:09 * service_register * imm1 * 0
    26-NOV-2002 17:56:09 * service_register * imm2 * 0

    TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Production on 26-NOV-2002 17:57:58

    (c) Copyright 1998 Oracle Corporation. All rights reserved.

    Il file dei parametri di sistema C:\oracle\ora81\network\admin\listener.ora
    Messaggi di log registrati in C:\oracle\ora81\network\log\listener.log
    Informazioni di traccia registrate in C:\oracle\ora81\network\trace\listener.trc
    Il livello di traccia attuale 0

    Ascolto su: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srvimm)(PORT=1521)))
    Ascolto su: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
    TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
    26-NOV-2002 17:58:09 * (CONNECT_DATA=(SERVICE_NAME=imm2)(CID=(PROGRAM=C:\Programmi\ACAD2000\acad.exe)(HOST=A_ROB)(USER=afm1 ))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.50.97)(PORT=1601)) * establish * imm2 * 0
    26-NOV-2002 17:58:29 * (CONNECT_DATA=(SERVICE_NAME=imm1)(CID=(PROGRAM=C:\Programmi\ACAD2000\acad.exe)(HOST=A_ROB)(USER=afm1 ))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.50.97)(PORT=1603)) * establish * imm1 * 0
    26-NOV-2002 17:58:33 * (CONNECT_DATA=(SERVICE_NAME=imm1)(CID=(PROGRAM=C:\Programmi\ACAD2000\acad.exe)(HOST=A_ROB)(USER=afm1 ))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.50.97)(PORT=1605)) * establish * imm1 * 0
    26-NOV-2002 17:58:58 * service_register * imm2 * 0
    26-NOV-2002 17:58:58 * service_register * imm1 * 0
    26-NOV-2002 18:00:08 * (CONNECT_DATA=(SERVICE_NAME=imm2)(CID=(PROGRAM=C:\Programmi\Quest Software\TOAD\TOAD.exe)(HOST=A_MAXIM)(USER=afm1))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.51.13)(PORT=3994)) * establish * imm2 * 0
    26-NOV-2002 18:00:21 * (CONNECT_DATA=(SERVICE_NAME=imm2)(CID=(PROGRAM=C:\Programmi\Quest Software\TOAD\TOAD.exe)(HOST=A_MAXIM)(USER=afm1))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.51.13)(PORT=3996)) * establish * imm2 * 0
    26-NOV-2002 18:02:03 * (CONNECT_DATA=(SERVICE_NAME=imm2)(CID=(PROGRAM=C:\Programmi\Quest Software\TOAD\TOAD.exe)(HOST=A_MAXIM)(USER=afm1))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.51.13)(PORT=4000)) * establish * imm2 * 0
    26-NOV-2002 18:09:00 * service_update * imm2 * 0
    26-NOV-2002 18:09:01 * service_update * imm1 * 0
    27-NOV-2002 09:16:36 * (CONNECT_DATA=(SERVICE_NAME=imm2)(CID=(PROGRAM=C:\oracle\ora81\bin\SQLPLUSW.EXE)(HOST=SRVIMM)(USER=A dministrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.49.247)(PORT=1531)) * establish * imm2 * 0
    27-NOV-2002 09:22:41 * service_update * imm2 * 0
    27-NOV-2002 09:24:05 * (CONNECT_DATA=(SERVICE_NAME=imm2)(CID=(PROGRAM=C:\Programmi\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=A_DA N)(USER=afm1))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.50.66)(PORT=4417)) * establish * imm2 * 0
    27-NOV-2002 09:24:16 * (CONNECT_DATA=(SERVICE_NAME=imm2)(CID=(PROGRAM=C:\Programmi\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=A_DA N)(USER=afm1))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.50.66)(PORT=4419)) * establish * imm2 * 0
    27-NOV-2002 09:25:01 * (CONNECT_DATA=(SERVICE_NAME=imm2)(CID=(PROGRAM=C:\Programmi\Quest Software\SQL Navigator 3\sqlnav3.exe)(HOST=A_DAN)(USER=afm1))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.50.66)(PORT=4421)) * establish * imm2 * 0
    27-NOV-2002 09:32:43 * service_update * imm2 * 0



    Regards
    Raf

Posting Permissions

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



Click Here to Expand Forum to Full Width