Monday, June 11, 2012

oracle 10g database silent installation

[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 ***------------------------

No comments:

Post a Comment

ORA-12519: TNS:no appropriate service handler found error

ORA-12519: TNS: no appropriate service handler found error The real problem lies in the PROCESSES parameter All you need ...