Shulou(Shulou.com)05/31 Report--

This article will explain in detail the example analysis of oracle11g silent installation database + manually created examples. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

Silent installation

1: configure the response file

Response file template

/ software/database/response/db_install.rsp

Vi / software/database/response/install.rsp

Oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0

Oracle.install.option=INSTALL_DB_SWONLY

ORACLE_HOSTNAME=O-test1

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=/app/oracle/oraInventory

SELECTED_LANGUAGES=en,zh_CN

ORACLE_HOME=/app/oracle/product/11.2.0/db_1

ORACLE_BASE=/app/oracle

Oracle.install.db.InstallEdition=EE

Oracle.install.db.EEOptionsSelection=false

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,oracle.rdbms.lbac:11.2.0.4.0,oracle.rdbms.rat:11.2.0.4.0

Oracle.install.db.DBA_GROUP=dba

Oracle.install.db.OPER_GROUP=oinstall

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.config.starterdb.characterSet=AL32UTF8

Oracle.install.db.config.starterdb.memoryOption=true

Oracle.install.db.config.starterdb.memoryLimit=512

Oracle.install.db.config.starterdb.installExampleSchemas=false

Oracle.install.db.config.starterdb.enableSecuritySettings=true

Oracle.install.db.config.starterdb.password.ALL=oracle

Oracle.install.db.config.starterdb.password.SYS=

Oracle.install.db.config.starterdb.password.SYSTEM=

Oracle.install.db.config.starterdb.password.SYSMAN=

Oracle.install.db.config.starterdb.password.DBSNMP=

Oracle.install.db.config.starterdb.control=DB_CONTROL

Oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=

Oracle.install.db.config.starterdb.automatedBackup.enable=false

Oracle.install.db.config.starterdb.automatedBackup.osuid=

Oracle.install.db.config.starterdb.automatedBackup.ospwd=

Oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE

Oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=/app/oracle/oradata

Oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=/app/oracle/recovery

Oracle.install.db.config.asm.diskGroup=

Oracle.install.db.config.asm.ASMSNMPPassword=

MYORACLESUPPORT_USERNAME=

MYORACLESUPPORT_PASSWORD=

SECURITY_UPDATES_VIA_MYORACLESUPPORT=

DECLINE_SECURITY_UPDATES=true

PROXY_HOST=

PROXY_PORT=

PROXY_USER=

PROXY_PWD=

PROXY_REALM=

COLLECTOR_SUPPORTHUB_URL=

Oracle.installer.autoupdates.option=

Oracle.installer.autoupdates.downloadUpdatesLoc=

AUTOUPDATES_MYORACLESUPPORT_USERNAME=

AUTOUPDATES_MYORACLESUPPORT_PASSWORD=

Execute after configuration

. / runInstaller-silent-responseFile / software/database/response/install.rsp-ignoreSysprereqs

The following interface appears

[oracle@O-test1 database] $. / runInstaller-silent-responseFile / software/database/response/install.rsp-ignoreSysprereqs

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB. Actual 29057 MB Passed

Checking swap space: must be greater than 150 MB. Actual 3998 MB Passed

Preparing to launch Oracle Universal Installer from / tmp/OraInstall2018-02-26 11-44-42PM. Please wait... [oracle@O-test1 database] $

At this point, you can check whether the installation directory is gradually taking up more space, and you can determine whether it is being installed.

-- build the library by hand

Edit the ora startup file

Vi orcl.ora

Db_name=orcl

Control_files=/u01/app/oracle/oradata/orcl/control01.ctl,/u01/app/oracle/oradata/orcl/control02.ctl

Open the database in nomount mode

Startup nomount pfile=/app/oracle/oradata/orcl/orcl.ora

Create a spfile file

Create spfile from pfile='/app/oracle/oradata/orcl/orcl.ora'

Restart the database

Shutdown immediate

Startup nomount

Execute the CREATE DATABASE statement to create the database

CREATE DATABASE orcl

USER SYS IDENTIFIED BY oracle

USER SYSTEM IDENTIFIED BY oracle

LOGFILE GROUP 1 ('/ app/oracle/oradata/orcl/redo01.log') SIZE 100m BLOCKSIZE 512

GROUP 2 ('/ app/oracle/oradata/orcl/redo02.log') SIZE 100m BLOCKSIZE 512

