Oracle 10g RAC 靜默安裝過程

本章主要介紹靜默安裝，OUI安裝過程請參照其他文件。

本文安裝環境為： vmware station 7 + redhat linux 4.7+ORACLE 10.2.4

以下是各步驟的靜默安裝方法:

1.安裝clusterware

./runInstaller -silent -responsefile /home/oracle/crs_rac01.rsp

crs_rac01.rsp內容：

RESPONSEFILE_VERSION=2.2.1.0.0

UNIX_GROUP_NAME="oinstall"

FROM_LOCATION="../stage/products.xml"

NEXT_SESSION_RESPONSE=

ORACLE_HOME="/app/oracle/product/10.2.0/crs_1"

ORACLE_HOME_NAME="Ora10gCrshome"

TOPLEVEL_COMPONENT={"oracle.crs","10.2.0.1.0"}

DEINSTALL_LIST={"oracle.crs","10.2.0.1.0"}

SHOW_SPLASH_SCREEN=false

SHOW_WELCOME_PAGE=false

SHOW_NODE_SELECTION_PAGE=false

SHOW_SUMMARY_PAGE=false

SHOW_INSTALL_PROGRESS_PAGE=false

SHOW_CONFIG_TOOL_PAGE=false

SHOW_XML_PREREQ_PAGE=false

SHOW_ROOTSH_CONFIRMATION=true

SHOW_END_SESSION_PAGE=false

SHOW_EXIT_CONFIRMATION=false

NEXT_SESSION=false

NEXT_SESSION_ON_FAIL=false

SHOW_DEINSTALL_CONFIRMATION=false

SHOW_DEINSTALL_PROGRESS=false

RESTART_SYSTEM=false

RESTART_REMOTE_SYSTEM=false

REMOVE_HOMES=

ORACLE_HOSTNAME=

SHOW_END_OF_INSTALL_MSGS=false

COMPONENT_LANGUAGES={"en"}

s_clustername="crs"

sl_tableList={"rac01:rac01-priv:rac01-vip:N:Y","rac02:rac02-priv:rac02-vip:N:Y"}

CLUSTER_CONFIGURATION_FILE=""

ret_PrivIntrList={"eth0:192.168.1.0:1","eth1:10.1.1.0:2"}

n_storageTypeOCR=2

s_ocrpartitionlocation="/dev/raw/raw3"

s_ocrMirrorLocation=""

n_storageTypeVDSK=2

s_votingdisklocation="/dev/raw/raw4"

s_OcrVdskMirror1RetVal=""

s_VdskMirror2RetVal=""

安裝完成後root依次執行：

/app/oracle/oraInventory/orainstRoot.sh (rac01,rac02)

/app/oracle/product/10.2.0/crs_1/root.sh (rac01,rac02)

#./oifcfg setif -global eth1/10.1.1.0:cluster_interconnect

#./oifcfg setif -global eth0/192.168.1.0:public

#vi vipca

unset LD_ASSUME_KERNEL

#./vipca -silent -nodelist rac01,rac02 -nodevips rac01/192.168.1.100,rac02/192.168.1.110

2.安裝oracle rac soft

./runInstaller -silent -responsefile /home/oracle/db_rac01.rsp

db_rac01.rsp內容：

RESPONSEFILE_VERSION=2.2.1.0.0

UNIX_GROUP_NAME="oinstall"

FROM_LOCATION="../stage/products.xml"

NEXT_SESSION_RESPONSE=

ORACLE_HOME="/app/oracle/product/10.2.0/db_1"

ORACLE_HOME_NAME="ora10gdbhome"

TOPLEVEL_COMPONENT={"oracle.server","10.2.0.1.0"}

DEINSTALL_LIST={"oracle.server","10.2.0.1.0"}

SHOW_SPLASH_SCREEN=false

SHOW_WELCOME_PAGE=false

SHOW_NODE_SELECTION_PAGE=false

SHOW_SUMMARY_PAGE=false

SHOW_INSTALL_PROGRESS_PAGE=false

SHOW_CONFIG_TOOL_PAGE=false

SHOW_XML_PREREQ_PAGE=false

SHOW_ROOTSH_CONFIRMATION=true

SHOW_END_SESSION_PAGE=false

SHOW_EXIT_CONFIRMATION=false

NEXT_SESSION=false

NEXT_SESSION_ON_FAIL=false

SHOW_DEINSTALL_CONFIRMATION=false

