<<Back to DB Administration Main Page
Step by Step How to Install and Create Oracle 18c Database in Silent Mode Using ASM
Installing oracle database is a lengthy process and therefore I have divided this post in 3 sectionsSection 1: Installing and Configuring GI for Standalone Server.
Step by Step instruction has been provided in post Step By Step How to Install Oracle 18c Grid Infrastructure for a Standalone Server in Silent Mode
Section 2: Installing Oracle 18c Database software in silent mode.
Section 3: Creating Oracle Database in silent mode
Once you have completed the section 1 you are ready to proceed with section 2 below.
Section 2: Installing Oracle 18c Database software in silent mode.
- Download the software
- Transfer the oracle database binary to the server
- Unzip the binaries
As oracle user unzip the software binary.
Note: Ensure to unzip the binary directly in the oracle home where you want to install the oracle software
$ unzip LINUX.X64_180000_db_home.zip -d /u01/dbatst1/18c/dbp1
- Create OS Groups and Users
login as root user, create required OS groups and users
#groupadd oinstall
#groupadd tst1dba
#groupadd dba
#useradd -g oinstall -G dba,tst1dba dbatst1
#groupadd tst1dba
#groupadd dba
#useradd -g oinstall -G dba,tst1dba dbatst1
- Create the required directories and change the ownership and permission
login as root user, Create required directories and change ownership and permission of the directory to the oracle installation user
#mkdir -p /u01/dbatst1/18c/dbp1
#chown -R dbatst1:oinstall /u01/dbatst1
#chmod -R 775 /u01/dbatst1
#chown -R dbatst1:oinstall /u01/dbatst1
#chmod -R 775 /u01/dbatst1
- Prepare the Response file
The template of response file is present in software. Navigate to the directory where you have unzipped the binaries and locate db_install.rsp. Backup the template before you modify it
$cp /u01/dbatst1/stage/install/response/db_install.rsp /u01/dbatst1/stage/install/response/db_install.rsp.orig
Modify the following in db_install.rsp file (adopt the value according to your environment)
$cp /u01/dbatst1/stage/install/response/db_install.rsp /u01/dbatst1/stage/install/response/db_install.rsp.orig
Modify the following in db_install.rsp file (adopt the value according to your environment)
oracle.install.option=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/oraInventory
ORACLE_BASE=/u01/dbatst1
oracle.install.db.InstallEdition=EE
oracle.install.db.OSDBA_GROUP=tst1dba
oracle.install.db.OSOPER_GROUP=tst1dba
oracle.install.db.OSBACKUPDBA_GROUP=tst1dba
oracle.install.db.OSDGDBA_GROUP=tst1dba
oracle.install.db.OSKMDBA_GROUP=tst1dba
oracle.install.db.OSRACDBA_GROUP=tst1dba
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/oraInventory
ORACLE_BASE=/u01/dbatst1
oracle.install.db.InstallEdition=EE
oracle.install.db.OSDBA_GROUP=tst1dba
oracle.install.db.OSOPER_GROUP=tst1dba
oracle.install.db.OSBACKUPDBA_GROUP=tst1dba
oracle.install.db.OSDGDBA_GROUP=tst1dba
oracle.install.db.OSKMDBA_GROUP=tst1dba
oracle.install.db.OSRACDBA_GROUP=tst1dba
Note: Starting from 18c It is not required to specify ORACLE_HOME in the response file for Database installation, because the its installed in the same directory where you extract the binary
- Perform Installation PreReqCheck
$/u01/dbatst1/18c/dbp1/runInstaller -silent -executePrereqs -responseFile /u01/dbatst1/18c/dbp1/install/response/db_install.rsp
Note:- Ensure to fix Error/Warning before you proceed ahead. I recommend you, not to use ignorePrereqFailure if you don't know the consequence. I am ignoring some warnings because I don't have enough memory in my server
Note:- Ensure to fix Error/Warning before you proceed ahead. I recommend you, not to use ignorePrereqFailure if you don't know the consequence. I am ignoring some warnings because I don't have enough memory in my server
NOTE: If you have role separation (which I have in my case) and you have installed oracle grid infrastructure/ASM as diffract OS Group and User than oracle software user then GI owner (in this example oragrid) must be the member of the primary group of oracle software owner (dbatst1)
# usermod -a -G tst1dba oragrid
- Execute silent DB Software installation
$ /u01/dbatst1/18c/dbp1/runInstaller -silent -ignorePrereqFailure -responseFile /u01/dbatst1/18c/dbp1/install/response/db_install.rsp
Launching Oracle Database Setup Wizard...
Launching Oracle Database Setup Wizard...
[WARNING] [INS-13014] Target environment does not meet some optional requirements.
CAUSE: Some of the optional prerequisites are not met. See logs for details. /u01/orainventory/logs/InstallActions2019-02-15_03-31-29PM/installActions2019-02-15_03-31-29PM.log
ACTION: Identify the list of failed prerequisite checks from the log: /u01/orainventory/logs/InstallActions2019-02-15_03-31-29PM/installActions2019-02-15_03-31-29PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
The response file for this session can be found at:
/u01/dbatst1/18c/dbp1/install/response/db_2019-02-15_03-31-29PM.rsp
CAUSE: Some of the optional prerequisites are not met. See logs for details. /u01/orainventory/logs/InstallActions2019-02-15_03-31-29PM/installActions2019-02-15_03-31-29PM.log
ACTION: Identify the list of failed prerequisite checks from the log: /u01/orainventory/logs/InstallActions2019-02-15_03-31-29PM/installActions2019-02-15_03-31-29PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
The response file for this session can be found at:
/u01/dbatst1/18c/dbp1/install/response/db_2019-02-15_03-31-29PM.rsp
You can find the log of this install session at:
/u01/orainventory/logs/InstallActions2019-02-15_03-31-29PM/installActions2019-02-15_03-31-29PM.log
/u01/orainventory/logs/InstallActions2019-02-15_03-31-29PM/installActions2019-02-15_03-31-29PM.log
As a root user, execute the following script(s):
1. /u01/dbatst1/18c/dbp1/root.sh
1. /u01/dbatst1/18c/dbp1/root.sh
Execute /u01/dbatst1/18c/dbp1/root.sh on the following nodes:
[test1]
[test1]
Successfully Setup Software with warning(s).
- Execute root.sh
login as root user and run root.sh
# /u01/dbatst1/18c/dbp1/root.sh
Check /u01/dbatst1/18c/dbp1/install/root_test16_2019-02-15_15-41-42-327743926.log for the output of root script
Check /u01/dbatst1/18c/dbp1/install/root_test16_2019-02-15_15-41-42-327743926.log for the output of root script
Section 3: Creating Oracle Database in silent mode
- Prepare the Response file for DBCA
Backup the original response file before modifying it
$cp /u01/dbatst1/18c/dbp1/assistants/dbca/dbca.rsp /u01/dbatst1/18c/dbp1/assistants/dbca/dbca.rsp_orig
gdbName=TST1T
sid=TST1T
databaseConfigType=SI
createAsContainerDatabase=true
templateName=/u01/dbatst1/18c/dbp1/assistants/dbca/templates/TPL_DB_18C.dbt
sysPassword=*******
systemPassword= **********
automaticMemoryManagement=false
sid=TST1T
databaseConfigType=SI
createAsContainerDatabase=true
templateName=/u01/dbatst1/18c/dbp1/assistants/dbca/templates/TPL_DB_18C.dbt
sysPassword=*******
systemPassword= **********
automaticMemoryManagement=false
NOTE: The content of the response file "/u01/dbatst1/18c/dbp1/assistants/dbca/templates/TPL_DB_18C.dbt" used in this example is provided below
- Run DBCA in Silent Mode to Create the Database
$ dbca -silent -createDatabase -responseFile /u01/dbatst1/18c/dbp1/assistants/dbca/dbca.rsp
Prepare for db operation
4% complete
Registering database with Oracle Restart
5% complete
Creating and starting Oracle instance
6% complete
7% complete
9% complete
Creating database files
12% complete
Creating data dictionary views
13% complete
16% complete
18% complete
19% complete
20% complete
21% complete
23% complete
Oracle JVM
28% complete
33% complete
39% complete
40% complete
Oracle Text
41% complete
42% complete
44% complete
Oracle Multimedia
54% complete
Oracle OLAP
58% complete
Oracle Spatial
59% complete
65% complete
Oracle Label Security
72% complete
Oracle Database Vault
79% complete
Creating cluster database views
80% complete
86% complete
Completing Database Creation
88% complete
89% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/u01/dbatst1/cfgtoollogs/dbca/TST1T.
Database Information:
Global Database Name:TST1T
System Identifier(SID):TST1T
Look at the log file "/u01/dbatst1/cfgtoollogs/dbca/TST1T/TST1T.log" for further details.
Prepare for db operation
4% complete
Registering database with Oracle Restart
5% complete
Creating and starting Oracle instance
6% complete
7% complete
9% complete
Creating database files
12% complete
Creating data dictionary views
13% complete
16% complete
18% complete
19% complete
20% complete
21% complete
23% complete
Oracle JVM
28% complete
33% complete
39% complete
40% complete
Oracle Text
41% complete
42% complete
44% complete
Oracle Multimedia
54% complete
Oracle OLAP
58% complete
Oracle Spatial
59% complete
65% complete
Oracle Label Security
72% complete
Oracle Database Vault
79% complete
Creating cluster database views
80% complete
86% complete
Completing Database Creation
88% complete
89% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/u01/dbatst1/cfgtoollogs/dbca/TST1T.
Database Information:
Global Database Name:TST1T
System Identifier(SID):TST1T
Look at the log file "/u01/dbatst1/cfgtoollogs/dbca/TST1T/TST1T.log" for further details.
============================================================
Template File "TPL_DB_18C.dbt" Content
============================================================
<DatabaseTemplate name="TPL_DB_18C.dbt" description="SI on ASM " version="18C">
<CommonAttributes>
<option name="OMS" value="true"/>
<option name="JSERVER" value="true"/>
<option name="SPATIAL" value="true"/>
<option name="IMEDIA" value="true"/>
<option name="ORACLE_TEXT" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="SAMPLE_SCHEMA" value="false"/>
<option name="CWMLITE" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="APEX" value="false"/>
<option name="DV" value="true"/>
</CommonAttributes>
<Variables/>
<CustomScripts Execute="false"/>
<InitParamAttributes>
<InitParams>
<initParam name="audit_file_dest" value="/u01/dbatest1/admin/TESTA/adump"/>
<initParam name="compatible" value="18.0.0"/>
<initParam name="remote_login_passwordfile" value="EXCLUSIVE"/>
<initParam name="undo_tablespace" value="UNDOTBS1"/>
<initParam name="diagnostic_dest" value="/u01/dbatest1"/>
<initParam name="db_block_size" value="8" unit="KB"/>
<initParam name="open_cursors" value="1000"/>
<initParam name="log_archive_dest_1" value="'LOCATION=+DATA'"/>
<initParam name="log_archive_format" value="TESTA_%T_%R_%S.arc"/>
<initParam name="archive_lag_target" value="1800" />
<initParam name="backup_tape_io_slaves" value="TRUE" />
<initParam name="control_file_record_keep_time" value="31"/>
<initParam name="db_create_file_dest" value="+DATA"/>
<initParam name="db_name" value="TEST"/>
<initParam name="db_domain" value="test"/>
<initParam name="thread" value="0"/>
<initParam name="memory_max_target" value="2048" unit="MB" />
<initParam name="memory_target" value="1280" unit="MB" />
<initParam name="java_pool_size" value="300" unit="MB"/>
<initParam name="db_create_online_log_dest_2" value="+DATA"/>
<initParam name="recyclebin" value="off" />
<initParam name="db_create_online_log_dest_1" value="+DATA"/>
<initParam name="db_block_checking" value="MEDIUM"/>
<initParam name="processes" value="1000"/>
<initParam name="db_block_checksum" value="FULL"/>
<initParam name="db_recovery_file_dest" value="+DATA"/>
<initParam name="audit_trail" value="DB"/>
<initParam name="db_recovery_file_dest_size" value="20" unit="GB"/>
</InitParams>
<MiscParams>
<databaseType>MULTIPURPOSE</databaseType>
<maxUserConn>20</maxUserConn>
<percentageMemTOSGA>40</percentageMemTOSGA>
<customSGA>false</customSGA>
<dataVaultEnabled>false</dataVaultEnabled>
<archiveLogMode>true</archiveLogMode>
<initParamFileName>/u01/dbatest1/admin/TESTA/pfile/init.ora</initParamFileName>
<characterSet>AL32UTF8</characterSet>
<nationalCharacterSet>AL16UTF16</nationalCharacterSet>
</MiscParams>
<SPfile useSPFile="true">/u01/dbatest1/18c/dbp1/dbs/spfileTEST.ora</SPfile>
</InitParamAttributes>
<StorageAttributes>
<ControlfileAttributes id="Controlfile">
<maxDatafiles>1024</maxDatafiles>
<maxLogfiles>192</maxLogfiles>
<maxLogMembers>3</maxLogMembers>
<maxLogHistory>1</maxLogHistory>
<maxInstances>32</maxInstances>
<image name="<OMF_CONTROL_0>" filepath="+DATA"/>
<image name="<OMF_CONTROL_1>" filepath="+DATA"/>
<image name="<OMF_CONTROL_2>" filepath="+DATA"/>
</ControlfileAttributes>
<DatafileAttributes id="<OMF_SYSAUX_DATAFILE_0>">
<tablespace>SYSAUX</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">120</size>
<reuse>false</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">10240</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="<OMF_SYSTEM_DATAFILE_0>">
<tablespace>SYSTEM</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">300</size>
<reuse>false</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">10240</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="<OMF_TEMP_DATAFILE_0>">
<tablespace>TEMP</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">20</size>
<reuse>false</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">640</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="<OMF_UNDOTBS1_DATAFILE_0>">
<tablespace>UNDOTBS1</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">200</size>
<reuse>false</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">5120</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="<OMF_USERS_DATAFILE_0>">
<tablespace>USERS</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">5</size>
<reuse>false</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">1280</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<TablespaceAttributes id="SYSAUX">
<online>true</online>
<offlineMode>1</offlineMode>
<readOnly>false</readOnly>
<temporary>false</temporary>
<defaultTemp>false</defaultTemp>
<undo>false</undo>
<local>true</local>
<blockSize>-1</blockSize>
<allocation>1</allocation>
<uniAllocSize unit="KB">-1</uniAllocSize>
<initSize unit="KB">64</initSize>
<increment unit="KB">64</increment>
<incrementPercent>50</incrementPercent>
<minExtends>1</minExtends>
<maxExtends>4096</maxExtends>
<minExtendsSize unit="KB">64</minExtendsSize>
<logging>true</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<autoSegmentMgmt>true</autoSegmentMgmt>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="<OMF_SYSAUX_DATAFILE_0>">
<id>-1</id>
</TablespaceDatafileAttributes>
</datafilesList>
</TablespaceAttributes>
<TablespaceAttributes id="SYSTEM">
<online>true</online>
<offlineMode>1</offlineMode>
<readOnly>false</readOnly>
<temporary>false</temporary>
<defaultTemp>false</defaultTemp>
<undo>false</undo>
<local>true</local>
<blockSize>-1</blockSize>
<allocation>3</allocation>
<uniAllocSize unit="KB">-1</uniAllocSize>
<initSize unit="KB">64</initSize>
<increment unit="KB">64</increment>
<incrementPercent>50</incrementPercent>
<minExtends>1</minExtends>
<maxExtends>-1</maxExtends>
<minExtendsSize unit="KB">64</minExtendsSize>
<logging>true</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<autoSegmentMgmt>true</autoSegmentMgmt>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="<OMF_SYSTEM_DATAFILE_0>">
<id>-1</id>
</TablespaceDatafileAttributes>
</datafilesList>
</TablespaceAttributes>
<TablespaceAttributes id="TEMP">
<online>true</online>
<offlineMode>1</offlineMode>
<readOnly>false</readOnly>
<temporary>true</temporary>
<defaultTemp>true</defaultTemp>
<undo>false</undo>
<local>true</local>
<blockSize>-1</blockSize>
<allocation>1</allocation>
<uniAllocSize unit="KB">-1</uniAllocSize>
<initSize unit="KB">64</initSize>
<increment unit="KB">64</increment>
<incrementPercent>0</incrementPercent>
<minExtends>1</minExtends>
<maxExtends>0</maxExtends>
<minExtendsSize unit="KB">64</minExtendsSize>
<logging>true</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<autoSegmentMgmt>true</autoSegmentMgmt>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="<OMF_TEMP_DATAFILE_0>">
<id>-1</id>
</TablespaceDatafileAttributes>
</datafilesList>
</TablespaceAttributes>
<TablespaceAttributes id="UNDOTBS1">
<online>true</online>
<offlineMode>1</offlineMode>
<readOnly>false</readOnly>
<temporary>false</temporary>
<defaultTemp>false</defaultTemp>
<undo>true</undo>
<local>true</local>
<blockSize>-1</blockSize>
<allocation>1</allocation>
<uniAllocSize unit="KB">-1</uniAllocSize>
<initSize unit="KB">512</initSize>
<increment unit="KB">512</increment>
<incrementPercent>50</incrementPercent>
<minExtends>8</minExtends>
<maxExtends>4096</maxExtends>
<minExtendsSize unit="KB">512</minExtendsSize>
<logging>true</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<autoSegmentMgmt>true</autoSegmentMgmt>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="<OMF_UNDOTBS1_DATAFILE_0>">
<id>-1</id>
</TablespaceDatafileAttributes>
</datafilesList>
</TablespaceAttributes>
<TablespaceAttributes id="USERS">
<online>true</online>
<offlineMode>1</offlineMode>
<readOnly>false</readOnly>
<temporary>false</temporary>
<defaultTemp>false</defaultTemp>
<undo>false</undo>
<local>true</local>
<blockSize>-1</blockSize>
<allocation>1</allocation>
<uniAllocSize unit="KB">-1</uniAllocSize>
<initSize unit="KB">128</initSize>
<increment unit="KB">128</increment>
<incrementPercent>0</incrementPercent>
<minExtends>1</minExtends>
<maxExtends>4096</maxExtends>
<minExtendsSize unit="KB">128</minExtendsSize>
<logging>true</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<autoSegmentMgmt>true</autoSegmentMgmt>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="<OMF_USERS_DATAFILE_0>">
<id>-1</id>
</TablespaceDatafileAttributes>
</datafilesList>
</TablespaceAttributes>
<RedoLogGroupAttributes id="1">
<reuse>false</reuse>
<fileSize unit="MB">2048</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="OMF_1_REDOLOG_MEMBER_0" filepath="+DATA"/>
<member ordinal="11" memberName="OMF_1_REDOLOG_MEMBER_1" filepath="+DATA"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="2">
<reuse>false</reuse>
<fileSize unit="MB">2048</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="OMF_2_REDOLOG_MEMBER_0" filepath="+DATA"/>
<member ordinal="6" memberName="OMF_2_REDOLOG_MEMBER_1" filepath="+DATA"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="3">
<reuse>false</reuse>
<fileSize unit="MB">2048</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="OMF_3_REDOLOG_MEMBER_0" filepath="+DATA"/>
<member ordinal="6" memberName="OMF_3_REDOLOG_MEMBER_1" filepath="+DATA"/>
</RedoLogGroupAttributes>
</StorageAttributes>
</DatabaseTemplate>
Comments
Post a Comment