oracle aide

September 17, 2007

“…Do not create the recovery catalog in the SYS schema.”

Filed under: rman — oracleaide @ 7:51 pm

If I try to connect to the RMAN catalog as SYSDBA I get many encouraging errors, like:
    RMAN-04004: error from recovery catalog database:
    ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

Why? Probably because:
“…When RMAN connects to the recovery catalog database, it does not use the SYSDBA role. So, when you are using SQL*Plus to diagnose connection problems to the recovery catalog database, you must enter the catalog connect string exactly as it was entered into RMAN. Do not also specify AS SYSDBA.”

RMAN> connect catalog sys/password@127.0.0.1/tako

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04004: error from recovery catalog database: ORA-28009: connection as SYS
should be as SYSDBA or SYSOPER


RMAN> connect catalog sys/password@127.0.0.1/tako as sysdba

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "as": expecting one of: "newline, ;"
RMAN-01007: at line 1 column 41 file: standard input


As usual – reading manuals helps.

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: