Home » RDBMS Server » Server Utilities » Forgort Internal Password...!!!
Forgort Internal Password...!!! [message #69628] Sat, 09 February 2002 20:37 Go to next message
rajesh
Messages: 173
Registered: November 1998
Senior Member
I have forgot my internal password for the Database.While I can connect as SYS.Please give me a solution.
Re: Forgort Internal Password...!!! [message #69641 is a reply to message #69628] Tue, 12 February 2002 12:49 Go to previous messageGo to next message
Gajanan Kini
Messages: 8
Registered: January 2002
Junior Member
The default Tablespace for internal is oracle.

GAJANAN KINI
Re: Forgort Internal Password...!!! [message #69651 is a reply to message #69628] Wed, 13 February 2002 12:02 Go to previous messageGo to next message
Bala
Messages: 205
Registered: November 1999
Senior Member
Create a new password file with a new password..

Don't know your oracle version or OS but
if you have oracle/NT/2000 then follow these steps

Change the directory path and oracle exe version accordingly
1. In the %ORACLE_HOME%database

Check for a file named "PWDsidname.ORA file,if it exists rename the file to something.
(This file may be hidden,use the Windows Explorer View/Option 'show all files' to see the file. The part of the file name 'sidname' is the name of your sid, so if sid is catp then the file name will be PWDCATP).

2.In the DOS prompt go to %ORACLE_HOME%bin and issue this command....

D:orantbin>ORAPWD73 FILE=D:ORANTDATABASEPWDcatp.ORA PASSWORD=newpas

This will create a PWDsidname.ORA file in the above stated directory.

3. Change directory to the D:orantdatabase directory and edit
the file "STRTcatp.CMD". Change the section "-usrpwd
OLDPASSWORD to the NEWPASSWORD given in Step 2.

4. At this point the internal password has been changed and you
should be able to connect internal with the new password
Re: Forgort Internal Password...!!! [message #69817 is a reply to message #69651] Sat, 09 March 2002 22:47 Go to previous message
rajesh
Messages: 173
Registered: November 1998
Senior Member
thanks .......

I got the Answer.

rajesh.
Previous Topic: Re: OCP Exam Papers
Next Topic: Re: FREE OCP PAPERS
Goto Forum:
  


Current Time: Fri Apr 26 10:31:38 CDT 2024