6 Replies Latest reply: Dec 10, 2012 5:26 AM by Arturo Gutierrez RSS

    ORA-12547: TNS:lost contact trying to access a Oracle Database 11.2.0.3

    Arturo Gutierrez
      Hello,

      I installed a server on a Linux server Oracle11.2.0.3 5.8 from 64 bits.
      The user who installed the Oracle software is "oracle" and belongs to oinstall and dba groups.
      ID ORACLE
      uid=503(oracle) gid=504(oinstall) groups=504(oinstall),505(dba),506(cvargas) context=user_u:system_r:unconfined_t

      The software has been installed correctly and have been able to create two databases. As a requirement of the application, you must create an operating system user that launches processes.
      This user belongs to dba.
      But when trying to access Oracle via sqlplus gives this error:

      -bash-3.2$ sqlplus davinci/xxxxxxx

      SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 7 23:22:40 2012

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

      ERROR:
      ORA-12547: TNS:lost contact


      Enter user-name:

      However, if you connect using a network descriptor works correctly.
      SQLPLUS DAVINCI/xxxx@tns_alias

      So there must be a problem with access to local resources.
      This user has the same profile file variable (. Bash_profile)

      Any idea of how to fix this problem?
      Many thanks
      Arturo
        • 1. Re: ORA-12547: TNS:lost contact trying to access a Oracle Database 11.2.0.3
          sb92075
          user11081143 wrote:
          Hello,

          I installed a server on a Linux server Oracle11.2.0.3 5.8 from 64 bits.
          The user who installed the Oracle software is "oracle" and belongs to oinstall and dba groups.
          ID ORACLE
          uid=503(oracle) gid=504(oinstall) groups=504(oinstall),505(dba),506(cvargas) context=user_u:system_r:unconfined_t

          The software has been installed correctly and have been able to create two databases. As a requirement of the application, you must create an operating system user that launches processes.
          This user belongs to dba.
          But when trying to access Oracle via sqlplus gives this error:

          -bash-3.2$ sqlplus davinci/xxxxxxx

          SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 7 23:22:40 2012

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

          ERROR:
          ORA-12547: TNS:lost contact
          needless to say, you should NOT be getting TNS error while connecting to local DB without using SQL*Net.

          >
          >
          Enter user-name:

          However, if you connect using a network descriptor works correctly.
          SQLPLUS DAVINCI/xxxx@tns_alias

          So there must be a problem with access to local resources.
          This user has the same profile file variable (. Bash_profile)
          Yes, problem exists at OS/Networking level

          >
          Any idea of how to fix this problem?
          post results from following OS commands

          uname -a
          hostname
          /sbin/ifconfig
          cat /etc/hosts
          • 2. Re: ORA-12547: TNS:lost contact trying to access a Oracle Database 11.2.0.3
            Arturo Gutierrez
            Hello,
            This is the info:
            uname -a
            Linux oracle11gr2.cinconet.local 2.6.18-308.4.1.el5 #1 SMP Wed Mar 28 01:54:56 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux

            [oracle@oracle11gr2 ~]$ hostname
            oracle11gr2.cinconet.local

            oracle@oracle11gr2 ~]$ cat /etc/hosts
            # Do not remove the following line, or various programs
            # that require network functionality will fail.
            127.0.0.1 localhost.localdomain localhost
            #10.100.190.86 oracle11gr2.cinconet.local
            10.100.81.56 oracle11gr2.cinconet.local

            [oracle@oracle11gr2 ~]$ /sbin/ifconfig
            bond0 Link encap:Ethernet HWaddr 00:1F:29:54:40:48
            inet addr:10.100.81.56 Bcast:10.100.81.255 Mask:255.255.255.0
            UP BROADCAST RUNNING MASTER MULTICAST MTU:1500 Metric:1
            RX packets:42522861 errors:0 dropped:0 overruns:0 frame:0
            TX packets:9349916 errors:0 dropped:0 overruns:0 carrier:0
            collisions:0 txqueuelen:0
            RX bytes:39624372488 (36.9 GiB) TX bytes:2132916076 (1.9 GiB)

            eth0 Link encap:Ethernet HWaddr 00:1F:29:54:40:48
            UP BROADCAST RUNNING SLAVE MULTICAST MTU:1500 Metric:1
            RX packets:11906339 errors:0 dropped:0 overruns:0 frame:0
            TX packets:9221908 errors:0 dropped:0 overruns:0 carrier:0
            collisions:0 txqueuelen:1000
            RX bytes:2689470918 (2.5 GiB) TX bytes:2103942140 (1.9 GiB)
            Interrupt:201 Memory:fdde0000-fde00000

            eth2 Link encap:Ethernet HWaddr 00:1F:29:54:40:48
            UP BROADCAST RUNNING SLAVE MULTICAST MTU:1500 Metric:1
            RX packets:30616524 errors:0 dropped:0 overruns:0 frame:0
            TX packets:128008 errors:0 dropped:0 overruns:0 carrier:0
            collisions:0 txqueuelen:1000
            RX bytes:36934901702 (34.3 GiB) TX bytes:28973936 (27.6 MiB)
            Interrupt:201 Memory:fdee0000-fdf00000

            eth4 Link encap:Ethernet HWaddr 00:1E:0B:CE:D6:62
            inet addr:10.100.190.86 Bcast:10.100.190.255 Mask:255.255.255.0
            UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
            RX packets:24305494 errors:0 dropped:0 overruns:0 frame:0
            TX packets:819 errors:0 dropped:0 overruns:0 carrier:0
            collisions:0 txqueuelen:1000
            RX bytes:2030832305 (1.8 GiB) TX bytes:82836 (80.8 KiB)
            Interrupt:169 Memory:f8000000-f8012800

            lo Link encap:Local Loopback
            inet addr:127.0.0.1 Mask:255.0.0.0
            UP LOOPBACK RUNNING MTU:16436 Metric:1
            RX packets:13614909 errors:0 dropped:0 overruns:0 frame:0
            TX packets:13614909 errors:0 dropped:0 overruns:0 carrier:0
            collisions:0 txqueuelen:0
            RX bytes:3873718597 (3.6 GiB) TX bytes:3873718597 (3.6 GiB)

            thanks
            Arturo
            • 3. Re: ORA-12547: TNS:lost contact trying to access a Oracle Database 11.2.0.3
              sb92075
              how is it that both eth0 & eth2 have the same MAC address?
              • 5. Re: ORA-12547: TNS:lost contact trying to access a Oracle Database 11.2.0.3
                Arturo Gutierrez
                Hello,
                I need to clarify with the systems people this issue.
                I've run RDA anf found this issue:

                A00320 /etc/hosts Format FAILED no entry found .

                The info about this rule.
                Rule A00320: /etc/hosts Format
                Description
                This rule checks that the /etc/hosts file contains a line with ip_address fully_qualified_domainname short_hostname.

                Unmatched Actions
                no entry found =~ ^Adequate
                no entry found == Cannot access /etc/hosts
                Default Action
                Result: FAILED
                Value: no entry found
                The fully qualified host name and host name are not configured correctly. Ensure that there is an IP address entry for the fully qualified domain name with the host name as one of the aliases.
                No entry with the fully qualified domain name followed by the host name was found.

                Thanks.
                Arturo
                • 6. Re: ORA-12547: TNS:lost contact trying to access a Oracle Database 11.2.0.3
                  Arturo Gutierrez
                  Hello ,

                  The problem was mount the file system where ORACLE_HOME was installed with the option - o nosuid.
                  Processes from a setuid binary located on a file system that is mounted using the nosetuid option do not run with the privileges of the setuid binary. The processes run with the privileges of the user that executes the binary.
                  /dev/mapper/vg_local-lv_oracle /u01/app/oracle ext3 rw,nodev,nosuid,data=ordered 0 0
                  This setting cause the ORA-12547 error. if remove this opton work fine.
                  Lesson learned!

                  Thanks for the help.
                  Arturo