I am in the process of converting the Single instance to RAC (2 node) using dbca.
SI is on Node A on ext3 filesystem.
RAC nodes are : Node A (SI lies on same node Local FS )
Node B
Using dbca from SI oracle home, i created a Template.
This template is not visible, when i try to Create db by invoking dbca from RAC oracle home ??
Am i missing something ??
Is my SI node also has to be on cluster, before converting to RAC???
I am using 10.2 on linux, with ocfs2 as shared FS.
Thx.
------------------------------------------------------------------------ The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway
If you want the new home to see the template, you should go to the old
ORACLE_HOME/assistants/dbca/templates and copy all the relevant files to the NEW_ORACLE_HOME/assistants/dbca/templates
Not sure however if this is the best method
If you want the new home to see the template, you should go to the old
ORACLE_HOME/assistants/dbca/templates and copy all the relevant files to the NEW_ORACLE_HOME/assistants/dbca/templates
Not sure however if this is the best method
Thanx BORE, It worked.
------------------------------------------------------------------------ The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway
When i take the backup as templates, what exactly oracle writes there ??
The dbca says it consits of structre as well as actual datafiles etc.
But when i check the template folder size, it is very small.
Thx.
Last edited by bang_dba; 11-28-2007 at 08:09 AM.
------------------------------------------------------------------------ The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway
Definaitely it writes data. DBCA itself says that during template creations. Also it says that i stores data in compressed form.
I observed it is almost 1:10 rate compression.
I am just wondering how it takes the backup.....becoz it is not exact image copies.
Whether it is RMAN type OR export Import type Or SQL queries etc ????????????????
------------------------------------------------------------------------ The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway
Reply With Quote
Originally Posted by Bore
Bookmarks