GROUP 3 ('/ app/oracle/oradata/orcl/redo03.log') SIZE 100m BLOCKSIZE 512

MAXLOGFILES 5

MAXLOGMEMBERS 5

MAXLOGHISTORY 1

MAXDATAFILES 100

CHARACTER SET ZHS16GBK

NATIONAL CHARACTER SET AL16UTF16

EXTENT MANAGEMENT LOCAL

DATAFILE'/ app/oracle/oradata/orcl/system01.dbf' SIZE 1024m REUSE

SYSAUX DATAFILE'/ app/oracle/oradata/orcl/sysaux01.dbf' SIZE 1024m REUSE

DEFAULT TABLESPACE users

DATAFILE'/ app/oracle/oradata/orcl/users01.dbf'

SIZE 2048M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED

DEFAULT TEMPORARY TABLESPACE tempts1

TEMPFILE'/ app/oracle/oradata/orcl/temp01.dbf'

SIZE 2048M REUSE

UNDO TABLESPACE undotbs

DATAFILE'/ app/oracle/oradata/orcl/undotbs01.dbf'

SIZE 2048M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED

Execute the create data dictionary script

Conn / as sysdba

@? / rdbms/admin/catalog.sql

@? / rdbms/admin/catproc.sql

@? / rdbms/admin/utlrp.sql

Conn system/oracle

@? / sqlplus/admin/pupbld.sql

Create a monitor and start it

Cd $ORACLE_HOME/network/admin

Ls

Samples shrept.lst

Vi listener.ora

Cat listener.ora

LISTENER=