SHOW_DEINSTALL_PROGRESS=false

RESTART_SYSTEM=

RESTART_REMOTE_SYSTEM=

REMOVE_HOMES=

ORACLE_HOSTNAME=

SHOW_END_OF_INSTALL_MSGS=false

CLUSTER_NODES={"rac01","rac02"}

COMPONENT_LANGUAGES={"en"}

INSTALL_TYPE="EE"

s_nameForDBAGrp="dba"

s_nameForOPERGrp="dba"

n_configurationOption=3 #3-只裝軟體 #2-配置asm例項#1-建立資料庫

s_ASMSYSPassword=""

s_ASMSYSPasswordAgain=""

#----------當n_configurationOption=3時以下引數暫不用配置----------------------------------------

n_dbType=1

oracle.assistants.server:s_responseFileName=

s_globalDBName=

s_dbSid="racdb"

s_dbRetChar="WE8ISO8859P1"

b_loadExampleSchemas=false

b_useDBControl=true

b_receiveEmailNotification=false

s_dlgEMSMTPServer=

s_dlgEMEmailAddress=

s_dlgEMCentralAgentSelected=

n_dbStorageType=

s_mountPoint=

s_rawDeviceMapFileLocation=

b_enableAutoBackup=false

b_useFileSystemForRecovery=true

s_dlgRBORecoveryLocation=

s_dlgRBOUsername=

s_dlgRBOPassword=

s_dlgASMCfgDiskGroupName="DATA"

s_dlgASMCfgDiskDiscoveryString=

n_dlgASMCfgRedundancySelected=

sl_dlgASMCfgSelectableDisks=

sl_dlgASMCfgDiskSelections=

sl_dlgASMDskGrpSelectedGroup={" "," "," "," "}

b_centrallyManageASMInstance=true

b_useSamePassword=true

s_superAdminSamePasswd=

s_superAdminSamePasswdAgain=

sl_superAdminPasswds=

sl_superAdminPasswdsAgain=

n_performUpgrade=0

n_upgradeDB=0

s_dbOHSelectedForUpgrade=""

s_dbSIDSelectedForUpgrade=""

n_upgradeASM=0

s_dbSelectedUsesASM="no"

sl_upgradableSIDBInstances={}

sl_upgradableRACDBInstances={}

n_dbSelection=0

b_stateOfUpgradeASMCheckbox=false

b_stateOfUpgradeDBCheckbox=false

b_oneClick=false

s_dlgASMCfgRedundancyValue=""

s_dlgASMCfgExistingFreeSpace="0"

s_dlgASMCfgNewDisksSize=""

s_dlgASMCfgAdditionalSpaceNeeded="0 MB"

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

安裝完成後root依次執行：

/app/oracle/product/10.2.0/db_1/root.sh

3.升級clusterware

./runInstaller -silent -responsefile /home/oracle/crs_patchset.rsp

crs_patchset.rsp內容：

RESPONSEFILE_VERSION=2.2.1.0.0

UNIX_GROUP_NAME= #預設為執行安裝的使用者

FROM_LOCATION=

NEXT_SESSION_RESPONSE=

ORACLE_HOME="/app/oracle/product/10.2.0/crs_1"

ORACLE_HOME_NAME="Ora10gCrshome"

TOPLEVEL_COMPONENT={"oracle.patchset.db","10.2.0.4.0"}

SHOW_SPLASH_SCREEN=false

SHOW_WELCOME_PAGE=false

SHOW_COMPONENT_LOCATIONS_PAGE=false

SHOW_CUSTOM_TREE_PAGE=false

SHOW_SUMMARY_PAGE=false

SHOW_INSTALL_PROGRESS_PAGE=true

SHOW_REQUIRED_CONFIG_TOOL_PAGE=false

SHOW_OPTIONAL_CONFIG_TOOL_PAGE=false

SHOW_CONFIG_TOOL_PAGE=false

SHOW_XML_PREREQ_PAGE=false

SHOW_RELEASE_NOTES=false

SHOW_END_OF_INSTALL_MSGS=true

SHOW_ROOTSH_CONFIRMATION=true

SHOW_END_SESSION_PAGE=false

SHOW_EXIT_CONFIRMATION=false

NEXT_SESSION=false

NEXT_SESSION_ON_FAIL=false

SHOW_DEINSTALL_CONFIRMATION=false

SHOW_DEINSTALL_PROGRESS=false

