Rman catalog Database creation

These are the steps for a catalog database creation

SAMPLE IS MY PRODUCTION DATABASE . THEN I HAVE CREATED A SEPERATE DATABASE FOR MY CATALOG BY USING DBCA.

target db_name =SAMPLE
catalog db_name =CATALOG

1.connect to the catalog database

a)here create a catalog tablespace

sql> create tablespace catalogThese are the steps for a catalog database creation

SAMPLE IS MY PRODUCTION DATABASE . THEN I HAVE CREATED A SEPERATE DATABASE FOR MY CATALOG BY USING DBCA.

target db_name =SAMPLE
catalog db_name =CATALOG

1.connect to the catalog database

a)here create a catalog tablespace

sql> create tablespace catalog
datafile ‘/……………………/catalog01.dbf’ size 250 m

b)create a user for recover catalog

sql> create user rmancat identified by rman
default tablespace catalog
default temporary tablespace temp
quota unlimited on catalog;

c)Grant the appropriate privilages.

sql>grant connect,resource,recover_catalog_owner to rmancat;

 

2. Login to the operating system
export ORACLE_SID=catalog

rman
rman> connect catalog rmancat/rman

rman>create catalog tablespace “CATALOG”

rman> exit

 

3.

a)Go to the listener.ora file.

Add the following highlighted entries then restart your listener.ora

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /home/oracle/oracle/product/10.2.0/db_4)

(PROGRAM = extproc)

)

(SID_DESC =

(ORACLE_HOME = /home/oracle/oracle/product/10.2.0/db_4)

(SID_NAME = sample)

)

(SID_DESC =

(ORACLE_HOME = /home/oracle/oracle/product/10.2.0/db_4)

(SID_NAME = catalog)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

)

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))

)

)

 

—————————————————————————————————–

>lsnrctl stop

>lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 – Production on 13-OCT-2008 13:31:14
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /home/oracle/oracle/product/10.2.0/db_4/bin/tnslsnr: please wait…

TNSLSNR for Linux: Version 10.2.0.1.0 – Production
System parameter file is /home/oracle/oracle/product/10.2.0/db_4/network/admin/listener.ora

Log messages written to /home/oracle/oracle/product/10.2.0/db_4/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

STATUS of the LISTENER

————————

Alias LISTENER

Version TNSLSNR for Linux: Version 10.2.0.1.0 – Production

Start Date 13-OCT-2008 13:31:15

Uptime 0 days 0 hr. 0 min. 3 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /home/oracle/oracle/product/10.2.0/db_4/network/admin/listener.ora

Listener Log File /home/oracle/oracle/product/10.2.0/db_4/network/log/listener.log

Listening Endpoints Summary…

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

Services Summary…

Service “PLSExtProc” has 1 instance(s).

Instance “PLSExtProc”, status UNKNOWN, has 1 handler(s) for this service…

Service “catalog” has 1 instance(s).

Instance “catalog”, status UNKNOWN, has 1 handler(s) for this service…

Service “sample” has 1 instance(s).

Instance “sample”, status UNKNOWN, has 1 handler(s) for this service…

The command completed successfully

 

you will found the above entries…

 

b)log in to the Operating system

export ORACLE_SID=sample
rman

rman> connect target sys/sys
rman>connect catalog rmancat/rman@catalog
rman > register database.

Now you configured your catalog database….

datafile ‘/……………………/catalog01.dbf’ size 250 m

b)create a user for recover catalog

sql> create user rmancat identified by rman
default tablespace catalog
default temporary tablespace temp
quota unlimited on catalog;

c)Grant the appropriate privilages.

sql>grant connect,resource,recover_catalog_owner to rmancat;

 

2. Login to the operating system
export ORACLE_SID=catalog

rman
rman> connect catalog rmancat/rman

rman>create catalog tablespace “CATALOG”

rman> exit

 

3.

a)Go to the listener.ora file.

Add the following highlighted entries then restart your listener.ora

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /home/oracle/oracle/product/10.2.0/db_4)

(PROGRAM = extproc)

)

(SID_DESC =

(ORACLE_HOME = /home/oracle/oracle/product/10.2.0/db_4)

(SID_NAME = sample)

)

(SID_DESC =

(ORACLE_HOME = /home/oracle/oracle/product/10.2.0/db_4)

(SID_NAME = catalog)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

)

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))

)

)

 

—————————————————————————————————–

>lsnrctl stop

>lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 – Production on 13-OCT-2008 13:31:14
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /home/oracle/oracle/product/10.2.0/db_4/bin/tnslsnr: please wait…

TNSLSNR for Linux: Version 10.2.0.1.0 – Production
System parameter file is /home/oracle/oracle/product/10.2.0/db_4/network/admin/listener.ora

Log messages written to /home/oracle/oracle/product/10.2.0/db_4/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

STATUS of the LISTENER

————————

Alias LISTENER

Version TNSLSNR for Linux: Version 10.2.0.1.0 – Production

Start Date 13-OCT-2008 13:31:15

Uptime 0 days 0 hr. 0 min. 3 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /home/oracle/oracle/product/10.2.0/db_4/network/admin/listener.ora

Listener Log File /home/oracle/oracle/product/10.2.0/db_4/network/log/listener.log

Listening Endpoints Summary…

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

Services Summary…

Service “PLSExtProc” has 1 instance(s).

Instance “PLSExtProc”, status UNKNOWN, has 1 handler(s) for this service…

Service “catalog” has 1 instance(s).

Instance “catalog”, status UNKNOWN, has 1 handler(s) for this service…

Service “sample” has 1 instance(s).

Instance “sample”, status UNKNOWN, has 1 handler(s) for this service…

The command completed successfully

 

you will found the above entries…

 

b)log in to the Operating system

export ORACLE_SID=sample
rman

rman> connect target sys/sys
rman>connect catalog rmancat/rman@catalog
rman > register database.

Now you configured your catalog database….

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s