DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: password file error

Hybrid View

  1. #1
    Join Date
    Apr 2002
    Posts
    86
    How to remove this error..?

    SQL> connect internal;
    Connected.
    SQL> select name from v$database;

    NAME
    ---------
    AAAA

    SQL> shutdown abort
    ORACLE instance shut down.
    SQL> startup open;
    ORACLE instance started.

    Total System Global Area 86657052 bytes
    Fixed Size 75804 bytes
    Variable Size 56520704 bytes
    Database Buffers 29982720 bytes
    Redo Buffers 77824 bytes
    ORA-01990: error opening password file 'C:\oracle\ora81\DATABASE\PWDaaaa.ORA'

    Thanks
    Harry





  2. #2
    Join Date
    Apr 2002
    Posts
    86

    Unhappy

    Somebody reply this ..?

  3. #3
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    If you are on Unix

    check the name of your password file and the name if your sid

    Make sure the sid's case matches that of the environment variable ORACLE_SID. If the environment for ORACLE_SID is set to ORACLE_SID=TEST and the password file is name is orapwtest then you would encounter the ORA-01990.


    You can also try recreating the password file using the orapwd utility.

    [Edited by ronnie on 05-10-2002 at 04:52 PM]
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  4. #4
    Join Date
    Aug 2001
    Posts
    75
    It looks like yor are using Oracle on Windows , you can recreate password file by using orapwd utility. The location of password file is in ORACLE_HOME/dbs

    C:\>orapwd
    Usage: orapwd file= password= entries=

    where
    file - name of password file (mand),
    password - password for SYS and INTERNAL (mand),
    entries - maximum number of distinct DBA and OPERs (opt),
    There are no spaces around the equal-to (=) character.


    The other thing is what is try setting REMOTE_LOGIN_PASSWORDFILE = NONE
    in your init.ora parameter file.

    Sanjay


    Originally posted by harrygulls
    How to remove this error..?

    SQL> connect internal;
    Connected.
    SQL> select name from v$database;

    NAME
    ---------
    AAAA

    SQL> shutdown abort
    ORACLE instance shut down.
    SQL> startup open;
    ORACLE instance started.

    Total System Global Area 86657052 bytes
    Fixed Size 75804 bytes
    Variable Size 56520704 bytes
    Database Buffers 29982720 bytes
    Redo Buffers 77824 bytes
    ORA-01990: error opening password file 'C:\oracle\ora81\DATABASE\PWDaaaa.ORA'

    Thanks
    Harry




    OCP 8i

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