OraFAQ Forum: Backup & Recovery » RMAN-06433: error installing recovery catalog

Home » RDBMS Server » Backup & Recovery » RMAN-06433: error installing recovery catalog (Windows, oracle9i)

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

RMAN-06433: error installing recovery catalog [message #411275]

Thu, 02 July 2009 23:10

in.lukfai
Messages: 8
Registered: July 2008
Location: India

Junior Member

I get the error while create a catalog:

RMAN-06433: error installing recovery catalog

I tried to allocate more space to the table(even up to 500M), drop catalog and tried to create again still same problem.
Then I started from the crash by create new tablespace and still get the same error. Please tell me what have I done wrong
or what have I missed.

-- Create tablepsace to hold repository
CREATE TABLESPACE new
DATAFILE 'C:\ORACLE\ORADATA\subway\new.DBF' SIZE 50M REUSE
AUTOEXTEND ON NEXT 64K MAXSIZE 32767M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;

-- Create rman schema owner
CREATE USER rman IDENTIFIED BY rman
TEMPORARY TABLESPACE temp
DEFAULT TABLESPACE new
QUOTA UNLIMITED ON new;

GRANT connect, resource, recovery_catalog_owner TO rman;

RMAN> create catalog tablespace "NEW";

dbms_rcvcat package body created with compilation errors
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06433: error installing recovery catalog

or

RMAN> create catalog;

dbms_rcvcat package body created with compilation errors
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06433: error installing recovery catalog

SQL> select table_name,tablespace_name from all_tables where tablespace_name like 'NEW';

TABLE_NAME TABLESPACE_NAME
------------------------------ ------------------------------
RCVER NEW
DB NEW
CONF NEW
DBINC NEW
CKP NEW
TS NEW
TSATT NEW
DF NEW
DFATT NEW
OFFR NEW
RR NEW

TABLE_NAME TABLESPACE_NAME
------------------------------ ------------------------------
RT NEW
ORL NEW
RLH NEW
AL NEW
BS NEW
BP NEW
BCF NEW
CCF NEW
XCF NEW
BSF NEW
BDF NEW

TABLE_NAME TABLESPACE_NAME
------------------------------ ------------------------------
CDF NEW
XDF NEW
BRL NEW
BCB NEW
CCB NEW
SCR NEW
SCRL NEW
CONFIG NEW

30 rows selected.

Report message to a moderator

Re: RMAN-06433: error installing recovery catalog [message #411280 is a reply to message #411275]

Thu, 02 July 2009 23:22

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Please read OraFAQ Forum Guide before posting.

And follow the full process of Creating the Recovery Catalog

Report message to a moderator

Re: RMAN-06433: error installing recovery catalog [message #411291 is a reply to message #411280]

Fri, 03 July 2009 00:15

in.lukfai
Messages: 8
Registered: July 2008
Location: India

Junior Member

[quote title=ebrian wrote on Fri, 03 July 2009 09:52]Please read OraFAQ Forum Guide before posting.

I have read the about the Forum Guide but still not sure what have I done wrong. Could you please tell me so that I will be careful for next time.

Report message to a moderator

Re: RMAN-06433: error installing recovery catalog [message #411298 is a reply to message #411291]

Fri, 03 July 2009 00:31

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

Senior Member
Account Moderator

Quote:

I have read the about the Forum Guide but still not sure what have I done wrong. Could you please tell me so that I will be careful for next time.

For instance, "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Regards
Michel

Report message to a moderator

Re: RMAN-06433: error installing recovery catalog [message #411431 is a reply to message #411275]

Fri, 03 July 2009 09:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

  1* select keyword from V_$RESERVED_WORDS where keyword like 'NEW%'
SQL> /

KEYWORD
------------------------------
NEW

You should avoid using KEYWORD as object name.

Report message to a moderator

Previous Topic:	How to tell if a database has a recovery catalog
Next Topic:	how to recover one table without any backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 15:24:41 CST 2024