SUSE Linux Enterprise 11SP1靜默安裝Oracle 11gR2說明文件

myamor發表於2013-09-09

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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章