Re: sys login -probably a dumb question

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_at_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_at_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

>>> John.Shaw_at_correctionscorp.com 12/05/02 20:56 PM >>>
I have 2 instances on a sun box.
instance abc I can connect by just -- sys/not_default_at_abc but on instance def I can't connect by
sys/not_default2_at_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_at_def as sysdba. why?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Markus Reger
  INET: reger_at_mdw.ac.at

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: ListGuru_at_fatcity.com (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).