oracle12c r2 单实例,12c r2单实例静默安装软件

最新推荐文章于 2023-03-15 10:17:05 发布

CodeNomad

最新推荐文章于 2023-03-15 10:17:05 发布

阅读量134

点赞数

文章标签： oracle12c r2 单实例

安装Oracle必需软件:

yum -y install compat-db compat-db42 compat-db43 compat-gcc-34 compat-gcc-34-c++ compat-libstdc++-33 glibc-* glibc-*.i686 libXpm-*.i686 libXp.so.6 libXt.so.6 libXtst.so.6 libgcc_s.so.1 ksh libXp libaio-devel numactl numactl-devel unixODBC unixODBC-devel

修改内核参数/etc/sysctl.conf

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

fs.file-max = 6815744

fs.aio-max-nr = 1048576

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

在 /etc/security/limits.conf 中添加如下内容

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft stack 10240

oracle hard stack 10240

/etc/pam.d/login 文件中添加

session required pam_limits.so

/etc/profile 中添加

if [ $USER = "oracle" ]; then

if [ $SHELL = "/bin/ksh" ]; then

ulimit -u 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

创建Oracle用户和组

groupadd oinstall

groupadd dba

groupadd oper

useradd -g oinstall -G dba,oper oracle

passwd oracle

创建目录

mkdir -p /u01/app/oracle/product/12.2.0/db_1

chown -R oracle.oinstall /u01

chmod -R 777 /u01

设置oracle用户的环境变量

TMP=/tmp; export TMP

TMPDIR=$TMP; export TMPDIR

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/12.1.0/db_1; export ORACLE_HOME

ORACLE_SID=oraa42; export ORACLE_SID

SHLIB_PATH=$LD_LIBRARY_PATH;export SHLIB_PATH

NLS_LANG=American_America.zhs16gbk;export NLS_LANG

ORA_NLS10=$ORACLE_HOME/nls/data;export ORA_NLS10

TNS_ADMIN=$ORACLE_HOME/network/admin;export TNS_ADMIN

ORACLE_TERM=xterm; export ORACLE_TERM

PATH=/usr/sbin:$PATH; export PATH

PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH

CLASSPATH=$ORACLE_HOME/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

source .bash_profile

配置静默安装的响应文件内容

===========db_install_new.rsp

####################################################################

## ##

## Specify values for the variables listed below to customize ##

## your installation. ##

## ##

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

## can help to populate the variables with the appropriate ##

## values. ##

## ##

## IMPORTANT NOTE: This file contains plain text passwords and ##

## should be secured to have read permission only by oracle user ##

## or db administrator who owns this installation. ##

## ##

####################################################################

#-------------------------------------------------------------------------------

# Do not change the following system generated value.

#-------------------------------------------------------------------------------

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.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 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=/u01/app/oraInventory

#-------------------------------------------------------------------------------

# Specify the complete path of the Oracle Home.

#-------------------------------------------------------------------------------

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

#-------------------------------------------------------------------------------

# Specify the complete path of the Oracle Base.

#-------------------------------------------------------------------------------

ORACLE_BASE=/u01/app/oracle/

#-------------------------------------------------------------------------------

# Specify the installation edition of the component.

# The value should contain only one of these choices.

# - EE : Enterprise Edition

# - SE2 : Standard Edition 2

#-------------------------------------------------------------------------------

oracle.install.db.InstallEdition=EE

###############################################################################

# #

# PRIVILEGED OPERATING SYSTEM GROUPS #

# ------------------------------------------ #

# Provide values for the OS groups to which SYSDBA and SYSOPER privileges #

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

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

# #

# The value to be specified for OSDBA and OSOPER group is only for UNIX based #

# Operating System. #

# #

###############################################################################

#------------------------------------------------------------------------------

# The OSDBA_GROUP is the OS group which is to be granted SYSDBA privileges.

#-------------------------------------------------------------------------------

oracle.install.db.OSDBA_GROUP=dba

#------------------------------------------------------------------------------

# The OSOPER_GROUP is the OS group which is to be granted SYSOPER privileges.

# The value to be specified for OSOPER group is optional.

#------------------------------------------------------------------------------

oracle.install.db.OSOPER_GROUP=oper

#------------------------------------------------------------------------------

