3 Replies Latest reply on Aug 31, 2017 10:33 AM by Beauty_and_dBest

    What messed up my Listener?

    Beauty_and_dBest

      Hi ALL,

       

      EBS R12.2.6

      12c

      OL6

       

       

      I rebooted our server and restart the database, but the listener will not stop/start

       

      But I can start/stop the database.

       

      Please help....

       

      Kind regards,

      jc

       

      [oravisn@oracle ~]$ ./stop

       

      You are running addbctl.sh version 120.1

       

      Shutting down database VISN ...

       

      SQL*Plus: Release 12.1.0.2.0 Production on Thu Aug 31 16:47:31 2017

       

      Copyright (c) 1982, 2014, Oracle.  All rights reserved.

       

      Connected.

      Database closed.

      Database dismounted.

      ORACLE instance shut down.

      Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

      With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

       

      addbctl.sh: exiting with status 0

       

      Logfile: /u01/oravisn/VISN/12.1.0/appsutil/log/VISN_fitr12/addlnctl.txt

       

      You are running addlnctl.sh version 120.4

       

      Shutting down listener process VISN ...

       

      LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 31-AUG-2017 16:48:23

       

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

       

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=fitr12.myoracle.com)(PORT=1521)))

      TNS-12535: TNS:operation timed out

      TNS-12560: TNS:protocol adapter error

        TNS-00505: Operation timed out

       

      addlnctl.sh: exiting with status 1

       

       

      [oravisn@oracle ~]$ ./start

      Logfile: /u01/oravisn/VISN/12.1.0/appsutil/log/VISN_fitr12/addlnctl.txt

       

      You are running addlnctl.sh version 120.4

       

      Starting listener process VISN ...

       

      LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 31-AUG-2017 17:07:44

       

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

       

      Starting /u01/oravisn/VISN/12.1.0/bin/tnslsnr: please wait...

       

      TNSLSNR for Linux: Version 12.1.0.2.0 - Production

      System parameter file is /u01/oravisn/VISN/12.1.0/network/admin/VISN_fitr12/listener.ora

      Log messages written to /u01/oravisn/VISN/12.1.0/admin/VISN_fitr12/diag/tnslsnr/fitr12/visn/alert/log.xml

      Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fitr12.myoracle.com)(PORT=1521)))

       

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=fitr12.myoracle.com)(PORT=1521)))

      TNS-12535: TNS:operation timed out

      TNS-12560: TNS:protocol adapter error

        TNS-00505: Operation timed out

       

      addlnctl.sh: exiting with status 1

       

      addlnctl.sh: check the logfile /u01/oravisn/VISN/12.1.0/appsutil/log/VISN_fitr12/addlnctl.txt for more information ...

       

      You are running addbctl.sh version 120.1

       

      Starting the database VISN ...

       

      SQL*Plus: Release 12.1.0.2.0 Production on Thu Aug 31 17:09:44 2017

       

      Copyright (c) 1982, 2014, Oracle.  All rights reserved.

       

      Connected to an idle instance.

      ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

      ORACLE instance started.

       

      Total System Global Area 2147483648 bytes

      Fixed Size                  2926472 bytes

      Variable Size             469764216 bytes

      Database Buffers         1660944384 bytes

      Redo Buffers               13848576 bytes

      Database mounted.

      Database opened.

      Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

      With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

       

      addbctl.sh: exiting with status 0

        • 1. Re: What messed up my Listener?
          Beauty_and_dBest

          Running autoconfig also hangs

           

          [oravisn@oracle VISN]$ ./adautocfg.sh

          Enter the APPS user password:

          The log file for this session is located at: /u01/oravisn/VISN/12.1.0/appsutil/log/VISN_fitr12/08311802/adconfig.log

           

          AutoConfig is configuring the Database environment...

           

          AutoConfig will consider the custom templates if present.

                  Using ORACLE_HOME location : /u01/oravisn/VISN/12.1.0

                  Classpath                   : :/u01/oravisn/VISN/12.1.0/jdbc/lib/ojdbc6.jar:/u01/oravisn/VISN/12.1.0/appsutil/java/xmlparserv2.jar:/u01/oravisn/VISN/12.1.0/appsutil/java:/u01/oravisn/VISN/12.1.0/jlib/netcfg.jar:/u01/oravisn/VISN/12.1.0/jlib/ldapjclnt12.jar

           

                  Using Context file          : /u01/oravisn/VISN/12.1.0/appsutil/VISN_fitr12.xml

           

          Context Value Management will now update the Context file

          .

          .

           

          IO Error: The Network Adapter could not establish the connection

           

          What happened to my network Adapter?

           

           

          Kind regards,

          • 2. Re: What messed up my Listener?
            John_K

            Can you ping "fitr12.myoracle.com"?

            • 3. Re: What messed up my Listener?
              Beauty_and_dBest

              Thanks Ora,

              yes the IP was changed , hence ping hangs