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 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/raw1crw-rw---- 1 oracle oinstall 162, 10 Oct 22 18:52 /dev/raw/raw10crw-rw---- 1 oracle oinstall 162, 11 Oct 22 18:52 /dev/raw/raw11crw-rw---- 1 oracle oinstall 162, 12 Oct 22 18:52 /dev/raw/raw12crw-rw---- 1 oracle oinstall 162, 13 Oct 22 18:52 /dev/raw/raw13crw-rw---- 1 oracle oinstall 162, 14 Oct 22 18:52 /dev/raw/raw14crw-rw---- 1 oracle oinstall 162, 15 Oct 22 18:52 /dev/raw/raw15crw-rw---- 1 oracle oinstall 162, 16 Oct 22 18:52 /dev/raw/raw16crw-rw---- 1 oracle oinstall 162, 17 Oct 22 18:52 /dev/raw/raw17crw-rw---- 1 oracle oinstall 162, 18 Oct 22 18:52 /dev/raw/raw18crw-rw---- 1 oracle oinstall 162, 19 Oct 22 18:52 /dev/raw/raw19crw-rw---- 1 oracle oinstall 162,  2 Oct 22 18:52 /dev/raw/raw2crw-rw---- 1 oracle oinstall 162, 20 Oct 22 18:52 /dev/raw/raw20crw-rw---- 1 oracle oinstall 162, 21 Oct 22 18:52 /dev/raw/raw21crw-rw---- 1 oracle oinstall 162,  3 Oct 22 18:52 /dev/raw/raw3crw-rw---- 1 oracle oinstall 162,  4 Oct 22 18:52 /dev/raw/raw4crw-rw---- 1 oracle oinstall 162,  5 Oct 22 18:52 /dev/raw/raw5crw-rw---- 1 oracle oinstall 162,  6 Oct 22 18:52 /dev/raw/raw6crw-rw---- 1 oracle oinstall 162,  7 Oct 22 18:52 /dev/raw/raw7crw-rw---- 1 oracle oinstall 162,  8 Oct 22 18:52 /dev/raw/raw8crw-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 startStarting portmap: [  OK  ][root@vzwc1 ~]# /etc/init.d/nfs startStarting NFS services:  exportfs: arch2 has non-inet addrexportfs: 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 -THFilesystem    Type     Size   Used  Avail Use% Mounted on/dev/mapper/VolGroup00-LogVol00              ext3      58G   5.7G    49G  11% //dev/sda1     ext3     104M    26M    74M  26% /boottmpfs        tmpfs     1.6G      0   1.6G   0% /dev/shmvzwc2:/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 startStarting portmap: [  OK  ][root@vzwc2 ~]# /etc/init.d/nfs startStarting NFS services:  exportfs: arch1 has non-inet addrexportfs: 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 -hFilesystem            Size  Used Avail Use% Mounted on/dev/mapper/VolGroup00-LogVol00                       54G  5.3G   46G  11% //dev/sda1              99M   24M   70M  26% /boottmpfs                 1.5G     0  1.5G   0% /dev/shmvzwc1:/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/raw14sysaux=/dev/raw/raw15example=/dev/raw/raw16temp=/dev/raw/raw/raw17users=/dev/raw/raw18undotbs1=/dev/raw/raw20undotbs2=/dev/raw/raw21redo1_1=/dev/raw/raw6redo1_2=/dev/raw/raw7redo2_1=/dev/raw/raw8redo2_2=/dev/raw/raw9control1=/dev/raw/raw10control2=/dev/raw/raw11pwdfile=/dev/raw/raw12spfile=/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 crsStopping 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.shCreating pre-patch directory for saving pre-patch clusterware filesCompleted patching clusterware files to /u01/app/oracle/product/10.2.0/crsRelinking some shared libraries.Relinking of patched files is complete.WARNING: directory '/u01/app/oracle/product/10.2.0' is not owned by rootWARNING: directory '/u01/app/oracle/product' is not owned by rootWARNING: directory '/u01/app/oracle' is not owned by rootWARNING: directory '/u01/app' is not owned by rootPreparing 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 vzwc1Creating OCR keys for user 'root', privgrp 'root'..Operation successful.clscfg -upgrade completed successfullyCreating '/u01/app/oracle/product/10.2.0/crs/install/paramfile.crs' with data used for CRS configurationSetting 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 crsStopping 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.shCreating pre-patch directory for saving pre-patch clusterware filesCompleted patching clusterware files to /u01/app/oracle/product/10.2.0/crsRelinking some shared libraries.Relinking of patched files is complete.WARNING: directory '/u01/app/oracle/product/10.2.0' is not owned by rootWARNING: directory '/u01/app/oracle/product' is not owned by rootWARNING: directory '/u01/app/oracle' is not owned by rootWARNING: directory '/u01/app' is not owned by rootPreparing 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 vzwc2Creating OCR keys for user 'root', privgrp 'root'..Operation successful.clscfg -upgrade completed successfullyCreating '/u01/app/oracle/product/10.2.0/crs/install/paramfile.crs' with data used for CRS configurationSetting 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 -vName           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 activeversionCRS 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/raw5located 3 votedisk(s).[oracle@vzwc1 crs]$ [oracle@vzwc1 crs]$ ocrcheckStatus 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.shRunning Oracle10 root.sh script...The following environment variables are set as:    ORACLE_OWNER= oracle    ORACLE_HOME=  /u01/app/oracle/product/10.2.0/db_1Enter 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 byDatabase Configuration Assistant when a database is createdFinished 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.shRunning Oracle10 root.sh script...The following environment variables are set as:    ORACLE_OWNER= oracle    ORACLE_HOME=  /u01/app/oracle/product/10.2.0/db_1Enter 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 byDatabase Configuration Assistant when a database is createdFinished 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 zhongwcInstance zhongwc1 is running on node vzwc1Instance zhongwc2 is running on node vzwc2[oracle@vzwc2 ~]$ [oracle@vzwc2 ~]$ srvctl status service -d zhongwc -s erpService erp is running on instance(s) zhongwc1[oracle@vzwc2 ~]$ [oracle@vzwc2 ~]$ srvctl status nodeapps -n vzwc1VIP is running on node: vzwc1GSD is running on node: vzwc1Listener is running on node: vzwc1ONS daemon is running on node: vzwc1[oracle@vzwc2 ~]$ [oracle@vzwc2 ~]$ srvctl status nodeapps -n vzwc2VIP is running on node: vzwc2GSD is running on node: vzwc2Listener is running on node: vzwc2ONS 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 databasezhongwc[oracle@vzwc2 ~]$ srvctl config database -d zhongwcvzwc1 zhongwc1 /u01/app/oracle/product/10.2.0/db_1vzwc2 zhongwc2 /u01/app/oracle/product/10.2.0/db_1

