August 22 2014

oracle静默安装数据库软件及实例

原来做过一次。没有写出来。。。。

今天写做一次 写一份出来 以后可以参照

首先用户及目录:
groupadd -g 6000 oinstall
groupadd -g 6001 dba
groupadd -g 5000 asmadmin
groupadd -g 5001 asmdba
groupadd -g 5002 asmoper
groupadd -g 6002 oper
useradd -g oinstall -G asmadmin,asmdba,asmoper grid  –本次安装不涉及grid 和grid相关的可以不做
useradd -g oinstall -G dba,asmdba    oracle

passwd oracle
passwd grid

mkdir /u01
mkdir -p /u01/soft
mkdir -p /u01/app/oracle
mkdir -p /u01/app/oraInventory
mkdir -p /u01/app/oracle/product/11.2.0/grid
mkdir -p /u01/app/oracle/product/11.2.0/dbhome_1
mkdir -p /u01/app/grid

chown -R oracle:oinstall /u01
chmod -R 775 /u01

chown -R oracle:oinstall /u01/app/oracle
chmod -R 775 /u01/app/oracle

chown -R oracle:oinstall /u01/app/oraInventory –如果是有grid 则把这个目录设成gridr
chmod -R 775 /u01/app/oraInventory

chown -R grid:oinstall /u01/app/oracle/product/11.2.0/grid
chmod -R 775 /u01/app/oracle/product/11.2.0/grid

chown -R oracle:oinstall /u01/app/oracle/product/11.2.0/dbhome_1
chmod -R 775 /u01/app/oracle/product/11.2.0/dbhome_1

chown -R grid:oinstall /u01/app/grid
chmod -R 775 /u01/app/grid
——————————————————————-
rpm包: 没有用yum
rpm -ivh gcc-4.1.2-51.el5.x86_64.rpm  glibc-devel-2.5-65.x86_64.rpm glibc-headers-2.5-65.x86_64.rpm kernel-headers-2.6.18-274.el5.x86_64.rpm
rpm -ivh elfutils-libelf-devel-0.137-3.el5.x86_64.rpm  elfutils-libelf-devel-static-0.137-3.el5.x86_64.rpm
rpm -ivh glibc-devel-2.5-65.x86_64.rpm
rpm -ivh glibc-headers-2.5-65.x86_64.rpm
rpm -ivh gcc-c++-4.1.2-51.el5.x86_64.rpm libstdc++-devel-4.1.2-51.el5.x86_64.rpm
rpm -ivh libaio-devel-0.3.106-5.x86_64.rpm libstdc++-devel-4.1.2-51.el5.x86_64.rpm
rpm -ivh sysstat-7.0.2-11.el5.x86_64.rpm
———————————————
内核参数调整和增加shell限制
vi /etc/sysctl.conf

kernel.sem =   100
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
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 = 1048586
–生效
sysctl -p
vi  /etc/security/limits.conf

oracle hard nofile 65536–添加
oracle           soft    nproc   2047
oracle           hard    nproc   16384
oracle           soft    nofile  1024
oracle           hard    nofile  65536

————————————————-
oracle用户的环境变量调整:
su – oracle
vi .bash_profile–添加下面的
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=cold; export ORACLE_HOSTNAME
ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
GRID_HOME=/u01/grid; export GRID_HOME
DB_HOME=$ORACLE_BASE/product/11.2.0/db_1; export DB_HOME
ORACLE_HOME=$DB_HOME; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
BASE_PATH=/usr/sbin:$PATH; export BASE_PATH
PATH=$ORACLE_HOME/bin:$BASE_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
—————————————————————————-
把介质上传解压到database目录在解压后oracle软件的response目录里有各种响应文件的模版

生成响应文件  这里分两种方式
生成响应文件模板方法一:
vi db
#以下参数不要更改
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
oracle.install.option=INSTALL_DB_SWONLY
DECLINE_SECURITY_UPDATES=true
#以下参数根据实际情况更改
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/app/oracle/oraInventory
SELECTED_LANGUAGES=en,zh_CN,zh_TW
ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
ORACLE_BASE=/u01/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.isCustomInstall=true
oracle.install.db.customComponents=oracle.rdbms.partitioning:11.2.0.3.0,oracle.oraolap:11.2.0.3.0,oracle.rdbms.lbac:11.2.0.3.0,oracle.rdbms.dm:11.2.0.3.0,oracle.rdbms.dv:11.2.0.3.0,oracle.rdbms.rat:11.2.0.3.0
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oinstall
#——————————————————————–