ACCEPT_LICENSE_AGREEMENT=true

RESTART_SYSTEM=

CLUSTER_NODES={"rac01","rac02"}

OUI_HOSTNAME=

REMOVE_HOMES=

COMPONENT_LANGUAGES={"en"}

sl_userNodeList={"rac01","rac02"}

b_acceptLicense=

b_useRegistration=

s_csiNumber=

s_metaLink=

s_countryName=

b_proxyused=

s_serverName=

s_portNumber=

s_userName=

s_proxyPassword=

b_authenticationused=

升級完成後root依次執行 { rac01，rac02}：

[/app/oracle/product/10.2.0/crs_1/bin]#./crsctl stop crs

[/app/oracle/product/10.2.0/crs_1/install]./root102.sh

4.升級RAC soft（打補丁）

./runInstaller -silent -responsefile /home/oracle/db_patchset.rsp

db_patchset.rsp內容：（與crs_patchset.rsp有差異的地方）

ORACLE_HOME="/app/oracle/product/10.2.0/db_1"

ORACLE_HOME_NAME="Ora10gdbhome"

升級完成後root依次執行：

/app/oracle/product/10.2.0/db_1/root.sh { rac01，rac02}

5.配置監聽listener

oracle使用者rac01,rac02節點依次操作

$ORACLE_HOME/network/admin/listener.ora

rac01配置如下：

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = rac01)(PORT = 1521)(IP = FIRST))

(ADDRESS = (PROTOCOL = TCP)(HOST = rac01-vip)(PORT = 1521)(IP = FIRST))

)

(ADDRESS_LIST =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

)

配置完成後，註冊到crs (oracle)；

$crs_register ora.rac01.LISTENER.lsnr -dir /home/oracle

ora.rac01.LISTENER.lsnr.cap 檔案內容：

NAME=ora.rac01.LISTENER_VMTEST02.lsnr

TYPE=application

ACTION_SCRIPT=/app/oracle/product/10.2.0/db_1/bin/racgwrap

ACTIVE_PLACEMENT=0

AUTO_START=1

CHECK_INTERVAL=600

DESCRIPTION=CRS application for listener on node

FAILOVER_DELAY=0

FAILURE_INTERVAL=0

FAILURE_THRESHOLD=0

HOSTING_MEMBERS=rac01

OPTIONAL_RESOURCES=

PLACEMENT=restricted

REQUIRED_RESOURCES=ora.rac01.vip

RESTART_ATTEMPTS=5

SCRIPT_TIMEOUT=600

START_TIMEOUT=0

STOP_TIMEOUT=0

UPTIME_THRESHOLD=7d

USR_ORA_ALERT_NAME=

USR_ORA_CHECK_TIMEOUT=0

USR_ORA_CONNECT_STR=/ as sysdba

USR_ORA_DEBUG=0

USR_ORA_DISCONNECT=false

USR_ORA_FLAGS=

USR_ORA_IF=

USR_ORA_INST_NOT_SHUTDOWN=

USR_ORA_LANG=

USR_ORA_NETMASK=

USR_ORA_OPEN_MODE=

USR_ORA_OPI=false

USR_ORA_PFILE=

USR_ORA_PRECONNECT=none

USR_ORA_SRV=

USR_ORA_START_TIMEOUT=0

USR_ORA_STOP_MODE=immediate

USR_ORA_STOP_TIMEOUT=0

USR_ORA_VIP=

6.配置ASM例項

oracle使用者rac01,rac02節點依次操作

6.1 配置pfile引數檔案

init+ASM1.ora引數檔案內容：

background_dump_dest=/app/oracle/admin/+ASM/bdump

core_dump_dest=/app/oracle/admin/+ASM/cdump

user_dump_dest=/app/oracle/admin/+ASM/udump

instance_type=asm

large_pool_size=12M

remote_login_passwordfile=exclusive

asm_diskgroups='DG1','DG2','RECOVERYDEST','DGTEST'

cluster_database=true

+ASM1.instance_number=1

+ASM2.instance_number=2

6.2 密碼檔案

$orapwd file=orapw+ASM1 password=oracle entries=5

6.3 建立必要目錄

$mkdir -p /app/oracle/admin/+ASM/bdump

$mkdir -p /app/oracle/admin/+ASM/cdump

$mkdir -p /app/oracle/admin/+ASM/udump

6.4 啟動例項，建立盤組

