Home » RDBMS Server » Security » How to change password of Sysdba
How to change password of Sysdba [message #112023] Tue, 22 March 2005 08:37 Go to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi,

Can any one tell me how to change the password of sys which is connected as Sysdab ?
Note password of sysdba is stored in Password file..
I need steps ...

thank you
sunil
Re: How to change password of Sysdba [message #112033 is a reply to message #112023] Tue, 22 March 2005 09:15 Go to previous messageGo to next message
oldboy
Messages: 9
Registered: March 2005
Location: Chongqing CHINA
Junior Member

you can finish it by following COMMAND

c:\>orapwd file=%oracle_home%\database\pwd%oracle_sid%.ora password=yournewpassword entries=5


usage:
C:\Documents and Settings\xl>orapwd
Usage: orapwd file=<fname> password=<password> entries=<users>

where
file - name of password file (mand),
password - password for SYS (mand),
entries - maximum number of distinct DBA and OPERs (opt),
There are no spaces around the equal-to (=) character.

C:\Documents and Settings\xl>
Re: How to change password of Sysdba [message #112121 is a reply to message #112023] Wed, 23 March 2005 02:37 Go to previous messageGo to next message
easywebtech123
Messages: 22
Registered: March 2005
Location: c
Junior Member
Remember first you have to rename or delete the current password file.
Otherwise it will not allow you to create new password file.

webmaster
http://www.easywebtech.com
Re: How to change password of Sysdba [message #112157 is a reply to message #112121] Wed, 23 March 2005 06:20 Go to previous message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi.....
just see the following step to create carsh because of password file and then how to recover it...


RECOVERY OF PASSWORD FILE
-------------------------
If in any case password file gets corrupted (i.e. deleted) then we have to generate password file.

Generating crash

[1] Shutdown

[2] Rename PASSWORD FILE or delete it.

[3] Go to DOS.
Start sqlplus sys as sysdba/password.

[4] Startup Database
Database does not start and gives following error :

ERROR at line 1:
ORA-01990: error opening password file 'E:\oracle\ora90\DATABASE\PWDora9i.ORA'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

[5] Shutdown

GENERATING PASSWORD FILE

[6] Create PASSWORD FILE

C:\ > ORAPWD FILE=e:\oracle\ora90\database\PWDora9i.ora password=oracle
entries=5

--“ORAPWD” is the utility to create password file
--password file we are creating must have extension as “.ORA”
--“ENTRIES” means how many users can be added to password file

regard

sunil

Previous Topic: How to delete a user?
Next Topic: Grant privileges on table to user
Goto Forum:
  


Current Time: Fri Mar 29 06:22:00 CDT 2024