各参数含义如下:
-silent 表示以静默方式安装,不会有任何提示
-force 允许安装到一个非空目录
-noconfig 表示不运行配置助手netca
-responseFile 表示使用哪个响应文件,必需使用绝对路径
oracle.install.responseFileVersion 响应文件模板的版本,该参数不要更改
oracle.install.option 安装选项,本例只安装oracle软件,该参数不要更改
DECLINE_SECURITY_UPDATES 是否需要在线安全更新,设置为false,该参数不要更改
ORACLE_HOSTNAME 安装主机名
UNIX_GROUP_NAME oracle用户用于安装软件的组名
INVENTORY_LOCATION oracle产品清单目录
SELECTED_LANGUAGES oracle运行语言环境,一般包括引文和简繁体中文
ORACLE_HOME Oracle安装目录
ORACLE_BASE oracle基础目录
oracle.install.db.InstallEdition 安装版本类型,一般是企业版
oracle.install.db.isCustomInstall 是否定制安装,默认Partitioning,OLAP,RAT都选上了
oracle.install.db.customComponents 定制安装组件列表:除了以上默认的,可加上Label Security和Database Vault
oracle.install.db.DBA_GROUP oracle用户用于授予OSDBA权限的组名
oracle.install.db.OPER_GROUP oracle用户用于授予OSOPER权限的组名

——————————我是分隔线———————————-

生成响应文件模板方法二:
在一台同样的机器上用正常的图形界面的方式运行 到rpm包检验完成之后有一个save as response 点一下 存的就是方法一你手写的
下面是我贴的一份。你可以看 也可以不看
####################################################################
## Copyright(c) Oracle Corporation 1998,2011. All rights reserved.##
##                                                                ##
## 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_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
#——————————————————————————-
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 the
# first hostname found on the system. (e.g., for systems with multiple hostnames
# and network interfaces)
#——————————————————————————-
ORACLE_HOSTNAME=cold

#——————————————————————————-
# 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 languages in which the components 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
#
# all_langs   : All languages
#
# Specify value as the following to select any of the languages.
# Example : SELECTED_LANGUAGES=en,fr,ja
#
# Specify value as the following to select all the languages.
# Example : SELECTED_LANGUAGES=all_langs
#——————————————————————————-
SELECTED_LANGUAGES=en

#——————————————————————————-
# Specify the complete path of the Oracle Home.
#——————————————————————————-
ORACLE_HOME=/u01/app/oracle/product/11.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
# 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 property is considered only if ‘EEOptionsSelection’ is set to true
#
# Description: List of Enterprise Edition Options you would like to enable.
#
#              The following choices are available. You may specify any
#              combination of these choices.  The components you choose should
#              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.3.0 – Oracle OLAP
#              oracle.rdbms.dm:11.2.0.3.0 – Oracle Data Mining RDBMS Files
#              oracle.rdbms.dv:11.2.0.3.0- Oracle Database Vault option
#              oracle.rdbms.lbac:11.2.0.3.0 – Oracle Label Security
#              oracle.rdbms.partitioning:11.2.0.3.0 – Oracle Partitioning
#              oracle.rdbms.rat:11.2.0.3.0 – Oracle Real Application Testing
#——————————————————————————-
oracle.install.db.optionalComponents=

###############################################################################
#                                                                             #
# PRIVILEGED OPERATING SYSTEM GROUPS                                          #
# ——————————————                                  #
# Provide values for the OS groups to which OSDBA and OSOPER 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 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=oper

#——————————————————————————-
# Specify the cluster node names selected during the installation.
# 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

#——————————————————————————
# Specify the name for RAC One Node Service.
#——————————————————————————
oracle.install.db.racOneServiceName=

#——————————————————————————-
# Specify the type of database to create.
# It can be one of the following:
# – GENERAL_PURPOSE/TRANSACTION_PROCESSING
# – DATA_WAREHOUSE
#——————————————————————————-
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE

#——————————————————————————-
# 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 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=false

#——————————————————————————-
# 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.
#——————————————————————————-
oracle.install.db.config.starterdb.installExampleSchemas=false

#——————————————————————————-
# This variable includes enabling audit settings, configuring password profiles
# and revoking some grants to public. These settings are provided by default.
# These settings may also be disabled.
#——————————————————————————-
oracle.install.db.config.starterdb.enableSecuritySettings=true

###############################################################################
#                                                                             #
# Passwords can be supplied for the following four schemas in the       #
# starter database:                  #
#   SYS                                                                       #
#   SYSTEM                                                                    #
#   SYSMAN (used by Enterprise Manager)                                       #
#   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 SYSMAN password for the starter database.
#——————————————————————————-
oracle.install.db.config.starterdb.password.SYSMAN=

#——————————————————————————-
# Specify the DBSNMP password for the starter database.
#——————————————————————————-
oracle.install.db.config.starterdb.password.DBSNMP=

#——————————————————————————-
# Specify the management option to be selected for the starter database.
# It can be one of the following:
# 1. GRID_CONTROL
# 2. DB_CONTROL
#——————————————————————————-
oracle.install.db.config.starterdb.control=DB_CONTROL

#——————————————————————————-
# Specify the Management Service to use if Grid Control is selected to manage
# the database.
#——————————————————————————-
oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=

###############################################################################
#                                                                             #
# SPECIFY BACKUP AND RECOVERY OPTIONS                                        #
# ————————————                                #
# Out-of-box backup and recovery options for the database can be mentioned    #
# using the entries below.            #
#                                                                             #
###############################################################################

#——————————————————————————
# This variable is to be set to false if automated backup is not required. Else
# this can be set to true.
#——————————————————————————-
oracle.install.db.config.starterdb.automatedBackup.enable=false

