C:\>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Mon Feb 11 16:24:13 2013

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Enter user-name: sys@rcat as sysdba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create tablespace rcatts datafile 'c:\oradata\rcat\rcatts01.dbf' size 100m
autoextend on next 10m maxsize 500m;

Tablespace created.

SQL> create user rcat_user identified by rcat_user  quota unlimited on rcatts;

User created.

SQL> grant recovery_catalog_owner to rcat_user;

Grant succeeded.

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

no rows selected

SQL>

C:\>rman target=sys/rcat catalog=rcat_user/rcat_user@rcat

Recovery Manager: Release 11.2.0.1.0 - Production on Mon Feb 11 16:33:06 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: RCAT (DBID=579270447)
connected to recovery catalog database

RMAN> create catalog;

error creating config_update
ORACLE error from recovery catalog database: ORA-01950: no privileges on tablespace 'USERS'

ORACLE error from recovery catalog database: ORA-00942: table or view does not exist

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06433: error installing recovery catalog

RMAN> drop catalog;

recovery catalog owner is RCAT_USER
enter DROP CATALOG command again to confirm catalog removal

RMAN> drop catalog;

recovery catalog dropped

RMAN> create catalog;

error creating config_update
ORACLE error from recovery catalog database: ORA-01950: no privileges on tablespace 'USERS'

ORACLE error from recovery catalog database: ORA-00942: table or view does not exist

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06433: error installing recovery catalog

SQL> alter user rcat_user default tablespace rcatts quota unlimited on rcatts;

User altered.

SQL>  select default_tablespace from dba_users where username ='RCAT_USER';

DEFAULT_TABLESPACE
------------------------------
RCATTS

SQL>

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Neetesh>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Tue Feb 12 18:42:48 2013

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$database;

NAME
---------
RCAT


SQL> create tablespace catalogts datafile 'C:\oradata\RCAT\rcat01.dbf' size 100m
 autoextend on;

Tablespace created.



SQL> create user rcatt identified by rcatt default tablespace catalogts quota un
limited on catalogts;

User created.

SQL> grant recovery_catalog_owner to rcatt;

Grant succeeded.

SQL> alter user rcatt account unlock;

User altered.

SQL> exit;
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64
bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

C:\Users\Neetesh>rman target sys catalog rcatt/rcatt

Recovery Manager: Release 11.2.0.1.0 - Production on Tue Feb 12 18:49:58 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

target database Password:
connected to target database: RCAT (DBID=579270447)
connected to recovery catalog database

RMAN> create catalog;

recovery catalog created

RMAN> exit;


Recovery Manager complete.

C:\Users\Neetesh>rman target sys@myprodb catalog rcatt/rcatt

Recovery Manager: Release 11.2.0.1.0 - Production on Tue Feb 12 18:51:10 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

target database Password:
connected to target database: MYPRODB (DBID=703298088)
connected to recovery catalog database

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

RMAN>

Enter user-name: sys as sysdba