silent install of 12c & creation of test database

From: kyle Hailey <kylelf_at_gmail.com>
Date: Mon, 15 Sep 2014 13:26:29 -0700
Message-ID: <CADsdiQiOxg0F_+b4Airc3yHQp12S4_XCXpiVCQawDDY3Qf54mg_at_mail.gmail.com>

I captured the response file form a database software install along with creation of a database.
If I run this response file as in

$ ./runInstaller -silent -responseFile `pwd`/install.rsp

it installs the software but not the database. Anyone know why?

Has anyone successfully done a silent install of both Oracle and creation of a database?

Here is my response file, captured from the GUI installer that both installed the software and created the database, but when run with silent mode only installs the software

$ cat install_gui.rsp

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.1.0 oracle.install.option=INSTALL_DB_AND_CONFIG ORACLE_HOSTNAME=localhost
UNIX_GROUP_NAME=dba
INVENTORY_LOCATION=/home/oracle/oraInventory SELECTED_LANGUAGES=en
ORACLE_HOME=/home/oracle/base/oracle12102 ORACLE_BASE=/home/oracle/base

oracle.install.db.InstallEdition=EE
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=dba
oracle.install.db.BACKUPDBA_GROUP=dba
oracle.install.db.DGDBA_GROUP=dba
oracle.install.db.KMDBA_GROUP=dba
oracle.install.db.rac.configurationType=
oracle.install.db.CLUSTER_NODES=
oracle.install.db.isRACOneInstall=false
oracle.install.db.racOneServiceName=
oracle.install.db.rac.serverpoolName=
oracle.install.db.rac.serverpoolCardinality=0
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName=orcl
oracle.install.db.config.starterdb.SID=orcl
oracle.install.db.ConfigureAsContainerDB=true
oracle.install.db.config.PDBName=pdborcl
oracle.install.db.config.starterdb.characterSet=WE8MSWIN1252
oracle.install.db.config.starterdb.memoryOption=false
oracle.install.db.config.starterdb.memoryLimit=6380
oracle.install.db.config.starterdb.installExampleSchemas=true
oracle.install.db.config.starterdb.password.ALL=
oracle.install.db.config.starterdb.password.SYS=sys
oracle.install.db.config.starterdb.password.SYSTEM=sys
oracle.install.db.config.starterdb.password.DBSNMP=sys
oracle.install.db.config.starterdb.password.PDBADMIN=sys
oracle.install.db.config.starterdb.managementOption=DEFAULT
oracle.install.db.config.starterdb.omsHost=
oracle.install.db.config.starterdb.omsPort=0
oracle.install.db.config.starterdb.emAdminUser=
oracle.install.db.config.starterdb.emAdminPassword=
oracle.install.db.config.starterdb.enableRecovery=false
oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=/home/oracle/base/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=true

PROXY_HOST=
PROXY_PORT=
PROXY_USER=
PROXY_PWD=

COLLECTOR_SUPPORTHUB_URL= I'd rather have a single response file that installed both the software and the database but as a workaround the following two response file seem to work in a two step process. The two step is first running runInstaller and then running dbca

the following seems to work.

# unzip files from Oracle
$ cd database
$ vi install.rsp
$ cat install.rsp

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.1.0

oracle.install.option=INSTALL_DB_SWONLY

ORACLE_HOSTNAME=perf250-target2

UNIX_GROUP_NAME=dba

INVENTORY_LOCATION=/home/oracle/oraInventory

SELECTED_LANGUAGES=en

ORACLE_HOME=/home/oracle/base/oracle12102

ORACLE_BASE=/home/oracle/base

oracle.install.db.InstallEdition=EE

oracle.install.db.DBA_GROUP=dba

oracle.install.db.BACKUPDBA_GROUP=dba

oracle.install.db.DGDBA_GROUP=dba

oracle.install.db.KMDBA_GROUP=dba

SECURITY_UPDATES_VIA_MYORACLESUPPORT=false

DECLINE_SECURITY_UPDATES=true

oracle.installer.autoupdates.option=SKIP_UPDATES

$ ./runInstaller -silent -responseFile `pwd`/install.rsp

The to create the database:

$ vi dbca.rsp
$ cat dbca.rsp

[GENERAL]
RESPONSEFILE_VERSION = "12.1.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "my12c"
SID = "my12c"
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD = "sys"
SYSTEMPASSWORD = "sys"
EMCONFIGURATION = "DBEXPRESS"
DBSNMPPASSWORD = "sys"
STORAGETYPE=FS
SAMPLESCHEMA=TRUE
$ dbca -silent -responseFile `pwd`/dbca.rsp

which creates the database.

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Sep 15 2014 - 22:26:29 CEST