create diskgroup DG external redundancy disk '/dev/raw/raw1','/dev/raw/raw2'

6.5 註冊ASM例項到CRS

$crs_register ora.rac01.ASM1.asm -dir /home/oracle

ora.rac01.ASM1.asm.cap 檔案內容：

NAME=ora.rac01.ASM1.asm

TYPE=application

ACTION_SCRIPT=/app/oracle/product/10.2.0/db_1/bin/racgwrap

ACTIVE_PLACEMENT=0

AUTO_START=1

CHECK_INTERVAL=600

DESCRIPTION=CRS application for ASM instance

FAILOVER_DELAY=0

FAILURE_INTERVAL=0

FAILURE_THRESHOLD=0

HOSTING_MEMBERS=rac01

OPTIONAL_RESOURCES=

PLACEMENT=restricted

REQUIRED_RESOURCES=

RESTART_ATTEMPTS=5

SCRIPT_TIMEOUT=600

START_TIMEOUT=0

STOP_TIMEOUT=0

UPTIME_THRESHOLD=7d

USR_ORA_ALERT_NAME=

USR_ORA_CHECK_TIMEOUT=0

USR_ORA_CONNECT_STR=/ as sysdba

USR_ORA_DEBUG=0

USR_ORA_DISCONNECT=false

USR_ORA_FLAGS=

USR_ORA_IF=

USR_ORA_INST_NOT_SHUTDOWN=

USR_ORA_LANG=

USR_ORA_NETMASK=

USR_ORA_OPEN_MODE=mount

USR_ORA_OPI=false

USR_ORA_PFILE=

USR_ORA_PRECONNECT=none

USR_ORA_SRV=

USR_ORA_START_TIMEOUT=0

USR_ORA_STOP_MODE=immediate

USR_ORA_STOP_TIMEOUT=0

USR_ORA_VIP=

7.手動建立資料庫

7.1 配置pfile.ora，建立必要目錄

注意引數：*.cluster_database=false(必須為false，create database 才能成功)

*.control_files='+DGTEST'

*.db_create_file_dest='+DGTEST'(未建立DB之前，指定db_create_file_dest，預設OMF)

例如：pfile.ora

*.__db_cache_size=142606336

*.__java_pool_size=4194304

*.__large_pool_size=4194304

*.__shared_pool_size=113246208

*.__streams_pool_size=0

*.audit_file_dest='/home/oracle/admin/racdb/adump'

*.background_dump_dest='/home/oracle/admin/racdb/bdump'

*.cluster_database_instances=2

*.cluster_database=false ###必須指定為false

*.compatible='10.2.0.5.0'

*.control_files='+DGTEST' ###建立資料庫前沒有具體控制檔名

*.db_create_file_dest='+DGTEST'

*.core_dump_dest='/home/oracle/admin/racdb/cdump'

*.db_block_size=8192

*.db_domain='guoxin.cn'

*.db_file_multiblock_read_count=16

*.db_name='racdb'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=racdbXDB)'

racdb1.instance_number=1

racdb2.instance_number=2

*.job_queue_processes=10

*.open_cursors=300

*.pga_aggregate_target=94371840

*.processes=150

*.remote_listener='LISTENERS_RACDB'

*.remote_login_passwordfile='exclusive'

*.sga_target=283115520

racdb2.thread=2

racdb1.thread=1

*.undo_management='AUTO'

racdb1.undo_tablespace='UNDOTBS1'

racdb2.undo_tablespace='UNDOTBS2'

*.user_dump_dest='/home/oracle/admin/racdb/udump'

[oracle]$mkdir -p /home/oracle/admin/racdb/adump

[oracle]$mkdir -p /home/oracle/admin/racdb/bdump

[oracle]$mkdir -p /home/oracle/admin/racdb/cdump

[oracle]$mkdir -p /home/oracle/admin/racdb/udump

[oracle]$mkdir -p /home/oracle/admin/racdb/dpdump

7.2 建立資料庫

SQL>startup nomount pfile='/app/oracle/product/10.2.0/db_1/dbs/pfile.ora'

SQL>CREATE DATABASE racdb

USER SYS IDENTIFIED BY oracle

USER SYSTEM IDENTIFIED BY oracle

CONTROLFILE REUSE

LOGFILE

GROUP 1 ('+SYSDG', '+DATADG') SIZE 500M reuse,

