| 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.
|
|
|
|
|
| Re: RMAN-06433: error installing recovery catalog [message #411298 is a reply to message #411291] |
Fri, 03 July 2009 00:31   |
Michel Cadot Messages: 28991 Registered: March 2007 Location: Nanterre, France, http://... |
Senior Member |
|
|
| 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
|
|
|
|