RE: sys login -probably a dumb question

sometimes password file gets out of sync ... that may be the reason ...  

Raj

Rajendra Jamadagni MIS, ESPN Inc.

Rajendra dot Jamadagni at ESPN dot com

Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!

-----Original Message-----
Sent: Monday, December 09, 2002 4:24 PM
To: Multiple recipients of list ORACLE-L

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-----
<mailto:John.Shaw_at_correctionscorp.com> ] 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: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.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).



text/plain attachment: ESPN_Disclaimer.txt