7 Replies Latest reply: Aug 2, 2012 12:29 PM by Wsiebel-Oracle RSS

    Issues with listener

    947953
      I'm currently installing Siebel, configuring a "New Enterprise in a Gateway Name Server" through the wizard. When I get to the part where I have to provide the name for the SQLNet connect string for Oracle, I first go into Oarcle ODBC Driver Configuration, choose "Test Connection" and get the following message: "Unable to connect. SQLSTATE=S1000. [Oracle][ODBC][Ora]ORA-12541: TNS: no listener". When I try the console with "lsnrctl status", I get a message saying "Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service". Does anyone know what's wrong/missing?

      Thanks!!
        • 1. Re: Issues with listener
          Wsiebel-Oracle
          Provide the following:

          1. Server Name in ODBC Oracle Driver Configuration
          2. Contents of listener.ora file in console
          3. Contents of tnsnames.ora file in console and/or siebel server machine
          4. output of command tnsping <sqlnet connect string>
          5. full output of lsnrctl status command

          Thanks,

          Wilson
          • 2. Re: Issues with listener
            947953
            1. Server Name in ODBC Oracle Driver Configuration
            SBA_81_DSN

            2. Contents of listener.ora file in console
            # listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
            # Generated by Oracle configuration tools.

            SID_LIST_LISTENER =
            (SID_LIST =
            (SID_DESC =
            (SID_NAME = PLSExtProc)
            (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
            (PROGRAM = extproc)
            )
            )

            LISTENER =
            (DESCRIPTION_LIST =
            (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP)(HOST = siebelwin2k3)(PORT = 2115))
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
            )
            )

            3. Contents of tnsnames.ora file in console and/or siebel server machine
            # tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
            # Generated by Oracle configuration tools.

            SIEBELDB244 =
            (DESCRIPTION =
            (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.10.244)(PORT = 1521))
            )
            (CONNECT_DATA =
            (SERVICE_NAME = SIEBELDB244)
            )
            )

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


            4. output of command tnsping <sqlnet connect string>

            C:\Documents and Settings\siebeladmin>tnsping SIEBELDB244

            TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 01-AUG-2
            012 15:48:16

            Copyright (c) 1997, 2006, Oracle. All rights reserved.

            Used parameter files:
            C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora

            TNS-03505: Failed to resolve name

            C:\Documents and Settings\siebeladmin>lsnrctl status

            LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 01-AUG-2012 16:19
            :14

            Copyright (c) 1991, 2006, Oracle. All rights reserved.

            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=siebelwin2k3)(PORT=2115)
            ))
            STATUS of the LISTENER
            ------------------------
            Alias LISTENER
            Version TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Produ
            ction
            Start Date 01-AUG-2012 13:54:01
            Uptime 0 days 2 hr. 25 min. 16 sec
            Trace Level off
            Security ON: Local OS Authentication
            SNMP OFF
            Listener Parameter File C:\oracle\product\10.2.0\db_1\network\admin\listener.o
            ra
            Listener Log File C:\oracle\product\10.2.0\db_1\network\log\listener.log

            Listening Endpoints Summary...
            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=siebelwin2k3)(PORT=2115)))
            (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
            Services Summary...
            Service "PLSExtProc" has 1 instance(s).
            Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
            The command completed successfully


            5. full output of lsnrctl status command

            C:\Documents and Settings\siebeladmin>lsnrctl status

            LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 01-AUG-2012 19:01
            :45

            Copyright (c) 1991, 2006, Oracle. All rights reserved.

            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=siebelwin2k3)(PORT=2115)
            ))
            STATUS of the LISTENER
            ------------------------
            Alias LISTENER
            Version TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Produ
            ction
            Start Date 01-AUG-2012 13:54:01
            Uptime 0 days 5 hr. 7 min. 47 sec
            Trace Level off
            Security ON: Local OS Authentication
            SNMP OFF
            Listener Parameter File C:\oracle\product\10.2.0\db_1\network\admin\listener.o
            ra
            Listener Log File C:\oracle\product\10.2.0\db_1\network\log\listener.log

            Listening Endpoints Summary...
            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=siebelwin2k3)(PORT=2115)))
            (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
            Services Summary...
            Service "PLSExtProc" has 1 instance(s).
            Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
            The command completed successfully

            C:\Documents and Settings\siebeladmin>

            Thanks!
            • 3. Re: Issues with listener
              Wsiebel-Oracle
              1. SBA_81_DSN seems to be the odbc name. Server name should be SIEBELDB244 based on your tnsnames.ora file.

              Per listener.ora file listener is listening in port 2115, you must use the same port number in tnsnames.ora file. Check if you are able to connect after updating tnsnames.ora file.

              I also assume that 10.0.10.244 is IP address for DB server siebelwin2k3. Make sure you can ping this IP from Siebel Server machine.

              Thanks,

              Wilson
              • 4. Re: Issues with listener
                947953
                Wilson,

                I updated the port to 1521 on loth listener.ora and tnsnames.ora, but I keep getting the same error as before. Besides, this is what I see when I try to check the listener status through the console:

                C:\Documents and Settings\siebeladmin>lsnrctl status

                LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 01-AUG-2012 19:51
                :24

                Copyright (c) 1991, 2006, Oracle. All rights reserved.

                Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=siebelwin2k3)(PORT=1521)
                ))
                TNS-12541: TNS:no listener
                TNS-12560: TNS:protocol adapter error
                TNS-00511: No listener
                32-bit Windows Error: 61: Unknown error
                Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
                STATUS of the LISTENER
                ------------------------
                Alias LISTENER
                Version TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Produ
                ction
                Start Date 01-AUG-2012 13:54:01
                Uptime 0 days 5 hr. 57 min. 26 sec
                Trace Level off
                Security ON: Local OS Authentication
                SNMP OFF
                Listener Parameter File C:\oracle\product\10.2.0\db_1\network\admin\listener.o
                ra
                Listener Log File C:\oracle\product\10.2.0\db_1\network\log\listener.log

                Listening Endpoints Summary...
                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=siebelwin2k3)(PORT=2115)))
                (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
                Services Summary...
                Service "PLSExtProc" has 1 instance(s).
                Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
                The command completed successfully


                And if I update the port to 2115 on both files I get this error: Unable to connect. SQLState=S1000. ORA 12514: TNS: Listener does not currently know of service requested in connect descriptor.

                If I check the status through the console, this is what I get:
                Microsoft Windows [Version 5.2.3790]
                (C) Copyright 1985-2003 Microsoft Corp.

                C:\Documents and Settings\siebeladmin>lsnrctl status

                LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 01-AUG-2012 19:56
                :19

                Copyright (c) 1991, 2006, Oracle. All rights reserved.

                Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=siebelwin2k3)(PORT=2115)
                ))
                STATUS of the LISTENER
                ------------------------
                Alias LISTENER
                Version TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Produ
                ction
                Start Date 01-AUG-2012 13:54:01
                Uptime 0 days 6 hr. 2 min. 21 sec
                Trace Level off
                Security ON: Local OS Authentication
                SNMP OFF
                Listener Parameter File C:\oracle\product\10.2.0\db_1\network\admin\listener.o
                ra
                Listener Log File C:\oracle\product\10.2.0\db_1\network\log\listener.log

                Listening Endpoints Summary...
                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=siebelwin2k3)(PORT=2115)))
                (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
                Services Summary...
                Service "PLSExtProc" has 1 instance(s).
                Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
                The command completed successfully

                Thanks!
                • 5. Re: Issues with listener
                  Wsiebel-Oracle
                  Ok, I have missed the listener.ora file, it is missing information about SIEBELDB244 instance. Add or Reconfigure the listener using Net Configuration Assistant under Start > Programs > Oracle - OraDb10g_home1> Configuration and Migration Tools.
                  • 6. Re: Issues with listener
                    947953
                    Hi Wilson,

                    I'm not sure what's wrong but I keep getting the same error. Below I'm listing what I see in the console and in tnsnames.ora and listener.ora files. If I test connection through the ODBC it says: no listener.

                    Thanks!

                    C:\Documents and Settings\siebeladmin>lsnrctl status

                    LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 02-AUG-2012 14:13
                    :04

                    Copyright (c) 1991, 2006, Oracle. All rights reserved.

                    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.10.244)(PORT=1521))
                    )
                    TNS-12541: TNS:no listener
                    TNS-12560: TNS:protocol adapter error
                    TNS-00511: No listener
                    32-bit Windows Error: 61: Unknown error
                    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
                    STATUS of the LISTENER
                    ------------------------
                    Alias LISTENER
                    Version TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Produ
                    ction
                    Start Date 01-AUG-2012 13:54:01
                    Uptime 1 days 0 hr. 19 min. 6 sec
                    Trace Level off
                    Security ON: Local OS Authentication
                    SNMP OFF
                    Listener Parameter File C:\oracle\product\10.2.0\db_1\network\admin\listener.o
                    ra
                    Listener Log File C:\oracle\product\10.2.0\db_1\network\log\listener.log

                    Listening Endpoints Summary...
                    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=siebelwin2k3)(PORT=2115)))
                    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
                    Services Summary...
                    Service "PLSExtProc" has 1 instance(s).
                    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
                    The command completed successfully

                    C:\Documents and Settings\siebeladmin>ping siebelwin2k3

                    Pinging siebelwin2k3 [10.0.10.244] with 32 bytes of data:

                    Reply from 10.0.10.244: bytes=32 time<1ms TTL=128
                    Reply from 10.0.10.244: bytes=32 time<1ms TTL=128
                    Reply from 10.0.10.244: bytes=32 time<1ms TTL=128
                    Reply from 10.0.10.244: bytes=32 time<1ms TTL=128

                    Ping statistics for 10.0.10.244:
                    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
                    Approximate round trip times in milli-seconds:
                    Minimum = 0ms, Maximum = 0ms, Average = 0ms

                    C:\Documents and Settings\siebeladmin>


                    LISTENER.ORA

                    # listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
                    # Generated by Oracle configuration tools.

                    SID_LIST_LISTENER =
                    (SID_LIST =
                    (SID_DESC =
                    (SID_NAME = PLSExtProc)
                    (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
                    (PROGRAM = extproc)
                    )
                    )

                    SIEBELDB244 =
                    (DESCRIPTION_LIST =
                    (DESCRIPTION =
                    (ADDRESS = (PROTOCOL = TCP)(HOST = siebelwin2k3)(PORT = 2115))
                    )
                    )

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


                    TNSNAMES.ORA
                    # tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
                    # Generated by Oracle configuration tools.

                    SIEBELDB244 =
                    (DESCRIPTION =
                    (ADDRESS_LIST =
                    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.10.244)(PORT = 1521))
                    )
                    (CONNECT_DATA =
                    (SERVICE_NAME = SIEBELDB244)
                    )
                    )

                    EXTPROC_CONNECTION_DATA =
                    (DESCRIPTION =
                    (ADDRESS_LIST =
                    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
                    )
                    (CONNECT_DATA =
                    (SID = PLSExtProc)
                    (PRESENTATION = RO)
                    )
                    )
                    • 7. Re: Issues with listener
                      Wsiebel-Oracle
                      Check if article below is helpful:

                      http://www.dba-oracle.com/t_windows_tns_no_listener_error.htm

                      Also try to use port 2115 in tnsnames.ora file.

                      Thanks,

                      Wilson