RE: Forgot password for "internal" , any ideeas what I can do?

Hi Eddy ,

I assume you use db server v 8.X and NT ,

The steps to recover Internal lost password ,

First , try to find password file named PWD<SID-name>.ora for example PWDORCL.ora in your %ORAHOME%\database directory
Make sure that you enable to show all files from your Explorer ==> View ==> Option

second , just delete the PWD<SID-name>.ora if you worry about it , just move it from its original location.

third , go to command prompt or DOS prompt. or you can call the application called ORAPWD80 just type

C:\ orapwd80 file=d:\orant\database\PWD<SID-name>.ora password=this_is_my_new_password   entries = integer

for example :

C:\ orapwd80 file=d:\orant\database\PWDORCL.ora password=isawherstandingthere entries = 5

Ok , just remember your new password : )

HTH , =bambang=

<> Bambang Setiawan <>

>>> "William Beilstein" <BeilstWH_at_obg.com> 03/10/01 04:46 >>>
Internal is NOT a user, it is the SYS user opened in a special mode. To connect as internal you must have set the Oracle password file to the SYS password and be logged onto the server as the Oracle administrative user. On a Unix system this is normally the "oracle" user with belongs to the "dba" group.

>>> Eddy Confer <EConfer_at_confluence.com> 03/09/01 04:10PM >>>
Pankaj
You say that you can change the internal password by connecting as SYS. Connecting
from where as SYS? SysMgr. After I connect do I just issues the alter user command to
change the internal password.

Thanks

-----Original Message-----
Sent: Friday, March 09, 2001 1:40 PM
To: Multiple recipients of list ORACLE-L

Hi Alex,

the default is "oracle" if you have not changed that...in case you do...you can change that to whatever you want to....by connecting through SYS account..

eNjoy life Technically ;-)

Pankaj

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, March 09, 2001 11:05 PM

>
> Hi all,
>
> I just forgot the password for internal user, do you have any ideea how I
> can connect as 'SYSDBA'?
> Or how I can recover the password.
>
> Thx, alex.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Berindei Alex
> INET: Alex.Berindei_at_elsag.it
>
> 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: Pankaj
  INET: gpankaj_at_yahoo.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: William Beilstein
  INET: BeilstWH_at_obg.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: Bambang Setiawan
  INET: Bambang.Setiawan_at_Sidola.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).