RE: New to DBA !

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:srama2_at_ford.com]
> 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
> * srama2_at_ford.com
> ____________________________________
>
>
> -----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.)" <srama2_at_ford.com> 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: wisernet100_at_yahoo.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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Rama, Shreekantha (K.)
> INET: srama2_at_ford.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Branimir Petrovic
  INET: BranimirP_at_cpas.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).