8 Replies Latest reply: Mar 15, 2010 8:17 AM by gv.chaitanya8 RSS

    Error: Listener is not up. Start the Listener and run EMCA

    741251
      Client cloned an environment from a cold backup (PSDEMO cold backup created, cloned to PSCFG). The PSCFG looks ok, we can connect ok, v$database looks correct but we keep getting the error CONFIG: ORA-12541: TNS:no listener oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12541: TNS:no listener.

      The client DBA says the tnsnames and the listener.ora look correct. He has done the EMCA but still gets the error. This should be an easy problem to resolve but he's having issues. Thanks in advance for the help.
        • 1. Re: Error: Listener is not up. Start the Listener and run EMCA
          sb92075
          post results from following commands run on DB server system as OS user oracle or who ever owns Oracle software

          lsnrctl start
          lsnrctl status
          lsnrctl service


          Post Operating System (OS) name & version for DB server system.
          Post results of
          SELECT * from v$version
          • 2. Re: Error: Listener is not up. Start the Listener and run EMCA
            741251
            OS - Windows 2008 R1

            C:\>lsnrctl status

            LSNRCTL for 64-bit Windows: Version 11.1.0.7.0 - Production on 11-MAR-2010 09:31
            :59

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

            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=204.235.166.110)(PORT=15
            21)))
            STATUS of the LISTENER
            ------------------------
            Alias LISTENER
            Version TNSLSNR for 64-bit Windows: Version 11.1.0.7.0 - Produ
            ction
            Start Date 09-MAR-2010 18:08:01
            Uptime 1 days 15 hr. 23 min. 59 sec
            Trace Level off
            Security ON: Local OS Authentication
            SNMP OFF
            Listener Parameter File C:\oracle\product\11.1.0\db_1\network\admin\listener.o
            ra
            Listener Log File c:\oracle\diag\tnslsnr\KUPSDB01\listener\alert\log.xml

            Listening Endpoints Summary...
            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=204.235.166.110)(PORT=1521)))
            (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
            Services Summary...
            Service "+ASM_XPT" has 1 instance(s).
            Instance "+asm", status READY, has 1 handler(s) for this service...
            Service "+asm" has 1 instance(s).
            Instance "+asm", status READY, has 1 handler(s) for this service...
            Service "CRMCFG" has 2 instance(s).
            Instance "CRMCFG", status UNKNOWN, has 1 handler(s) for this service...
            Instance "CRMCFG", status BLOCKED, has 1 handler(s) for this service...
            Service "CRMCFG_XPT" has 1 instance(s).
            Instance "CRMCFG", status BLOCKED, has 1 handler(s) for this service...
            Service "CRMDMOXDB" has 1 instance(s).
            Instance "crmdmo", status READY, has 1 handler(s) for this service...
            Service "CRMDMO_XPT" has 1 instance(s).
            Instance "crmdmo", status READY, has 1 handler(s) for this service...
            Service "CRMSYSXDB" has 1 instance(s).
            Instance "crmsys", status READY, has 1 handler(s) for this service...
            Service "CRMSYS_XPT" has 1 instance(s).
            Instance "crmsys", status READY, has 1 handler(s) for this service...
            Service "CSDMOXDB" has 1 instance(s).
            Instance "csdmo", status READY, has 1 handler(s) for this service...
            Service "CSDMO_XPT" has 1 instance(s).
            Instance "csdmo", status READY, has 1 handler(s) for this service...
            Service "CSSYSXDB" has 1 instance(s).
            Instance "cssys", status READY, has 1 handler(s) for this service...
            Service "CSSYS_XPT" has 1 instance(s).
            Instance "cssys", status READY, has 1 handler(s) for this service...
            Service "EPCFG" has 2 instance(s).
            Instance "EPCFG", status UNKNOWN, has 1 handler(s) for this service...
            Instance "EPCFG", status READY, has 1 handler(s) for this service...
            Service "EPCFG_XPT" has 1 instance(s).
            Instance "EPCFG", status READY, has 1 handler(s) for this service...
            Service "EPDMOXDB" has 1 instance(s).
            Instance "epdmo", status READY, has 1 handler(s) for this service...
            Service "EPDMO_XPT" has 1 instance(s).
            Instance "epdmo", status READY, has 1 handler(s) for this service...
            Service "EPSYSXDB" has 1 instance(s).
            Instance "epsys", status READY, has 1 handler(s) for this service...
            Service "EPSYS_XPT" has 1 instance(s).
            Instance "epsys", status READY, has 1 handler(s) for this service...
            Service "crmdmo" has 1 instance(s).
            Instance "crmdmo", status READY, has 1 handler(s) for this service...
            Service "crmsys" has 1 instance(s).
            Instance "crmsys", status READY, has 1 handler(s) for this service...
            Service "csdmo" has 1 instance(s).
            Instance "csdmo", status READY, has 1 handler(s) for this service...
            Service "cssys" has 1 instance(s).
            Instance "cssys", status READY, has 1 handler(s) for this service...
            Service "epdmo" has 1 instance(s).
            Instance "epdmo", status READY, has 1 handler(s) for this service...
            Service "epsys" has 1 instance(s).
            Instance "epsys", status READY, has 1 handler(s) for this service...
            Service "orcl" has 1 instance(s).
            Instance "orcl", status READY, has 1 handler(s) for this service...
            Service "orclXDB" has 1 instance(s).
            Instance "orcl", status READY, has 1 handler(s) for this service...
            Service "orcl_XPT" has 1 instance(s).
            Instance "orcl", status READY, has 1 handler(s) for this service...
            The command completed successfully

            C:\>

            C:\>lsnrctl status

            LSNRCTL for 64-bit Windows: Version 11.1.0.7.0 - Production on 11-MAR-2010 09:31
            :59

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

            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=204.235.166.110)(PORT=15
            21)))
            STATUS of the LISTENER
            ------------------------
            Alias LISTENER
            Version TNSLSNR for 64-bit Windows: Version 11.1.0.7.0 - Produ
            ction
            Start Date 09-MAR-2010 18:08:01
            Uptime 1 days 15 hr. 23 min. 59 sec
            Trace Level off
            Security ON: Local OS Authentication
            SNMP OFF
            Listener Parameter File C:\oracle\product\11.1.0\db_1\network\admin\listener.o
            ra
            Listener Log File c:\oracle\diag\tnslsnr\KUPSDB01\listener\alert\log.xml

            Listening Endpoints Summary...
            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=204.235.166.110)(PORT=1521)))
            (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
            Services Summary...
            Service "+ASM_XPT" has 1 instance(s).
            Instance "+asm", status READY, has 1 handler(s) for this service...
            Service "+asm" has 1 instance(s).
            Instance "+asm", status READY, has 1 handler(s) for this service...
            Service "CRMCFG" has 2 instance(s).
            Instance "CRMCFG", status UNKNOWN, has 1 handler(s) for this service...
            Instance "CRMCFG", status BLOCKED, has 1 handler(s) for this service...
            Service "CRMCFG_XPT" has 1 instance(s).
            Instance "CRMCFG", status BLOCKED, has 1 handler(s) for this service...
            Service "CRMDMOXDB" has 1 instance(s).
            Instance "crmdmo", status READY, has 1 handler(s) for this service...
            Service "CRMDMO_XPT" has 1 instance(s).
            Instance "crmdmo", status READY, has 1 handler(s) for this service...
            Service "CRMSYSXDB" has 1 instance(s).
            Instance "crmsys", status READY, has 1 handler(s) for this service...
            Service "CRMSYS_XPT" has 1 instance(s).
            Instance "crmsys", status READY, has 1 handler(s) for this service...
            Service "CSDMOXDB" has 1 instance(s).
            Instance "csdmo", status READY, has 1 handler(s) for this service...
            Service "CSDMO_XPT" has 1 instance(s).
            Instance "csdmo", status READY, has 1 handler(s) for this service...
            Service "CSSYSXDB" has 1 instance(s).
            Instance "cssys", status READY, has 1 handler(s) for this service...
            Service "CSSYS_XPT" has 1 instance(s).
            Instance "cssys", status READY, has 1 handler(s) for this service...
            Service "EPCFG" has 2 instance(s).
            Instance "EPCFG", status UNKNOWN, has 1 handler(s) for this service...
            Instance "EPCFG", status READY, has 1 handler(s) for this service...
            Service "EPCFG_XPT" has 1 instance(s).
            Instance "EPCFG", status READY, has 1 handler(s) for this service...
            Service "EPDMOXDB" has 1 instance(s).
            Instance "epdmo", status READY, has 1 handler(s) for this service...
            Service "EPDMO_XPT" has 1 instance(s).
            Instance "epdmo", status READY, has 1 handler(s) for this service...
            Service "EPSYSXDB" has 1 instance(s).
            Instance "epsys", status READY, has 1 handler(s) for this service...
            Service "EPSYS_XPT" has 1 instance(s).
            Instance "epsys", status READY, has 1 handler(s) for this service...
            Service "crmdmo" has 1 instance(s).
            Instance "crmdmo", status READY, has 1 handler(s) for this service...
            Service "crmsys" has 1 instance(s).
            Instance "crmsys", status READY, has 1 handler(s) for this service...
            Service "csdmo" has 1 instance(s).
            Instance "csdmo", status READY, has 1 handler(s) for this service...
            Service "cssys" has 1 instance(s).
            Instance "cssys", status READY, has 1 handler(s) for this service...
            Service "epdmo" has 1 instance(s).
            Instance "epdmo", status READY, has 1 handler(s) for this service...
            Service "epsys" has 1 instance(s).
            Instance "epsys", status READY, has 1 handler(s) for this service...
            Service "orcl" has 1 instance(s).
            Instance "orcl", status READY, has 1 handler(s) for this service...
            Service "orclXDB" has 1 instance(s).
            Instance "orcl", status READY, has 1 handler(s) for this service...
            Service "orcl_XPT" has 1 instance(s).
            Instance "orcl", status READY, has 1 handler(s) for this service...
            The command completed successfully

            C:\>

            C:\>set
            ALLUSERSPROFILE=C:\ProgramData
            APPDATA=C:\Users\Administrator\AppData\Roaming
            CLIENTNAME=DL100486
            CommonProgramFiles=C:\Program Files\Common Files
            CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files
            COMPUTERNAME=KUPSDB01
            ComSpec=C:\Windows\system32\cmd.exe
            DFSTRACINGON=FALSE
            FP_NO_HOST_CHECK=NO
            HOMEDRIVE=C:
            HOMEPATH=\Users\Administrator
            LOCALAPPDATA=C:\Users\Administrator\AppData\Local
            LOGONSERVER=\\KUPSDB01
            NUMBER_OF_PROCESSORS=8
            ORACLE_HOSTNAME=kupsdb01
            ORACLE_SID=CSDMO
            OS=Windows_NT
            Path=C:\chgasst\dll;C:\psoft\cs\sys\bin\client\winx86;C:\ORACLE\PRODUCT\11.1.0\C
            lient_1\bin;C:\oracle\product\11.1.0\db_1\bin;C:\oracle\product\11.1.0\asm\bin;C
            :\oracle\product\11.1.0\db_1\network\admin;C:\Windows\system32;C:\Windows;C:\Win
            dows\System32\Wbem
            PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
            PROCESSOR_ARCHITECTURE=AMD64
            PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 23 Stepping 6, GenuineIntel
            PROCESSOR_LEVEL=6
            PROCESSOR_REVISION=1706
            ProgramData=C:\ProgramData
            ProgramFiles=C:\Program Files
            ProgramFiles(x86)=C:\Program Files (x86)
            PROMPT=$P$G
            PUBLIC=C:\Users\Public
            SESSIONNAME=RDP-Tcp#0
            SystemDrive=C:
            SystemRoot=C:\Windows
            TEMP=C:\Users\ADMINI~1\AppData\Local\Temp
            TMP=C:\Users\ADMINI~1\AppData\Local\Temp
            TRACE_FORMAT_SEARCH_PATH=\\winseqfe\release\Windows6.0\lh_sp2rtm\6002.18005.0904
            10-1830\amd64fre\symbols.pri\TraceFormat
            USERDOMAIN=KUPSDB01
            USERNAME=Administrator
            USERPROFILE=C:\Users\Administrator
            windir=C:\Windows

            C:\>lsnrctl stop

            LSNRCTL for 64-bit Windows: Version 11.1.0.7.0 - Production on 11-MAR-2010 09:35
            :54

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

            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=204.235.166.110)(PORT=15
            21)))
            The command completed successfully

            C:\>lsnrctl start

            LSNRCTL for 64-bit Windows: Version 11.1.0.7.0 - Production on 11-MAR-2010 09:36
            :01

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

            Starting tnslsnr: please wait...

            TNSLSNR for 64-bit Windows: Version 11.1.0.7.0 - Production
            System parameter file is C:\oracle\product\11.1.0\db_1\network\admin\listener.or
            a
            Log messages written to c:\oracle\diag\tnslsnr\KUPSDB01\listener\alert\log.xml
            Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=204.235.166.110)(PORT=15
            21)))
            Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521
            ipc)))

            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=204.235.166.110)(PORT=15
            21)))
            STATUS of the LISTENER
            ------------------------
            Alias LISTENER
            Version TNSLSNR for 64-bit Windows: Version 11.1.0.7.0 - Produ
            ction
            Start Date 11-MAR-2010 09:36:04
            Uptime 0 days 0 hr. 0 min. 4 sec
            Trace Level off
            Security ON: Local OS Authentication
            SNMP OFF
            Listener Parameter File C:\oracle\product\11.1.0\db_1\network\admin\listener.o
            ra
            Listener Log File c:\oracle\diag\tnslsnr\KUPSDB01\listener\alert\log.xml

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

            C:\>

            From select:
            BANNER
            --------------------------------------------------------------------------------
            Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
            PL/SQL Release 11.1.0.7.0 - Production
            CORE 11.1.0.7.0 Production
            TNS for 64-bit Windows: Version 11.1.0.7.0 - Production
            NLSRTL Version 11.1.0.7.0 - Production

            5 rows selected
            • 3. Re: Error: Listener is not up. Start the Listener and run EMCA
              sb92075
              DB server looks OK, so problem exists on client.

              post content of tnsnames.ora from client
              • 4. Re: Error: Listener is not up. Start the Listener and run EMCA
                741251
                # tnsnames.ora Network Configuration File: C:\oracle\product\11.1.0\db_1\NETWORK\ADMIN\tnsnames.ora
                # Generated by Oracle configuration tools.

                CSDMO =
                (DESCRIPTION =
                (ADDRESS_LIST =
                (ADDRESS = (PROTOCOL = TCP)(HOST = 204.XXX.162.XXX)(PORT = 1521))
                )
                (CONNECT_DATA =
                (SERVER = DEDICATED)
                (SERVICE_NAME = CSDMO)
                )
                )

                CRMDMO =
                (DESCRIPTION =
                (ADDRESS_LIST =
                (ADDRESS = (PROTOCOL = TCP)(HOST = 204.XXX.162.XXX)(PORT = 1521))
                )
                (CONNECT_DATA =
                (SERVER = DEDICATED)
                (SERVICE_NAME = CRMDMO)
                )
                )

                EPDMO =
                (DESCRIPTION =
                (ADDRESS_LIST =
                (ADDRESS = (PROTOCOL = TCP)(HOST = 204.XXX.162.XXX)(PORT = 1521))
                )
                (CONNECT_DATA =
                (SERVER = DEDICATED)
                (SERVICE_NAME = EPDMO)
                )
                )

                CSSYS =
                (DESCRIPTION =
                (ADDRESS_LIST =
                (ADDRESS = (PROTOCOL = TCP)(HOST = 204.XXX.162.XXX)(PORT = 1521))
                )
                (CONNECT_DATA =
                (SERVER = DEDICATED)
                (SERVICE_NAME = CSSYS)
                )
                )

                EPCFG =
                (DESCRIPTION =
                (ADDRESS_LIST =
                (ADDRESS = (PROTOCOL = TCP)(HOST = 204.XXX.162.XXX)(PORT = 1521))
                )
                (CONNECT_DATA =
                (SERVER = DEDICATED)
                (SERVICE_NAME = EPCFG)
                )
                )

                CRMSYS =
                (DESCRIPTION =
                (ADDRESS_LIST =
                (ADDRESS = (PROTOCOL = TCP)(HOST = 204.XXX.162.XXX)(PORT = 1521))
                )
                (CONNECT_DATA =
                (SERVER = DEDICATED)
                (SERVICE_NAME = CRMSYS)
                )
                )

                EPSYS =
                (DESCRIPTION =
                (ADDRESS_LIST =
                (ADDRESS = (PROTOCOL = TCP)(HOST = 204.XXX.162.XXX)(PORT = 1521))
                )
                (CONNECT_DATA =
                (SERVER = DEDICATED)
                (SERVICE_NAME = EPSYS)
                )
                )

                ORCL =
                (DESCRIPTION =
                (ADDRESS_LIST =
                (ADDRESS = (PROTOCOL = TCP)(HOST = 204.XXX.162.XXX)(PORT = 1521))
                )
                (CONNECT_DATA =
                (SERVER = DEDICATED)
                (SERVICE_NAME = orcl)
                )
                )
                • 5. Re: Error: Listener is not up. Start the Listener and run EMCA
                  sb92075
                  listener is listening at (HOST=204.235.166.110)
                  tnsnames is pointing to (HOST = 204.XXX.162.XXX)

                  which are DIFFERENT subnets!
                  • 6. Re: Error: Listener is not up. Start the Listener and run EMCA
                    741251
                    I didn't want to put in the entire IP, the XXX was added by me. The current TNSNAMES contains:

                    # tnsnames.ora Network Configuration File: C:\oracle\product\11.1.0\db_1\NETWORK\ADMIN\tnsnames.ora
                    # Generated by Oracle configuration tools.

                    CSDMO =
                    (DESCRIPTION =
                    (ADDRESS_LIST =
                    (ADDRESS = (PROTOCOL = TCP)(HOST = 204.235.166.110)(PORT = 1521))
                    )
                    (CONNECT_DATA =
                    (SERVER = DEDICATED)
                    (SERVICE_NAME = CSDMO)
                    )
                    )

                    CRMDMO =
                    (DESCRIPTION =
                    (ADDRESS_LIST =
                    (ADDRESS = (PROTOCOL = TCP)(HOST = 204.235.166.110)(PORT = 1521))
                    )
                    (CONNECT_DATA =
                    (SERVER = DEDICATED)
                    (SERVICE_NAME = CRMDMO)
                    )
                    )

                    EPDMO =
                    (DESCRIPTION =
                    (ADDRESS_LIST =
                    (ADDRESS = (PROTOCOL = TCP)(HOST = 204.235.166.110)(PORT = 1521))
                    )
                    (CONNECT_DATA =
                    (SERVER = DEDICATED)
                    (SERVICE_NAME = EPDMO)
                    )
                    )

                    CSSYS =
                    (DESCRIPTION =
                    (ADDRESS_LIST =
                    (ADDRESS = (PROTOCOL = TCP)(HOST = 204.235.166.110)(PORT = 1521))
                    )
                    (CONNECT_DATA =
                    (SERVER = DEDICATED)
                    (SERVICE_NAME = CSSYS)
                    )
                    )

                    EPCFG =
                    (DESCRIPTION =
                    (ADDRESS_LIST =
                    (ADDRESS = (PROTOCOL = TCP)(HOST = 204.235.166.110)(PORT = 1521))
                    )
                    (CONNECT_DATA =
                    (SERVER = DEDICATED)
                    (SERVICE_NAME = EPCFG)
                    )
                    )

                    CRMSYS =
                    (DESCRIPTION =
                    (ADDRESS_LIST =
                    (ADDRESS = (PROTOCOL = TCP)(HOST = 204.235.166.110)(PORT = 1521))
                    )
                    (CONNECT_DATA =
                    (SERVER = DEDICATED)
                    (SERVICE_NAME = CRMSYS)
                    )
                    )

                    EPSYS =
                    (DESCRIPTION =
                    (ADDRESS_LIST =
                    (ADDRESS = (PROTOCOL = TCP)(HOST = 204.235.166.110)(PORT = 1521))
                    )
                    (CONNECT_DATA =
                    (SERVER = DEDICATED)
                    (SERVICE_NAME = EPSYS)
                    )
                    )

                    ORCL =
                    (DESCRIPTION =
                    (ADDRESS_LIST =
                    (ADDRESS = (PROTOCOL = TCP)(HOST = 204.235.166.110)(PORT = 1521))
                    )
                    (CONNECT_DATA =
                    (SERVER = DEDICATED)
                    (SERVICE_NAME = orcl)
                    )
                    )
                    • 7. Re: Error: Listener is not up. Start the Listener and run EMCA
                      741251
                      Any idea on the resolution for this?
                      • 8. Re: Error: Listener is not up. Start the Listener and run EMCA
                        gv.chaitanya8
                        Hi,

                        Check the network connectivity between the client and the server. Ping the server from client machine and check.

                        Rest all seems to be okay.