have two instnaces on some machines as well. normally I've ORACLE_SID set to a first instance, lets asume ONE. typing at the command line sqlplus "/ as sysdba" or sqlplus "sys/passphrase as sysdba" or sqlplus "sys/passphrase@ONE as sysdba" are the same. now either you choose to set ORACLE_SID=TWO export ORACLE_SID then it works the same way for instance TWO. The other way is sqlplus "sys/passphras@TWO as sysdba"
For the latter it might be that you must assure, that you can tnsping your instances from the local machine. Never checked that out separately, because I always arrange it that way. This works on SunOS-es and on LINUX-es. kr >>> [EMAIL PROTECTED] 12/05/02 20:56 PM >>> I have 2 instances on a sun box. instance abc I can connect by just -- sys/not_default@abc but on instance def I can't connect by sys/not_default2@def it gives a ERROR: ORA-01017: invalid username/password; logon denied Warning: You are no longer connected to ORACLE. I have to use sys/not_default2@def as sysdba. why? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).