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.

Create a free website or blog at WordPress.com.