This discussion is archived
6 Replies Latest reply: Dec 10, 2012 3:26 AM by Arturo Gutierrez RSS

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

Arturo Gutierrez Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points