Home » RDBMS Server » Backup & Recovery » RMAN-06433: error installing recovery catalog (Windows, oracle9i)
RMAN-06433: error installing recovery catalog [message #411275] Thu, 02 July 2009 23:10 Go to next message
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.
Re: RMAN-06433: error installing recovery catalog [message #411280 is a reply to message #411275] Thu, 02 July 2009 23:22 Go to previous messageGo to next message
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
Re: RMAN-06433: error installing recovery catalog [message #411291 is a reply to message #411280] Fri, 03 July 2009 00:15 Go to previous messageGo to next message
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.
Re: RMAN-06433: error installing recovery catalog [message #411298 is a reply to message #411291] Fri, 03 July 2009 00:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: RMAN-06433: error installing recovery catalog [message #411431 is a reply to message #411275] Fri, 03 July 2009 09:50 Go to previous message
BlackSwan
Messages: 25050
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.
Previous Topic: How to tell if a database has a recovery catalog
Next Topic: how to recover one table without any backup
Goto Forum:
  


Current Time: Fri Dec 09 19:40:25 CST 2016

Total time taken to generate the page: 0.11214 seconds