Installation Oracle 10gR2(10.2.0.5) RAC with RAW on RHEL5

最新推荐文章于 2019-08-01 21:41:48 发布

ZhongWeicheng

最新推荐文章于 2019-08-01 21:41:48 发布

阅读量2.2k

点赞数

本文链接：https://blog.csdn.net/staricqxyz/article/details/12950207

版权

Oracle 同时被 2 个专栏收录

165 篇文章 0 订阅

订阅专栏

Oracle RAC

47 篇文章 0 订阅

订阅专栏

The generic steps to follow when adding the new node to the cluster are:
Install Operating System
Install required software
Add/modify users and groups required for the installation
Configure network
Configure kernel parameters

Configure services required such as NTP

Configure /etc/hosts,sshKey

Configure storage (multipathing, zoning, storage discovery,UDEV, RAW)

modify /etc/udev/rules.d/60-raw.rules

[root@vzwc1 ~]# 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=="sdd1", RUN+="/bin/raw /dev/raw/raw6 %N"
ACTION=="add", KERNEL=="sdd2", RUN+="/bin/raw /dev/raw/raw7 %N"
ACTION=="add", KERNEL=="sdd3", RUN+="/bin/raw /dev/raw/raw8 %N"
ACTION=="add", KERNEL=="sdd4", RUN+="/bin/raw /dev/raw/raw9 %N"
ACTION=="add", KERNEL=="sde1", RUN+="/bin/raw /dev/raw/raw10 %N"
ACTION=="add", KERNEL=="sde2", RUN+="/bin/raw /dev/raw/raw11 %N"
ACTION=="add", KERNEL=="sde3", RUN+="/bin/raw /dev/raw/raw12 %N"
ACTION=="add", KERNEL=="sde4", RUN+="/bin/raw /dev/raw/raw13 %N"
ACTION=="add", KERNEL=="sdf1", RUN+="/bin/raw /dev/raw/raw14 %N"
ACTION=="add", KERNEL=="sdf2", RUN+="/bin/raw /dev/raw/raw15 %N"
ACTION=="add", KERNEL=="sdf3", RUN+="/bin/raw /dev/raw/raw16 %N"
ACTION=="add", KERNEL=="sdf4", RUN+="/bin/raw /dev/raw/raw17 %N"
ACTION=="add", KERNEL=="sdg1", RUN+="/bin/raw /dev/raw/raw18 %N"
ACTION=="add", KERNEL=="sdg2", RUN+="/bin/raw /dev/raw/raw19 %N"
ACTION=="add", KERNEL=="sdg3", RUN+="/bin/raw /dev/raw/raw20 %N"
ACTION=="add", KERNEL=="sdg4", RUN+="/bin/raw /dev/raw/raw21 %N"
ACTION=="add", KERNEL=="raw*", OWNER=="oracle", GROUP=="oinstall", MODE=="0660"
[root@vzwc1 ~]# 
[root@vzwc1 ~]# 
[root@vzwc1 ~]# 
[root@vzwc1 ~]# ls -l /dev/raw/*
crw-rw---- 1 oracle oinstall 162,  1 Oct 22 18:52 /dev/raw/raw1
crw-rw---- 1 oracle oinstall 162, 10 Oct 22 18:52 /dev/raw/raw10
crw-rw---- 1 oracle oinstall 162, 11 Oct 22 18:52 /dev/raw/raw11
crw-rw---- 1 oracle oinstall 162, 12 Oct 22 18:52 /dev/raw/raw12
crw-rw---- 1 oracle oinstall 162, 13 Oct 22 18:52 /dev/raw/raw13
crw-rw---- 1 oracle oinstall 162, 14 Oct 22 18:52 /dev/raw/raw14
crw-rw---- 1 oracle oinstall 162, 15 Oct 22 18:52 /dev/raw/raw15
crw-rw---- 1 oracle oinstall 162, 16 Oct 22 18:52 /dev/raw/raw16
crw-rw---- 1 oracle oinstall 162, 17 Oct 22 18:52 /dev/raw/raw17
crw-rw---- 1 oracle oinstall 162, 18 Oct 22 18:52 /dev/raw/raw18
crw-rw---- 1 oracle oinstall 162, 19 Oct 22 18:52 /dev/raw/raw19
crw-rw---- 1 oracle oinstall 162,  2 Oct 22 18:52 /dev/raw/raw2
crw-rw---- 1 oracle oinstall 162, 20 Oct 22 18:52 /dev/raw/raw20
crw-rw---- 1 oracle oinstall 162, 21 Oct 22 18:52 /dev/raw/raw21
crw-rw---- 1 oracle oinstall 162,  3 Oct 22 18:52 /dev/raw/raw3
crw-rw---- 1 oracle oinstall 162,  4 Oct 22 18:52 /dev/raw/raw4
crw-rw---- 1 oracle oinstall 162,  5 Oct 22 18:52 /dev/raw/raw5
crw-rw---- 1 oracle oinstall 162,  6 Oct 22 18:52 /dev/raw/raw6
crw-rw---- 1 oracle oinstall 162,  7 Oct 22 18:52 /dev/raw/raw7
crw-rw---- 1 oracle oinstall 162,  8 Oct 22 18:52 /dev/raw/raw8
crw-rw---- 1 oracle oinstall 162,  9 Oct 22 18:52 /dev/raw/raw9

