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