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'
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
$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
配置方法与安装时相同;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16976507/viewspace-1250399/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/16976507/viewspace-1250399/