-
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.
-
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,
Cheers!
OraKid.
-
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".
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|