# The OSBACKUPDBA_GROUP is the OS group which is to be granted SYSBACKUP privileges.

#------------------------------------------------------------------------------

oracle.install.db.OSBACKUPDBA_GROUP=dba

#------------------------------------------------------------------------------

# The OSDGDBA_GROUP is the OS group which is to be granted SYSDG privileges.

#------------------------------------------------------------------------------

oracle.install.db.OSDGDBA_GROUP=dba

#------------------------------------------------------------------------------

# The OSKMDBA_GROUP is the OS group which is to be granted SYSKM privileges.

#------------------------------------------------------------------------------

oracle.install.db.OSKMDBA_GROUP=dba

#------------------------------------------------------------------------------

# The OSRACDBA_GROUP is the OS group which is to be granted SYSRAC privileges.

#------------------------------------------------------------------------------

oracle.install.db.OSRACDBA_GROUP=dba

###############################################################################

# #

# Grid Options #

# #

###############################################################################

#------------------------------------------------------------------------------

# Specify the type of Real Application Cluster Database

# - ADMIN_MANAGED: Admin-Managed

# - POLICY_MANAGED: Policy-Managed

# If left unspecified, default will be ADMIN_MANAGED

#------------------------------------------------------------------------------

oracle.install.db.rac.configurationType=

#------------------------------------------------------------------------------

# Value is required only if RAC database type is ADMIN_MANAGED

# Specify the cluster node names selected during the installation.

# Leaving it blank will result in install on local server only (Single Instance)

# Example : oracle.install.db.CLUSTER_NODES=node1,node2

#------------------------------------------------------------------------------

oracle.install.db.CLUSTER_NODES=

#------------------------------------------------------------------------------

# This variable is used to enable or disable RAC One Node install.

# - true : Value of RAC One Node service name is used.

# - false : Value of RAC One Node service name is not used.

# If left blank, it will be assumed to be false.

#------------------------------------------------------------------------------

oracle.install.db.isRACOneInstall=false

#------------------------------------------------------------------------------

# Value is required only if oracle.install.db.isRACOneInstall is true.

# Specify the name for RAC One Node Service

#------------------------------------------------------------------------------

oracle.install.db.racOneServiceName=

#------------------------------------------------------------------------------

# Value is required only if RAC database type is POLICY_MANAGED

# Specify a name for the new Server pool that will be configured

# Example : oracle.install.db.rac.serverpoolName=pool1

#------------------------------------------------------------------------------

oracle.install.db.rac.serverpoolName=

#------------------------------------------------------------------------------

# Value is required only if RAC database type is POLICY_MANAGED

# Specify a number as cardinality for the new Server pool that will be configured

# Example : oracle.install.db.rac.serverpoolCardinality=2

#------------------------------------------------------------------------------

oracle.install.db.rac.serverpoolCardinality=

###############################################################################

# #

# Database Configuration Options #

# #

###############################################################################

#-------------------------------------------------------------------------------

# Specify the type of database to create.

# It can be one of the following:

# - GENERAL_PURPOSE

# - DATA_WAREHOUSE

# GENERAL_PURPOSE: A starter database designed for general purpose use or transaction-heavy applications.

# DATA_WAREHOUSE : A starter database optimized for data warehousing applications.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.type=

#-------------------------------------------------------------------------------

# Specify the Starter Database Global Database Name.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.globalDBName=

#-------------------------------------------------------------------------------

# Specify the Starter Database SID.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.SID=

#-------------------------------------------------------------------------------

# Specify whether the database should be configured as a Container database.

# The value can be either "true" or "false". If left blank it will be assumed

# to be "false".

#-------------------------------------------------------------------------------

oracle.install.db.ConfigureAsContainerDB=

#-------------------------------------------------------------------------------

# Specify the Pluggable Database name for the pluggable database in Container Database.

#-------------------------------------------------------------------------------

oracle.install.db.config.PDBName=

#-------------------------------------------------------------------------------

# Specify the Starter Database character set.

# 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

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.characterSet=

#------------------------------------------------------------------------------

# This variable should be set to true if Automatic Memory Management

# in Database is desired.

# If Automatic Memory Management is not desired, and memory allocation

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

#------------------------------------------------------------------------------

oracle.install.db.config.starterdb.memoryOption=

