OraFAQ Forum: Server Administration » Cannot Cpen Database

Home » RDBMS Server » Server Administration » Cannot Cpen Database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Cannot Cpen Database [message #197301]

Tue, 10 October 2006 22:47

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.

Report message to a moderator

Re: Cannot Cpen Database [message #197312 is a reply to message #197301]

Tue, 10 October 2006 23:36

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.

Report message to a moderator

Re: Cannot Cpen Database [message #197360 is a reply to message #197312]

Wed, 11 October 2006 01:27

gmkhaw@yahoo.com
Messages: 14
Registered: September 2006
Location: Malaysia

Junior Member

How to create new password file?

Report message to a moderator

Re: Cannot Cpen Database [message #197373 is a reply to message #197360]

Wed, 11 October 2006 01:47

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

Report message to a moderator

Re: Cannot Cpen Database [message #197384 is a reply to message #197373]

Wed, 11 October 2006 02:01

gmkhaw@yahoo.com
Messages: 14
Registered: September 2006
Location: Malaysia

Junior Member

thanks, now it is working fine!

Report message to a moderator

Re: Cannot Cpen Database [message #197391 is a reply to message #197384]

Wed, 11 October 2006 02:13

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

You're Welcome

Report message to a moderator

Previous Topic:	dbms_stats.gather_schema_stats
Next Topic:	Start up problem in oracle 9i on Windows XP professional 2002

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 12:01:19 CST 2024