Configuration NFS Using Archivelog

vzwc1

[root@vzwc1 ~]# chkconfig --level 2345 portmap on
[root@vzwc1 ~]# chkconfig --level 2345 nfs on
[root@vzwc1 ~]# echo "/u01/app/oracle/arch1 vzwc2(rw,sync)" > /etc/exports
[root@vzwc1 ~]# /etc/init.d/portmap start
Starting portmap: [  OK  ]
[root@vzwc1 ~]# /etc/init.d/nfs start
Starting NFS services:  exportfs: arch2 has non-inet addr
exportfs: arch2 has non-inet addr
[  OK  ]
Starting NFS quotas: [  OK  ]
Starting NFS daemon: [  OK  ]
Starting NFS mountd: [  OK  ]
Stopping RPC idmapd: [  OK  ]
Starting RPC idmapd: [  OK  ]
[root@vzwc1 ~]# mount -t nfs -o rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actimeo=0 vzwc2:/u01/app/oracle/arch2 /u01/app/oracle/arch2
[root@vzwc1 ~]# 
[root@vzwc1 ~]# 
[root@vzwc1 ~]# df -TH
Filesystem    Type     Size   Used  Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
              ext3      58G   5.7G    49G  11% /
/dev/sda1     ext3     104M    26M    74M  26% /boot
tmpfs        tmpfs     1.6G      0   1.6G   0% /dev/shm
vzwc2:/u01/app/oracle/arch2
               nfs      58G   5.7G    49G  11% /u01/app/oracle/arch2

vzwc2

