ITPub博客

首页 > Linux操作系统 > Linux操作系统 > SUSE Linux Enterprise 11SP1静默安装Oracle 11gR2说明文档

SUSE Linux Enterprise 11SP1静默安装Oracle 11gR2说明文档

原创 Linux操作系统 作者:myamor 时间:2013-09-09 10:46:08 0 删除 编辑

1       准备oracle安装文件

Oracle11gR2包含两个文件linux_11gR2_database_1of2.ziplinux_11gR2_database_2of2.zip,下载地址分别是:

http://download.oracle.com/otn/linux/oracle11g/R2/linux_11gR2_database_1of2.zip

http://download.oracle.com/otn/linux/oracle11g/R2/linux_11gR2_database_2of2.zip

下载完成后将这两个文件通过SSH上传到/usr/local/oracle中。

 

解压安装文件到当前目录

[root@localhost root]#cd /usr/local/oracle

[root@localhost oracle]#unzip linux_11gR2_database_1of2.zip

[root@localhost oracle]#unzip linux_11gR2_database_2of2.zip

执行以上命令后,将会在/usr/local/oracle/下面产生名为database的目录,这就是oracle安装程序的目录。

2       准备oracle的安装目标目录

[root@localhost oracle]#mkdir –p /opt/oracle

安装目标目录是用户想将oracle安装到哪个位置的目录,本次我们将oracle安装到/opt/oracle目录中,以下为目录创建命令。

3       创建oracle相关用户和用户组

oracle不能在root帐户下进行安装,所以需要为oracle的安装专门创建一个用户,同时需要创建dbaoinstall的用户组。

[root@localhost oracle]#groupadd dba

[root@localhost oracle]#groupadd oinstall

以下命令将创建dbaoinstall用户组:

 

以下命令将创建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 linux-kernel-headers-2.6.32-1.4.13.noarch.rpm

[root@localhost oracle]#rpm -ivh glibc-devel-2.11.1-0.17.4.i586.rpm

[root@localhost oracle]#rpm -ivh gcc43-4.3.4_20091019-0.7.35.i586.rpm

[root@localhost oracle]#rpm -ivh gcc-4.3-62.198.i586.rpm

[root@localhost oracle]#rpm -ivh libstdc++43-devel-4.3.4_20091019-0.7.35.i586.rpm

[root@localhost oracle]#rpm -ivh gcc43-c++-4.3.4_20091019-0.7.35.i586.rpm

[root@localhost oracle]#rpm -ivh gcc-c++-4.3-62.198.i586.rpm

[root@localhost oracle]#rpm -ivh sysstat-8.1.5-7.9.56.i586.rpm

[root@localhost oracle]#rpm -ivh libaio-devel-0.3.109-0.1.46.i586.rpm

[root@localhost oracle]#rpm -ivh libstdc++-devel-4.3-62.198.i586.rpm

[root@localhost oracle]#rpm -ivh unixODBC-2.2.12-198.17.i586.rpm

[root@localhost oracle]#rpm -ivh unixODBC-devel-2.2.12-198.17.i586.rpm

 

5       设置linux内核参数

打开修改/etc/sysctl.conf,在最后加入以下内容

kernel.shmall = 2097152

kernel.shmmax = 2147483648

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.core.rmem_default = 4194304

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

fs.file-max = 6815744

net.ipv4.ip_local_port_range = 9000 65500

net.core.wmem_max = 1048576

fs.aio-max-nr = 1048576

有的时候我们需要调整oracle数据库的最大链接数,而这个链接数的调整是在oacle下的dbs目录下init.ora文件中调整的。
  ORACLE的连接数(sessions)与其参数文件中的进程数(process)有关,它们的关系如下:
  sessions=(1.1*process+5)
  但是我们增加process数时,往往数据库不能启动了。这因为我们还漏调了一个unix系统参数:它是核心参数中的semmns,这是unix系统的信号量参数。每个process会占用一个信号量。semmns调整后,需要重新启动unix操作系统,参数才能生效。不过它的大小会受制于硬件的内存或 ORACLE SGA。范围可从200——2000不等。
  但是,Processes的修改不仅应该调整init.ora文件中的参数,而且应该调整OS的内核参数,象 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要加大,至少要比processes18

  SEMMNI1010000150):指定在核心中信号识别的数量。这是可以在任意给定时间被激活的唯一信号设置数量。缺省值是150。最大值由系统自动调整产生。
  SEMMSL25300150):指定每个信号识别中信号量的最大值。缺省值是25
  SEMMNS 除最大db外的所有db PROCESSES之和+2*最大dbPROCESSES+10*实例数。如3个实例进程数分别为100100200,则=100+100+2*200+10*3=630
  SEMOPM102010):指定在每个系统调用semop中能够被执行的信号操作量的最大值。缺省值是10
  SHMMAX1310721073741824524288):指定了共享内存部分大小的最大值。等于0.5×物理内存字节数
  SHMMNI101000100):指定了系统范围内共享内存标识的最大值。
  SHMSEG6156):指定了与每个进程相关连的共享内存块(或标识)的数量。缺省值是6。与每个进程相关连的共享内存块的最大值与进程拥有的未使用空间有关。因此,尽管一个进程拥有少于SHMSEG数值的共享内存块,它也有可能因为其有限的空间而不能与其它进程相联系。
  init.ora中调整为:
  processes = 50 # SMALL
  #processes = 100 # MEDIUM
  #processes = 200 # LARGE

 

 

