Oracle 11g Silent Installation Software + manual database creation

Oracle 11g Silent Installation Software + manual database creation

Because it is a secondary jump + remote operation, the GUI cannot be used and cannot be directly installed on the GUI. Use silent software installation + manual database creation to complete the requirement.

1. Install the Oracle software in silent mode and configure the listener

2. manual database creation

3. check whether all components meet the requirements.

1. Install the Oracle software in silent mode and configure the listener

The installation packages on which all Oracle software depends are installed by default, and relevant operating system parameters are adjusted.
For more information about the preparations before installing the software, see: Quick Reference for installation and deployment configuration of oracle 11G Single Instance on Linux

Decompress the database installation package. In the response folder of the database folder, there is a configuration file db_install.rsp. modify this configuration file as needed.

Cd./database/response/
Db_install.rsp // install the database software

Note that this option DECLINE_SECURITY_UPDATES = true. The default value is false. Change it to true.
$./RunInstaller-silent-force-ignorePrereq-ignoreSysPrereqs-responseFile/data/database/response/db_install.rsp
Starting Oracle Universal Installer...

Check temporary space: it must be greater than 120 MB. Actually 8122 MB passed
Check swap space: it must be greater than 150 MB. Actually 255999 MB passed
Prepare to start Oracle Universal Installer/tmp/OraInstall2015-07-09_01-40-01PM from the following address. please wait... [oracle @ CRNOPHQDW12 database] $ [WARNING] [INS-32055] the list of main products is located in the Oracle base directory.
Cause: the main product list is located in the Oracle base directory.
Operation: We recommend that you place this main product list outside the Oracle base directory.
You can find the log of this installation session in the following locations:
/Opt/app/oracle/oraInventory/logs/installActions2015-07-09_01-40-01PM.log
Oracle Database 11g has been installed successfully.
For more information, see '/opt/app/oracle/oraInventory/logs/silentInstall2015-07-09_01-40-01PM.log.

Run the following script as the root user:
1./opt/app/oracle/oraInventory/orainstRoot. sh
2./opt/app/oracle/product/11.2.0/dbhome_1/root. sh

Successfully Setup Software.

Then, follow the prompts that the root user executes 2 scripts. For the execution result of 2nd scripts, see the log file displayed on the screen.

For details about db_install.rsp modification, refer to (because only software is installed and the relevant database is not modified ):
#------------------------------------------------------------------------------
# Do not change the following system generated value.
#------------------------------------------------------------------------------
Oracle. install. responseFileVersion =/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0

#------------------------------------------------------------------------------
# Specify the installation option.
# It can be one of the following:
#-INSTALL_DB_SWONLY
#-INSTALL_DB_AND_CONFIG
#-UPGRADE_DB
#-------------------------------------------------------------------------------
Oracle. install. option = INSTALL_DB_SWONLY

#-------------------------------------------------------------------------------
# Specify the hostname of the system as set during the install. It can be used
# To force the installation to use an alternative hostname rather than using
# First hostname found on the system. (e.g., for systems with multiple hostnames
# And network interfaces)
#-------------------------------------------------------------------------------
ORACLE_HOSTNAME = CRNOPHQDW12

#-------------------------------------------------------------------------------
# Specify the Unix group to be set for the inventory directory.
#-------------------------------------------------------------------------------
UNIX_GROUP_NAME = oinstall
#-------------------------------------------------------------------------------
# Specify the location which holds the inventory files.
# This is an optional parameter if installing on
# Windows based Operating System.
#-------------------------------------------------------------------------------
INVENTORY_LOCATION =/opt/app/oracle/oraInventory

#-------------------------------------------------------------------------------
# Specify the versions in which the components will be installed.
#
# En: English ja: Japan
# Fr: French ko: Korean
# Ar: Arabic es: Latin American Spanish
# Bn: Bengali lv: Latvian
# Pt_BR: Brazilian Portuguese lt: Lithuanian
# Bg: Bulgarian MS: Malay
# Fr_CA: Canadian French es_MX: Mexican Spanish
# Ca: Catalan no: Norwegian
# Hr: Croatian pl: Polish
# Cs: Czech pt: Portuguese
# Da: Danish ro: Romanian
# Nl: Dutch ru: Russian
# Ar_EG: Egyptian zh_CN: Simplified Chinese
# En_GB: English (Great briain) sk: Slovak
# Et: Estonian sl: Slovenian
# Fi: Finnish es_ES: Spanish
# De: German sv: Swedish
# El: Greek th: Thai
# Iw: Hebrew zh_TW: Traditional Chinese
# Hu: Hungarian tr: Turkish
# Is: Icelandic uk: Ukrainian
# In: Indonesian vi: Vietnamese
# It: Italian
#
# All_langs: All Ages
#
# Specify value as the following to select any of the versions.
# Example: selected_ages = en, fr, ja
#
# Specify value as the following to select all the versions.
# Example: selected_ages = all_langs
#------------------------------------------------------------------------------
Selected_ages = en, zh_CN

#------------------------------------------------------------------------------
# Specify the complete path of the Oracle Home.
#------------------------------------------------------------------------------
ORACLE_HOME =/opt/app/oracle/product/11.2.0/dbhome_1
#------------------------------------------------------------------------------
# Specify the complete path of the Oracle Base.
#------------------------------------------------------------------------------
ORACLE_BASE =/opt/app/oracle