[root@vzwc2 ~]# chkconfig --level 2345 portmap on
[root@vzwc2 ~]# chkconfig --level 2345 nfs on
[root@vzwc2 ~]# echo "/u01/app/oracle/arch2 vzwc1(rw,sync)" > /etc/exports
[root@vzwc2 ~]# /etc/init.d/portmap start
Starting portmap: [  OK  ]
[root@vzwc2 ~]# /etc/init.d/nfs start
Starting NFS services:  exportfs: arch1 has non-inet addr
exportfs: arch1 has non-inet addr
[  OK  ]
Starting NFS quotas: [  OK  ]
Starting NFS daemon: [  OK  ]
Starting NFS mountd: [  OK  ]
Stopping RPC idmapd: [  OK  ]
Starting RPC idmapd: [  OK  ]
[root@vzwc2 ~]# mount -t nfs -o rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actimeo=0 vzwc1:/u01/app/oracle/arch1 /u01/app/oracle/arch1
[root@vzwc2 ~]# 
[root@vzwc2 ~]# 
[root@vzwc2 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
                       54G  5.3G   46G  11% /
/dev/sda1              99M   24M   70M  26% /boot
tmpfs                 1.5G     0  1.5G   0% /dev/shm
vzwc1:/u01/app/oracle/arch1
                       54G  5.3G   46G  11% /u01/app/oracle/arch1

Configuration RAW Mapping File

[oracle@vzwc1 ~]$ cat raw_mapp.txt 
system=/dev/raw/raw14
sysaux=/dev/raw/raw15
example=/dev/raw/raw16
temp=/dev/raw/raw/raw17
users=/dev/raw/raw18
undotbs1=/dev/raw/raw20
undotbs2=/dev/raw/raw21
redo1_1=/dev/raw/raw6
redo1_2=/dev/raw/raw7
redo2_1=/dev/raw/raw8
redo2_2=/dev/raw/raw9
control1=/dev/raw/raw10
control2=/dev/raw/raw11
pwdfile=/dev/raw/raw12
spfile=/dev/raw/raw13

Install ClusterWare

[oracle@vzwc1 clusterware]$ ./runInstaller -ignoresysprereqs

vzwc2 Ignore Error

CSS is active on these nodes.
vzwc1
vzwc2
CSS is active on all nodes.
Waiting for the Oracle CRSD and EVMD to start
Oracle CRS stack installed and running under init(1M)
Running vipca(silent) for configuring nodeapps
/u01/app/oracle/product/10.2.0/crs/jdk/jre//bin/java: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory

Upgrade ClusterWare to 10.2.0.5

[root@vzwc1 ~]# /u01/app/oracle/product/10.2.0/crs/bin/crsctl stop crs
Stopping resources.
Successfully stopped CRS resources 
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
[root@vzwc1 ~]# /u01/app/oracle/product/10.2.0/crs/install/root102.sh
Creating pre-patch directory for saving pre-patch clusterware files
Completed patching clusterware files to /u01/app/oracle/product/10.2.0/crs
Relinking some shared libraries.
Relinking of patched files is complete.
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
Preparing to recopy patched init and RC scripts.
Recopying init and RC scripts.
Startup will be queued to init within 30 seconds.
Starting up the CRS daemons.
Waiting for the patched CRS daemons to start.
  This may take a while on some systems.
.
10205 patch successfully applied.
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully deleted 1 values from OCR.
Successfully deleted 1 keys from OCR.
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: vzwc1 vzwc1-priv vzwc1
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
clscfg -upgrade completed successfully
Creating '/u01/app/oracle/product/10.2.0/crs/install/paramfile.crs' with data used for CRS configuration
Setting CRS configuration values in /u01/app/oracle/product/10.2.0/crs/install/paramfile.crs

[root@vzwc2 ~]# /u01/app/oracle/product/10.2.0/crs/bin/crsctl stop crs
Stopping resources.
Successfully stopped CRS resources 
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
[root@vzwc2 ~]# /u01/app/oracle/product/10.2.0/crs/install/root102.sh
Creating pre-patch directory for saving pre-patch clusterware files
Completed patching clusterware files to /u01/app/oracle/product/10.2.0/crs
Relinking some shared libraries.
Relinking of patched files is complete.
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
Preparing to recopy patched init and RC scripts.
Recopying init and RC scripts.
Startup will be queued to init within 30 seconds.
Starting up the CRS daemons.
Waiting for the patched CRS daemons to start.
  This may take a while on some systems.
.
10205 patch successfully applied.
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully deleted 1 values from OCR.
Successfully deleted 1 keys from OCR.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 2: vzwc2 vzwc2-priv vzwc2
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
clscfg -upgrade completed successfully
Creating '/u01/app/oracle/product/10.2.0/crs/install/paramfile.crs' with data used for CRS configuration
Setting CRS configuration values in /u01/app/oracle/product/10.2.0/crs/install/paramfile.crs

Configuration VIPCA

[root@vzwc1 ~]# export DISPLAY=192.168.1.100:0.0
[root@vzwc1 ~]# /u01/app/oracle/product/10.2.0/crs/bin/vipca

[oracle@vzwc1 crs]$ crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host        
----------------------------------------------------------------------
ora.vzwc1.gsd  application    0/5    0/0    ONLINE    ONLINE    vzwc1       
ora.vzwc1.ons  application    0/3    0/0    ONLINE    ONLINE    vzwc1       
ora.vzwc1.vip  application    0/0    0/0    ONLINE    ONLINE    vzwc1       
ora.vzwc2.gsd  application    0/5    0/0    ONLINE    ONLINE    vzwc2       
ora.vzwc2.ons  application    0/3    0/0    ONLINE    ONLINE    vzwc2       
ora.vzwc2.vip  application    0/0    0/0    ONLINE    ONLINE    vzwc2       
[oracle@vzwc1 crs]$ 
[oracle@vzwc1 crs]$ 
[oracle@vzwc1 crs]$ 
[oracle@vzwc1 crs]$ crsctl query crs activeversion
CRS active version on the cluster is [10.2.0.5.0]
[oracle@vzwc1 crs]$ crsctl query css votedisk
 0.     0    /dev/raw/raw3
 1.     0    /dev/raw/raw4
 2.     0    /dev/raw/raw5

located 3 votedisk(s).
[oracle@vzwc1 crs]$ 
[oracle@vzwc1 crs]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          2
         Total space (kbytes)     :     497744
         Used space (kbytes)      :       2020
         Available space (kbytes) :     495724
         ID                       :  358473670
         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

Installation Database SoftWare

[root@vzwc1 ~]# /u01/app/oracle/product/10.2.0/db_1/root.sh
Running Oracle10 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.

[root@vzwc2 ~]# /u01/app/oracle/product/10.2.0/db_1/root.sh
Running Oracle10 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.

Upgrade Database SoftWare to 10.2.0.5

Create RAC Database

Validated RAC Database

[oracle@vzwc2 ~]$ srvctl status database -d zhongwc
Instance zhongwc1 is running on node vzwc1
Instance zhongwc2 is running on node vzwc2
[oracle@vzwc2 ~]$ 
[oracle@vzwc2 ~]$ srvctl status service -d zhongwc -s erp
Service erp is running on instance(s) zhongwc1
[oracle@vzwc2 ~]$ 
[oracle@vzwc2 ~]$ srvctl status nodeapps -n vzwc1
VIP is running on node: vzwc1
GSD is running on node: vzwc1
Listener is running on node: vzwc1
ONS daemon is running on node: vzwc1
[oracle@vzwc2 ~]$ 
[oracle@vzwc2 ~]$ srvctl status nodeapps -n vzwc2
VIP is running on node: vzwc2
GSD is running on node: vzwc2
Listener is running on node: vzwc2
ONS daemon is running on node: vzwc2
[oracle@vzwc2 ~]$ 
[oracle@vzwc2 ~]$ srvctl status asm -n vzwc1
[oracle@vzwc2 ~]$ srvctl status asm -n vzwc2
[oracle@vzwc2 ~]$ 
[oracle@vzwc2 ~]$ srvctl config database
zhongwc
[oracle@vzwc2 ~]$ srvctl config database -d zhongwc
vzwc1 zhongwc1 /u01/app/oracle/product/10.2.0/db_1
vzwc2 zhongwc2 /u01/app/oracle/product/10.2.0/db_1

[oracle@vzwc2 ~]$ crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host        
----------------------------------------------------------------------
ora....C1.lsnr application    0/5    0/0    ONLINE    ONLINE    vzwc1       
ora.vzwc1.gsd  application    0/5    0/0    ONLINE    ONLINE    vzwc1       
ora.vzwc1.ons  application    0/3    0/0    ONLINE    ONLINE    vzwc1       
ora.vzwc1.vip  application    0/0    0/0    ONLINE    ONLINE    vzwc1       
ora....C2.lsnr application    0/5    0/0    ONLINE    ONLINE    vzwc2       
ora.vzwc2.gsd  application    0/5    0/0    ONLINE    ONLINE    vzwc2       
ora.vzwc2.ons  application    0/3    0/0    ONLINE    ONLINE    vzwc2       
ora.vzwc2.vip  application    0/0    0/0    ONLINE    ONLINE    vzwc2       
ora.zhongwc.db application    0/0    0/1    ONLINE    ONLINE    vzwc1       
ora.....erp.cs application    0/0    0/1    ONLINE    ONLINE    vzwc1       
ora....wc1.srv application    0/0    0/0    ONLINE    ONLINE    vzwc1       
ora....c1.inst application    0/5    0/0    ONLINE    ONLINE    vzwc1       
ora....c2.inst application    0/5    0/0    ONLINE    ONLINE    vzwc2       
[oracle@vzwc2 ~]$ 
[oracle@vzwc2 ~]$ crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
[oracle@vzwc2 ~]$ crsctl query crs activeversion
CRS active version on the cluster is [10.2.0.5.0]
[oracle@vzwc2 ~]$ 
[oracle@vzwc2 ~]$ crsctl query css votedisk
 0.     0    /dev/raw/raw3
 1.     0    /dev/raw/raw4
 2.     0    /dev/raw/raw5

located 3 votedisk(s).
[oracle@vzwc2 ~]$ 
[oracle@vzwc2 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          2
         Total space (kbytes)     :     497744
         Used space (kbytes)      :       3804
         Available space (kbytes) :     493940
         ID                       :  358473670
         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@vzwc1 ~]$ sqlplus system@zhongwc1

SQL*Plus: Release 10.2.0.5.0 - Production on Tue Oct 22 22:23:52 2013

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> 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@vzwc1 ~]$ sqlplus system@zhongwc2

