ORACLE 8i PASSWORD FILE

[shenru]

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!

[ggnanaraj]

You need to delete the old password file, before creating it using orapwd.

HTH.

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

[ggnanaraj]

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.

[sirhaggus]

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.