RE: silent install of 12c & creation of test database

Only a guess since I’ve never done both at once, but maybe because you need to run root.sh in between? If memory serves me correctly the passwords etc. are used more for automating backups, but I could be completely wrong on all of this – it’s happened before. :)  

I’ve always run a software only installation separate to creating the database – just personal foible I guess. :)  

Pete

Pete Sharman
Database Architect, DBaaS
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA

Phone: <tel:+61262924095> +61262924095 | | Fax: <fax:+61262925183> +61262925183 | | Mobile: +61414443449

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook  

"Oh no, it's not, it's much harder than that!"

Bruce Pihlamae, long term Oracle DBA

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of kyle Hailey Sent: Tuesday, September 16, 2014 6:26 AM To: ORACLE-L
Subject: silent install of 12c & creation of test database    

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