SQL*Plus: Release 10.2.0.5.0 - Production on Tue Oct 22 22:23:58 2013

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> 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@vzwc1 ~]$ sqlplus system@zhongwc

SQL*Plus: Release 10.2.0.5.0 - Production on Tue Oct 22 22:24:02 2013

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> 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@vzwc1 ~]$ sqlplus system@erp

SQL*Plus: Release 10.2.0.5.0 - Production on Tue Oct 22 22:24:12 2013

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> 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@vzwc1 ~]$ 
[oracle@vzwc1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 22-OCT-2013 22:24:20

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_VZWC1
Version                   TNSLSNR for Linux: Version 10.2.0.5.0 - Production
Start Date                22-OCT-2013 22:03:37
Uptime                    0 days 0 hr. 20 min. 43 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_vzwc1.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.161)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.61)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Services Summary...
Service "erp" has 1 instance(s).
  Instance "zhongwc1", status READY, has 2 handler(s) for this service...
Service "zhongwc" has 2 instance(s).
  Instance "zhongwc1", status READY, has 2 handler(s) for this service...
  Instance "zhongwc2", status READY, has 1 handler(s) for this service...
Service "zhongwcXDB" has 2 instance(s).
  Instance "zhongwc1", status READY, has 1 handler(s) for this service...
  Instance "zhongwc2", status READY, has 1 handler(s) for this service...
