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
Thank you.
ReplyDeleteThanks but I would suggest reader to refer below link to get going:
ReplyDeletehttps://forums.oracle.com/forums/thread.jspa?threadID=1010435
Oracle 11g R2 Automated Script
ReplyDeletehttp://bilalhussaindba.blogspot.com/
Nice post, there is also a possibility
ReplyDeletehow to install Oracle in silent mode without using response file