[oracle@e1lab bin]$ ./dbca -silent -clonetemplate -responsefile /home/oracle/dbca.rsp
Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
Look at the log file "/u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/dbca/shoaib21/shoaib21.log" for further details.
[oracle@e1lab bin]$ export ORACLE_SID=shoaib21
[oracle@e1lab bin]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 26 14:31:10 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select name from v$database;
NAME
_ __ __ __ __
SHOAIB21
#############################################################################
#############################################################################
Few of the parameters of the response file:-
[GENERAL]
RESPONSEFILE_VERSION = "10.0.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "shoaib21"
SID = "shoaib21"
TEMPLATENAME = "General Purpose"
#SYSPASSWORD = "oracle"
#SYSTEMPASSWORD = "oracle"
#EMCONFIGURATION = "central"
#SYSMANPASSWORD = "oracle"
#DBSNMPPASSWORD = "oracle"
#EMAILADDRESS =
#DATAFILEDESTINATION =
#STORAGETYPE=FS
#DISKGROUPNAME=DATA
#REDUNDANCY=NORMAL
#CHARACTERSET = "US7ASCII"
#NATIONALCHARACTERSET= "UTF8"
#WALLETPASSWORD= "password"
#LISTENERS = "listener1 listener2"
#MEMORYPERCENTAGE = "40"
#-----------------------*** End of CREATEDATABASE section ***------------------------
SOURCEDB = "myhost:1521:shoaib21"
SYSDBAUSERNAME = "system"
#SYSDBAPASSWORD = "oracle"
TEMPLATENAME = "My Copy TEMPLATE"
#-----------------------*** End of createTemplateFromDB section ***------------------------
[createCloneTemplate]
SOURCEDB = "orcl"
TEMPLATENAME = "My Clone TEMPLATE"
[DELETEDATABASE]
SOURCEDB = "orcl"
#-----------------------*** End of CONFIGUREDISKGROUPS section ***------------------------
Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
Look at the log file "/u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/dbca/shoaib21/shoaib21.log" for further details.
[oracle@e1lab bin]$ export ORACLE_SID=shoaib21
[oracle@e1lab bin]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 26 14:31:10 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select name from v$database;
NAME
_ __ __ __ __
SHOAIB21
#############################################################################
#############################################################################
Few of the parameters of the response file:-
[GENERAL]
RESPONSEFILE_VERSION = "10.0.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "shoaib21"
SID = "shoaib21"
TEMPLATENAME = "General Purpose"
#SYSPASSWORD = "oracle"
#SYSTEMPASSWORD = "oracle"
#EMCONFIGURATION = "central"
#SYSMANPASSWORD = "oracle"
#DBSNMPPASSWORD = "oracle"
#EMAILADDRESS =
#DATAFILEDESTINATION =
#STORAGETYPE=FS
#DISKGROUPNAME=DATA
#REDUNDANCY=NORMAL
#CHARACTERSET = "US7ASCII"
#NATIONALCHARACTERSET= "UTF8"
#WALLETPASSWORD= "password"
#LISTENERS = "listener1 listener2"
#MEMORYPERCENTAGE = "40"
#-----------------------*** End of CREATEDATABASE section ***------------------------
SOURCEDB = "myhost:1521:shoaib21"
SYSDBAUSERNAME = "system"
#SYSDBAPASSWORD = "oracle"
TEMPLATENAME = "My Copy TEMPLATE"
#-----------------------*** End of createTemplateFromDB section ***------------------------
[createCloneTemplate]
SOURCEDB = "orcl"
TEMPLATENAME = "My Clone TEMPLATE"
[DELETEDATABASE]
SOURCEDB = "orcl"
#-----------------------*** End of CONFIGUREDISKGROUPS section ***------------------------
No comments:
Post a Comment