1 2 Previous Next 22 Replies Latest reply: Dec 18, 2012 1:47 PM by Hussein Sawwan-Oracle Go to original post RSS
      • 15. Re: adcfgclone.pl dbTier on Target DB removes listener and tnsnames files
        Hussein Sawwan-Oracle
        TNSLSNR for Linux: Version 11.1.0.7.0 - Production
        System parameter file is /u01/oracle/WMSTST/db/tech_st/11.1.0/network/admin/WMSTST_x07tst00/listener.ora
        Log messages written to /u01/oracle/WMSTST/db/tech_st/11.1.0/log/diag/tnslsnr/x07tst00/wmstst/alert/log.xml
        TNS-01151: Missing listener name, WMSTST, in LISTENER.ORA

        Listener failed to start. See the error message(s) above...


        addlnctl.sh: exiting with status 1

        addlnctl.sh: check the logfile /u01/oracle/WMSTST/db/tech_st/11.1.0/appsutil/log/WMSTST_x07tst00/addlnctl.txt for more information ...

        That file shows the following:

        Starting database listener for WMSTST:
        Running:
        /u01/oracle/WMSTST/db/tech_st/11.1.0/appsutil/scripts/WMSTST_x07tst00/addlnctl.sh start WMSTST
        Logfile: /u01/oracle/WMSTST/db/tech_st/11.1.0/appsutil/log/WMSTST_x07tst00/addlnctl.txt

        You are running addlnctl.sh version 120.1.12010000.4


        Starting listener process WMSTST ...


        LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 18-DEC-2012 11:25:39

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

        Starting /u01/oracle/WMSTST/db/tech_st/11.1.0/bin/tnslsnr: please wait...

        TNSLSNR for Linux: Version 11.1.0.7.0 - Production
        System parameter file is /u01/oracle/WMSTST/db/tech_st/11.1.0/network/admin/WMSTST_x07tst00/listener.ora
        Log messages written to /u01/oracle/WMSTST/db/tech_st/11.1.0/log/diag/tnslsnr/x07tst00/wmstst/alert/log.xml
        TNS-01151: Missing listener name, WMSTST, in LISTENER.ORA

        Listener failed to start. See the error message(s) above...


        addlnctl.sh: exiting with status 1

        addlnctl.sh: check the logfile /u01/oracle/WMSTST/db/tech_st/11.1.0/appsutil/log/WMSTST_x07tst00/addlnctl.txt for more information ...


        Should I have stopped the DB or listener before running the script?
        The database and the database listener should be up and running.

        If the listener.ora file is missing, please create it using one of the following options:

        - Use netca
        - Manually
        - Copy it from the source server and edit the file (hostname, directory paths, domain name, port, listener name, ..etc).

        Thanks,
        Hussein
        • 16. Re: adcfgclone.pl dbTier on Target DB removes listener and tnsnames files
          user4434301
          Thanks I modified the listener.ora file manually and was able to run the addlnctl.sh start WMSTST script successfully.

          Should I be concerned that the listener now appears to be running on 1521, as I was not able to select 1521 upon running adcfgclone.pl dbTechStack?

          LSNRCTL> status
          Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
          STATUS of the LISTENER
          ------------------------
          Alias LISTENER
          Version TNSLSNR for Linux: Version 11.1.0.7.0 - Production
          Start Date 14-DEC-2012 17:15:24
          Uptime 3 days 19 hr. 34 min. 27 sec
          Trace Level off
          Security ON: Local OS Authentication
          SNMP OFF
          Listener Parameter File /u01/oracle/WMSTST/db/tech_st/11.1.0/network/admin/WMSTST_x07tst00/listener.ora
          Listener Log File /u01/oracle/WMSTST/db/tech_st/11.1.0/log/diag/tnslsnr/x07tst00/listener/alert/log.xml
          Listening Endpoints Summary...
          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=x07tst00.isd.upmc.edu)(PORT=1521)))
          Services Summary...
          Service "WMSTST" has 1 instance(s).
          Instance "WMSTST", status READY, has 1 handler(s) for this service...
          Service "WMSTST_XPT" has 1 instance(s).
          Instance "WMSTST", status READY, has 1 handler(s) for this service...
          The command completed successfully

          LSNRCTL> status WMSTST
          Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=x07tst00.isd.upmc.edu)(PORT=1522)))
          TNS-12541: TNS:no listener
          TNS-12560: TNS:protocol adapter error
          TNS-00511: No listener
          Linux Error: 111: Connection refused
          • 17. Re: adcfgclone.pl dbTier on Target DB removes listener and tnsnames files
            Hussein Sawwan-Oracle
            Please post the contents of the listener.ora file here.

            What is your listener name? Is it LISTENER or WMSTST?

            Do you have proper entry in the hosts file? -- R11i: adalnctl.sh fails to startup a cloned Instance - LSNRCTL shows 'Connection refused' [ID 1355564.1]

            Thanks,
            Hussein
            • 18. Re: adcfgclone.pl dbTier on Target DB removes listener and tnsnames files
              EBSDBA
              Hi,

              First it shows, port number 1521
              (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=x07tst00.isd.upmc.edu)(PORT=1521)))
              Then it shows 1522
              SNRCTL> status WMSTST
              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=x07tst00.isd.upmc.edu)(PORT=1522)))
              Thanks
              • 19. Re: adcfgclone.pl dbTier on Target DB removes listener and tnsnames files
                user4434301
                WMSTST =
                (DESCRIPTION_LIST =
                (DESCRIPTION =
                (ADDRESS = (PROTOCOL = TCP)(HOST = x07tst00.isd.upmc.edu)(PORT = 1522))
                )
                )

                SID_LIST_WMSTST =
                (SID_LIST =
                (SID_DESC =
                (ORACLE_HOME= /u01/oracle/WMSTST/db/tech_st/11.1.0)
                (SID_NAME = WMSTST)
                )
                )

                STARTUP_WAIT_TIME_WMSTST = 0
                CONNECT_TIMEOUT_WMSTST = 10
                TRACE_LEVEL_WMSTST = OFF

                LOG_DIRECTORY_WMSTST = /u01/oracle/WMSTST/db/tech_st/11.1.0/network/admin
                LOG_FILE_WMSTST = WMSTST
                TRACE_DIRECTORY_WMSTST = /u01/oracle/WMSTST/db/tech_st/11.1.0/network/admin
                TRACE_FILE_WMSTST =
                ADMIN_RESTRICTIONS_WMSTST = ON
                SUBSCRIBE_FOR_NODE_DOWN_EVENT_WMSTST = OFF


                # added parameters for bug# 9286476
                LOG_STATUS_WMSTST = ON
                INBOUND_CONNECT_TIMEOUT_WMSTST = 60

                # ADR is only applicable for 11gDB
                DIAG_ADR_ENABLED_WMSTST = ON
                ADR_BASE_WMSTST = /u01/oracle/WMSTST/db/tech_st/11.1.0/admin/WMSTST_x07tst00

                IFILE=/u01/oracle/WMSTST/db/tech_st/11.1.0/network/admin/WMSTST_x07tst00/listener_ifile.ora
                • 20. Re: adcfgclone.pl dbTier on Target DB removes listener and tnsnames files
                  Hussein Sawwan-Oracle
                  Issue "lsnrctl start WMSTST" followed by "lsnrctl status WMSTST".

                  Thanks,
                  Hussein
                  • 21. Re: adcfgclone.pl dbTier on Target DB removes listener and tnsnames files
                    user4434301
                    [oracle@x07tst00 WMSTST_x07tst00]$ lsnrctl start WMSTST

                    LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 18-DEC-2012 14:44:00

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

                    TNS-01106: Listener using listener name WMSTST has already been started
                    [oracle@x07tst00 WMSTST_x07tst00]$ lsnrctl status WMSTST

                    LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 18-DEC-2012 14:44:08

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

                    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=x07tst00.isd.upmc.edu)(PORT=1522)))
                    STATUS of the LISTENER
                    ------------------------
                    Alias WMSTST
                    Version TNSLSNR for Linux: Version 11.1.0.7.0 - Production
                    Start Date 18-DEC-2012 12:58:34
                    Uptime 0 days 1 hr. 45 min. 34 sec
                    Trace Level off
                    Security ON: Local OS Authentication
                    SNMP OFF
                    Listener Parameter File /u01/oracle/WMSTST/db/tech_st/11.1.0/network/admin/WMSTST_x07tst00/listener.ora
                    Listener Log File /u01/oracle/WMSTST/db/tech_st/11.1.0/admin/WMSTST_x07tst00/diag/tnslsnr/x07tst00/wmstst/alert/log.xml
                    Listening Endpoints Summary...
                    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=x07tst00.isd.upmc.edu)(PORT=1522)))
                    Services Summary...
                    Service "WMSTST" has 1 instance(s).
                    Instance "WMSTST", status UNKNOWN, has 1 handler(s) for this service...
                    The command completed successfully
                    • 22. Re: adcfgclone.pl dbTier on Target DB removes listener and tnsnames files
                      Hussein Sawwan-Oracle
                      user4434301 wrote:
                      [oracle@x07tst00 WMSTST_x07tst00]$ lsnrctl start WMSTST

                      LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 18-DEC-2012 14:44:00

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

                      TNS-01106: Listener using listener name WMSTST has already been started
                      [oracle@x07tst00 WMSTST_x07tst00]$ lsnrctl status WMSTST

                      LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 18-DEC-2012 14:44:08

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

                      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=x07tst00.isd.upmc.edu)(PORT=1522)))
                      STATUS of the LISTENER
                      ------------------------
                      Alias WMSTST
                      Version TNSLSNR for Linux: Version 11.1.0.7.0 - Production
                      Start Date 18-DEC-2012 12:58:34
                      Uptime 0 days 1 hr. 45 min. 34 sec
                      Trace Level off
                      Security ON: Local OS Authentication
                      SNMP OFF
                      Listener Parameter File /u01/oracle/WMSTST/db/tech_st/11.1.0/network/admin/WMSTST_x07tst00/listener.ora
                      Listener Log File /u01/oracle/WMSTST/db/tech_st/11.1.0/admin/WMSTST_x07tst00/diag/tnslsnr/x07tst00/wmstst/alert/log.xml
                      Listening Endpoints Summary...
                      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=x07tst00.isd.upmc.edu)(PORT=1522)))
                      Services Summary...
                      Service "WMSTST" has 1 instance(s).
                      Instance "WMSTST", status UNKNOWN, has 1 handler(s) for this service...
                      The command completed successfully
                      Your listener looks up and running.

                      Thanks,
                      Hussein
                      1 2 Previous Next