Home » RDBMS Server » Server Administration » Cannot Cpen Database
Cannot Cpen Database [message #197301] Tue, 10 October 2006 22:47 Go to next message
gmkhaw@yahoo.com
Messages: 14
Registered: September 2006
Location: Malaysia
Junior Member

My oracle 9i database could not be opened automatically, it always stopped at the mounting phase stating error:
ORA-01991: Invalid password file [database path]\PWDxxx.ORA
This occurs after i have changed the admin password at my main database server but later i replaced the whole database folder from backup server (with old pwd).
Please help.
Re: Cannot Cpen Database [message #197312 is a reply to message #197301] Tue, 10 October 2006 23:36 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

SQL> startup
ORACLE instance started.

Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145488364 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
ORA-01990: error opening password file
'D:\oracle\product\10.1.0\Db_2\DATABASE\PWDorcl.ORA'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.


SQL> show parameter pass

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
SQL> shutdown;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> host orapwd file=d:\oracle\product\10.1.0\db_2\database\pwdorcl.ora passwor
d=oracle entries=5

SQL> startup
ORACLE instance started.

Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145488364 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
Database mounted.
Database opened.
SQL>



Try to create new password file.
Re: Cannot Cpen Database [message #197360 is a reply to message #197312] Wed, 11 October 2006 01:27 Go to previous messageGo to next message
gmkhaw@yahoo.com
Messages: 14
Registered: September 2006
Location: Malaysia
Junior Member

How to create new password file?
Re: Cannot Cpen Database [message #197373 is a reply to message #197360] Wed, 11 October 2006 01:47 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

cmd>orapwd file=d:\oracle\product\10.1.0\db_2\database\pwdorcl.ora passwor
d=oracle entries=5
Re: Cannot Cpen Database [message #197384 is a reply to message #197373] Wed, 11 October 2006 02:01 Go to previous messageGo to next message
gmkhaw@yahoo.com
Messages: 14
Registered: September 2006
Location: Malaysia
Junior Member

thanks, now it is working fine!
Re: Cannot Cpen Database [message #197391 is a reply to message #197384] Wed, 11 October 2006 02:13 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

You're Welcome
Previous Topic: dbms_stats.gather_schema_stats
Next Topic: Start up problem in oracle 9i on Windows XP professional 2002
Goto Forum:
  


Current Time: Fri Dec 02 13:52:22 CST 2016

Total time taken to generate the page: 0.08550 seconds