(DESCRIPTION=

(ADDRESS_LIST=

(ADDRESS= (PROTOCOL=TCP) (HOST=O-test1) (PORT=1521))

(ADDRESS= (PROTOCOL=IPC) (KEY=EXTPROC1521)

Lsnrctl start

Appendix A:db_install.rsp for details

#

# # Copyright (c) Oracle Corporation1998,2008. All rights reserved. # #

# # Specify values for the variables listedbelow to customize your installation. # #

# # Each variable is associated with acomment. The comment # #

# # can help to populate the variables withthe appropriate values. # #

# # IMPORTANT NOTE: This file contains plaintext passwords and # #

# # should be secured to have readpermission only by oracle user # #

# # or db administrator who owns thisinstallation. # #

# # description of the whole file, which contains parameter description and confidentiality of password information in silent file # #

#

#-

# Do not change the following system generatedvalue. Mark the version of the response file, which must be the same as the database version to be installed. The installation check cannot be passed and cannot be changed.

#-

Oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0

#-

# Specify the installation option.

# It can be one of the following:

# 1. INSTALL_DB_SWONLY

# 2. INSTALL_DB_AND_CONFIG

# 3. UPGRADE_DB

# Select installation type: 1. Only install database software 2. Install database software and build library 3. Upgrade the database

#-

Oracle.install.option=INSTALL_DB_SWONLY

#-

# Specify the hostname of the system as setduring the install. It can be used

# to force the installation to use analternative hostname rather than using the

# first hostname found on the system. (e.g., for systems with multiple hostnames

# and network interfaces) specify the operating system hostname, which is obtained through the hostname command

#-

ORACLE_HOSTNAME=ora11gr2

#-

# Specify the Unix group to be set for theinventory directory.

# specify the owner of the oracle inventory directory, usually oinstall or dba

#-

UNIX_GROUP_NAME=oinstall

#-

# Specify the location which holds theinventory files.

# specify the path to the oracle inventory directory of the product list, which can be omitted on Win platform

#-

INVENTORY_LOCATION=/u01/app/oracle/oraInventory

#-

# Specify the languages in which thecomponents will be installed.

# en: English ja: Japanese

# 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 Britain) 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

# Example: SELECTED_LANGUAGES=en,fr,ja

# specify the database language. You can choose more than one, separated by commas. Select en, zh_CN (English and simplified Chinese)

#-

SELECTED_LANGUAGES=en,zh_CN

#-

# Specify the complete path of the OracleHome. Set the path of ORALCE_HOME

#-

ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1

#-

# Specify the complete path of the OracleBase. Set the path of ORALCE_BASE

#-

ORACLE_BASE=/u01/app/oracle

#-

# Specify the installation edition of thecomponent.

# The value should contain only one ofthese choices.

# EE: EnterpriseEdition

# SE: Standard Edition

# SEONE Standard Edition One

# PE: Personal Edition (WINDOWS ONLY)

# Select the version in which Oracle installs the database software (Enterprise Edition, Standard Edition, Standard Edition 1). Different versions have different functions

# refer to Appendix D for detailed version differences

#-

Oracle.install.db.InstallEdition=EE

#-

# This variable is used to enable ordisable custom install.

# true: Components mentioned as part of 'customComponents' property

# are considered for install.

# false: Value for 'customComponents' isnot considered.

# whether to customize the components of Oracle. If you select false, the default components will be used.

# if you choose true, you need to list the components to be installed in the following parameter.

# all components will be installed after installing the appropriate copyright. If a component is missing at a later stage, it will be very troublesome to install again.

#-

Oracle.install.db.isCustomInstall=true

#-

# This variable is considered only if'IsCustomInstall' is set to true.

# Description: List of Enterprise EditionOptions you would like to install.

# The following choices areavailable. You may specify any

# combination of thesechoices. The components you chooseshould

# be specified in the form "internal-component-name:version"

# Below is a list of components youmay specify to install.

# oracle.rdbms.partitioning:11.2.0.1.0- Oracle Partitioning

# oracle.rdbms.dm:11.2.0.1.0- Oracle Data Mining

# oracle.rdbms.dv:11.2.0.1.0- Oracle Database Vault

# oracle.rdbms.lbac:11.2.0.1.0- Oracle Label Security

# oracle.rdbms.rat:11.2.0.1.0- Oracle Real Application Testing

# oracle.oraolap:11.2.0.1.0- Oracle OLAP

# oracle.install.db.isCustomInstall=true must be manually selected if components need to be installed

#-

Oracle.install.db.customComponents=oracle.server:11.2.0.1.0,oracle.sysman.ccr:10.2.7.0.0,oracle.xdk:11.2.0.1.0,oracle.rdbms.oci:11.2.0.1.0,oracle.network:11.2.0.1.0,oracle.network.listener:11.2.0.1.0,oracle.rdbms:11.2.0.1.0,oracle.options:11.2.0.1.0 Oracle.rdbms.partitioning:11.2.0.1.0,oracle.oraolap:11.2.0.1.0,oracle.rdbms.dm:11.2.0.1.0,oracle.rdbms.dv:11.2.0.1.0,orcle.rdbms.lbac:11.2.0.1.0,oracle.rdbms.rat:11.2.0.1.0

#

# PRIVILEGED OPERATING SYSTEM GROUPS

# Provide values for the OS groups to whichOSDBA and OSOPER privileges #

# needs to be granted. If the install isbeing performed as a member of the #

# group "dba", then that will beused unless specified otherwise below. #

# specify a user group with OSDBA and OSOPER permissions, usually a dba group

#

#-

# The DBA_GROUP is the OS group which is tobe granted OSDBA privileges.

#-

Oracle.install.db.DBA_GROUP=dba

#-

# The OPER_GROUP is the OS group which isto be granted OSOPER privileges.

#-

Oracle.install.db.OPER_GROUP=oinstall

#-

# Specify the cluster node names selectedduring the installation.

# if it is the installation of RAC, specify all nodes here

#-

Oracle.install.db.CLUSTER_NODES=

#-

# Specify the type of database to create.

# It can be one of the following:

#-GENERAL_PURPOSE/TRANSACTION_PROCESSING

#-DATA_WAREHOUSE

# Select the use of the database, general purpose / transaction processing, data warehouse

#-

Oracle.install.db.config.starterdb.type=GENERAL_PURPOSE

#-

# Specify the Starter Database GlobalDatabase Name. Specify GlobalName

#-

Oracle.install.db.config.starterdb.globalDBName=ora11g

#-

# Specify the Starter Database SID. Specify SID

#-

Oracle.install.db.config.starterdb.SID=ora11g

#-

# Specify the Starter Database characterset.

# It can be one of the following:

# AL32UTF8, WE8ISO8859P15, WE8MSWIN1252,EE8ISO8859P2

# EE8MSWIN1250, NE8ISO8859P10,NEE8ISO8859P4, BLT8MSWIN1257

# BLT8ISO8859P13, CL8ISO8859P5,CL8MSWIN1251, AR8ISO8859P6

# AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253,IW8ISO8859P8

# IW8MSWIN1255, JA16EUC, JA16EUCTILDE,JA16SJIS, JA16SJISTILDE

# KO16MSWIN949, ZHS16GBK, TH8TISASCII,ZHT32EUC, ZHT16MSWIN950

# ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254,VN8MSWIN1258

# Select a character set. Incorrect character sets bring a lot of trouble to data display and storage.

# ZHS16GBK simplified Chinese library is usually selected in Chinese. It is recommended to choose unicode's AL32UTF8 international character set.

#-

Oracle.install.db.config.starterdb.characterSet=AL32UTF8

#-

# This variable should be set to true ifAutomatic Memory Management

# in Database is desired.

# If Automatic Memory Management is notdesired, and memory allocation

# is to be done manually, then set it tofalse.

The new feature of # 11g is automatic memory management, that is, SGA_TARGET and PAG_AGGREGATE_TARGET are both # need not be set, Oracle will automatically allocate the size of the two parts.

#-

Oracle.install.db.config.starterdb.memoryOption=true

#-

# Specify the total memory allocation forthe database. Value (in MB) should be

# at least 256 MB, and should not exceedthe total physical memory available on the system.

# Example:oracle.install.db.config.starterdb.memoryLimit=512

# specify the size of the memory automatically managed by Oracle, with a minimum of 256MB

#-

Oracle.install.db.config.starterdb.memoryLimit=

#-

# This variable controls whether to loadExample Schemas onto the starter

# database or not. Whether to load the template example

#-

Oracle.install.db.config.starterdb.installExampleSchemas=false

#-

# This variable includes enabling auditsettings, configuring password profiles

# and revoking some grants to public. Thesesettings are provided by default.

# These settings may also be disabled. Whether to enable security settings

#-

Oracle.install.db.config.starterdb.enableSecuritySettings=true

#

# Passwords can be supplied for thefollowing four schemas in the #

# starter database: #

# SYS #

# SYSTEM #

# SYSMAN (used by Enterprise Manager) #

# DBSNMP (used by Enterprise Manager) #

# Same password can be used for allaccounts (not recommended) #

# or different passwords for each accountcan be provided (recommended) #

# set database user password

#

#-

# This variable holds the password that isto be used for all schemas in the

# starter database.

# set all database users to use the same password, so that other database users do not have to set it separately.

#-

Oracle.install.db.config.starterdb.password.ALL=oracle

#-

# Specify the SYS password for the starterdatabase.

#-

Oracle.install.db.config.starterdb.password.SYS=

#-

# Specify the SYSTEM password for thestarter database.

#-

Oracle.install.db.config.starterdb.password.SYSTEM=

#-

# Specify the SYSMAN password for thestarter database.

#-

Oracle.install.db.config.starterdb.password.SYSMAN=

#-

# Specify the DBSNMP password for thestarter database.

#-

Oracle.install.db.config.starterdb.password.DBSNMP=

#-

# Specify the management option to beselected for the starter database.

# It can be one of the following:

# 1. GRID_CONTROL

# 2. DB_CONTROL

# Database local management tool DB_CONTROL, remote centralized management tool GRID_CONTROL

#-

Oracle.install.db.config.starterdb.control=DB_CONTROL

#-

# Specify the Management Service to use ifGrid Control is selected to manage

# the database. GRID_CONTROL needs to set the remote path URL of grid control

#-

Oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=

#-

# This variable indicates whether toreceive email notification for critical

# alerts when using DB control. Whether to enable Email notification. When enabled, alarm and other information will be sent to the specified mailbox.

#-

Oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=false

#-

# Specify the email address to which thenotifications are to be sent. Set notification EMAIL address

#-

Oracle.install.db.config.starterdb.dbcontrol.emailAddress=

#-

# Specify the SMTP server used for emailnotifications. Set up an EMAIL mail server

#-

Oracle.install.db.config.starterdb.dbcontrol.SMTPServer=

#

# SPECIFY BACKUP AND RECOVERY OPTIONS #

# Out-of-box backup and recovery optionsfor the database can be mentioned #

# using the entries below. #

# Security and recovery settings (default) out-of-box (out-of-box experience) abbreviated to OOBE

# the product gives users a good first impression and feeling of use

#

#-

# This variable is to be set to false ifautomated backup is not required. Else

# this can be set to true. Set up automatic backup, just like automatic backup in OUI.

#-

Oracle.install.db.config.starterdb.automatedBackup.enable=false

#-

# Regardless of the type of storage that ischosen for backup and recovery, if

# automated backups are enabled, a job willbe scheduled to run daily at

# 2:00 AM to backup the database. This jobwill run as the operating system

# user that is specified in this variable. Automatic backup starts a job, specifying the system user ID that starts JOB

#-

Oracle.install.db.config.starterdb.automatedBackup.osuid=

#-

# Regardless of the type of storage that ischosen for backup and recovery, if

# automated backups are enabled, a job willbe scheduled to run daily at

# 2:00 AM to backup the database. This jobwill run as the operating system user

# specified by the above entry. Thefollowing entry stores the password for the

# above operating system user. Automatic backup will open a job. You need to specify the password of the OSUser.

#-

Oracle.install.db.config.starterdb.automatedBackup.ospwd=

#-

# Specify the type of storage to use forthe database.

# It can be one of the following:

#-FILE_SYSTEM_STORAGE

#-ASM_STORAGE

# automatic backup, which is required to specify which file system is used to store database files or ASM

#-

Oracle.install.db.config.starterdb.storageType=

#-

# Specify the database file location whichis a directory for datafiles, control

# files, redo logs.

# Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM

# use the file system to store database files in order to specify the storage directory of data files, control files and Redo log

#-

Oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=

#-

# Specify the backup and recovery location.

# Applicable only whenoracle.install.db.config.starterdb.storage=FILE_SYSTEM

# use the file system to store database files before you need to specify a backup recovery directory

#-

Oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=

#-

# Specify the existing ASM disk groups tobe used for storage.

# Applicable only whenoracle.install.db.config.starterdb.storage=ASM

# you need to specify the disk group to store database files using ASM

#-

Oracle.install.db.config.asm.diskGroup=

#-

# Specify the password for ASMSNMP user ofthe ASM instance.

# Applicable only whenoracle.install.db.config.starterdb.storage=ASM_SYSTEM

# you need to specify the ASM instance password when using ASM to store database files

#-

Oracle.install.db.config.asm.ASMSNMPPassword=

#-

# Specify the My Oracle Support AccountUsername.

# Example: MYORACLESUPPORT_USERNAME=metalink

# specify metalink account user name

#-

MYORACLESUPPORT_USERNAME=

#-

# Specify the My Oracle Support AccountUsername password.

# Example: MYORACLESUPPORT_PASSWORD=password

# specify metalink account password

#-

MYORACLESUPPORT_PASSWORD=

#-

# Specify whether to enable the user to setthe password for

# My Oracle Support credentials. The valuecan be either true or false.

# If left blank it will be assumed to befalse.

# Example: SECURITY_UPDATES_VIA_MYORACLESUPPORT=true

# whether users can set metalink password

#-

SECURITY_UPDATES_VIA_MYORACLESUPPORT=

#-

# Specify whether user wants to give anyproxy details for connection.

# The value can be either true or false. Ifleft blank it will be assumed to be false.

# Example: DECLINE_SECURITY_UPDATES=false

# False indicates that there is no need to set a security update. Note that there is a suspected BUG in the silent installation of 11.2.

# true must be specified in # Response File, otherwise an error will be prompted, regardless of whether the email address is entered correctly or not

#-

DECLINE_SECURITY_UPDATES=true

#-

# Specify the Proxy server name. Lengthshould be greater than zero.

# proxy server name

# Example: PROXY_HOST=proxy.domain.com

#-

PROXY_HOST=

#-

# Specify the proxy port number. Should beNumeric and atleast 2 chars.

# proxy server port

# Example: PROXY_PORT=25

#-

PROXY_PORT=

#-

# Specify the proxy user name. LeavePROXY_USER and PROXY_PWD

# blank if your proxy server requires noauthentication.

# proxy server user name

# Example: PROXY_USER=username

#-

PROXY_USER=

#-

# Specify the proxy password. LeavePROXY_USER and PROXY_PWD

# blank if your proxy server requires noauthentication.

# proxy server password

# Example: PROXY_PWD=password

#-

PROXY_PWD=

This is the end of this article on "oracle11g silent installation database + example analysis of manually created instances". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it out for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.