password file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: password file

  1. #1
    Join Date
    Mar 2001
    Posts
    65
    mine is 8.1.6.3 on hpux 11.o

    while creating a database the instance is looking for the password file under $HOME/dbs

    why?

    even when i used orapwd to create a new password file the problem persisted.i had to change remote_login_passwordfile to none to be able to go ahead.

    thanks

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    The password file must be under $ORACLE_HOME/dbs
    The file name MUST be "orapw" and you must use the SID for the database in which the password file is being created. Do not add an extension to the file name.

    Do the following:

    1. Shutdown immediate the database.

    2. cd $ORACLE_HOME/dbs.

    3. orapwd file=orapw password= entries=

    4. In the init.ora file, add REMOTE_LOGIN_PASSWORDFILE=exclusive

    5. Startup the database.





  3. #3
    Join Date
    Mar 2001
    Posts
    65
    thanks Julian


  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Did it work?

  5. #5
    Join Date
    Mar 2001
    Posts
    65
    i can't bring the DB down so i haven't tried yet.

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    OK, try it when you have the dowtime.


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