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

Legend

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