-
ORACLE 8i PASSWORD FILE
Hi, all
I have got a problem here. I want to change the password for 'internal' by using ORAPWD. I execute the task in this sequence:
1. Shutdown oracle 8i, stop all the services
2. Make sure REMOTE_LOGIN_PASSWORDFILE=exclusive
3. Set oracle_sid
4. Run orapwd file=xxx password=xxx
5. Start up oracle 8i
However, the password for internal is still the old one. I couldn't login using the new password. Did I miss any step? Thanks!
-
You need to delete the old password file, before creating it using orapwd.
HTH.
-
Thank you, ggnanaraj. I did delete the old password file before creating the new one. Is there any format required for password file name in 8i ? Thanks.
-
Originally posted by shenru
Thank you, ggnanaraj. I did delete the old password file before creating the new one. Is there any format required for password file name in 8i ? Thanks.
Yep! Password file name should be same as the old one you deleted.
HTH.
-
Shutdown the DB in server manager then shut down all oracle services and follow the following steps.
Make sure when you run the orapwd command that you are in the directory that your old password file is in. Rename your old password file PWDXXXXXX.OLD
For example from the DOS prompt
c:\cd oracle
c:\oracle\cd ora81
c:\oracle\ora81\cd database
c:\oracle\ora81\database\
Then type
orapwd (with the appropriate parameters)
Make sure that your new password file name is the same as your old one. PWDXXXXXX.ORA where XXXXXX is your SID.
This should do it for you.
Chester Ney
CODY Computer Services
System DBA
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
|