RE: silent install of 12c & creation of test database
- From: "Pete Sharman" <pete.sharman@xxxxxxxxxx>
- To: <kylelf@xxxxxxxxx>, "'ORACLE-L'" <Oracle-L@xxxxxxxxxxxxx>
- Date: Tue, 16 Sep 2014 07:11:26 +1000
Kyle
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.
Other related posts:
