Search This Blog

Monday, August 18, 2008

ORA-01991: invalid password file

Oracle Version: 10gr1

OS: Windows 2003 Server

In development db i was getting below error message during database startup in mount stage.

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-01991: invalid password file


above error occured after i refreshed development db from production db.

Clause: I was restore production db hot backup (user mananged) to development db and re-create oracle services and forget to create password file. so everything is new but the password file is old one. that is why i was getting ABOVE error during startup database.

Solution: Re-create the password file.

1. Stop oracle services

D:\oracle\product\10.1.0\Db_1\BIN>net stop oracleserviceSPIPR

The OracleServiceSPIPR service is stopping.......

The OracleServiceSPIPR service was stopped successfully.

2. Re-create password file through ORAPWD utility

D:\oracle\product\10.1.0\Db_1\BIN>orapwd file=D:\oracle\product\10.1.0\Db_1\database\pwdSPIPR.ORA password=oracle entries=5 force=Y

NOTE: FORCE=Y will re-create password file and replace any existing passwordfile.

3. start oracle database services

D:\oracle\product\10.1.0\Db_1\BIN>net stART oracleserviceSPIPR

The OracleServiceSPIPR service is starting......

The OracleServiceSPIPR service was started successfully.

D:\oracle\product\10.1.0\Db_1\BIN>sqlplus / as sysdba

SQL*Plus: Release - Production on Mon Aug 18 19:11:19 2008
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:

Oracle Database 10g Enterprise Edition Release - Production

With the Partitioning, OLAP and Data Mining options

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.
[output cut]

Database mounted.

Database opened.

No comments: