Pages

Wednesday, July 3, 2019

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

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

Login to Server 1 as oracle

cd $ORACLE_HOME/assistants/dbca/templates

check the available templates.
Server1:(WhiteDG)$ 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 White.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 FahadDB.dbc

Now copy FahadDB.dbc template from Server1 to Server2.
Ex:

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

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


No comments:

Post a Comment