| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re[2]: SYS password is not known (Oracle for NT)
Before changing the SYS password then seeing what breaks you may want to
save the password
first in case you need to get back. I agree with Dick I would take the
hardline approach here, you as a
DBA need to know what the SYS password is. If you cannot contact the
previous DBA then change it
and see what happens.
Rick
SQL> select password from dba_users where username='SYS'; PASSWORD
SQL> alter user sys identified by new_sys_password; User altered.
SQL> connect sys/new_sys_password
Connected.
REM Do whatever you like...see if anything breaks
SQL> connect sys/new_sys_password
Connected.
REM If you need to reset then...
SQL> alter user sys identified by values 'F894844C34402B67';
User altered.
> -----Original Message-----
> From: dgoulet_at_vicr.com [SMTP:dgoulet_at_vicr.com]
> Sent: Tuesday, December 12, 2000 10:13 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re[2]: SYS password is not known (Oracle for NT)
>
> I don't know about the rest of you folks out there, but I don't let anyone
> put
> the sys password in anything, programs, scripts, etc... Including third
> party
> apps. The problem is that those applications that do create things in the
> sys
> account don't get exported when you do a full db export. It should be
> reserved
> for Oracle and Oracle use only. Therefore I'd take the attitude that you
> change
> it & see what breaks. Then massacre the developer who did it.
>
> Dick Goulet
>
> ____________________Reply Separator____________________
> Author: Ramamohan B N <ramamohan.bn_at_tatainfotech.com>
> Date: 12/11/2000 10:50 PM
>
> Hi Don,
>
> You can create a password file. It JUST sets the password
> for connecting as internal. I **THINK** it wont change the
> password for SYS account.
>
> Regards,
> Mohan
>
> Don Dealy II wrote:
> >
> > The dba left and now we are stuck!
> >
> > We know the SYSTEM password, but we don't know the SYS password. Is
> there any
> way that this can be "hacked" (Ver 8.0.5.1.1) so we can know what it is?
> >
> > Yes, we could change it, but nobody knows what scripts or other
> applications
> rely on the current SYS password. It's kind of a sticky wicket.
> >
> > We want to get OEM 2.1 up and running with the intelligent agent, but
> that may
> require building the password file. Will that mess up the current SYS
> password?
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ramamohan B N
> INET: ramamohan.bn_at_tatainfotech.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: dgoulet_at_vicr.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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
Received on Tue Dec 12 2000 - 09:54:49 CST
 |
 |