Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    ORA-12547: TNS:lost contact - after attempted copy

    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Problem Symptoms:
    After an attempted copy of Aleph to a new server, util f/4, util o/1/2, etc., all get the following error:

    Oracle error: handle_connection
    ORA-12547: TNS:lost contact

    Error: io_z00 - table doesn't exist in database or tab_io_remote for library: IAD01

    Cause:
    The permission on $ORACLE_HOME/bin/oracle was incorrect.

    Resolution:
    > cd $ORACLE_HOME/bin/oracle

    oracle@chiprc12blnr(aleph20)~/bin$chmod 6751 oracle

    This changed:

    oracle@chiprc12blnr(aleph20)~/bin$ls -ltr *oracle*
    -rwxr-xr-x 1 oracle dba 195915389 Oct 29 2009 oracleO
    -rwxr-x--x 1 oracle dba 195932743 Apr 22 2010 oracle

    to:

    oracle@chiprc12blnr(aleph20)~/bin$ls -ltr *oracle*
    -rwxr-xr-x 1 oracle dba 195915389 Oct 29 2009 oracleO
    -rwsr-s--x 1 oracle dba 195932743 Apr 22 2010 oracle

    Category: System Management (500)