-
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
-
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|