OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Rman error (Linux)

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

Rman error [message #331302]

Wed, 02 July 2008 23:35

darshana01
Messages: 7
Registered: June 2008
Location: Bangalore

Junior Member

Hi,
I am getting the following error.Please guide me through this:

[oracle@trainee bin]$ ./rman catalog=sys/sys

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jul 3 09:48:27 2008

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-04004: error from recovery catalog database: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

******
Please help!! Smile

Report message to a moderator

Re: Rman error [message #331310 is a reply to message #331302]

Wed, 02 July 2008 23:47

varu123
Messages: 754
Registered: October 2007

Senior Member

Did you grant sysdba privilege to catalog owner?

Report message to a moderator

Re: Rman error [message #331311 is a reply to message #331302]

Wed, 02 July 2008 23:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

What does your documented & tested Recovery Manual say to do?

Report message to a moderator

Re: Rman error [message #331316 is a reply to message #331310]

Thu, 03 July 2008 00:06

darshana01
Messages: 7
Registered: June 2008
Location: Bangalore

Junior Member

yes i did grant the privilage.

Report message to a moderator

Re: Rman error [message #331318 is a reply to message #331316]

Thu, 03 July 2008 00:11

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

darshana01 wrote on Wed, 02 July 2008 22:06

yes i did grant the privilage.

So, what do you do now?

Report message to a moderator

Re: Rman error [message #331325 is a reply to message #331302]

Thu, 03 July 2008 00:44

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

Senior Member
Account Moderator

You do not need sysdba priv for the catalog owner.
Overkill.
Just make sure you are logging in as the correct catalog owner.
SYS should NOT BE CATALOG owner.
Create a separate rman user with NECESSARY privs.
By default

--wont work.
oracle@gretel#rman catalog=sys/sys

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jul 3 01:36:39 2008

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-04004: error from recovery catalog database: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

-- will not work
oracle@gretel#rman catalog=sys/sys@rmandb

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jul 3 01:36:46 2008

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-04004: error from recovery catalog database: ORA-28009: connection to sys should be as sysdba or sysoper

-- login as correct catalog owner to RMANDB
oracle@gretel#rman catalog=r_xxx/rman@rmandb

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jul 3 01:36:54 2008

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

connected to recovery catalog database

RMAN> exit


Recovery Manager complete

Report message to a moderator