My understanding is that the password file is only used to authenticate
users that are authorized to perform database administration functions.
Changing the password in the password file does not change the password for
SYS in ORACLE'S data dictionary. If you connect to ORACLE as SYS and issue
the SQL statement 'ALTER USER SYS IDENTIFIED BY whatever;' it will change
the password in both the data dictionary and the password file.
Scott Patterson wrote in message <35b0c2f8.0_at_feed1.realtime.net>...
>I must be missing some thing easy but I am just not seeing it. I am trying
>to change the internal password.
>
>The database (oracle 7.3.4) is on a DEC Alpha running OSF/1 v.4.0F
>
>orapwd creates the password file but the instance obviously is not using
it.
>I did see that on DEC UNIX the file was supposed to be in $ORACLE_HOME/dbs
>and have the name orapw<sid> (which is not the original file name I
tried).
>
>The command I used is
>orapwd file=/oracle7/app/oracle/product/7.3.4/dbs/orapwora7
>password=newpassword entries=20
>
>ORACLE_HOME is
>/oracle7/app/oracle/product/7.3.4
>
>ORACLE_SID is ora7
>
>
>I stop and start the instance, but the internal password is not changed.
>
>Anyone see what I am missing?
>
>Scott
>
>
Received on Mon Jul 20 1998 - 15:40:54 CDT
