Sunday, February 12, 2012

How to Install Oracle Database 11gR2 in Silent Mode

I need install Oracle DB 11gR2 to OVM in remote city via VPN.

The difficulty is via VPN, it's very slow to do normal installation with GUI via ssh.

So I decide to do silent installation without any GUI part involved.

Here is the workable response file sample for installation and configuration of  database.

You can use the below command to run the silent mode and after installation finish, run root.sh with root privilege.

 ./runInstaller -silent -responseFile /u01/app/oracle/data/db/database/db_install_new.rsp



oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
oracle.install.option=INSTALL_DB_AND_CONFIG
ORACLE_HOSTNAME=myhost.com.au
UNIX_GROUP_NAME=soa
INVENTORY_LOCATION=/home/soa/oraInventory
SELECTED_LANGUAGES=en
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
ORACLE_BASE=/u01/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.isCustomInstall=false
oracle.install.db.customComponents=oracle.server:11.2.0.1.0,oracle.sysman.ccr:10.2.7.0.0,oracle.xdk:11.2.0.1.0,oracle.rdbms.oci:11.2.0.1.0,oracle.network:11.2.0.1.0,oracle.network.listener:11.2.0.1.0,oracle.rdbms:11.2.0.1.0,oracle.options:11.2.0.1.0,oracle.rdbms.partitioning:11.2.0.1.0,oracle.oraolap:11.2.0.1.0,oracle.rdbms.dm:11.2.0.1.0,oracle.rdbms.dv:11.2.0.1.0,orcle.rdbms.lbac:11.2.0.1.0,oracle.rdbms.rat:11.2.0.1.0

oracle.install.db.DBA_GROUP=soa
oracle.install.db.OPER_GROUP=soa
oracle.install.db.CLUSTER_NODES=
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE/TRANSACTION_PROCESSING
oracle.install.db.config.starterdb.globalDBName=emcc
oracle.install.db.config.starterdb.SID=emcc
oracle.install.db.config.starterdb.characterSet=AL32UTF8
oracle.install.db.config.starterdb.memoryOption=true
oracle.install.db.config.starterdb.memoryLimit=512
oracle.install.db.config.starterdb.installExampleSchemas=false
oracle.install.db.config.starterdb.enableSecuritySettings=true
oracle.install.db.config.starterdb.password.ALL=welcome1
oracle.install.db.config.starterdb.password.SYS=welcome1
oracle.install.db.config.starterdb.password.SYSTEM=welcome1
oracle.install.db.config.starterdb.password.SYSMAN=welcome1
oracle.install.db.config.starterdb.password.DBSNMP=welcome1
oracle.install.db.config.starterdb.control=DB_CONTROL
oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=
oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=false
oracle.install.db.config.starterdb.dbcontrol.emailAddress=
oracle.install.db.config.starterdb.dbcontrol.SMTPServer=
oracle.install.db.config.starterdb.automatedBackup.enable=false
oracle.install.db.config.starterdb.automatedBackup.osuid=
oracle.install.db.config.starterdb.automatedBackup.ospwd=
oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=/u01/app/oracle/oradata
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=
oracle.install.db.config.asm.diskGroup=
oracle.install.db.config.asm.ASMSNMPPassword=
MYORACLESUPPORT_USERNAME=
MYORACLESUPPORT_PASSWORD=
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=false
PROXY_HOST=
PROXY_PORT=
PROXY_USER=
PROXY_PWD=


The way to create db instance via dbca silently:


<Oracle_Home>/bin/dbca -silent -createDatabase -templateName General_Purpose.dbc -sid emcc12c -gdbName emcc12c -emConfiguration LOCAL -storageType FS -datafileDestination /u01/app/oracle/product/11.2.0/oradata -datafileJarLocation /u01/app/oracle/product/11.2.0/dbhome_1/assistants/dbca/templates -responseFile /u01/app/oracle/data/db/db_install_new.rsp -characterset AL32UTF8 -obfuscatedPasswords false -sampleSchema false -oratabLocation /u01/app/oracle/product/11.2.0/dbhome_1/install/oratab -automaticMemoryManagement true -totalMemory 512 -maskPasswords false -oui_internal


4 comments:

  1. Thanks but I would suggest reader to refer below link to get going:

    https://forums.oracle.com/forums/thread.jspa?threadID=1010435

    ReplyDelete
  2. Oracle 11g R2 Automated Script

    http://bilalhussaindba.blogspot.com/

    ReplyDelete