#——————————————————————————
# Regardless of the type of storage that is chosen for backup and recovery, if
# automated backups are enabled, a job will be scheduled to run daily to backup
# the database. This job will run as the operating system user that is
# specified in this variable.
#——————————————————————————-
oracle.install.db.config.starterdb.automatedBackup.osuid=

#——————————————————————————-
# Regardless of the type of storage that is chosen for backup and recovery, if
# automated backups are enabled, a job will be scheduled to run daily to backup
# the database. This job will run as the operating system user specified by the
# above entry. The following entry stores the password for the above operating
# system user.
#——————————————————————————-
oracle.install.db.config.starterdb.automatedBackup.ospwd=

#——————————————————————————-
# 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 backup and 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 false.
#
# 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 atleast 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 proxy realm.
#
# Example    : PROXY_REALM=metalink
#——————————————————————————
PROXY_REALM=
#——————————————————————————
# Specify the Oracle Support Hub URL.
#
# Example    : COLLECTOR_SUPPORTHUB_URL=https://orasupporthub.company.com:8080/
#——————————————————————————
COLLECTOR_SUPPORTHUB_URL=

#——————————————————————————
# Specify the auto-updates option. It can be one of the following:
# a.MYORACLESUPPORT_DOWNLOAD
# b.OFFLINE_UPDATES
# c.SKIP_UPDATES
#——————————————————————————
oracle.installer.autoupdates.option=SKIP_UPDATES
#——————————————————————————
# In case MYORACLESUPPORT_DOWNLOAD option is chosen, specify the location where
# the updates are to be downloaded.
# In case OFFLINE_UPDATES option is chosen, specify the location where the updates
# are present.
oracle.installer.autoupdates.downloadUpdatesLoc=
#——————————————————————————
# Specify the My Oracle Support Account Username which has the patches download privileges
# to be used for software updates.
#  Example   : AUTOUPDATES_MYORACLESUPPORT_USERNAME=abc@oracle.com
#——————————————————————————
AUTOUPDATES_MYORACLESUPPORT_USERNAME=

#——————————————————————————
# Specify the My Oracle Support Account Username password which has the patches download privileges
# to be used for software updates.
#
# Example    : AUTOUPDATES_MYORACLESUPPORT_PASSWORD=password
#——————————————————————————
AUTOUPDATES_MYORACLESUPPORT_PASSWORD=
———————————————————————–

不管你用哪种方法有了响应文件之后运行下一行命令就可以了
./runInstaller -silent -noconfig -ignorePrereq -responseFile /home/oracle/db.rsp

/u01/app/oracle/oraInventory/orainstRoot.sh

/u01/app/oracle/product/11.2.0/dbhome_1/root.sh
最后会让你用root执行这两个脚本
—————————————————————————————————-

完成之后 使用默认的监听响应文件创建监听 当然 手动的去写也可以
netca -silent -responsefile /u01/soft/database/response/netca.rsp
————————————————————————————————————-
接下来静默安装数据库 还是响应文件:如下

[GENERAL]
RESPONSEFILE_VERSION = “11.2.0”
OPERATION_TYPE = “createDatabase”
[CREATEDATABASE]
GDBNAME = “ORCL”
TEMPLATENAME = “General_Purpose.dbc”
CHARACTERSET = “ZHS16GBK”
TOTALMEMORY = “1024”

 

各参数含义如下:

-silent 表示以静默方式安装
-responseFile 表示使用哪个响应文件,必需使用绝对路径
RESPONSEFILE_VERSION 响应文件模板的版本,该参数不要更改
OPERATION_TYPE 安装类型,该参数不要更改
GDBNAME 全局数据库名,点号前面默认是db_name,点号后面默认就是db_domain
TEMPLATENAME 建库模板名,参考各模板定义:$ORACLE_HOME/assistants/dbca/templates/*.dbc
CHARACTERSET 字符集,默认是WE8MSWIN1252
TOTALMEMORY 实例内存,默认是服务器物理内存的40%
——————————————————————————————–

命令如下:
dbca -silent -responseFile /u01/app/db_create.rsp
Enter SYS user password:

Enter SYSTEM user password:
。。。
Copying database files
37% complete
Creating and starting Oracle instance

62% complete
Completing Database Creation

100% complete
Look at the log file “/u01/app/oracle/cfgtoollogs/dbca/ORCL/ORCL.log” for further details
完成之后建议:
execute utl_recomp.recomp_serial(); (重新编译所有可能失效对象)
归档。闪回。spfile及其它都配置一下
——————————————
原理
种子数据库和控制文件位于$ORACLE_HOME/assistants/dbca/templates/下, 即Seed_Database.dfb和Seed_Database.ctl文件,
实际上建库就是基于通过rman恢复种子数据库和控制文件来实现的.
————————————————-
注册监听alter system register;
———————————————————
说明:
也许有些版本的有些参数可能有出入 如有问题请查看官方文档
期间所有步骤都有日志可以看 会输出给你看哪个文件 使用tail -f可以查看、



Copyright 2019. All rights reserved.

Posted 2014年8月22日 by ucjmh in category "oracle

Leave a Reply

Your email address will not be published. Required fields are marked *