ORACLE 8i PASSWORD FILE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ORACLE 8i PASSWORD FILE

Hybrid View

  1. #1
    Join Date
    May 2002
    Posts
    35

    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!

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    You need to delete the old password file, before creating it using orapwd.

    HTH.

  3. #3
    Join Date
    May 2002
    Posts
    35
    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.

  4. #4
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    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.

  5. #5
    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
  •  



Click Here to Expand Forum to Full Width