#------------------------------------------------------------------------------
# Specify the installation edition of the component.
#
# The value shoshould contain only one of these choices.
#-EE: Enterprise Edition
#-SE: Standard Edition
#-SEONE: Standard Edition One
#-PE: Personal Edition (windows only)
#------------------------------------------------------------------------------
Oracle. install. db. InstallEdition = EE

#------------------------------------------------------------------------------
# This variable is used to enable or disable custom install and is considered
# Only if InstallEdition is EE.
#
# True: Components mentioned as part of 'optionalcomponents' property
# Are considered for install.
# False: Value for 'optionalcomponents' is not considered.
#------------------------------------------------------------------------------
Oracle. install. db. EEOptionsSelection = false

#------------------------------------------------------------------------------
# This variable is considered only if 'eeoptionsselection 'is set to true.
#
# Description: List of Enterprise Edition Options you wowould like to enable.
#
# The following choices are available. You may specify any
# Combination of these choices. The components you choose showould
# Be specified in the form "internal-component-name: version"
# Below is a list of components you may specify to enable.
#
# Oracle. oraolap: 11.2.0.4.0-Oracle OLAP
# Oracle. rdbms. dm: 11.2.0.4.0-Oracle Data Mining
# Oracle. rdbms. dv: 11.2.0.4.0-Oracle Database Vault
# Oracle. rdbms. lbac: 11.2.0.4.0-Oracle Label Security
# Oracle. rdbms. partitioning: 11.2.0.4.0-Oracle Partitioning
# Oracle. rdbms. rat: 11.2.0.4.0-Oracle Real Application Testing
#------------------------------------------------------------------------------
Oracle. install. db. optionalComponents = oracle. rdbms. partitioning: 11.2.0.4.0, oracle. oraolap: 11.2.0.4.0, oracle. rdbms. dm: 11.2.0.4.0, oracle. rdbms. dv: 11.2.0.4.0, or
Acle. rdbms. lbac: 11.2.0.4.0, oracle. rdbms. rat: 11.2.0.4.0
#------------------------------------------------------------------------------
# The DBA_GROUP is the OS group which is to be granted OSDBA privileges.
#------------------------------------------------------------------------------
Oracle. install. db. DBA_GROUP = dba

#------------------------------------------------------------------------------
# The OPER_GROUP is the OS group which is to be granted OSOPER privileges.
# The value to be specified for OSOPER group is optional.
#------------------------------------------------------------------------------
Oracle. install. db. OPER_GROUP =

#------------------------------------------------------------------------------
# Specify whether user doesn' t want to configure Security Updates.
# The value for this variable shocould be true if you don't want to configure
# Security Updates, false otherwise.
#
# The value can be either true or false. If left blank it will be assumed
# To be false.
#
# Example: DECLINE_SECURITY_UPDATES = false
#------------------------------------------------------------------------------
DECLINE_SECURITY_UPDATES = true

Netca. rsp does not need to be modified. You can directly create a listener.

Netca-silent-responsefile/data/database/response/netca. rsp
Netca silent listener creation:
$ Netca-silent-responsefile/data/database/response/netca. rsp

Syntax analysis on command line parameters:
Parameter "silent" = true
Parameter "responsefile" =/data/database/response/netca. rsp
Complete the syntax analysis of command line parameters.
Oracle Net Services Configuration:
Complete the profile configuration.
Oracle Net Listener startup:
Running Listener Control:
/Opt/app/oracle/product/11.2.0/dbhome_1/bin/lsnrctl start LISTENER
The Listener Control is completed.
The listener has been started successfully.
The Listener Configuration is complete.
The Oracle Net Services configuration is successfully completed. Exit code is 0

2. manual database creation

Create a parameter file $ ORACLE_HOME/dbs/initcrnophq. ora
Db_name = crnophq
Memory_target = 100G

Database creation script:
Create database crnophq
User sys identified by oracle
User system identified by oracle
Logfile group 1 ('/opt/app/oracle/oradata/crnophq/redo01a. log') SIZE 2000 m blocksize 512,
GROUP 2 ('/opt/app/oracle/oradata/crnophq/redo02a. log') SIZE 2000 m blocksize 512,
GROUP 3 ('/opt/app/oracle/oradata/crnophq/redo03a. log') SIZE 2000 m blocksize 512
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 1000
Character set ZHS16GBK
National character set AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/opt/app/oracle/oradata/crnophq/system01.dbf' SIZE 300 M REUSE
Sysaux datafile '/opt/app/oracle/oradata/crnophq/sysaux01.dbf' SIZE 300 M REUSE
Default tablespace users
DATAFILE '/opt/app/oracle/oradata/crnophq/users01.dbf'
SIZE 5 M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
Default temporary tablespace temp
TEMPFILE '/opt/app/oracle/oradata/crnophq/temp01.dbf'
SIZE 20 M REUSE
Undo tablespace undotbs
DATAFILE '/opt/app/oracle/oradata/crnophq/undotbs01.dbf'
SIZE 20 m reuse autoextend on maxsize unlimited;

Execute the following script to create a data dictionary and a stored procedure.
SQL> @? /Rdbms/admin/catalog. SQL
SQL> @? /Rdbms/admin/catproc. SQL
SQL> @? /Sqlplus/admin/pupbld. SQL

For more information about manual database creation, see the reprinted article: Oracle 11g manual database creation

3. check whether all components meet the requirements.
Col comp_name for a60
Set linesize 1000
Select comp_id, comp_name, version, status from sys. dba_registry;