#-------------------------------------------------------------------------------

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

# at least 256 MB, and should not exceed the total physical memory available

# on the system.

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

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.memoryLimit=

#-------------------------------------------------------------------------------

# This variable controls whether to load Example Schemas onto

# the starter database or not.

# The value can be either "true" or "false". If left blank it will be assumed

# to be "false".

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.installExampleSchemas=

###############################################################################

# #

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

# starter database: #

# SYS #

# SYSTEM #

# DBSNMP (used by Enterprise Manager) #

# #

# Same password can be used for all accounts (not recommended) #

# or different passwords for each account can be provided (recommended) #

# #

###############################################################################

#------------------------------------------------------------------------------

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

# starter database.

#-------------------------------------------------------------------------------

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

#-------------------------------------------------------------------------------

# Specify the SYS password for the starter database.

#-------------------------------------------------------------------------------

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

#-------------------------------------------------------------------------------

# Specify the SYSTEM password for the starter database.

#-------------------------------------------------------------------------------

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

#-------------------------------------------------------------------------------

# Specify the DBSNMP password for the starter database.

# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL

#-------------------------------------------------------------------------------

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

#-------------------------------------------------------------------------------

# Specify the PDBADMIN password required for creation of Pluggable Database in the Container Database.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.password.PDBADMIN=

#-------------------------------------------------------------------------------

# Specify the management option to use for managing the database.

# Options are:

# 1. CLOUD_CONTROL - If you want to manage your database with Enterprise Manager Cloud Control along with Database Express.

# 2. DEFAULT -If you want to manage your database using the default Database Express option.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.managementOption=

#-------------------------------------------------------------------------------

# Specify the OMS host to connect to Cloud Control.

# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.omsHost=

#-------------------------------------------------------------------------------

# Specify the OMS port to connect to Cloud Control.

# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.omsPort=

#-------------------------------------------------------------------------------

# Specify the EM Admin user name to use to connect to Cloud Control.

# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.emAdminUser=

#-------------------------------------------------------------------------------

# Specify the EM Admin password to use to connect to Cloud Control.

# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.emAdminPassword=

###############################################################################

# #

# SPECIFY RECOVERY OPTIONS #

# ------------------------------------ #

# Recovery options for the database can be mentioned using the entries below #

# #

###############################################################################

#------------------------------------------------------------------------------

# This variable is to be set to false if database recovery is not required. Else

# this can be set to true.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.enableRecovery=

#-------------------------------------------------------------------------------

# Specify the type of storage to use for the database.

# It can be one of the following:

# - FILE_SYSTEM_STORAGE

# - ASM_STORAGE

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.storageType=

#-------------------------------------------------------------------------------

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

# files, redo logs.

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

#-------------------------------------------------------------------------------

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

#-------------------------------------------------------------------------------

# Specify the recovery location.

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

#-------------------------------------------------------------------------------

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

#-------------------------------------------------------------------------------

# Specify the existing ASM disk groups to be used for storage.

# Applicable only when oracle.install.db.config.starterdb.storageType=ASM_STORAGE

#-------------------------------------------------------------------------------

oracle.install.db.config.asm.diskGroup=

#-------------------------------------------------------------------------------

# Specify the password for ASMSNMP user of the ASM instance.

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

#-------------------------------------------------------------------------------

oracle.install.db.config.asm.ASMSNMPPassword=

#------------------------------------------------------------------------------

# Specify the My Oracle Support Account Username.

# Example : MYORACLESUPPORT_USERNAME=abc@oracle.com

#------------------------------------------------------------------------------

MYORACLESUPPORT_USERNAME=

#------------------------------------------------------------------------------

# Specify the My Oracle Support Account Username password.

# Example : MYORACLESUPPORT_PASSWORD=password

#------------------------------------------------------------------------------

MYORACLESUPPORT_PASSWORD=

#------------------------------------------------------------------------------

# Specify whether to enable the user to set the password for

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

# If left blank it will be assumed to be false.

# Example : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true

#------------------------------------------------------------------------------

SECURITY_UPDATES_VIA_MYORACLESUPPORT=false

#------------------------------------------------------------------------------

# Specify whether user doesn't want to configure Security Updates.

# The value for this variable should 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 true.

# Example : DECLINE_SECURITY_UPDATES=false

