Re: ora-12545

Hi Haoyu Zhou, thanks for writing this:
> I tried to run "sqlplus user/passwd" from a solaris box with oracle client
> installed w/o any luck. The error code is ora-12545. However, I was able
> to connect to the database use "sqlplus user/passwd_at_SID". But ORACLE_SID
> was set correctly in the .profile.
>
> I checked tnsnames.ora, which has such an entry:
> MYSID=(Description=
> (Address=(protocol=tcp)(host=numeric IP)(port=1521))
> (connect_data=(sid=mysid)
> )
>

You might want to look into the TWO_TASK environment variable. Using your sample tnsnames.ora, you can do the following (assuming ksh):

export TWO_TASK=MYSID
sqlplus user/passwd

That should be equivalent to:

sqlplus user/passwd_at_mysid

-- 
[:%s/Karsten Farrell/Oracle DBA/g]