| ORA-00554 initialization of internal recovery manager package failed [message #582435] |
Thu, 18 April 2013 06:56  |
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 #582512 is a reply to message #582441] |
Fri, 19 April 2013 00:33  |
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 #582518 is a reply to message #582516] |
Fri, 19 April 2013 01:53 |
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 #582525 is a reply to message #582521] |
Fri, 19 April 2013 02:16 |
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 
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