#------------------------------------------------------------------------------

DECLINE_SECURITY_UPDATES=true

#------------------------------------------------------------------------------

# Specify the Proxy server name. Length should be greater than zero.

# Example : PROXY_HOST=proxy.domain.com

#------------------------------------------------------------------------------

PROXY_HOST=

#------------------------------------------------------------------------------

# Specify the proxy port number. Should be Numeric and at least 2 chars.

# Example : PROXY_PORT=25

#------------------------------------------------------------------------------

PROXY_PORT=

#------------------------------------------------------------------------------

# Specify the proxy user name. Leave PROXY_USER and PROXY_PWD

# blank if your proxy server requires no authentication.

# Example : PROXY_USER=username

#------------------------------------------------------------------------------

PROXY_USER=

#------------------------------------------------------------------------------

# Specify the proxy password. Leave PROXY_USER and PROXY_PWD

# blank if your proxy server requires no authentication.

# Example : PROXY_PWD=password

#------------------------------------------------------------------------------

PROXY_PWD=

#------------------------------------------------------------------------------

# Specify the Oracle Support Hub URL.

# Example : COLLECTOR_SUPPORTHUB_URL=https://orasupporthub.company.com:8080/

#------------------------------------------------------------------------------

COLLECTOR_SUPPORTHUB_URL=

提取以上响应文件内容

[oracle@testSOA database]$ sed -n '/^[^#]/p' response/db_install_new.rsp

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.2.0

oracle.install.option=INSTALL_DB_SWONLY

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=/u01/app/oraInventory

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

ORACLE_BASE=/u01/app/oracle/

oracle.install.db.InstallEdition=EE

oracle.install.db.OSDBA_GROUP=dba

oracle.install.db.OSOPER_GROUP=oper

oracle.install.db.OSBACKUPDBA_GROUP=dba

oracle.install.db.OSDGDBA_GROUP=dba

oracle.install.db.OSKMDBA_GROUP=dba

oracle.install.db.OSRACDBA_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=

oracle.install.db.config.starterdb.type=

oracle.install.db.config.starterdb.globalDBName=

oracle.install.db.config.starterdb.SID=

oracle.install.db.ConfigureAsContainerDB=

oracle.install.db.config.PDBName=

oracle.install.db.config.starterdb.characterSet=

oracle.install.db.config.starterdb.memoryOption=

oracle.install.db.config.starterdb.memoryLimit=

oracle.install.db.config.starterdb.installExampleSchemas=

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

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

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

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

oracle.install.db.config.starterdb.password.PDBADMIN=

oracle.install.db.config.starterdb.managementOption=

oracle.install.db.config.starterdb.omsHost=

oracle.install.db.config.starterdb.omsPort=

oracle.install.db.config.starterdb.emAdminUser=

oracle.install.db.config.starterdb.emAdminPassword=

oracle.install.db.config.starterdb.enableRecovery=

oracle.install.db.config.starterdb.storageType=

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

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=

开始安装

./runInstaller -silent -responseFile /opt/database/response/db_install_new.rsp -ignoreSysPrereqs

[oracle@testSOA database]$ ./runInstaller -silent -responseFile /opt/database/response/db_install_new.rsp -ignoreSysPrereqs

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 500 MB. Actual 13157 MB Passed

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

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-03-03_03-13-10PM. Please wait ...[oracle@testSOA database]$ [WARNING] [INS-13014] Target environment does not meet some optional requirements.

CAUSE: Some of the optional prerequisites are not met. See logs for details. installActions2017-03-03_03-13-10PM.log

ACTION: Identify the list of failed prerequisite checks from the log: installActions2017-03-03_03-13-10PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.

You can find the log of this install session at:

/u01/app/oraInventory/logs/installActions2017-03-03_03-13-10PM.log

The installation of Oracle Database 12c was successful.

Please check '/u01/app/oraInventory/logs/silentInstall2017-03-03_03-13-10PM.log' for more details.

As a root user, execute the following script(s):

1. /u01/app/oraInventory/orainstRoot.sh

2. /u01/app/oracle/product/12.2.0/db_1/root.sh

Successfully Setup Software.

[root@testSOA ~]# /u01/app/oraInventory/orainstRoot.sh

Changing permissions of /u01/app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.