Password Change

[binjovi]

Hi Guys
How can we change the password of the internal.
I tried with sys as well as system its not allowing to change and I tried oradim but i got confused how to change the password.. Can anybody suggest me is it the right way or how to go about it.

Regards
bins

 

[rcurva]

Use orapwd instead.

 

[binjovi]

Thanks rcurva
I tried that orapwd then also its not working may be i am not doing it in correct way if possible can you tell me how to go about it.

When I tried with oradim as follows
oradim -edit -sid orcon -intpwd newpass
This statement didnt show any error message but it didnt change the password then i tried to delete the instance and then recreated it but then also it didnt work as well it showed me a message

connected to idle instance

can you tell me something about it.

regards
bins

 

[rcurva]

Shutdown database

The ORACLE_HOME\DATABASE\PWD.ORA file contains the internal password. This is a binary file and cannot be manually edited. The ORAPWDxx.EXE utility was created for DBAs who need to change the INTERNAL login password.

From the DOS prompt run:

orapwd file=c:\oracle_home\database\pwd.ora
For example it would be something like:
orapwdXX file=c:\orant\database\pwdorcl.ora password=oracle entries=5

FILE = Path and name of the password file. (mandatory)
Password = Password for SYS and INTERNAL. (Mandatory)
Entries = Maximum number of distinct DBAs and OPERs. (Optional, default=5)

 

[binjovi]

Thanks a lot rcurva..
The problem I am facing is . I have 2 database in my system now how to know which password file is associate.
lets say the pwdxxxx.ora xxxx is the database name right.
so that means you must have 2 password file. I have only one file so I created a password file for the other database with pwdxxxx.ora and I changed the password for it,now the problem i am facing is one of it work without any problem but when trying to connect the other database through internal or sys as sydba its showing error the former is showing their is no such user internal and later its not allowing . So what may be the possible reasons for that or whether you can create a seperate internal user etc... or how to retain back the internal user..

thanks again for the support

regards
bins

 

[rcurva]

be sure when you try to recreate the internal password of the other instance, you have set your ORACLE_SID properly
like;

export ORACLE_SID = instance2 (if u are in unix)

set ORACLE_SID = instance2 (in NT)