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

    ERROR: ORA-12545, Please help me.

      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

      ~ user$ sqlplus scott tiger

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

      env settings:
      $ORACLE_SID="Oracle 10g+ASM" // I don't know what ORACLE_SID means

      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".

          Laurenz Albe