Change Internal Password

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

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

Quote:

---

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.

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

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

thnx,

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".