Re: How to change Oracle internal password

depending what u mean with internal password. Oracle has two users internal and sys. When changing the password file the user sys password in not changed. So you have to change it when the database is in use. SQLPLUS> alter user sys identified by <password> then put the user sys in the password file by: SQLPLUS > grant sysdba to sys The password file contains now the user sys with the new password of sys. select * from v$pwfile_users shows which user are in the password file.

QUOTE]Originally posted by John Mak I running Oracle 8.1.6. on Win2K with database instance "prod" and would like to change the Oracle internal password. After I run "orapwd file=PWDprod.ora password=testing" and replaced the $ORACLE_HOME\database\PWDprod.ora with newly created one, I found that the Oracle internal password still not changed. Would someone tell me the rite procedure of doing that ?

Thanks, Giovanni

--
Ir. A.P. Djuly
Gabon Straat 5
2622 Delft
djuly_at_wanadoo.nl

Posted via dBforums
http://dbforums.com