On Win2K the easiest way to hack your way back into the
database is to log on as local administrator then run
orapwd utility to re-create the password file (change
working directory to ORACLE_HOME/bin then type orapwd
and you'll see the full syntax).
New password file should be created in such a way as to
be compliant with (or following) Oracle's defaults (be
where Oracle expects to find it):
ORACLE_HOME\database\PWD<YOUR_SID>.ora
If the password file was already there but you forgot
the what that password is, rename existing password file
to say PWD<YOUR_SID>.ora.old then create the new one:
orapwd file=C:\Oracle\Ora92\database\PWD<YOUR_SID>.ora
password=<YOUR_NEW_PWD>
Using SQL*Plus:
connect sys/<YOUR_NEW_PWD>@<YOUR_SERVICE> as sysdba
then
alter user sys identified by <YOUR_NEW_PWD>
to synchronize sys'es password in data dictionary.
After that - the business as usual.
Other way to achieve the same (hack back in) would be
to fiddle with pfile, sqlnet.ora, and local ORA_DBA group
in order to be able to use OS account to log on as SYSDBA
and then 'alter user sys...'. But this way is a pain
compared to simply 'blowing up' the old password file,
creating the new one then re-synch-ing it.
Branimir
> -----Original Message-----
> From: Rama, Shreekantha (K.) [mailto:[EMAIL PROTECTED]
> Sent: October 21, 2003 12:24 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: New to DBA !
>
>
> No ! this is is on Windows 2000..
>
> Warm Regards
> Shreekanth
> ____________________________________
> Satyam Computer Services Ltd
> BSAQ Project
> Dearborn, MI
> ( (313) 206 9132
> * [EMAIL PROTECTED]
> ____________________________________
>
>
> -----Original Message-----
> Sent: Tuesday, October 21, 2003 11:45 AM
> To: Multiple recipients of list ORACLE-L
>
>
> is this a Unix box?
>
> if so, log on as the oracle account to the Unix server. Then in
> sqlplus, login as follows
>
> sqlplus "/ as sysdba"
>
> this will get you in as the database owner and will allow you
> to change
> the system password
>
> alter user system identified by your_new_password;
>
> then log out of sqlplus and log in as system to do what you need to
>
>
> --- "Rama, Shreekantha (K.)" <[EMAIL PROTECTED]> wrote:
> > Hi All,
> >
> > I am new to the world of Oracle..
> > I am having this issue..
> >
> > I have created a database on Oracle 8.1.7.4..
> >
> > But I am not able to access as the password is lost..
> > Now, I am not able to login..
> > I tried login using system /manager.. but oracle is not
> > allowing me to login ..
> >
> > What's the solution ??
> >
> > Regards
> > Shreekanth
> >
> >
> >
>
>
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product search
> http://shopping.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Rachel Carmichael
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Rama, Shreekantha (K.)
> 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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Branimir Petrovic
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).
