Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE1.      添加GRID（50分钟）

-- <节点2> root用户

# chmod 775 /oracle/app

# chmod 775 /oracle/app/11.2

 

-- <节点1> GRID用户

$ export GRID_HOME=/oracle/app/11.2/grid

$ cd $GRID_HOME/oui/bin

 

-- <节点1> 测试，注意报错信息

$ ./addNode.sh "CLUSTER_NEW_NODES={acctdb04}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={acctdb04-vip}"

 

-- <节点1> 修改addNode.sh文件后再次运行（40分钟完成CP和跑脚本）

$ ./addNode.sh "CLUSTER_NEW_NODES={acctdb04}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={acctdb04-vip}"

 

-- <节点2> 跑脚本

# /oracle/app/oraInventory/orainstRoot.sh

# /oracle/app/11.2/grid/root.sh

 

-- <节点2> 监控日志

/cfgtoollogs/crsconfig/rootcrs_.log

 

-- 屏幕输出示例

root@hrdb02#[/oracle/app/11.2]/oracle/app/11.2/grid/root.sh Performing root user operation for Oracle 11g   The following environment variables are set as:     ORACLE_OWNER= grid     ORACLE_HOME=  /oracle/app/11.2/grid   Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of "dbhome" have not changed. No need to overwrite. The contents of "oraenv" have not changed. No need to overwrite. The contents of "coraenv" have not changed. No need to overwrite.     Creating /etc/oratab file... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed. Using configuration parameter file: /oracle/app/11.2/grid/crs/install/crsconfig_params Creating trace directory User ignored Prerequisites during installation User grid has the required capabilities to run CSSD in realtime mode OLR initialization - successful Adding Clusterware entries to inittab CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node unknown, number unknown, and is terminating An active cluster was found during exclusive startup, restarting to join the cluster clscfg: EXISTING configuration version 5 detected. clscfg: version 5 is 11g Release 2. Successfully accumulated necessary OCR keys. Creating OCR keys for user 'root', privgrp 'system'.. Operation successful. Configure Oracle Grid Infrastructure for a Cluster ... succeeded

 

2.      添加DBHOME(50分钟)

-- <节点1> oracle用户

$ cd $ORACLE_HOME/oui/bin

$ ./addNode.sh "CLUSTER_NEW_NODES={acctdb04}"

 

-- <节点2> 跑脚本

# $ORACLE_HOME/root.sh

 

3.      添加INSTANCE

-- 加REDO

alter database add logfile thread 2 group  7 '/dev/vx/rdsk/vgacctdb21/lv_redo_1g_401' size 1023M;

alter database add logfile thread 2 group  8 '/dev/vx/rdsk/vgacctdb22/lv_redo_1g_402' size 1023M;

alter database add logfile thread 2 group  9 '/dev/vx/rdsk/vgacctdb23/lv_redo_1g_403' size 1023M;

alter database add logfile thread 2 group 10 '/dev/vx/rdsk/vgacctdb21/lv_redo_1g_404' size 1023M;

alter database add logfile thread 2 group 11 '/dev/vx/rdsk/vgacctdb22/lv_redo_1g_405' size 1023M;

alter database add logfile thread 2 group 12 '/dev/vx/rdsk/vgacctdb23/lv_redo_1g_406' size 1023M;

alter database enable thread 2;

 

-- 加UNDO

create undo tablespace undotbs2    datafile '/dev/vx/rdsk/vgacctdb21/lv_undo_16g_401' size 16383M autoextend off;

alter tablespace undotbs2 add datafile '/dev/vx/rdsk/vgacctdb22/lv_undo_16g_402' size 16383M autoextend off;

alter tablespace undotbs2 add datafile '/dev/vx/rdsk/vgacctdb23/lv_undo_16g_403' size 16383M autoextend off;

 

-- 设置参数

ALTER SYSTEM SET thread=2                 SCOPE=SPFILE SID='xzb2';

ALTER SYSTEM SET instance_number=2        SCOPE=SPFILE SID='xzb2';

ALTER SYSTEM SET undo_tablespace=undotbs2 SCOPE=SPFILE SID='xzb2';

ALTER SYSTEM SET log_archive_dest_1='location=/acct4_arch' SCOPE=SPFILE SID='xzb2';

 

-- 节点2上修改init文件指向

srvctl add instance -d xzb -i xzb2 -n acctdb04

srvctl start instance -d xzb -n acctdb04

拷贝TNSNAMES.ORA

修改init.ora（可以不做）

创建密码文件