18 responses

  1. sunil
    August 12, 2011

    great fix. had a similar issue. thanks for the post.

  2. Taj
    August 22, 2011

    Nice post.

  3. 北在南方
    August 22, 2011

    I have a database which has been upgraded from 11.2.0.1 to 11.2.0.2 ; when execute “sqlplus /” as a OS user ADMIN which is not belong to the oracle oinstall group,ORA-12547: TNS:lost contact occurs
    when do “sqlplus /nolog” and then conn /as sysdba as ORACLE user ,the resault id normal
    oracle@p1a.ora.sd.aliyun.com:/home/oracle>sqlplus /nolog
    SQL*Plus: Release 11.2.0.2.0 Production on Sat Aug 20 14:59:50 2011
    Copyright (c) 1982, 2010, Oracle. All rights reserved.
    @>conn /as sysdba
    Connected.
    sys@alibank1>exit

    but when do this as ADMIN uers ,ORA-12547: TNS:lost contact occurs;
    admin@p1a.ora.sd.aliyun.com:/home/admin>tnsping alibank1
    TNS Ping Utility for Linux: Version 11.2.0.2.0 – Production on 20-AUG-2011 14:57:19
    Copyright (c) 1997, 2010, Oracle. All rights reserved.
    Used parameter files:
    TNS-03505: Failed to resolve name
    admin@p1a.ora.sd.aliyun.com:/home/admin>sqlplus /nolog
    SQL*Plus: Release 11.2.0.2.0 Production on Sat Aug 20 14:57:33 2011
    Copyright (c) 1982, 2010, Oracle. All rights reserved.
    @>conn /as sysdba
    ERROR:
    ORA-12547: TNS:lost contact

  4. 北在南方
    August 22, 2011

    I am a oracle dba from chain and looking forward to your advice..

  5. suhas
    November 28, 2011

    Thanks

    problem is solve

  6. Gaurav R
    December 16, 2011

    Thanks. had a similar issue after upgrading from Oracle10g (10.2.0.5) to Oracle11g.

  7. Gaurav R
    December 16, 2011

    We can also use following commands:

    cd $ORACLE_HOME/bin
    relink all

  8. isma
    January 6, 2012

    Hi,
    Need your help.
    Even after perform the command as suggested, I’m still can’t start the listener. Help!!
    root@ormdevl # chmod 6751 oracle
    root@ormdevl # ls -ltr oracle
    -rwsr-s–x 1 oracle dba 66435324 Mar 8 2006 oracle
    root@ormdevl # lsnrctl

    LSNRCTL for Solaris: Version 9.2.0.7.0 – Production on 06-JAN-2012 11:21:02

    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    Welcome to LSNRCTL, type “help” for information.

    LSNRCTL> start
    Starting /oracle/9.2.0/bin/tnslsnr: please wait…

    ld.so.1: tnslsnr: fatal: /oracle/9.2.0/lib/libclntsh.so.9.0: Permission denied
    TNS-12547: TNS:lost contact
    TNS-12560: TNS:protocol adapter error
    TNS-00517: Lost contact
    Solaris Error: 32: Broken pipe
    LSNRCTL>

  9. Brian Repko
    January 6, 2012

    Had the same issue – thanks a ton!!

  10. gopal
    January 21, 2012

    chmod 6751 oracle
    $ ls -ltr oracle
    -rwsr-s–x 1 oracle dba 136803483 Mar 16 20:32 oracle
    $

    Resolved my issue. Thanks for your support.

  11. Meiron
    January 21, 2012

    great. chmod 6751 helped a lot.

  12. Vivek
    March 13, 2012

    ORA-12547: TNS:lost contact
    exapmple :

    – $ORACLE_HOME
    – chmod r 777 where oracle is installed
    – chown -R oracle_llg uo2 (changing recursively the owner of u02 where oracle is installed )
    – chown -R oracle_llg:oinstall uo2(changing recursively the group of u02 where oracle is installed)

    this helped me..

  13. Elliot
    March 17, 2012

    Helped me too. Thanks.

    Any idea on what would have caused the permissions to change? I don’t want it to happen again.

  14. Sidhu
    March 21, 2012

    @Elliot

    May be they were like this since ever. Or it was working fine before you faced this error one day ?

  15. Amith
    May 15, 2012

    Thanks Amardeep. It worked like a charm.
    Cheers
    Amith

  16. Sidhu
    May 17, 2012

    Great ! :)

  17. Amit
    June 9, 2012

    Thanks Amardeep.. worked for me

  18. amanpreet
    June 29, 2012

    Thanks Amardeep…. worked for me too….

Leave a Reply

 

 

 

Back to top
mobile desktop