输入以下命令,使配置生效

[root@localhost oracle]#sysctl -p

 

6       修改 /etc/security/limits.conf

修改 /etc/security/limits.conf,加入内容

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_install.rsp

[以下为ORACLE安装程序输出的结果]

Starting Oracle Universal Installer...

 

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 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 directory. 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/OraInstall2011-05-31_09-41-19AM/installActions2011-05-31_09-41-19AM.log

   ACTION: Identify the list of failed prerequisite checks from the log: /tmp/OraInstall2011-05-31_09-41-19AM/installActions2011-05-31_09-41-19AM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites 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 directory. 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/OraInstall2011-05-31_09-41-19AM/installActions2011-05-31_09-41-19AM.log

   ACTION: Identify the list of failed prerequisite checks from the log: /tmp/OraInstall2011-05-31_09-41-19AM/installActions2011-05-31_09-41-19AM.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:

 /opt/oracle/oraInventory/logs/installActions2011-05-31_09-41-19AM.log[日志文件位置]

 

可通过执行以下命令,查看安装进度

[oracle@localhost database] #tail -f /opt/oracle/oraInventory/logs/installActions2011-05-31_09-41-19AM.log

 

 

oracle软件安装成功后,切换到root用户,执行以下2个脚本:

/opt/oracle/oraInventory/orainstRoot.sh

/opt/oracle/product/11.2.0/db_1/root.sh

12             安装监听器

应答文件:

lihaolong:/opt/oracle/product/11.2.0/db_1/bin # ./netca /silent /responseFile /home/database/response/netca.rsp

 

Parsing command line arguments:

    Parameter "silent" = true

    Parameter "responsefile" = /home/database/response/netca.rsp

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/dbca.rsp

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/orcl.log" 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

 

使环境变量配置生效(分别在rootoracle用户下执行)

[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文件造成的,该文件位于ORALCE_HOME下的dbs目录下,

这个lk的主要作用是说明DATABASE MOUNT上了,不用在MOUNT.DATABASE UNMOUNT 后会删除掉,如果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_DBUA0.dat

-rw-rw---- 1 oracle oinstall 1544 May 31 11:05 hc_ORCL.dat

-rw-rw---- 1 oracle oinstall 1544 May 31 10:42 hc_orcl.dat

-rw-r--r-- 1 oracle oinstall 2851 May 15  2009 initORCL.ora

-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 spfileorcl.ora

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/init.ora.4312011104150

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_install.rsp范例

 

 

 

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

## 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.

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

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_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)

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

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

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

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

#       

#              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.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 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.

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

oracle.install.db.DBA_GROUP=dba

 

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

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

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

oracle.install.db.OPER_GROUP=dba

 

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

# Specify the cluster node names selected during the installation.

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

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                                

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

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

 

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

# Specify the Starter Database Global Database Name.

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

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

 

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

# Specify the Starter Database SID.

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

oracle.install.db.config.starterdb.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

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

oracle.install.db.config.starterdb.characterSet=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.

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

oracle.install.db.config.starterdb.memoryOption=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: oracle.install.db.config.starterdb.memoryLimit=512

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

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

 

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

# 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=ora11r2

 

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

# Specify the SYS password for the starter database.

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

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

 

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

# Specify the SYSTEM password for the starter database.

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

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

 

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

# Specify the SYSMAN password for the starter database.

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

oracle.install.db.config.starterdb.password.SYSMAN=ora11r2

 

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

# Specify the DBSNMP password for the starter database.

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

oracle.install.db.config.starterdb.password.DBSNMP=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

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

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=

 

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

# This variable indicates whether to receive email notification for critical

# alerts when using DB control.  

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

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

 

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

# Specify the email address to which the notifications are to be sent.

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

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

 

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

# Specify the SMTP server used for email notifications.

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

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

 

 

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

#                                                                             #

# 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 at

# 2:00 AM 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 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.

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

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=FILE_SYSTEM_STORAGE

 

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

# 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

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

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

 

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

# Specify the backup and recovery location.

#

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

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

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.storage=ASM

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

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_SYSTEM

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

oracle.install.db.config.asm.ASMSNMPPassword=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.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=

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/177006/viewspace-772378/,如需转载,请注明出处,否则将追究法律责任。

上一篇: TSM概念笔记(转)
下一篇: HIVE的安装配置
请登录后发表评论 登录
全部评论

注册时间:2012-03-20

  • 博文量
    20
  • 访问量
    136740