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
$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
Edited by: 985428 on Jan 31, 2013 12:36 PM
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".