目前环境是一个版本为10.2.0.5的双节点RAC,hostname分别为racnode1,racnode2需要添加新节点racnode3。
OS版本是Oracle Linux 5.7 x86_64
保证RAC正常运行
配置public IP,private IP,VIP,将这些信息配置到/etc/hosts文件中
192.168.1.51 racnode1
192.168.1.151 racnode1-vip
172.168.1.51 racnode1-priv
192.168.1.52 racnode2
192.168.1.152 racnode2-vip
172.168.1.52 racnode2-priv
192.168.1.53 racnode3
192.168.1.153 racnode3-vip
172.168.1.53 racnode3-priv
安装相关的rpm包,配置系统内核参数,我这里使用的是Oracle Linux5提供的的oracle-validated包进行安装配置
[root@racnode3 ~]# yum -y install oracle-validated
Loaded plugins: rhnplugin, security
This system is not registered with ULN.
ULN support will be disabled.
Setting up Install Process
Package oracle-validated-1.1.0-15.el5.x86_64 already installed and latest version
同步各节点的时间,我这里使用的是NTP服务
[root@racnode3 ~]# crontab -l
*/5 * * * * /usr/sbin/ntpdate 0.asia.pool.ntp.org > /dev/null 2>&1
配置共享磁盘
[root@racnode3 ~]# cat /etc/udev/rules.d/60-raw.rules
# Enter raw device bindings here.
#
# An example would be:
# ACTION=="add", KERNEL=="sda", RUN+="/bin/raw /dev/raw/raw1 %N"
# to bind /dev/raw/raw1 to /dev/sda, or
# ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="1", RUN+="/bin/raw /dev/raw/raw2 %M %m"
# to bind /dev/raw/raw2 to the device with major 8, minor 1.
ACTION=="add", KERNEL=="sdb1", RUN+="/bin/raw /dev/raw/raw1 %N"
ACTION=="add", KERNEL=="sdb2", RUN+="/bin/raw /dev/raw/raw2 %N"
ACTION=="add", KERNEL=="sdc1", RUN+="/bin/raw /dev/raw/raw3 %N"
ACTION=="add", KERNEL=="sdc2", RUN+="/bin/raw /dev/raw/raw4 %N"
ACTION=="add", KERNEL=="sdc3", RUN+="/bin/raw /dev/raw/raw5 %N"
ACTION=="add", KERNEL=="raw*", OWNER=="oracle", GROUP=="oinstall", MODE=="0660"
[root@racnode3 ~]# cat /etc/udev/rules.d/99-oracle-asmdevices.rules
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p", RESULT=="SATA_VBOX_HARDDISK_VB5407c582-c0bbcc9c_", NAME="asm-diskd", OWNER="oracle", GROUP="oinstall", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p", RESULT=="SATA_VBOX_HARDDISK_VB2048e338-447949c0_", NAME="asm-diske", OWNER="oracle", GROUP="oinstall", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p", RESULT=="SATA_VBOX_HARDDISK_VB6d6f72b0-997f769f_", NAME="asm-diskf", OWNER="oracle", GROUP="oinstall", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p", RESULT=="SATA_VBOX_HARDDISK_VB867b3aae-2e3a3f0b_", NAME="asm-diskg", OWNER="oracle", GROUP="oinstall", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p", RESULT=="SATA_VBOX_HARDDISK_VB4dcf4abf-0266b2fc_", NAME="asm-diskh", OWNER="oracle", GROUP="oinstall", MODE="0660"
[root@racnode3 ~]#
[root@racnode3 ~]# start_udev
Starting udev: [ OK ]
[root@racnode3 ~]# ls -l /dev/raw/raw*
crw-rw---- 1 oracle oinstall 162, 1 Dec 24 14:31 /dev/raw/raw1
crw-rw---- 1 oracle oinstall 162, 2 Dec 24 14:31 /dev/raw/raw2
crw-rw---- 1 oracle oinstall 162, 3 Dec 24 14:31 /dev/raw/raw3
crw-rw---- 1 oracle oinstall 162, 4 Dec 24 14:31 /dev/raw/raw4
crw-rw---- 1 oracle oinstall 162, 5 Dec 24 14:31 /dev/raw/raw5
[root@racnode3 ~]# ls -l /dev/asm-disk*
brw-rw---- 1 oracle oinstall 8, 48 Dec 24 14:31 /dev/asm-diskd
brw-rw---- 1 oracle oinstall 8, 64 Dec 24 14:31 /dev/asm-diske
brw-rw---- 1 oracle oinstall 8, 80 Dec 24 14:31 /dev/asm-diskf
brw-rw---- 1 oracle oinstall 8, 96 Dec 24 14:31 /dev/asm-diskg
brw-rw---- 1 oracle oinstall 8, 112 Dec 24 14:31 /dev/asm-diskh
配置ssh用户等效性
[oracle@racnode1 ~]$ ssh racnode1 date;ssh racnode2 date;ssh racnode3 date
Mon Dec 24 14:37:08 CST 2012
Mon Dec 24 14:37:08 CST 2012
Mon Dec 24 14:37:08 CST 2012
[oracle@racnode1 ~]$ ssh racnode1-priv date;ssh racnode2-priv date;ssh racnode3-priv date
Mon Dec 24 14:37:15 CST 2012
Mon Dec 24 14:37:16 CST 2012
Mon Dec 24 14:37:16 CST 2012
[oracle@racnode2 ~]$ ssh racnode1 date;ssh racnode2 date;ssh racnode3 date
Mon Dec 24 14:38:22 CST 2012
Mon Dec 24 14:38:22 CST 2012
Mon Dec 24 14:38:22 CST 2012
[oracle@racnode2 ~]$ ssh racnode1-priv date;ssh racnode2-priv date;ssh racnode3-priv date
Mon Dec 24 14:38:27 CST 2012
Mon Dec 24 14:38:27 CST 2012
Mon Dec 24 14:38:27 CST 2012
[oracle@racnode3 ~]$ ssh racnode1 date;ssh racnode2 date;ssh racnode3 date
Mon Dec 24 14:40:39 CST 2012
Mon Dec 24 14:40:39 CST 2012
Mon Dec 24 14:40:39 CST 2012
[oracle@racnode3 ~]$ ssh racnode1-priv date;ssh racnode2-priv date;ssh racnode3-priv date
Mon Dec 24 14:40:54 CST 2012
Mon Dec 24 14:40:54 CST 2012
Mon Dec 24 14:40:54 CST 2012
配置racnode3 oracle用户的环境变量
alias ls="ls -FA"
export JAVA_HOME=/usr/local/java
# User specific environment and startup programs
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORA_CRS_HOME=$ORACLE_BASE/product/10.2.0/crs
export ORACLE_PATH=$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin
export CV_JDKHOME=/usr/local/java
export ORACLE_SID=racdb3
export PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin:$ORA_CRS_HOME/bin
export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
export PATH=${PATH}:$ORACLE_BASE/common/oracle/bin
export ORACLE_TERM=xterm
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS10=$ORACLE_HOME/nls/data
export NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"
export DISPLAY=192.168.2.224:0.0
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export CLASSPATH=$ORACLE_HOME/JRE
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export THREADS_FLAG=native
export TEMP=/tmp
export TMPDIR=/tmp
alias ls="ls -FA"
alias sqlplus="rlwrap sqlplus"
alias rman="rlwrap rman"
alias ggsci="rlwrap ggsci"
alias logdump="rlwrap logdump"
alias asmcmd="rlwrap asmcmd"
alias base="cd $ORACLE_BASE"
alias home="cd $ORACLE_HOME"
在racnode1使用oracle用户执行$ORA_CRS_HOME/oui/bin/addNode.sh
[oracle@racnode1 ~]$ cd /u01/app/oracle/product/10.2.0/crs/oui/bin/
[oracle@racnode1 bin]$ ./addNode.sh
Starting Oracle Universal Installer...
No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
Oracle Universal Installer, Version 10.2.0.5.0 Production
Copyright (C) 1999, 2010, Oracle. All rights reserved.
用root用户在racnode3上运行
/u01/app/oracle/oraInventory/orainstRoot.sh
[root@racnode3 ~]# /u01/app/oracle/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oracle/oraInventory to 770.
Changing groupname of /u01/app/oracle/oraInventory to oinstall.
The execution of the script is complete
用root用户在racnode1上运行
/u01/app/oracle/product/10.2.0/crs/install/rootaddnode.sh
[root@racnode1 ~]# /u01/app/oracle/product/10.2.0/crs/install/rootaddnode.sh
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Attempting to add 1 new nodes to the configuration
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 3: racnode3 racnode3-priv racnode3
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
/u01/app/oracle/product/10.2.0/crs/bin/srvctl add nodeapps -n racnode3 -A racnode3-vip/255.255.0.0/eth0 -o /u01/app/oracle/product/10.2.0/crs
用root用户在racnode3运行
/u01/app/oracle/product/10.2.0/crs/root.sh
[root@racnode3 ~]# /u01/app/oracle/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oracle/oraInventory to 770.
Changing groupname of /u01/app/oracle/oraInventory to oinstall.
The execution of the script is complete
[root@racnode3 ~]# /u01/app/oracle/product/10.2.0/crs/root.sh
WARNING: directory '/u01/app/oracle/product/10.2.0' is not owned by root
WARNING: directory '/u01/app/oracle/product' is not owned by root
WARNING: directory '/u01/app/oracle' is not owned by root
WARNING: directory '/u01/app' is not owned by root
No value set for the CRS parameter CRS_OCR_LOCATIONS. Using Values in paramfile.crs
Checking to see if Oracle CRS stack is already configured
/etc/oracle does not exist. Creating it now.
OCR LOCATIONS = /dev/raw/raw1,/dev/raw/raw2
OCR backup directory '/u01/app/oracle/product/10.2.0/crs/cdata/crs' does not exist. Creating now
Setting the permissions on OCR backup directory
Setting up NS directories
Oracle Cluster Registry configuration upgraded successfully
WARNING: directory '/u01/app/oracle/product/10.2.0' is not owned by root
WARNING: directory '/u01/app/oracle/product' is not owned by root
WARNING: directory '/u01/app/oracle' is not owned by root
WARNING: directory '/u01/app' is not owned by root
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 1: racnode1 racnode1-priv racnode1
node 2: racnode2 racnode2-priv racnode2
clscfg: Arguments check out successfully.
NO KEYS WERE WRITTEN. Supply -force parameter to override.
-force is destructive and will destroy any previous cluster
configuration.
Oracle Cluster Registry for cluster has already been initialized
Startup will be queued to init within 30 seconds.
Adding daemons to inittab
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
racnode1
racnode2
racnode3
CSS is active on all nodes.
Waiting for the Oracle CRSD and EVMD to start
Waiting for the Oracle CRSD and EVMD to start
Oracle CRS stack installed and running under init(1M)
在racnode3上安装Oracle Database software
在racnode1上使用oracle用户执行$ORACLE_HOME/oui/bin/addNode.sh
[oracle@racnode1 bin]$ cd /u01/app/oracle/product/10.2.0/db_1/oui/bin/
[oracle@racnode1 bin]$ ./addNode.sh
Starting Oracle Universal Installer...
No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
Oracle Universal Installer, Version 10.2.0.5.0 Production
Copyright (C) 1999, 2010, Oracle. All rights reserved.
用root用户在racnode3上执行
/u01/app/oracle/product/10.2.0/db_1/root.sh
[root@racnode3 ~]# /u01/app/oracle/product/10.2.0/db_1/root.sh
Running Oracle 10g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/10.2.0/db_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
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.sh script.
Now product-specific root actions will be performed.
执行之后Exit退出
配置监听
[oracle@racnode3 admin]$ cat listener.ora
# listener.ora.racnode2 Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora.racnode2
# Generated by Oracle configuration tools.
LISTENER_RACNODE3 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = racnode3-vip)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.53)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
[oracle@racnode3 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
RACDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = racnode1-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdb)
(INSTANCE_NAME = racdb1)
)
)
RACDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = racnode1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = racnode2-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = racnode3-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdb)
)
)
LISTENERS_RACDB =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = racnode1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = racnode2-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = racnode3-vip)(PORT = 1521))
)
RACDB2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = racnode2-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdb)
(INSTANCE_NAME = racdb2)
)
)
RACDB3 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = racnode3-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdb)
(INSTANCE_NAME = racdb3)
)
)
在racnode1上使用DBCA添加racnode3的instance
点击No
验证
SQL> select INSTANCE_NAME,HOST_NAME,VERSION,STARTUP_TIME,STATUS,ACTIVE_STATE,INSTANCE_ROLE,DATABASE_STATUS from gv$INSTANCE;
INSTANCE_NAME HOST_NAME VERSION STARTUP_TIME STATUS ACTIVE_ST INSTANCE_ROLE DATABASE_STATUS
---------------- ----------- ----------------- ----------------------- ------------ --------- ------------------ -----------------
racdb2 racnode2 10.2.0.5.0 20-DEC-2012 16:07:46 OPEN NORMAL PRIMARY_INSTANCE ACTIVE
racdb1 racnode1 10.2.0.5.0 20-DEC-2012 16:07:46 OPEN NORMAL PRIMARY_INSTANCE ACTIVE
racdb3 racnode3 10.2.0.5.0 24-DEC-2012 16:32:35 OPEN NORMAL PRIMARY_INSTANCE ACTIVE
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
[oracle@racnode2 ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora.racdb.db application 0/0 0/1 ONLINE ONLINE racnode1
ora....b1.inst application 0/5 0/0 ONLINE ONLINE racnode1
ora....b2.inst application 0/5 0/0 ONLINE ONLINE racnode2
ora....b3.inst application 0/5 0/0 ONLINE ONLINE racnode3
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE racnode1
ora....E1.lsnr application 0/5 0/0 ONLINE ONLINE racnode1
ora....de1.gsd application 0/5 0/0 ONLINE ONLINE racnode1
ora....de1.ons application 0/3 0/0 ONLINE ONLINE racnode1
ora....de1.vip application 0/0 0/0 ONLINE ONLINE racnode1
ora....SM2.asm application 0/5 0/0 ONLINE ONLINE racnode2
ora....E2.lsnr application 0/5 0/0 ONLINE ONLINE racnode2
ora....de2.gsd application 0/5 0/0 ONLINE ONLINE racnode2
ora....de2.ons application 0/3 0/0 ONLINE ONLINE racnode2
ora....de2.vip application 0/0 0/0 ONLINE ONLINE racnode2
ora....SM3.asm application 0/5 0/0 ONLINE ONLINE racnode3
ora....E3.lsnr application 0/5 0/0 ONLINE ONLINE racnode3
ora....de3.gsd application 0/5 0/0 ONLINE ONLINE racnode3
ora....de3.ons application 0/3 0/0 ONLINE ONLINE racnode3
ora....de3.vip application 0/0 0/0 ONLINE ONLINE racnode3
[oracle@racnode2 ~]$ sqlplus system@racdb1
SQL*Plus: Release 10.2.0.5.0 - Production on Mon Dec 24 16:39:26 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> show parameter local_lis
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string (ADDRESS = (PROTOCOL = TCP)(HO
ST = 192.168.1.151)(PORT = 152
1))
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
[oracle@racnode2 ~]$ sqlplus system@racdb2
SQL*Plus: Release 10.2.0.5.0 - Production on Mon Dec 24 16:39:38 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> show parameter local_lis
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string (ADDRESS = (PROTOCOL = TCP)(HO
ST = 192.168.1.152)(PORT = 152
1))
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
[oracle@racnode2 ~]$ sqlplus system@racdb3
SQL*Plus: Release 10.2.0.5.0 - Production on Mon Dec 24 16:39:47 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> show parameter local_lis
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string
SQL> alter system set local_listener ='(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.153)(PORT = 1521))' sid='racdb3';
System altered.
SQL> show parameter local_lis
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string (ADDRESS = (PROTOCOL = TCP)(HO
ST = 192.168.1.153)(PORT = 152
1))
SQL>
[oracle@racnode3 ~]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 24-DEC-2012 16:42:41
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER_RACNODE3
Version TNSLSNR for Linux: Version 10.2.0.5.0 - Production
Start Date 24-DEC-2012 16:33:03
Uptime 0 days 0 hr. 9 min. 37 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener_racnode3.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.153)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.53)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM3", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM3", status BLOCKED, has 1 handler(s) for this service...
Service "racdb" has 3 instance(s).
Instance "racdb1", status READY, has 1 handler(s) for this service...
Instance "racdb2", status READY, has 1 handler(s) for this service...
Instance "racdb3", status READY, has 2 handler(s) for this service...
Service "racdbXDB" has 3 instance(s).
Instance "racdb1", status READY, has 1 handler(s) for this service...
Instance "racdb2", status READY, has 1 handler(s) for this service...
Instance "racdb3", status READY, has 1 handler(s) for this service...
Service "racdb_XPT" has 3 instance(s).
Instance "racdb1", status READY, has 1 handler(s) for this service...
Instance "racdb2", status READY, has 1 handler(s) for this service...
Instance "racdb3", status READY, has 2 handler(s) for this service...
The command completed successfully
[oracle@racnode3 ~]$ lsnrctl service
LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 24-DEC-2012 16:43:07
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM3", status BLOCKED, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM3", status BLOCKED, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "racdb" has 3 instance(s).
Instance "racdb1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.151)(PORT=1521))
Instance "racdb2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.152)(PORT=1521))
Instance "racdb3", status READY, has 2 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.153)(PORT=1521))
"DEDICATED" established:1 refused:0 state:ready
LOCAL SERVER
Service "racdbXDB" has 3 instance(s).
Instance "racdb1", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: racnode1, pid: 13625>
(ADDRESS=(PROTOCOL=tcp)(HOST=racnode1)(PORT=30569))
Instance "racdb2", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: racnode2, pid: 6359>
(ADDRESS=(PROTOCOL=tcp)(HOST=racnode2)(PORT=57869))
Instance "racdb3", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: racnode3, pid: 1929>
(ADDRESS=(PROTOCOL=tcp)(HOST=racnode3)(PORT=59281))
Service "racdb_XPT" has 3 instance(s).
Instance "racdb1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.151)(PORT=1521))
Instance "racdb2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.152)(PORT=1521))
Instance "racdb3", status READY, has 2 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.153)(PORT=1521))
"DEDICATED" established:1 refused:0 state:ready
LOCAL SERVER
The command completed successfully
[oracle@racnode3 ~]$ crsctl query crs activeversion
CRS active version on the cluster is [10.2.0.5.0]
[oracle@racnode3 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 2
Total space (kbytes) : 1469612
Used space (kbytes) : 5384
Available space (kbytes) : 1464228
ID : 621085552
Device/File Name : /dev/raw/raw1
Device/File integrity check succeeded
Device/File Name : /dev/raw/raw2
Device/File integrity check succeeded
Cluster registry integrity check succeeded
[oracle@racnode3 ~]$ crsctl query css votedisk
0. 0 /dev/raw/raw3
1. 0 /dev/raw/raw4
2. 0 /dev/raw/raw5
located 3 votedisk(s).
C:\>sqlplus system@rac3
SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 12月 24 16:44:50 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
输入口令:
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> show parameter instance_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string racdb3
SQL> set linesize 400
SQL> col host_name format a11
SQL> select INSTANCE_NAME,HOST_NAME,VERSION,STARTUP_TIME,STATUS,ACTIVE_STATE,INSTANCE_ROLE,DATABASE_STATUS from gv$INSTANCE;
INSTANCE_NAME HOST_NAME VERSION STARTUP_TIME STATUS ACTIVE_ST INSTANCE_ROLE DATABASE_STATUS
---------------- ----------- ----------------- -------------- ------------ --------- ------------------ ----------------
racdb3 racnode3 10.2.0.5.0 24-12月-12 OPEN NORMAL PRIMARY_INSTANCE ACTIVE
racdb2 racnode2 10.2.0.5.0 20-12月-12 OPEN NORMAL PRIMARY_INSTANCE ACTIVE
racdb1 racnode1 10.2.0.5.0 20-12月-12 OPEN NORMAL PRIMARY_INSTANCE ACTIVE