Oracle 10g RAC 增添节点

Oracle 10g RAC 添加节点

目前环境是一个版本为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"

添加RAC Clusterware节点

在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.

Oracle 10g RAC 增添节点

用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)

脚本全部执行后Exit退出

Oracle 10g RAC 增添节点

在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.

Oracle 10g RAC 增添节点

用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 10g RAC 增添节点

配置监听

[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

Oracle 10g RAC 增添节点

点击No

Oracle 10g RAC 增添节点

验证

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

相关推荐