Home » RDBMS Server » Backup & Recovery » RMAN-00554, RMAN-04005, ORA-0103 (Oracle 11g, OEL 4.8)
RMAN-00554, RMAN-04005, ORA-0103 [message #550076] Thu, 05 April 2012 15:02 Go to next message
sureshd
Messages: 3
Registered: April 2012
Location: Bangalore
Junior Member
/forum/fa/10034/0/Hi I'm a newbie to Oracle DBA

I have a weird situation with this issue

I have 2 db's running ORCL - created using dbca &

TEST - created manually

when I try to login into RMAN with target as test db I get the following error

oracle@localhost ~]$ rman target system/manager@test

Recovery Manager: Release 11.1.0.6.0 - Production on Fri Apr 6 00:34:57 2012

Copyright (c) 1982, 2007, 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



and when I try to login into RMAN with target as ORCL and user as system I get the same error

oracle@localhost ~]$ rman target system/manager@orcl

Recovery Manager: Release 11.1.0.6.0 - Production on Fri Apr 6 00:35:13 2012

Copyright (c) 1982, 2007, 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


but to my surprise when I try to login with sys/password it works fine.

[oracle@localhost ~]$ rman target sys/********@orcl

Recovery Manager: Release 11.1.0.6.0 - Production on Fri Apr 6 00:35:52 2012

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

connected to target database: ORCL (DBID=1307590838)

RMAN>


tried a lot to solve this issue but nothing worked out.
  • Attachment: error.jpg
    (Size: 137.81KB, Downloaded 11188 times)
Re: RMAN-00554, RMAN-04005, ORA-0103 [message #550077 is a reply to message #550076] Thu, 05 April 2012 15:15 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You need a SYSDBA account to connect to target database.
Re: RMAN-00554, RMAN-04005, ORA-0103 [message #550107 is a reply to message #550077] Fri, 06 April 2012 01:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition, you need to read the documentation BEFORE using any tool or feature in Oracle:
Administrator's Guide
Database Backup and Recovery Basics
Database Backup and Recovery Reference
Database Backup and Recovery Advanced User's Guide

Regards
Michel

Re: RMAN-00554, RMAN-04005, ORA-0103 [message #550129 is a reply to message #550107] Fri, 06 April 2012 03:59 Go to previous messageGo to next message
sureshd
Messages: 3
Registered: April 2012
Location: Bangalore
Junior Member
I have checked this before if user system has SYSDBA priv's or not

select * from v$pwfile_users;
and the result was

USERNAME SYSDB SYSOP SYSAS
---------------------------------------
SYS TRUE TRUE FALSE
SYSTEM TRUE FALSE FALSE

this shows that user system has SYSDBA priv's but when I try to login into rman with user system/manager it gives the error I mentioned above while everything is fine with user SYS/********

Michael: I don't think anyone starts working on something like this without reading documentation.
Re: RMAN-00554, RMAN-04005, ORA-0103 [message #550134 is a reply to message #550129] Fri, 06 April 2012 04:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Michael: I don't think anyone starts working on something like this without reading documentation.


You do not explore the forum very often, do you? You will be surprised by the number of posts that is (or can be) answered by a link to the documentation.

Quote:
select * from v$pwfile_users;


On which database do you execute this statement?
Check in v$database, the DBID and DB NAME are the ones you get in RMAN: "connected to target database: ORCL (DBID=1307590838)".

Regards
Michel
Re: RMAN-00554, RMAN-04005, ORA-0103 [message #550152 is a reply to message #550134] Fri, 06 April 2012 05:55 Go to previous messageGo to next message
sureshd
Messages: 3
Registered: April 2012
Location: Bangalore
Junior Member
Nothing worked out so I finally deleted the old password file and re created a new password file and it works now. anyways thanks for your suggestions.

Michael: result of the query you wanted is in my previous reply.

Re: RMAN-00554, RMAN-04005, ORA-0103 [message #550154 is a reply to message #550152] Fri, 06 April 2012 06:21 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, I didn't ask for this query, I quoted your text to answer to it, the query I wanted was on v$database, sorry for the confusion.
Anyway, it does not matter now.

Regards
Michel
Previous Topic: Partly restore a database
Next Topic: How to Automate TDPOSYNC utility using pl/sql
Goto Forum:
  


Current Time: Fri Mar 29 10:31:16 CDT 2024