Service "zhongwc_XPT" has 2 instance(s).
  Instance "zhongwc1", status READY, has 2 handler(s) for this service...
  Instance "zhongwc2", status READY, has 1 handler(s) for this service...
The command completed successfully

SQL> select tablespace_name, file_name from dba_data_files
  2  union all
  3  select tablespace_name, file_name from dba_temp_files;

TABLESPACE_NAME                FILE_NAME
------------------------------ --------------------
USERS                          /dev/raw/raw18
SYSAUX                         /dev/raw/raw15
UNDOTBS1                       /dev/raw/raw20
SYSTEM                         /dev/raw/raw14
EXAMPLE                        /dev/raw/raw16
UNDOTBS2                       /dev/raw/raw21
TEMP                           /dev/raw/raw17

7 rows selected.

SQL> create tablespace zwc datafile '/dev/raw/raw19' size 800M autoextend off;

Tablespace created.

SQL> select tablespace_name, file_name from dba_data_files
  2  union all
  3  select tablespace_name, file_name from dba_temp_files;

TABLESPACE_NAME                FILE_NAME
------------------------------ --------------------
USERS                          /dev/raw/raw18
SYSAUX                         /dev/raw/raw15
UNDOTBS1                       /dev/raw/raw20
SYSTEM                         /dev/raw/raw14
EXAMPLE                        /dev/raw/raw16
UNDOTBS2                       /dev/raw/raw21
ZWC                            /dev/raw/raw19
TEMP                           /dev/raw/raw17

8 rows selected.

SQL> select name from v$controlfile;

NAME
------------------------------
/dev/raw/raw10
/dev/raw/raw11

SQL> select member from v$logfile;

MEMBER
------------------------------
/dev/raw/raw7
/dev/raw/raw6
/dev/raw/raw8
/dev/raw/raw9

SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /dev/raw/raw13

SQL> select AUTOEXTENSIBLE,tablespace_name,file_name from dba_data_files
  2  union all
  3  select AUTOEXTENSIBLE,tablespace_name,file_name from dba_temp_files
  4  /

AUT TABLESPACE_NAME                FILE_NAME
--- ------------------------------ ------------------------------
NO  USERS                          /dev/raw/raw18
NO  SYSAUX                         /dev/raw/raw15
NO  UNDOTBS1                       /dev/raw/raw20
NO  SYSTEM                         /dev/raw/raw14
NO  EXAMPLE                        /dev/raw/raw16
NO  UNDOTBS2                       /dev/raw/raw21
NO  ZWC                            /dev/raw/raw19
NO  TEMP                           /dev/raw/raw17

8 rows selected.

[oracle@vzwc2 ~]$ sqlplus system@zhongwc

SQL*Plus: Release 10.2.0.5.0 - Production on Tue Oct 22 22:55:25 2013

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> col host_name format a11
SQL> set line 300 
SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';

Session altered.

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
---------------- ----------- ----------------- ------------------- ------------ --------- ------------------ -----------------
zhongwc1         vzwc1       10.2.0.5.0        2013-10-22 22:53:16 OPEN         NORMAL    PRIMARY_INSTANCE   ACTIVE
zhongwc2         vzwc2       10.2.0.5.0        2013-10-22 22:54:17 OPEN         NORMAL    PRIMARY_INSTANCE   ACTIVE

NO ASM

ZhongWeicheng

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Installation Oracle 10gR2(10.2.0.5) RAC with RAW on RHEL5

The generic steps to follow when adding the new node to the cluster are:Install Operating SystemInstall required softwareAdd/modify users and groups required for the installationConfigure netw
复制链接

扫一扫

专栏目录