5 Replies Latest reply: Feb 13, 2013 4:02 AM by saurabh RSS

    ORA-12547: TNS: lost contact

    user13809017
      Hi,

      We using oracle 11g on Aix.

      We getting the below error.

      ERROR:
      ORA-12547: TNS: lost contact

      SP2-0306: Invalid option.
      Usage: CONN[ECT] [logon [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
      where <logon> ::= <username>[<password>][@<connect_identifier>]
      <proxy> ::= <proxyuser>[<username>][<password>][@<connect_identifier>]
      SP2-0306: Invalid option.
      Usage: CONN[ECT] [logon [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
      where <logon> ::= <username>[<password>][@<connect_identifier>]
      <proxy> ::= <proxyuser>[<username>][<password>][@<connect_identifier>]
      SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

      Where i have to look first,whether listener.log or sql*net log?

      Thanks