RE: sys login -probably a dumb question

Yo win - at least I think so - when I regranted the (supposedly) same password to sys it started working normally - now I have to find who changed the password - cause I create them all with standard scripts.

>>> adam.donahue_at_hcmny.com 12/05/02 04:09PM >>>

You probably have the sys password incorrect on instance2. If you specify "as sysdba" it basically ignores the password if you are authorized as an OS user (belong to group oracle, for example).

Adam
-----Original Message-----
Sent: Thursday, December 05, 2002 4:05 PM To: Multiple recipients of list ORACLE-L

Nope - they are both 9.2.0.2 solaris 9

>>> Jeremy.Pulcifer_at_kadiri.com 12/05/02 02:08PM >>>

Any chance that instance 2 is 9i, and instance 1 isn't? -----Original Message-----
Sent: Thursday, December 05, 2002 11:34 AM To: Multiple recipients of list ORACLE-L

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: John Shaw
  INET: John.Shaw_at_correctionscorp.com

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