Windows Support Tools

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Monday, 30 July 2012

ORA-01991: invalid password file

Posted on 02:47 by Unknown

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
'D:\oracle\product\10.1.0\Db_1\DATABASE\PWDspipr.ORA'
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 10.1.0.2.0 - 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 10.1.0.2.0 - 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.
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Posted in | No comments
Newer Post Older Post Home

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • What is Cloud Computing ?
  • Removing the complexity from information protection
    How encryption can add value to your business The use of encryption is no longer optional for many organizations. Certain new regulations de...
  • Setting up a DHCP server in Windows 2003
    The DHCP server assigns a client an IP address taken from a predefined scope for a given amount of time. If an IP address is required for lo...
  • Five ways to fix Outlook connectivity issues
    1. Confirm that Outlook is actually the problem. First, you need to confirm the problem truly is related to Outlook. Identify which users a...
  • Manage your home network better with Network Magic 5.0
    Cisco announced on Thursday Network Magic 5.0, a suite of network management software. This is is the first product released by Cisco since ...
  • Why ignore the tips given by the foreign intelligence unit about approaching 2 Black Tigers to Jeyaraj?
    (Lanka-e-news, 7th April 2008, 11.30pm) It is revealed by now that Minister Jeyaraj Fernandopulle was assassinated due to lack of security, ...
  • Cartoons of the Week
  • A light-weight system monitor
    Conky is a free, light-weight system monitor for X, that displays any information on your desktop. Conky is licensed under the GPL and runs ...
  • Exchange Server 2010 Beta available
    Microsoft Exchange Server 2010 brings a new and rich set of technologies, features, and services to the Exchange Server product line. This t...
  • Linux version of XAMPP
    Step 1: Download Simply click on one of the links below. It's a good idea to get the latest version. :) A complete list of downloads (ol...

Categories

  • ISA Firewall
  • ISA Server 2006
  • Quick Tips
  • Reports
  • Tips

Blog Archive

  • ►  2013 (7)
    • ►  October (6)
    • ►  February (1)
  • ▼  2012 (10)
    • ►  September (3)
    • ►  August (3)
    • ▼  July (3)
      • ORA-01991: invalid password file
      • Removing an Automatic Storage Management Instance
      • The value of the environment variable PATH is more...
    • ►  June (1)
  • ►  2011 (16)
    • ►  August (2)
    • ►  July (4)
    • ►  June (3)
    • ►  May (1)
    • ►  April (1)
    • ►  March (4)
    • ►  January (1)
  • ►  2010 (12)
    • ►  December (3)
    • ►  October (4)
    • ►  March (1)
    • ►  January (4)
  • ►  2009 (67)
    • ►  August (2)
    • ►  July (18)
    • ►  June (23)
    • ►  April (3)
    • ►  March (6)
    • ►  February (7)
    • ►  January (8)
  • ►  2008 (319)
    • ►  December (30)
    • ►  November (43)
    • ►  October (45)
    • ►  September (12)
    • ►  August (18)
    • ►  July (27)
    • ►  June (15)
    • ►  May (7)
    • ►  April (55)
    • ►  March (65)
    • ►  January (2)
  • ►  2007 (10)
    • ►  December (2)
    • ►  November (8)
Powered by Blogger.

About Me

Unknown
View my complete profile