Sunday, June 13, 2010

How to copy DBCA template from one DB Server to other DB Server? --Moid

  • Assuming you have two DB servers called Server1 and Server2 and you want to copy a database template called MoidDB from Server1 to Server2

  • Login to Server 1 as oracle

  • cd $ORACLE_HOME/assistants/dbca/templates

  • check the available templates.
    Server1:(PrimeDG)$ ls -tlrh
    total 112M
    -rw-r--r-- 1 oracle oinstall 6.8M Jan 6 17:10 Seed_Database.ctl
    -rw-r--r-- 1 oracle oinstall 5.6K Jan 6 17:10 Data_Warehouse.dbc
    -rw-r--r-- 1 oracle oinstall 5.6K Jan 6 17:10 Transaction_Processing.dbc
    -rw-r--r-- 1 oracle oinstall 92M Jan 6 17:10 Seed_Database.dfb
    -rw-r----- 1 oracle oinstall 6.3K Jan 6 17:10 RecoCAT.dbc
    -rw-r----- 1 oracle oinstall 6.2K Jan 6 17:10 Prime.dbc
    -rw-r--r-- 1 oracle oinstall 12K Jan 6 17:10 New_Database.dbt
    -rw-r----- 1 oracle oinstall 6.3K Jan 6 17:10 MoidDB.dbc
    -rw-r----- 1 oracle oinstall 6.3K Jan 6 17:10 MarsDB.dbc
    -rw-r----- 1 oracle oinstall 6.3K Jan 6 17:10 kaleemdba.dbc
    -rw-r----- 1 oracle oinstall 6.2K Jan 6 17:10 JayzeeDB.dbc
    -rw-r--r-- 1 oracle oinstall 5.5K Jan 6 17:10 General_Purpose.dbc
    -rw-r----- 1 oracle oinstall 6.1K Jan 6 17:10 FlashDB.dbc
    -rw-r--r-- 1 oracle oinstall 1.0M Jan 6 17:10 example.dmp
    -rw-r--r-- 1 oracle oinstall 13M Jan 6 17:10 example01.dfb
    -rw-r----- 1 oracle oinstall 6.2K Jan 6 17:10 alidb.dbc
    -rw-r----- 1 oracle oinstall 6.2K Jan 16 13:08 SamaDB.dbc

  • Now copy MoidDB.dbc template from Server1 to Server2.
    Ex:

    scp $ORACLE_HOME/assistants/dbca/templates/MoidDB.dbc Server2:$ORACLE_HOME/assistants/dbca/templates/.

  • Login to Server2 as oracle and verify $ORACLE_HOME/assistants/dbca/templates/MoidDB.dbc availability. Start DBCA and you will have your template.



References:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14196/install003.htm#i1008647

1 comment:

  1. Oracle database much better than ever......love it

    ReplyDelete

Followers