Change Internal Password

[RBRIENDA]

Hi Everybody

At the moment I'm working with OEM 8i release 8.1.6 and migrating for OEM 9i on NT2000 platform and I've been problem when I tried to change the Internal/Sys user password. I used the command ORADIM and ORAPWD, but now I get connect with my old/new password. I don't Know what's happening. I think that have many people ( user ) with the same problem. Please, I hope that anyone can solve my problem.

Thank´s

[gandolf989]

Sometimes rebooting after changing the internal password works. Of course you know that Oracle 9i does not have internal or svrmgrl.

[julian]

I've been problem when I tried to change the Internal/Sys user password

Internal is not exactcly same as SYS. The password file is meant for INTERNAL not for SYS. Let me explain it with an example:

You have the default password for SYS change_on_install. Then you connect as SYS:

$sqlplus /nolog
SQL>connect sys/change_on_install
Connected.

Now create the password file:

$orapwd file=orapwABC password=xyz entries=3

Now, try again:

$sqlplus /nolog
SQL>connect internal
Connected.

Startup the instance

SQL>connect sys/change_on_install
Connected.

connect sys/change_on_install as sysdba
Now you get ORA-01017: invalid password

The difference is that SYS connecting as SYSDBA is like INTERNAL, they both use the password file, SYS however, uses its own password.

[balajiyes]

where will this orapwd file reside in sun machine?
we tried but getting error

wht should by "FILE = " (imean the file parameter)

thnx,

[julian]

The name of the password file must be of the format $ORACLE_HOME/dbs/orapw{$ORACLE_SID }because the name and location of the password file is hard coded in the file "sparams.h" (the line is: # define SS_SIDPWFILE_DEFAULT "?/dbs/orapw@"). Thus, the file must be put in the "dbs" directory and named "orapw".