ORACLE_UNQNAME=ORCL
ORACLE_SID=ORCL2
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_2
orarac2poc:ORCL2:/home/oracle> export ORACLE_SID=RCAT
orarac2poc:RCAT:/home/oracle> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Fri Dec 28 09:52:49 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SYS@RCAT> select file_name from dba_data_files;
FILE_NAME
------------------------------------------------------------------------------------------------------------------------------------
+DGRCAT/rcat/datafile/system.261.803153779
+DGRCAT/rcat/datafile/sysaux.262.803153789
+DGRCAT/rcat/datafile/undotbs1.263.803153795
+DGRCAT/rcat/datafile/users.265.803153807
SYS@RCAT> create tablespace rman_tbs datafile '+DGRCAT/rcat/datafile/rman_tbs01.dbf' size 100m ;
Tablespace created.
SYS@RCAT> create user rman identified by rman123 default tablespace rman_tbs temporary tablespace temp;
User created.
orarac2poc:ORCL2:/home/oracle> rcat
orarac2poc:RCAT:/home/oracle> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Fri Dec 28 10:49:40 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SYS@RCAT> select * from dba_sys_privs where grantee='CONNECT';
GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
CONNECT CREATE SESSION NO
SYS@RCAT> grant create session, resource, recovery_catalog_owner to rman;
Grant succeeded.
SYS@RCAT> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
orarac2poc:RCAT:/home/oracle> cd $ORACLE_HOME
orarac2poc:RCAT:/u01/app/oracle/product/11.2.0/db_2> tnsping RCAT
TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 28-DEC-2012 10:51:05
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orarac2poc)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RCAT)))
OK (10 msec)
orarac2poc:RCAT:/u01/app/oracle/product/11.2.0/db_2> sqlplus rman/rman123@RCAT
SQL*Plus: Release 11.2.0.2.0 Production on Fri Dec 28 10:51:21 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
RMAN@RCAT> exit
orarac2poc:RCAT:/home/oracle> rman catalog rman/rman123@RCAT
Recovery Manager: Release 11.2.0.2.0 - Production on Fri Dec 28 10:54:40 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN> create catalog;
recovery catalog created
RMAN> exit
Recovery Manager complete.
orarac2poc:RCAT:/home/oracle> sqlplus rman/rman123@RCAT
SQL*Plus: Release 11.2.0.2.0 Production on Fri Dec 28 10:55:13 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
RMAN@RCAT> select object_name from user_objects;
OBJECT_NAME
--------------------------------------------------------------------------------------------------------------------------------
DB
DB_P
DB_U1
RMAN_SEQ
NODE
NODE_P
...
VPC_USERS_V
VPC_DATABASES_V
CFS_V
BCR_V
252 rows selected.
RMAN@RCAT> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
orarac2poc:RCAT:/home/oracle> sqlplus rman/rman123@RCAT
SQL*Plus: Release 11.2.0.2.0 Production on Fri Dec 28 10:56:04 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
RMAN@RCAT> select * from rc_database;
no rows selected
RMAN@RCAT> exit
References: