1 Reply Latest reply: Feb 1, 2013 1:53 AM by Laurenz Albe RSS

    ERROR: ORA-12545, Please help me.

    988431
      Hi,
      I have installed the Oracle Instant Client* on UNIX(Mac OS X Lion 10.7.5), and I want to use it on localhost because i just want to study and test it.
      but here, the some error appeared to me. so I was so screwed up.

      here is the error messages and the settings

      Command:
      ~ user$ sqlplus scott tiger

      ERROR:
      ORA-12545: Connect failed because target host or object does not exist

      env settings:
      $ORACLE_HOME=/usr/local/oracle
      $ORACLE_SID="Oracle 10g+ASM" // I don't know what ORACLE_SID means
      $ORACLE_LIBRARY=/usr/local/oracle/instantclient_10_2
      $DYLD_LIBRARY_PATH=$DYLD_LIBRARY_PATH:$ORACLE_HOME/instantclient_10_2
      $SQLPATH=$ORACLE_HOME/instantclient_10_2
      $PATH=$PATH:$SQLPATH

      tnsnames.ora:
      I didn't make it, because I don't know it well.



      Please let me free from errors.

      Have a nice day

      Thank you!

      Edited by: 985428 on Jan 31, 2013 12:36 PM
        • 1. Re: ERROR: ORA-12545, Please help me.
          Laurenz Albe
          Your ORACLE_SID is most certainly wrong.

          The SID is the "Oracle System Identifier", the name of your database that you specified when you created it.
          See http://docs.oracle.com/cd/E11882_01/server.112/e25789/startup.htm#sthref1602
          If you don't remember creating an Oracle database, chances ate that the ORACLE_SID is "ORCL".
          If you don't want to guess, look in the "dbs" subdirectory of your ORACLE_HOME for a file called "initYOUR_SID.ora".

          Yours,
          Laurenz Albe