[oracle@vzwc2 ~]$ crs_stat -t -vName           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 crsCSS appears healthyCRS appears healthyEVM appears healthy[oracle@vzwc2 ~]$ crsctl query crs activeversionCRS 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/raw5located 3 votedisk(s).[oracle@vzwc2 ~]$ [oracle@vzwc2 ~]$ ocrcheckStatus 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@zhongwc1SQL*Plus: Release 10.2.0.5.0 - Production on Tue Oct 22 22:23:52 2013Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.Enter password: Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsSQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing options[oracle@vzwc1 ~]$ sqlplus system@zhongwc2SQL*Plus: Release 10.2.0.5.0 - Production on Tue Oct 22 22:23:58 2013Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.Enter password: Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsSQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing options[oracle@vzwc1 ~]$ sqlplus system@zhongwcSQL*Plus: Release 10.2.0.5.0 - Production on Tue Oct 22 22:24:02 2013Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.Enter password: Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsSQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing options[oracle@vzwc1 ~]$ sqlplus system@erpSQL*Plus: Release 10.2.0.5.0 - Production on Tue Oct 22 22:24:12 2013Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.Enter password: Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsSQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing options[oracle@vzwc1 ~]$ [oracle@vzwc1 ~]$ lsnrctl statusLSNRCTL for Linux: Version 10.2.0.5.0 - Production on 22-OCT-2013 22:24:20Copyright (c) 1991, 2010, Oracle.  All rights reserved.Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))STATUS of the LISTENER------------------------Alias                     LISTENER_VZWC1Version                   TNSLSNR for Linux: Version 10.2.0.5.0 - ProductionStart Date                22-OCT-2013 22:03:37Uptime                    0 days 0 hr. 20 min. 43 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.oraListener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener_vzwc1.logListening 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/raw18SYSAUX                         /dev/raw/raw15UNDOTBS1                       /dev/raw/raw20SYSTEM                         /dev/raw/raw14EXAMPLE                        /dev/raw/raw16UNDOTBS2                       /dev/raw/raw21TEMP                           /dev/raw/raw177 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/raw18SYSAUX                         /dev/raw/raw15UNDOTBS1                       /dev/raw/raw20SYSTEM                         /dev/raw/raw14EXAMPLE                        /dev/raw/raw16UNDOTBS2                       /dev/raw/raw21ZWC                            /dev/raw/raw19TEMP                           /dev/raw/raw178 rows selected.SQL> select name from v$controlfile;NAME------------------------------/dev/raw/raw10/dev/raw/raw11SQL> select member from v$logfile;MEMBER------------------------------/dev/raw/raw7/dev/raw/raw6/dev/raw/raw8/dev/raw/raw9SQL> show parameter spfileNAME                                 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/raw18NO  SYSAUX                         /dev/raw/raw15NO  UNDOTBS1                       /dev/raw/raw20NO  SYSTEM                         /dev/raw/raw14NO  EXAMPLE                        /dev/raw/raw16NO  UNDOTBS2                       /dev/raw/raw21NO  ZWC                            /dev/raw/raw19NO  TEMP                           /dev/raw/raw178 rows selected.

[oracle@vzwc2 ~]$ sqlplus system@zhongwcSQL*Plus: Release 10.2.0.5.0 - Production on Tue Oct 22 22:55:25 2013Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.Enter password: Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsSQL> col host_name format a11SQL> 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   ACTIVEzhongwc2         vzwc2       10.2.0.5.0        2013-10-22 22:54:17 OPEN         NORMAL    PRIMARY_INSTANCE   ACTIVE

NO ASM