GROUP 2 ('+SYSDG', '+DATADG') SIZE 500M reuse,

GROUP 3 ('+SYSDG', '+DATADG') SIZE 500M reuse

MAXLOGFILES 50

MAXLOGHISTORY 200

MAXDATAFILES 20000

MAXINSTANCES 8

NOARCHIVELOG

CHARACTER SET ZHS16GBK

NATIONAL CHARACTER SET AL16UTF16

DATAFILE '+SYSDG' SIZE 2000M autoextend on next 100M maxsize unlimited EXTENT MANAGEMENT LOCAL

SYSAUX DATAFILE '+SYSDG' SIZE 1000M autoextend on next 100M maxsize unlimited

UNDO TABLESPACE UNDOTBS1 DATAFILE '+SYSDG' SIZE 500M autoextend on next 100M maxsize unlimited

DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '+SYSDG' SIZE 500M autoextend on next 100M maxsize unlimited

DEFAULT TABLESPACE USERS DATAFILE '+SYSDG' SIZE 1000M autoextend on next 100M maxsize unlimited;

建立成功！

7.3 修改pfile.ora，重啟例項

例如：

*.cluster_database=TRUE

*.control_files='+DGTEST/dxdb/controlfile/current.256.778609959'##指定具體控制檔名

*.db_create_file_dest='+DGTEST'

SQL>shutdown immediate

SQL>startup pfile='/app/oracle/product/10.2.0/db_1/dbs/pfile.ora'

7.4 為thread 2建立UNDO表空間和REDO檔案

例如：

alter database add logfile thread 2 group 4 ('+DATADG','+SYSDG') size 500M;

alter database add logfile thread 2 group 5 ('+DATADG','+SYSDG') size 500M;

alter database add logfile thread 2 group 6 ('+DATADG','+SYSDG') size 500M;

alter database enable public thread 2;

create UNDO TABLESPACE UNDOTBS2 DATAFILE '+SYSDG' SIZE 500M autoextend on next 100M maxsize unlimited;

7.5 建立必要檢視

sql>sqlplus / as sysdba

sql>@$ORACLE_HOME/rdbms/admin/catalog.sql

sql>@$ORACLE_HOME/rdbms/admin/catproc.sql

sql>conn system/oracle

sql>@$ORACLE_HOME/sqlplus/admin/pupbld.sql

sql>@?/sqlplus/admin/help/hlpbld.sql helpus.sql

叢集必要檢視

sql>sqlplus / as sysdba

SQL> @?/rdbms/admin/catclust.sql

7.6 註冊database和instance到CRS

$sqlplus / as sysdba

sql>startup pfile='/app/oracle/product/10.2.0/db_1/dbs/pfile.ora'

sql>create spfile='+DG/RACDB/spfileracdb.ora' from pfile;

$srvctl add database -d racdb -o '/app/oracle/product/10.2.0/db_1' -p '+DG/RACDB/spfileracdb.ora'

$ srvctl add instance -d racdb -i racdb1 -n rac01

$srvctl add instance -d racdb -i racdb2 -n rac02

$srvctl start database -d racdb

8.增加新節點到RAC

增加新節點到RAC的順序與安裝順序相同；

8.1 準備新節點

? 作業系統及相關rpm包

? 資料庫安裝準備，如oracle使用者（userid、groupid與RAC節點相同）

? 能訪問共享儲存，與其他節點相同許可權；

? 網路連線，ip、ssh、時間同步

8.2 增加新節點到叢集件（clusterware）

? 靜默方式，在已經存在的RAC節點上，oracle使用者下：

$ORA_CRS_HOME/oui/bin/addNode.sh -silent "CLUSTER_NEW_NODES={ rac03}"

"CLUSTER_NEW_PRIVATE_NODE_NAMES={rac03-priv}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={ rac03-vip}"

? ORA_CRS_HOME/opmn/conf/ons.config 瞭解相關埠

? racgons add_config new_node_name:remote_port

8.3 增加新節點到資料庫

執行ORACLE_HOME/oui/bin/addNode.sh

靜默方式，在已經存在的RAC節點上，oracle使用者下：

./addNode.sh -silent "CLUSTER_NEW_NODES={rac03}"

8.4新節點上配置監聽listener

配置方法與安裝時相同；

8.5新節點上配置ASM、DB例項，增加ASM、DB例項到crs

配置方法與安裝時相同；

Oracle 10g RAC 靜默安裝過程

相關文章