From Bambang.Setiawan@Sidola.com Fri, 09 Mar 2001 18:02:05 -0800 From: "Bambang Setiawan" Date: Fri, 09 Mar 2001 18:02:05 -0800 Subject: RE: Forgot password for "internal" , any ideeas what I can do? Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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.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.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.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" 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 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" 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@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@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@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@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@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@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@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@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).