password file error

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

Somebody reply this ..?

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]

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

Quote:

---

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

---