• 30. Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba
      Ujjwal Rana

      Hi Pavan,

      Here is the output for rpm -qa | grep ^libaio

       

      [root@storage ~]# rpm -qa | grep ^libaio

      libaio-devel-0.3.107-10.el6.i686

      libaio-0.3.107-10.el6.x86_64

      libaio-devel-0.3.107-10.el6.x86_64

      libaio-0.3.107-10.el6.i686

      [root@storage ~]#

       

      Also you haven mentioned to check this one as well :- (not grid one)

       

      [oracle@storage bin]$ pwd

      /u01/app/oracle/product/11.2.0/db_1/bin

       

      [oracle@storage bin]$ ls -al oracle

      -rwxrwxr-x 1 grid asmadmin 210823812 Jul 10 09:03 oracle

      [oracle@storage bin]$

       

      [oracle@storage bin]$ chmod 6751 $ORACLE_HOME/bin/oracle

      chmod: changing permissions of `/u01/app/oracle/product/11.2.0/db_1/bin/oracle': Operation not permitted

       

      [oracle@storage bin]$ chmod ug+s oracle or chmod 6751 oracle

      chmod: changing permissions of `oracle': Operation not permitted

      chmod: cannot access `or': No such file or directory

      chmod: cannot access `chmod': No such file or directory

      chmod: cannot access `6751': No such file or directory

      chmod: changing permissions of `oracle': Operation not permitted

       

      [oracle@storage bin]$ dbca (REGARDING INSTALLING DBCA, at ASM credentials it ask for the password of ASMSNMP but when i give the correct password it does not accept) and the reason could be ASM does not appear under listener status. Besides i tried changing SQLNET.AUTHORIZATION_SERVICE=(ALL) to (NONE) that did not work as well. Also at grid i tried to login as sqlplus / as sysasm and changed the password as alter user asmsnmp identified by asmnepal; and re tried giving the password at DBCA but that did not work. However i tried to check the ASM status by srvctl status ASM and it shows ASM IS RUNNING but when you type lsnrctl status then under lsnrctl status it does not show ASM. PLEASE LET  ME know if you want me to do or provide any further information.

      I ALSO  WOULD LIKE TO TALK  ABOUT CLUSTER UTILITY WITH YOU but will like to go through your instruction first


      WAITING FOR YOUR RESPONSE

      • 31. Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba
        Ujjwal Rana

        [oracle@storage bin]$ ping storage.castrading.com

        PING storage.castrading.com (192.168.0.227) 56(84) bytes of data.

        64 bytes from storage.castrading.com (192.168.0.227): icmp_seq=1 ttl=64 time=0.036 ms

        64 bytes from storage.castrading.com (192.168.0.227): icmp_seq=2 ttl=64 time=0.044 ms

        64 bytes from storage.castrading.com (192.168.0.227): icmp_seq=3 ttl=64 time=0.045 ms

        ^C

        --- storage.castrading.com ping statistics ---

        3 packets transmitted, 3 received, 0% packet loss, time 2257ms

        rtt min/avg/max/mdev = 0.036/0.041/0.045/0.008 ms

         

        [oracle@storage bin]$ exit

        logout

         

        [grid@storage ~]$ ping storage.castrading.com

        PING storage.castrading.com (192.168.0.227) 56(84) bytes of data.

        64 bytes from storage.castrading.com (192.168.0.227): icmp_seq=1 ttl=64 time=0.031 ms

        64 bytes from storage.castrading.com (192.168.0.227): icmp_seq=2 ttl=64 time=0.036 ms

        64 bytes from storage.castrading.com (192.168.0.227): icmp_seq=3 ttl=64 time=0.042 ms

        ^C

        --- storage.castrading.com ping statistics ---

        3 packets transmitted, 3 received, 0% packet loss, time 2378ms

        rtt min/avg/max/mdev = 0.031/0.036/0.042/0.006 ms

        [grid@storage ~]$

        • 32. Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba

          do same errors still occur with listener.log file?

          • 33. Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba
            rchem

            [oracle@storage bin]$ pwd

            /u01/app/oracle/product/11.2.0/db_1/bin

            [oracle@storage bin]$ ls -al oracle

            -rwxrwxr-x 1 grid asmadmin 210823812 Jul 10 09:03 oracle

             

             

            Why the oracle binary under DB home is owned by grid user? With which user you installed Oracle Software?

             

            https://oracledbamasters.wordpress.com/2014/02/25/ora-12547-tns-lost-contact/

            • 34. Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba
              Ujjwal Rana

              I installed oracle from root user and I have grid installed in my pc.

              • 35. Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba
                Ujjwal Rana

                yes it does,,,HERE IS THE OUTPUT

                 

                [grid@storage ~]$ lsnrctl status

                 

                LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 16-JUL-2015 08:10:59

                 

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

                 

                Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=storage.castrading.com)(PORT=1521)))

                STATUS of the LISTENER

                ------------------------

                Alias                     LISTENER

                Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production

                Start Date                16-JUL-2015 07:03:24

                Uptime                    0 days 1 hr. 7 min. 34 sec

                Trace Level               off

                Security                  ON: Local OS Authentication

                SNMP                      OFF

                Listener Parameter File   /u01/app/11.2.0/grid/network/admin/listener.ora

                Listener Log File         /u01/app/grid/diag/tnslsnr/storage/listener/alert/log.xml

                Listening Endpoints Summary...

                  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=storage.castrading.com)(PORT=1521)))

                Services Summary...

                Service "orcl" has 1 instance(s).

                Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...

                The command completed successfully

                 

                [grid@storage ~]$ srvctl status ASM

                ASM is running on storage

                • 36. Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba

                  post last 100 lines or so from   /u01/app/grid/diag/tnslsnr/storage/listener/alert/log.xml file

                  • 37. Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba
                    Ujjwal Rana

                    [grid@storage ~]$ tail /u01/app/grid/diag/tnslsnr/storage/listener/alert/log.xml file -n 100

                    ==> /u01/app/grid/diag/tnslsnr/storage/listener/alert/log.xml <==

                    host_addr='192.168.0.227'>

                    <txt>16-JUL-2015 08:16:31 * service_died * LsnrAgt * 12537

                    </txt>

                    </msg>

                    <msg time='2015-07-16T08:16:31.384+05:45' org_id='oracle' comp_id='tnslsnr'

                    type='UNKNOWN' level='16' host_id='storage.castrading.com'

                    host_addr='192.168.0.227'>

                    <txt>16-JUL-2015 08:16:31 * version * 0

                    </txt>

                    </msg>

                    <msg time='2015-07-16T08:16:31.467+05:45' org_id='oracle' comp_id='tnslsnr'

                    type='UNKNOWN' level='16' host_id='storage.castrading.com'

                    host_addr='192.168.0.227'>

                    <txt>Error listening on: (ADDRESS=(PROTOCOL=TCP)(HOST=54.84.74.52)(PORT=1521)(IP=FIRST))

                    </txt>

                    </msg>

                    <msg time='2015-07-16T08:16:31.468+05:45' org_id='oracle' comp_id='tnslsnr'

                    type='UNKNOWN' level='16' host_id='storage.castrading.com'

                    host_addr='192.168.0.227'>

                    <txt>16-JUL-2015 08:16:31 * service_register * LsnrAgt * 12545

                    </txt>

                    </msg>

                    <msg time='2015-07-16T08:16:31.468+05:45' org_id='oracle' comp_id='tnslsnr'

                    type='UNKNOWN' level='16' host_id='storage.castrading.com'

                    host_addr='192.168.0.227'>

                    <txt>TNS-12545: Connect failed because target host or object does not exist

                    TNS-12560: TNS:protocol adapter error

                      TNS-00515: Connect failed because target host or object does not exist

                       Linux Error: 99: Cannot assign requested address

                    </txt>

                    </msg>

                    <msg time='2015-07-16T08:16:32.500+05:45' org_id='oracle' comp_id='tnslsnr'

                    type='UNKNOWN' level='16' host_id='storage.castrading.com'

                    host_addr='192.168.0.227'>

                    <txt>WARNING: Subscription for node down event still pending

                    </txt>

                    </msg>

                    <msg time='2015-07-16T08:16:32.501+05:45' org_id='oracle' comp_id='tnslsnr'

                    type='UNKNOWN' level='16' host_id='storage.castrading.com'

                    host_addr='192.168.0.227'>

                    <txt>16-JUL-2015 08:16:32 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=storage.castrading.com)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 0

                    </txt>

                    </msg>

                    <msg time='2015-07-16T08:17:31.279+05:45' org_id='oracle' comp_id='tnslsnr'

                    type='UNKNOWN' level='16' host_id='storage.castrading.com'

                    host_addr='192.168.0.227'>

                    <txt>WARNING: Subscription for node down event still pending

                    </txt>

                    </msg>

                    <msg time='2015-07-16T08:17:31.280+05:45' org_id='oracle' comp_id='tnslsnr'

                    type='UNKNOWN' level='16' host_id='storage.castrading.com'

                    host_addr='192.168.0.227'>

                    <txt>16-JUL-2015 08:17:31 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=storage.castrading.com)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 0

                    </txt>

                    </msg>

                    <msg time='2015-07-16T08:17:31.358+05:45' org_id='oracle' comp_id='tnslsnr'

                    type='UNKNOWN' level='16' host_id='storage.castrading.com'

                    host_addr='192.168.0.227'>

                    <txt>16-JUL-2015 08:17:31 * service_died * LsnrAgt * 12537

                    </txt>

                    </msg>

                    <msg time='2015-07-16T08:17:31.388+05:45' org_id='oracle' comp_id='tnslsnr'

                    type='UNKNOWN' level='16' host_id='storage.castrading.com'

                    host_addr='192.168.0.227'>

                    <txt>16-JUL-2015 08:17:31 * version * 0

                    </txt>

                    </msg>

                    <msg time='2015-07-16T08:17:31.471+05:45' org_id='oracle' comp_id='tnslsnr'

                    type='UNKNOWN' level='16' host_id='storage.castrading.com'

                    host_addr='192.168.0.227'>

                    <txt>Error listening on: (ADDRESS=(PROTOCOL=TCP)(HOST=54.84.74.52)(PORT=1521)(IP=FIRST))

                    </txt>

                    </msg>

                    <msg time='2015-07-16T08:17:31.471+05:45' org_id='oracle' comp_id='tnslsnr'

                    type='UNKNOWN' level='16' host_id='storage.castrading.com'

                    host_addr='192.168.0.227'>

                    <txt>16-JUL-2015 08:17:31 * service_register * LsnrAgt * 12545

                    </txt>

                    </msg>

                    <msg time='2015-07-16T08:17:31.471+05:45' org_id='oracle' comp_id='tnslsnr'

                    type='UNKNOWN' level='16' host_id='storage.castrading.com'

                    host_addr='192.168.0.227'>

                    <txt>TNS-12545: Connect failed because target host or object does not exist

                    TNS-12560: TNS:protocol adapter error

                      TNS-00515: Connect failed because target host or object does not exist

                       Linux Error: 99: Cannot assign requested address

                    </txt>

                    </msg>

                    <msg time='2015-07-16T08:17:32.497+05:45' org_id='oracle' comp_id='tnslsnr'

                    type='UNKNOWN' level='16' host_id='storage.castrading.com'

                    host_addr='192.168.0.227'>

                    <txt>WARNING: Subscription for node down event still pending

                    </txt>

                    </msg>

                    <msg time='2015-07-16T08:17:32.498+05:45' org_id='oracle' comp_id='tnslsnr'

                    type='UNKNOWN' level='16' host_id='storage.castrading.com'

                    host_addr='192.168.0.227'>

                    <txt>16-JUL-2015 08:17:32 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=storage.castrading.com)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 0

                    </txt>

                    </msg>

                    tail: cannot open `file' for reading: No such file or directory

                    [grid@storage ~]$

                    • 38. Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba
                      rchem

                      So you installed Database home with root user and changed the permissions on installed binaries to grid user manually?

                      If so, then that might be the reason for ORA-12547. Install DB home with oracle user and try again.

                      • 39. Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba

                        unless & until you correct the network/OS configuration the error below will prevent the listener from working

                         

                        <msg time='2015-07-16T08:17:31.471+05:45' org_id='oracle' comp_id='tnslsnr'

                        type='UNKNOWN' level='16' host_id='storage.castrading.com'

                        host_addr='192.168.0.227'>

                        <txt>TNS-12545: Connect failed because target host or object does not exist

                        TNS-12560: TNS:protocol adapter error

                          TNS-00515: Connect failed because target host or object does not exist

                           Linux Error: 99: Cannot assign requested address

                        </txt>

                        • 40. Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba
                          Ujjwal Rana

                          Please feel free to check the listener.ora, tnsnames.ora and sqlnet.ora at page 1 of this discussion or you might like to see this output as well

                           

                          [grid@storage admin]$ tnsping LISTENERCONF

                           

                          TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 16-JUL-2015 09:04:48

                           

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

                           

                          Used parameter files:

                          /u01/app/11.2.0/grid/network/admin/sqlnet.ora

                           

                           

                          Used TNSNAMES adapter to resolve the alias

                          Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = storage.castrading.com)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))

                          OK (0 msec)

                          [grid@storage admin]$

                          • 41. Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba

                            Please do as below

                             

                            cd /u01/app/11.2.0/grid/network/admin/

                            lsnrctl stop

                            mv listener.ora listener.ora.sav

                            lsnrctl start

                            lsnrctl status

                             

                            COPY the results from above then PASTE all back here

                             

                            post last 100 lines or so from   /u01/app/grid/diag/tnslsnr/storage/listener/alert/log.xml file which shows all the activity above

                            • 42. Re: Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba
                              Ujjwal Rana

                              [grid@storage admin]$ cd $ORACLE_HOME/network/admin

                               

                              [grid@storage admin]$ pwd

                              /u01/app/11.2.0/grid/network/admin

                               

                              [grid@storage admin]$ lsnrctl stop

                               

                              [grid@storage admin]$ mv listener.ora listener.ora.sav

                               

                              [grid@storage admin]$ lsnrctl start

                               

                              [grid@storage admin]$ lsnrctl status

                               

                              STATUS of the LISTENER

                              ------------------------

                              Alias                     LISTENER

                              Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production

                              Start Date                16-JUL-2015 09:10:14

                              Uptime                    0 days 0 hr. 0 min. 11 sec

                              Trace Level               off

                              Security                  ON: Local OS Authentication

                              SNMP                      OFF

                              Listener Log File         /u01/app/grid/diag/tnslsnr/storage/listener/alert/log.xml

                              Listening Endpoints Summary...

                                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=storage.castrading.com)(PORT=1521)))

                              The listener supports no services

                              The command completed successfully

                              [grid@storage admin]$

                               

                               

                              [grid@storage admin]$ tail  /u01/app/grid/diag/tnslsnr/storage/listener/alert/log.xml -n 100

                              host_addr='192.168.0.227'>

                              <txt>16-JUL-2015 09:10:18 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=storage.castrading.com)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 0

                              </txt>

                              </msg>

                              <msg time='2015-07-16T09:10:18.207+05:45' org_id='oracle' comp_id='tnslsnr'

                              type='UNKNOWN' level='16' host_id='storage.castrading.com'

                              host_addr='192.168.0.227'>

                              <txt>16-JUL-2015 09:10:18 * service_died * LsnrAgt * 12537

                              </txt>

                              </msg>

                              <msg time='2015-07-16T09:10:18.237+05:45' org_id='oracle' comp_id='tnslsnr'

                              type='UNKNOWN' level='16' host_id='storage.castrading.com'

                              host_addr='192.168.0.227'>

                              <txt>16-JUL-2015 09:10:18 * version * 0

                              </txt>

                              </msg>

                              <msg time='2015-07-16T09:10:18.318+05:45' org_id='oracle' comp_id='tnslsnr'

                              type='UNKNOWN' level='16' host_id='storage.castrading.com'

                              host_addr='192.168.0.227'>

                              <txt>16-JUL-2015 09:10:18 * service_register * LsnrAgt * 1195

                              </txt>

                              </msg>

                              <msg time='2015-07-16T09:10:18.319+05:45' org_id='oracle' comp_id='tnslsnr'

                              type='UNKNOWN' level='16' host_id='storage.castrading.com'

                              host_addr='192.168.0.227'>

                              <txt>TNS-01195: Listener rejected registration of endpoint &quot;(ADDRESS=(PROTOCOL=TCP)(HOST=54.84.74.52)(PORT=1521)(IP=FIRST))&quot;

                              </txt>

                              </msg>

                              <msg time='2015-07-16T09:10:19.344+05:45' org_id='oracle' comp_id='tnslsnr'

                              type='UNKNOWN' level='16' host_id='storage.castrading.com'

                              host_addr='192.168.0.227'>

                              <txt>WARNING: Subscription for node down event still pending

                              </txt>

                              </msg>

                              <msg time='2015-07-16T09:10:19.344+05:45' org_id='oracle' comp_id='tnslsnr'

                              type='UNKNOWN' level='16' host_id='storage.castrading.com'

                              host_addr='192.168.0.227'>

                              <txt>16-JUL-2015 09:10:19 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=storage.castrading.com)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 0

                              </txt>

                              </msg>

                              <msg time='2015-07-16T09:10:26.130+05:45' org_id='oracle' comp_id='tnslsnr'

                              type='UNKNOWN' level='16' host_id='storage.castrading.com'

                              host_addr='192.168.0.227'>

                              <txt>WARNING: Subscription for node down event still pending

                              </txt>

                              </msg>

                              <msg time='2015-07-16T09:10:26.130+05:45' org_id='oracle' comp_id='tnslsnr'

                              type='UNKNOWN' level='16' host_id='storage.castrading.com'

                              host_addr='192.168.0.227'>

                              <txt>16-JUL-2015 09:10:26 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=storage.castrading.com)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 0

                              </txt>

                              </msg>

                              <msg time='2015-07-16T09:11:19.494+05:45' org_id='oracle' comp_id='tnslsnr'

                              type='UNKNOWN' level='16' host_id='storage.castrading.com'

                              host_addr='192.168.0.227'>

                              <txt>WARNING: Subscription for node down event still pending

                              </txt>

                              </msg>

                              <msg time='2015-07-16T09:11:19.495+05:45' org_id='oracle' comp_id='tnslsnr'

                              type='UNKNOWN' level='16' host_id='storage.castrading.com'

                              host_addr='192.168.0.227'>

                              <txt>16-JUL-2015 09:11:19 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=storage.castrading.com)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 0

                              </txt>

                              </msg>

                              <msg time='2015-07-16T09:11:19.561+05:45' org_id='oracle' comp_id='tnslsnr'

                              type='UNKNOWN' level='16' host_id='storage.castrading.com'

                              host_addr='192.168.0.227'>

                              <txt>16-JUL-2015 09:11:19 * service_died * LsnrAgt * 12537

                              </txt>

                              </msg>

                              <msg time='2015-07-16T09:11:19.576+05:45' org_id='oracle' comp_id='tnslsnr'

                              type='UNKNOWN' level='16' host_id='storage.castrading.com'

                              host_addr='192.168.0.227'>

                              <txt>16-JUL-2015 09:11:19 * version * 0

                              </txt>

                              </msg>

                              <msg time='2015-07-16T09:11:19.670+05:45' org_id='oracle' comp_id='tnslsnr'

                              type='UNKNOWN' level='16' host_id='storage.castrading.com'

                              host_addr='192.168.0.227'>

                              <txt>16-JUL-2015 09:11:19 * service_register * LsnrAgt * 1195

                              </txt>

                              </msg>

                              <msg time='2015-07-16T09:11:19.670+05:45' org_id='oracle' comp_id='tnslsnr'

                              type='UNKNOWN' level='16' host_id='storage.castrading.com'

                              host_addr='192.168.0.227'>

                              <txt>TNS-01195: Listener rejected registration of endpoint &quot;(ADDRESS=(PROTOCOL=TCP)(HOST=54.84.74.52)(PORT=1521)(IP=FIRST))&quot;

                              </txt>

                              </msg>

                              <msg time='2015-07-16T09:11:20.697+05:45' org_id='oracle' comp_id='tnslsnr'

                              type='UNKNOWN' level='16' host_id='storage.castrading.com'

                              host_addr='192.168.0.227'>

                              <txt>WARNING: Subscription for node down event still pending

                              </txt>

                              </msg>

                              <msg time='2015-07-16T09:11:20.697+05:45' org_id='oracle' comp_id='tnslsnr'

                              type='UNKNOWN' level='16' host_id='storage.castrading.com'

                              host_addr='192.168.0.227'>

                              <txt>16-JUL-2015 09:11:20 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=storage.castrading.com)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 0

                              </txt>

                              </msg>

                              [grid@storage admin]$

                              • 43. Re: Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba

                                The posted  log  file excerpt shows neither the STOP nor the START; which I need to see.