2024年4月19日发(作者：)
SUSE Linux Enterprise 11SP1
静默安装Oracle 11gR2说明文档
1 准备oracle安装文件
Oracle11gR2包含两个文件linux_11gR2_database_和linux_11gR2_database_，
下载地址分别是：
/otn/linux/oracle11g/R2/linux_11gR2_database_
/otn/linux/oracle11g/R2/linux_11gR2_database_
下载完成后将这两个文件通过SSH上传到/usr/local/oracle中。
解压安装文件到当前目录
[root@localhost root]#cd /usr/local/oracle
[root@localhost oracle]#unzip linux_11gR2_database_
[root@localhost oracle]#unzip linux_11gR2_database_
执行以上命令后，将会在/usr/local/oracle/下面产生名为database的目录，这就是oracle安
装程序的目录。
2 准备oracle的安装目标目录
安装目标目录是用户想将oracle安装到哪个位置的目录，本次我们将oracle安装到/opt/ora
cle目录中，以下为目录创建命令。
[root@localhost oracle]#mkdir –p /opt/oracle
3 创建oracle相关用户和用户组
oracle不能在root帐户下进行安装，所以需要为oracle的安装专门创建一个用户，同时需要
创建dba和oinstall的用户组。
以下命令将创建dba和oinstall用户组：
[root@localhost oracle]#groupadd dba
[root@localhost oracle]#groupadd oinstall
以下命令将创建oracle用户，并设置密码
[root@localhost oracle]#useradd -g oinstall -G dba oracle
[root@localhost oracle]#passwd oracle
Changing password for user oracle.
New UNIX password: [
在此键入密码
]
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password: [
在此再次键入密码
]
passwd: all authentication tokens updated successfully.
创建oracle用户home目录
[root@localhost oracle]# md /home/oracle
[root@localhost oracle]# chown -R oracle:oinstall /home/oracle
以下命令将oracle安装目录（/opt/oracle）赋予oracle用户oinstall用户组
[root@localhost oracle]#chown –R oracle:oinstall /opt/oracle
4 检查安装ORACLE依赖的RPM软件包
oracle的安装所依赖的软件包，有一部分linux是没有安装的。这需要将这些尚未安装的软
件包先安装后才能正常安装oracle。这些未安装的软件包在linux安装光盘上可以取到，我
们直接在linux的光盘上对这些软件包进行安装（也可将所需的软件包直接复制到linux本地
磁盘中），首先我们需要挂载linux光盘，使用以下命令：
[root@localhost oracle]#mkdir /mnt/cdrom
[root@localhost oracle]#mount /dev/cdrom /mnt/cdrom
安装所缺少的软件包，此处只安装本linux系统所缺少的软件包。如oracle安装过程中，对
软件包进行检查时，发现仍有所需软件包未安装时，可根据显示未安装软件包的名字，再次
对所缺少的软件包进行安装。以下为安装命令：
[root@localhost oracle]#rpm -ivh
[root@localhost oracle]#rpm -ivh
[root@localhost oracle]#rpm -ivh gcc43-4.3.4_
[root@localhost oracle]#rpm -ivh
[root@localhost oracle]#rpm -ivh libstdc++43-devel-4.3.4_
[root@localhost oracle]#rpm -ivh gcc43-c++-4.3.4_
[root@localhost oracle]#rpm -ivh gcc-c++-
[root@localhost oracle]#rpm -ivh
[root@localhost oracle]#rpm -ivh
[root@localhost oracle]#rpm -ivh libstdc++-
[root@localhost oracle]#rpm -ivh
[root@localhost oracle]#rpm -ivh
5 设置linux内核参数
打开修改/etc/，在最后加入以下内容
= 2097152
= 2147483648
= 4096
= 250 32000 100 128
_default = 4194304
_max = 4194304
_default = 262144
-max = 6815744
_local_port_range = 9000 65500
_max = 1048576
-max-nr = 1048576
有的时候我们需要调整oracle数据库的最大链接数，而这个链接数的调整是在oacle下的dbs目录下ini
文件中调整的。
ORACLE的连接数(sessions)与其参数文件中的进程数(process)有关，它们的关系如下：
sessions=(1.1*process+5)
但是我们增加process数时，往往数据库不能启动了。这因为我们还漏调了一个unix系统参数：它是
核心参数中的semmns,这是unix系统的信号量参数。每个process会占用一个信号量。semmns调整后，需
要重新启动unix操作系统，参数才能生效。不过它的大小会受制于硬件的内存或 ORACLE SGA。范围可从
200——2000不等。
但是，Processes的修改不仅应该调整init
象 AIX,HPUX,Solaris,SCO,UNIXWare都是这样，OS的调整是需要重新启动的，而且这个参数的设置不能简
单按照多少个终端要连到这个服务器上而定，最关键是考虑会有多少同时连上的session（在使用一些共
享连接的中间件时，一般就不需要太大），当然还要考虑一些Oracle的后台进程，还有一些系统维护工作
需要多一些连接等。
我的atmp大前置机器上对oracle调整的时候，其使用的是unixware操作系统，在做链接数调整的时
候，要先对核心参数进行调整。
核心主要相关的参数的调整如下：
SHMMAX 1000000000
SHMMIN 1
SHMMNI 200
SHMSEG 15
SEMMNI 1000
SEMMSL 300
SEMMNS 230
SEMOPM 20
其中semmni,semmns,semmsl要加大，至少要比processes大18 ；
SEMMNI（10，10000；150）：指定在核心中信号识别的数量。这是可以在任意给定时间被激活的唯一
信号设置数量。缺省值是150。最大值由系统自动调整产生。
SEMMSL（25，300；150）：指定每个信号识别中信号量的最大值。缺省值是25。
SEMMNS 除最大db外的所有db 的PROCESSES之和+2*最大db的PROCESSES+10*实例数。如3个实例进
程数分别为100、100、200，则=（100+100）+2*200+10*3=630
SEMOPM（10，20；10）：指定在每个系统调用semop中能够被执行的信号操作量的最大值。缺省值是
10。
SHMMAX（131072，1073741824；524288）：指定了共享内存部分大小的最大值。等于0.5×物理内存
字节数
SHMMNI（10，1000；100）：指定了系统范围内共享内存标识的最大值。
SHMSEG（6，15；6）：指定了与每个进程相关连的共享内存块（或标识）的数量。缺省值是6。与每
个进程相关连的共享内存块的最大值与进程拥有的未使用空间有关。因此，尽管一个进程拥有少于SHMSEG
数值的共享内存块，它也有可能因为其有限的空间而不能与其它进程相联系。
中调整为：
processes = 50 # SMALL
#processes = 100 # MEDIUM
#processes = 200 # LARGE
输入以下命令，使配置生效
[root@localhost oracle]#sysctl -p
6 修改 /etc/security/
修改 /etc/security/,加入内容
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
7 修改系统环境变量/etc/profile
修改环境变量/etc/profile，加入以下内容
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
8 修改hosts文件
lihaolong:~ # vi /etc/hosts
增加一行
127.0.0.1 lihaolong
9 增加/dev/shm
MEMORY_MAX_TARGET 的设置不能超过 /dev/shm 的大小
编辑fstab，添加一行：
vi /etc/fstab
tmpfs /dev/shm tmpfs defaults,size=1024m 0 0
重新挂载来修改其大小
mount -o remount /dev/shm
10 修改suse版本
lihaolong:/home/database # vi /etc/SuSE-release
SUSE Linux Enterprise Server 11 (i586)
VERSION = 9（等号后面要有个空格）
PATCHLEVEL = 1
11 开始安装过程
应答文件：
注：安装oracle的目录，至少具备4G的空闲空间
[root@localhost oracle] # su oracle
[oracle@localhost oracle] #cd /usr/local/oracle/database
运行安装命令
[oracle@localhost database] # ./runInstaller -silent -responseFile /home/database/response/
db_
[
以下为
ORACLE
安装程序输出的结果
]
Starting Oracle
Checking Temp space: must be greater than 80 MB. Actual 10176 MB Passed
Checking swap space: must be greater than 150 MB. Actual 2047 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-05-31_09-41-19AM.
Please wait ...oracle@lihaolong:/home/database> [WARNING] [INS-32018] The selected Or
acle home is outside of Oracle base.
CAUSE: The Oracle home selected was outside of Oracle base.
ACTION: Oracle recommends installing Oracle software within the Oracle base director
y. Adjust the Oracle home or Oracle base accordingly.
[WARNING] [INS-13014] Target environment do not meet some optional requirements.
CAUSE: Some of the optional prerequisites are not met. See logs for details. /tmp/Or
aInstall2011-05-31_09-41-19AM/installActions2011-05-31_
ACTION: Identify the list of failed prerequisite checks from the log: /tmp/OraInstall201
1-05-31_09-41-19AM/installActions2011-05-31_. Then either from the log fil
e or from installation manual find the appropriate configuration to meet the prerequisite
s and fix it manually.
[WARNING] [INS-32018] The selected Oracle home is outside of Oracle base.
CAUSE: The Oracle home selected was outside of Oracle base.
ACTION: Oracle recommends installing Oracle software within the Oracle base director
y. Adjust the Oracle home or Oracle base accordingly.
[WARNING] [INS-13014] Target environment do not meet some optional requirements.
CAUSE: Some of the optional prerequisites are not met. See logs for details. /tmp/Or
aInstall2011-05-31_09-41-19AM/installActions2011-05-31_
ACTION: Identify the list of failed prerequisite checks from the log: /tmp/OraInstall201
1-05-31_09-41-19AM/installActions2011-05-31_. Then either from the log fil
e or from installation manual find the appropriate configuration to meet the prerequisite
s and fix it manually.
You can find the log of this install session at:
/opt/oracle/oraInventory/logs/installActions2011-05-31_[
日志文件位置
]
可通过执行以下命令，查看安装进度
[oracle@localhost database] #tail -f /opt/oracle/oraInventory/logs/installActions2011-05-31_0
oracle软件安装成功后，切换到root用户，执行以下2个脚本：
/opt/oracle/oraInventory/
/opt/oracle/product/11.2.0/db_1/
12 安装监听器
应答文件：
lihaolong:/opt/oracle/product/11.2.0/db_1/bin # ./netca /silent /responseFile /home/databas
e/response/
Parsing command line arguments:
Parameter "silent" = true
Parameter "responsefile" = /home/database/response/
Done parsing command line arguments.
Oracle Net Services Configuration:
Configuring Listener:LISTENER
Listener configuration complete.
Oracle Net Listener Startup:
Running Listener Control:
/opt/oracle/product/11.2.0/db_1/bin/lsnrctl start LISTENER
Listener Control complete.
Listener started successfully.
Profile configuration complete.
Oracle Net Services configuration successful. The exit code is 0
在安装完成后，需要将oracle目录的文件夹权限修改为755, 这样其他有ORACLE环境的
用户可以连接数据库。 20120201
13 创建数据库
应答文件：
lihaolong:/opt/oracle/product/11.2.0/db_1/bin # ./dbca -silent -responseFile /home/database
/response/
Copying database files
1% complete
2% complete
3% complete
4% complete
37% complete
Creating and starting Oracle instance
38% complete
40% complete
41% complete
46% complete
51% complete
56% complete
57% complete
58% complete
61% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
74% complete
85% complete
86% complete
87% complete
88% complete
99% complete
100% complete
Look at the log file "/opt/oracle/cfgtoollogs/dbca/orcl/" for further details.
14 设置ORACLE环境变量
切换至root用户修改全局环境变量配置文件profile。使用以下命令
[root@localhost oracle]#vi /etc/profile
往配置文件中加入以下内容
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=orcl
export PATH=$PATH:$ORACLE_HOME/bin
使环境变量配置生效（分别在root、oracle用户下执行）
[root@localhost oracle]# source /etc/profile
15 启动ORACLE
完成以上操作时，建议重新启动一次，避免某些设置未生效。重启后使用oracle用户登录，
打开终端，键入以下命令运行sqlplus
oracle@lihaolong:/opt/oracle/admin/orcl/pfile> sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Tue May 31 11:04:50 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 414298112 bytes
Fixed Size 1336904 bytes
Variable Size 255855032 bytes
Database Buffers 150994944 bytes
Redo Buffers 6111232 bytes
Database mounted.
Database opened.
SQL>
恭喜，你的ORACLE数据库已经启动成功！现在可以休息一下了。
全部完成后，再把suse的版本号改回去
16 异常解决
16.1 ORA-01102
这个错误主要是lk
这个lk
会删除掉,如果DATABASE确实没有MOUNT,这个文件在你也MOUNT上,只有手工删除,所以一定要小心.
具体解决ORA-01102问题的步骤:
oracle@lihaolong:/opt/oracle/product/11.2.0/db_1/dbs> ls -l
total 36
-rw-rw---- 1 oracle oinstall 1544 May 31 10:37 hc_
-rw-rw---- 1 oracle oinstall 1544 May 31 11:05 hc_
-rw-rw---- 1 oracle oinstall 1544 May 31 10:42 hc_
-rw-r--r-- 1 oracle oinstall 2851 May 15 2009
-rw-r----- 1 oracle oinstall 24 May 31 10:40 lkORCL
-rw-r----- 1 oracle oinstall 1536 May 31 10:41 orapworcl
drwx------ 2 oracle oinstall 4096 May 31 10:36 peshm_DBUA0_0
drwx------ 2 oracle oinstall 4096 May 31 10:37 peshm_orcl_0
-rw-r----- 1 oracle oinstall 2560 May 31 11:02
oracle@lihaolong:/opt/oracle/product/11.2.0/db_1/dbs> fuser -u lkORCL
/opt/oracle/product/11.2.0/db_1/dbs/lkORCL: 14588(oracle) 14594(oracle) 14598(oracle)
14600(oracle) 14604(oracle) 14606(oracle) 14608(oracle) 14610(oracle) 14612(oracle)
14614(oracle) 14616(oracle) 14618(oracle) 14664(oracle) 14683(oracle) 14685(oracle)
14687(oracle) 14759(oracle) 15300(oracle)
[
该文件没释放，用
fuser
命令
kill
掉：
]
oracle@lihaolong:/opt/oracle/product/11.2.0/db_1/dbs> fuser -k lkORCL
/opt/oracle/product/11.2.0/db_1/dbs/lkORCL: 14588 14594 14598 14600 14604 14606 14608
14610 14612 14614 14616 14618 14664 14683 14685 14687 14759 15300
oracle@lihaolong:/opt/oracle/product/11.2.0/db_1/dbs> fuser -u lkORCL
SQL> startup pfile=/opt/oracle/admin/orcl/pfile/.43
ORACLE instance started.
Total System Global Area 414298112 bytes
Fixed Size 1336904 bytes
Variable Size 255855032 bytes
Database Buffers 150994944 bytes
Redo Buffers 6111232 bytes
Database mounted.
Database opened.
SQL>
17 附件：Db_范例
####################################################################
## Copyright(c) Oracle Corporation 1998,2008. 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.
#------------------------------------------------------------------------------
seFileVersion=/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
#-------------------------------------------------------------------------------
=INSTALL_DB_AND_CONFIG
#-------------------------------------------------------------------------------
# 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=smdw
#-------------------------------------------------------------------------------
# Specify the Unix group to be set for the inventory directory.
#-------------------------------------------------------------------------------
UNIX_GROUP_NAME=oinstall
#-------------------------------------------------------------------------------
# Specify the location which holds the inventory files.
#-------------------------------------------------------------------------------
INVENTORY_LOCATION=/opt/oracle/inventory
#-------------------------------------------------------------------------------
# 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
#
# Example : SELECTED_LANGUAGES=en,fr,ja
#------------------------------------------------------------------------------
SELECTED_LANGUAGES=en
#------------------------------------------------------------------------------
# Specify the complete path of the Oracle Home.
#------------------------------------------------------------------------------
ORACLE_HOME=/opt/oracle/product/11.2.0
#------------------------------------------------------------------------------
# Specify the complete path of the Oracle Base.
#------------------------------------------------------------------------------
ORACLE_BASE=/opt/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)
#------------------------------------------------------------------------------
lEdition=EE
#------------------------------------------------------------------------------
# This variable is used to enable or disable custom install.
#
# true : Components mentioned as part of 'customComponents' property
# are considered for install.
# false : Value for 'customComponents' is not considered.
#------------------------------------------------------------------------------
omInstall=false
#------------------------------------------------------------------------------
# This variable is considered only if 'IsCustomInstall' is set to true.
#
# Description: List of Enterprise Edition Options you would like to install.
#
# 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 install.
#
# ioning:11.2.0.1.0 - Oracle Partitioning
# :11.2.0.1.0 - Oracle Data Mining
# :11.2.0.1.0 - Oracle Database Vault
# :11.2.0.1.0 - Oracle Label Security
# :11.2.0.1.0 - Oracle Real Application Testing
# p:11.2.0.1.0 - Oracle OLAP
#------------------------------------------------------------------------------
Components=:11.2.0.1.0,:10.2.7.0.0,oracle
.xdk:11.2.0.1.0,:11.2.0.1.0,k:11.2.0.1.0,er:11.
2.0.1.0,:11.2.0.1.0,s:11.2.0.1.0,ioning:11.2.0.1.0,ora
p:11.2.0.1.0,:11.2.0.1.0,:11.2.0.1.0,:1
1.2.0.1.0,:11.2.0.1.0
###############################################################################
# #
# 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 DBA_GROUP is the OS group which is to be granted OSDBA privileges.
#------------------------------------------------------------------------------
_GROUP=dba
#------------------------------------------------------------------------------
# The OPER_GROUP is the OS group which is to be granted OSOPER privileges.
#------------------------------------------------------------------------------
_GROUP=dba
#------------------------------------------------------------------------------
# Specify the cluster node names selected during the installation.
#------------------------------------------------------------------------------
R_NODES=
#------------------------------------------------------------------------------
# Specify the type of database to create.
# It can be one of the following:
# - GENERAL_PURPOSE/TRANSACTION_PROCESSING
# - DATA_WAREHOUSE
#------------------------------------------------------------------------------
=
#------------------------------------------------------------------------------
# Specify the Starter Database Global Database Name.
#------------------------------------------------------------------------------
DBName=orcl
#------------------------------------------------------------------------------
# Specify the Starter Database SID.
#------------------------------------------------------------------------------
=orcl
#------------------------------------------------------------------------------
# Specify the Starter Database character set.
#
# 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
#------------------------------------------------------------------------------
terSet=AL32UTF8
#------------------------------------------------------------------------------
# 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.
#------------------------------------------------------------------------------
Option=true
#------------------------------------------------------------------------------
# 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: Limit=512
#------------------------------------------------------------------------------
Limit=512
#------------------------------------------------------------------------------
# This variable controls whether to load Example Schemas onto the starter
# database or not.
#------------------------------------------------------------------------------
lExampleSchemas=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.
#------------------------------------------------------------------------------
SecuritySettings=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.
#-------------------------------------------------------------------------------
=ora11r2
#-------------------------------------------------------------------------------
# Specify the SYS password for the starter database.
#-------------------------------------------------------------------------------
=ora11r2
#-------------------------------------------------------------------------------
# Specify the SYSTEM password for the starter database.
#-------------------------------------------------------------------------------
=ora11r2
#-------------------------------------------------------------------------------
# Specify the SYSMAN password for the starter database.
#-------------------------------------------------------------------------------
=ora11r2
#-------------------------------------------------------------------------------
# Specify the DBSNMP password for the starter database.
#-------------------------------------------------------------------------------
=ora11r2
#-------------------------------------------------------------------------------
# Specify the management option to be selected for the starter database.
# It can be one of the following:
# 1. GRID_CONTROL
# 2. DB_CONTROL
#-------------------------------------------------------------------------------
l=DB_CONTROL
#-------------------------------------------------------------------------------
# Specify the Management Service to use if Grid Control is selected to manage
# the database.
#-------------------------------------------------------------------------------
ntrolServiceURL=
#-------------------------------------------------------------------------------
# This variable indicates whether to receive email notification for critical
# alerts when using DB control.
#-------------------------------------------------------------------------------
EmailNotification=false
#-------------------------------------------------------------------------------
# Specify the email address to which the notifications are to be sent.
#-------------------------------------------------------------------------------
ddress=
#-------------------------------------------------------------------------------
# Specify the SMTP server used for email notifications.
#-------------------------------------------------------------------------------
rver=
###############################################################################
# #
# 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.
#------------------------------------------------------------------------------
=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 at
# 2:00 AM to backup the database. This job will run as the operating system
# user that is specified in this variable.
#------------------------------------------------------------------------------
=
#-------------------------------------------------------------------------------
# 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 at
# 2:00 AM 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.
#-------------------------------------------------------------------------------
=
#-------------------------------------------------------------------------------
# Specify the type of storage to use for the database.
# It can be one of the following:
# - FILE_SYSTEM_STORAGE
# - ASM_STORAGE
#------------------------------------------------------------------------------
eType=FILE_SYSTEM_STORAGE
#-------------------------------------------------------------------------------
# Specify the database file location which is a directory for datafiles, control
# files, redo logs.
#
# Applicable only when e=FILE_SYSTEM
#-------------------------------------------------------------------------------
cation=/opt/oracle/
#-------------------------------------------------------------------------------
# Specify the backup and recovery location.
#
# Applicable only when e=FILE_SYSTEM
#-------------------------------------------------------------------------------
ryLocation=
#-------------------------------------------------------------------------------
# Specify the existing ASM disk groups to be used for storage.
#
# Applicable only when e=ASM
#-------------------------------------------------------------------------------
oup=
#-------------------------------------------------------------------------------
# Specify the password for ASMSNMP user of the ASM instance.
#
# Applicable only when e=ASM_SYSTEM
#-------------------------------------------------------------------------------
PPassword=ora11r2
#------------------------------------------------------------------------------
# Specify the My Oracle Support Account Username.
#
# Example : MYORACLESUPPORT_USERNAME=metalink
#------------------------------------------------------------------------------
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=
#------------------------------------------------------------------------------
# Specify whether user wants to give any proxy details for connection.
# 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_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=
发布评论