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