Re: sqlplus from a perl script is giving ORA-12545 error.

>>>>> "Anton" == Anton Buijs <remove_aammbuijs_at_xs4all.nl> writes:

 Anton> What you say is correct but if I may add something.  sqlplus
 Anton> un/pw_at_db will connect to the database using sqlnet.  You can
 Anton> omit the alias name (@db) when you set the variable
 Anton> $TWO_TASK=db.  TWO_TASK prevails upon ORACLE_SID.  ORACLE_SID
 Anton> can only connect you to a local database running in the same
 Anton> ORACLE_HOME only.

Are you sure about that?

I connect to remote databases daily using $ORACLE_SID from sqlplus - I even connect to both 7.3.4 and 8.1.7 databases. We don't use TWO_TASK anymore at all.

Tim

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!