1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

error ORA-0001:unable to open password file

Discussion in 'Server Administration and Options' started by tedinho123, Jul 4, 2014.

  1. tedinho123

    tedinho123 Active Member

    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    80
    hi guys,

    I deleted the old pawdfile and created a new file but i get the error 0RA 00001:unable to open password files

    orapwd file=c:\app\yoka.gael\product\11.2.0\dbhome_1\database\PWDstatdb.ora password=manager

    Please help??
     
  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Hi.
    1) check folder name in full-path
    orapwd file=c:\app\yoka.gael\product\11.2.0\dbhome_1\data base\PWDstatdb.ora password=manager - there is a gap character in database

    2) check right(permission) on folders for os-your_user
     
  3. tedinho123

    tedinho123 Active Member

    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    80
    I did not put any space in "database" still gives an error
     
  4. tedinho123

    tedinho123 Active Member

    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    80
    where do i check on folders in oracle??
     
  5. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Q: your user in Windows is included into ORA_DBA group?


    simple check:
    1) Presed key combination: Win+R
    write command: cmd
    2) in the opened window it is necessary to enter command:
    mkdir c:\testdir
    then second command:
    orapwd file=c:\testdir\PWDstatdb.ora password=manager


    see to link: Creating and Maintaining a Password File
     
  6. tedinho123

    tedinho123 Active Member

    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    80
    still giving error....also it is not allowing me to create a password, there is a user called yoka.gael but not working when trying to connect with that user bacause i dnt no the password

    orapwd file=c:\app\yoka.gael\product\11.2.0\dbhome_1\database\PWDstatdb.ora password=manager

    this how i want to create the passfile but gives an error
     
  7. tedinho123

    tedinho123 Active Member

    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    80
    i even removed the file PWDstatdb.ora and re-created a new file with the same name but still gives an error
     
  8. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,345
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You did STOP the database before you did any of this?
     
  9. tedinho123

    tedinho123 Active Member

    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    80
    when i use
    orapwd file=C:\app\yoka.gael\product\11.1.0\db_1\database \PWDstatdb.ora password=manager the error is produced
    OPW-00001: Unable to open password-file.
    But when I change a way orapwd file=D:\TTT\PWDstatdb.ora password=manager it works.

    Help???
     
  10. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Check, your user is the member of ORA_DBA group
    (
    net user your_user
    or
    net localgroup ora_dba
    ) .
     
  11. tedinho123

    tedinho123 Active Member

    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    80
    The user is yoka.gael
     

    Attached Files:

  12. tedinho123

    tedinho123 Active Member

    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    80
    but i cannot add any user i don't have the privileges to do so