Home » RDBMS Server » Server Administration » ORA-00554 initialization of internal recovery manager package failed (10g, 10.2.0.4, windowXP)
ORA-00554 initialization of internal recovery manager package failed [message #582435] Thu, 18 April 2013 06:56 Go to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear All,

When I am issuing below command from auxiliary database, getting ORA-00554.
My tnsping is okay from both the side, remote login is exclusion. Password file is also okay.
I ran UTLRP.sql twice to complie invalid packages.



From Auxiliary Database


[ashish@localhost dbs]$ rman target sys/oracle@suman auxiliary /

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Apr 11 19:04:03 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges



Require your kind response...

Regards,
Ishika
Re: ORA-00554 initialization of internal recovery manager package failed [message #582440 is a reply to message #582435] Thu, 18 April 2013 07:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The problem is:
RMAN-04005: error from target database:
ORA-01031: insufficient privileges


Regards
Michel
Re: ORA-00554 initialization of internal recovery manager package failed [message #582441 is a reply to message #582435] Thu, 18 April 2013 07:05 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
What do you get when you run this from the same location:
sqlplus sys/oracle@suman as sysdba
Re: ORA-00554 initialization of internal recovery manager package failed [message #582512 is a reply to message #582441] Fri, 19 April 2013 00:33 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear John,


I changed the password in the target database by using the below command

SQL> alter user sys identified by oracle;

Then bounce back the database and then after I issued the below command in auxiliary database.


sqlplus sys/oracle@suman as sysdba

ERROR:
ORA-01031: insufficient privileges


How to rectify this privileges issues?

Regards,
Ishika

Re: ORA-00554 initialization of internal recovery manager package failed [message #582516 is a reply to message #582512] Fri, 19 April 2013 01:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Verify
1/ You point to the correct database
2/ You have a password file for this database
3/ The parameter remote_login_passwordfile is set to EXCLUSIVE

Regards
Michel
Re: ORA-00554 initialization of internal recovery manager package failed [message #582518 is a reply to message #582516] Fri, 19 April 2013 01:53 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear Michel,

1) i have pointed to correct database only.
2) Yes, both databases has password file.
3) Yes, it is EXCLUSIVE.

For your reference, i have copied the file below.


[suman@test dbs]$ ls -ls
total 6028
   8 -rw-rw----  1 suman oinstall    1544 Apr  5 12:12 hc_SUMAN.dat
  20 -rw-r-----  1 suman oinstall   12920 May  3  2001 initdw.ora
  16 -rw-r-----  1 suman oinstall    8385 Sep 11  1998 init.ora
   8 -rw-r--r--  1 suman oinstall    1015 Apr  5 12:12 initsuman.ora
   8 -rw-rw----  1 suman oinstall      24 Apr  5 12:23 lkSUMAN
   8 -rw-r-----  1 suman oinstall    2048 Apr  5 14:16 orapwsuman
5952 -rw-r-----  1 suman oinstall 6078464 Apr  5 13:42 snapcf_SUMAN.f
   8 -rw-r-----  1 suman oinstall    3584 Apr  5 16:51 spfileSUMAN.ora
[suman@test dbs]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 5 18:19:03 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> show parameter remote

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_archive_enable                string      true
remote_dependencies_mode             string      TIMESTAMP
remote_listener                      string
remote_login_passwordfile            string      EXCLUSIVE
remote_os_authent                    boolean     FALSE
remote_os_roles                      boolean     FALSE
SQL> select name from v$database;

NAME
---------
SUMAN

SQL>


Regards,
Ishika
Re: ORA-00554 initialization of internal recovery manager package failed [message #582519 is a reply to message #582518] Fri, 19 April 2013 02:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Rebuild the password file with the new SYS password.

Regards
Michel
Re: ORA-00554 initialization of internal recovery manager package failed [message #582521 is a reply to message #582518] Fri, 19 April 2013 02:07 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I think you are confused about whether your database instance is called suman or SUMAN. Try re-naming orapwsuman to orapwSUNAM
Re: ORA-00554 initialization of internal recovery manager package failed [message #582525 is a reply to message #582521] Fri, 19 April 2013 02:16 Go to previous message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Thank You Mr. John / Michel.

You have solved my problem. This is purely because of password file. When i created password file as orapwSUMAN, its connected to target database from auxiliary DB.

I have created pfile as initsuman but when i created spfile from pfile, spfile generated as spfileSUMAN which i ignored.

Thanks a lot.

Regards,
Ishika Smile
Previous Topic: ORA-12547: TNS:lost contact while login as sysdba
Next Topic: How to run ADDM report for the particular SQL stmt
Goto Forum:
  


Current Time: Thu Mar 28 11:39:33 CDT 2024