This discussion is archived
1 Reply Latest reply: Jan 31, 2013 11:53 PM by LaurenzAlbe RSS

ERROR: ORA-12545, Please help me.

988431 Newbie
Currently Being Moderated
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.
    LaurenzAlbe Journeyer
    Currently Being Moderated
    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.
    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


  • Correct Answers - 10 points
  • Helpful Answers - 5 points