Configure catalog in Oracle

1: Create a tablespace on the catalog Database:
Export Oracle_SID = ORCL
 
Create tablespace rmants datafile '/home/oracle/rman/rmants. ora' size 20 M;
 
Note: The tablespace name must not be rman. If it is rman, an error will be reported in the next operation because rman is a keyword;
 
2. Create a user on the catalog Database:
 
SQL> Create user rman identified by rman default tablespace rmants
 
2 temporary tablespace temp quota unlimited on rmants;
 
SQL> grant recovery_catalog_owner to rman;
 
In this example, two databases are on the same server.
 
Next, go to the target database.

1. [oracle @ aoracle admin] $ vi tnsnames. ora

Catalog =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.190.140) (PORT = 1521 ))
)
(CONNECT_DATA =
(SID = ORCL)
)
)
 
2. [oracle @ aoracle ~] $ Tnsping catalog
 
Check whether it can be connected.

1 2 Next Page