OraFAQ Forum: Backup & Recovery » RMAN-00554, RMAN-04005, ORA-0103

Home » RDBMS Server » Backup & Recovery » RMAN-00554, RMAN-04005, ORA-0103 (Oracle 11g, OEL 4.8)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN-00554, RMAN-04005, ORA-0103 [message #550076]

Thu, 05 April 2012 15:02

sureshd
Messages: 3
Registered: April 2012
Location: Bangalore

Junior Member

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 12288 times)

Report message to a moderator

Re: RMAN-00554, RMAN-04005, ORA-0103 [message #550077 is a reply to message #550076]

Thu, 05 April 2012 15:15

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You need a SYSDBA account to connect to target database.

Report message to a moderator

Re: RMAN-00554, RMAN-04005, ORA-0103 [message #550107 is a reply to message #550077]

Fri, 06 April 2012 01:13

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: RMAN-00554, RMAN-04005, ORA-0103 [message #550129 is a reply to message #550107]

Fri, 06 April 2012 03:59

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.

Report message to a moderator

Re: RMAN-00554, RMAN-04005, ORA-0103 [message #550134 is a reply to message #550129]

Fri, 06 April 2012 04:11

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: RMAN-00554, RMAN-04005, ORA-0103 [message #550152 is a reply to message #550134]

Fri, 06 April 2012 05:55

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.

Report message to a moderator

Re: RMAN-00554, RMAN-04005, ORA-0103 [message #550154 is a reply to message #550152]

Fri, 06 April 2012 06:21

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 00:52:04 CST 2025