OraFAQ Forum: Security » How to change password of Sysdba

Home » RDBMS Server » Security » How to change password of Sysdba

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to change password of Sysdba [message #112023]

Tue, 22 March 2005 08:37

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

Report message to a moderator

Re: How to change password of Sysdba [message #112033 is a reply to message #112023]

Tue, 22 March 2005 09:15

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>

Report message to a moderator

Re: How to change password of Sysdba [message #112121 is a reply to message #112023]

Wed, 23 March 2005 02:37

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

Report message to a moderator

Re: How to change password of Sysdba [message #112157 is a reply to message #112121]

Wed, 23 March 2005 06:20

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 09:06:50 CST 2025