

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** Section7 ********************
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------


******************** TOPIC 1 ********************
/dev/raw/raw1:	bound to major 8, minor 17
/dev/raw/raw2:	bound to major 8, minor 18
/dev/raw/raw3:	bound to major 8, minor 19
/dev/raw/raw5:	bound to major 8, minor 21
/dev/raw/raw6:	bound to major 8, minor 22
/dev/raw/raw7:	bound to major 8, minor 23
/dev/raw/raw8:	bound to major 8, minor 24
raw devices OK
Status of Oracle Cluster Registry is as follows :
	 Version                  :          2
	 Total space (kbytes)     :    1003976
	 Used space (kbytes)      :       4552
	 Available space (kbytes) :     999424
	 ID                       :  478038524
	 Device/File Name         : /dev/raw/raw2
                                    Device/File integrity check succeeded

                                    Device/File not configured

	 Cluster registry integrity check succeeded



R100001=0.66


A: 	 Device/File Name         : /dev/raw/raw2
 0.     0    /dev/raw/raw3

located 1 votedisk(s).


R100002=0.66


A:  0.     0    /dev/raw/raw3


******************** TOPIC 2 ********************
bin
cdata
cfgtoollogs
clone
crs
css
cv
diagnostics
evm
has
install
install.platform
inventory
jdk
jlib
jre
JRE
ldap
lib
log
network
nls
OPatch
opmn
oracore
oraInst.loc
oui
perl
plsql
precomp
racg
rdbms
relnotes
root.sh
slax
sqlplus
srvm
xdk


R200000=0.1


A: crs


R200000=.66


B: ACTION_SCRIPT=/u01/crs_1/bin/racgwrap
ACTION_SCRIPT=/u01/crs_1/bin/racgwrap
ACTION_SCRIPT=/u01/crs_1/bin/racgwrap
ACTION_SCRIPT=/u01/crs_1/bin/racgwrap
ACTION_SCRIPT=/u01/crs_1/bin/racgwrap
ACTION_SCRIPT=/u01/crs_1/bin/racgwrap
ACTION_SCRIPT=/u01/crs_1/bin/racgwrap


******************** TOPIC 3 ********************
assistants
bin
cdata
cfgtoollogs
clone
config
crs
css
ctx
dbs
demo
diagnostics
has
hs
install
install.platform
inventory
javavm
jdbc
jdk
jlib
jre
ldap
lib
log
md
mesg
mgw
network
nls
oc4j
odbc
olap
OPatch
opmn
oracore
oraInst.loc
ord
oui
owm
perl
plsql
precomp
racg
rdbms
relnotes
root.sh
root.sh.old
slax
sqlj
sqlplus
srvm
sysman
uix
wwg
xdk


R300000=0.66


A: sqlplus


******************** TOPIC 4 ********************
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.racdb.db   application    ONLINE    ONLINE    station20   
ora....b1.inst application    ONLINE    ONLINE    station19   
ora....b2.inst application    ONLINE    ONLINE    station20   
ora....serv.cs application    OFFLINE   OFFLINE               
ora....db1.srv application    ONLINE    OFFLINE               
ora....db2.srv application    ONLINE    OFFLINE               
ora....SM1.asm application    ONLINE    ONLINE    station19   
ora....19.lsnr application    ONLINE    ONLINE    station19   
ora....n19.gsd application    ONLINE    ONLINE    station19   
ora....n19.ons application    ONLINE    ONLINE    station19   
ora....n19.vip application    ONLINE    ONLINE    station19   
ora....SM2.asm application    ONLINE    ONLINE    station20   
ora....20.lsnr application    ONLINE    ONLINE    station20   
ora....n20.gsd application    ONLINE    ONLINE    station20   
ora....n20.ons application    ONLINE    ONLINE    station20   
ora....n20.vip application    ONLINE    ONLINE    station20   


R400000=0.03


A: ora.racdb.db   application    ONLINE    ONLINE    station20   


R400000=.06


B: ora....b1.inst application    ONLINE    ONLINE    station19   


R400000=.10


C: ora....b2.inst application    ONLINE    ONLINE    station20   
ASM
/u01/db_1

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 10 12:34:57 2015

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL> 
  COUNT(*)
----------
	 2

SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R400000=.11


D: 2
ASM
/u01/db_1

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 10 12:34:57 2015

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL> 
  COUNT(*)
----------
	 2

SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R400000=.12


E: 2
ASM
/u01/db_1

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 10 12:34:57 2015

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL> 
COUNT(TYPE)
-----------
	  2

SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R400000=.13


F: 2
R400000=0.5


******************** TOPIC 5 ********************
DATABASE

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 10 12:34:58 2015

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL> 
NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_name 			     string	 racdb
SQL> 
NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest		     string	 +RECOVERDG
db_recovery_file_dest_size	     big integer 2G
SQL> 
OPEN_MODE
----------
READ WRITE

SQL> 
NAME
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+DATADG/racdb/datafile/system.256.868621791
+DATADG/racdb/datafile/undotbs1.258.868621791
+DATADG/racdb/datafile/sysaux.257.868621791
+DATADG/racdb/datafile/users.259.868621791
+DATADG/racdb/datafile/undotbs2.264.868622041

SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R500001=0.1


A: db_name 			     string	 racdb
+DATADG/racdb/datafile/system.256.868621791
+DATADG/racdb/datafile/undotbs1.258.868621791
+DATADG/racdb/datafile/sysaux.257.868621791
+DATADG/racdb/datafile/users.259.868621791
+DATADG/racdb/datafile/undotbs2.264.868622041

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 10 12:34:58 2015

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL> 
NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_name 			     string	 racdb
SQL> 
NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest		     string	 +RECOVERDG
db_recovery_file_dest_size	     big integer 2G
SQL> 
OPEN_MODE
----------
READ WRITE

SQL> 
NAME
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+DATADG/racdb/datafile/system.256.868621791
+DATADG/racdb/datafile/undotbs1.258.868621791
+DATADG/racdb/datafile/sysaux.257.868621791
+DATADG/racdb/datafile/users.259.868621791
+DATADG/racdb/datafile/undotbs2.264.868622041

SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R500001=.2


B: READ WRITE

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 10 12:34:58 2015

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL> 
NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_name 			     string	 racdb
SQL> 
NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest		     string	 +RECOVERDG
db_recovery_file_dest_size	     big integer 2G
SQL> 
OPEN_MODE
----------
READ WRITE

SQL> 
NAME
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+DATADG/racdb/datafile/system.256.868621791
+DATADG/racdb/datafile/undotbs1.258.868621791
+DATADG/racdb/datafile/sysaux.257.868621791
+DATADG/racdb/datafile/users.259.868621791
+DATADG/racdb/datafile/undotbs2.264.868622041

SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R500001=.4


C: db_recovery_file_dest		     string	 +RECOVERDG
db_recovery_file_dest: db_recovery_file_dest		     string	 +RECOVERDG

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 10 12:34:58 2015

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL> 
NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_name 			     string	 racdb
SQL> 
NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest		     string	 +RECOVERDG
db_recovery_file_dest_size	     big integer 2G
SQL> 
OPEN_MODE
----------
READ WRITE

SQL> 
NAME
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+DATADG/racdb/datafile/system.256.868621791
+DATADG/racdb/datafile/undotbs1.258.868621791
+DATADG/racdb/datafile/sysaux.257.868621791
+DATADG/racdb/datafile/users.259.868621791
+DATADG/racdb/datafile/undotbs2.264.868622041

SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R500001=.5


D: 0
OTHER Diskgroup: 0
INSTANCE1

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 10 12:34:59 2015

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL> 
NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
instance_name			     string	 racdb1
SQL> 
OPEN_MODE
----------
READ WRITE

SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R500002=0.2


A: instance_name			     string	 racdb1

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 10 12:34:59 2015

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL> 
NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
instance_name			     string	 racdb1
SQL> 
OPEN_MODE
----------
READ WRITE

SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R500002=.5


B: READ WRITE
INSTANCE2

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 10 12:34:59 2015

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL> 
NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
instance_name			     string	 racdb2
SQL> 
OPEN_MODE
----------
READ WRITE

SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R500003=0.2


A: instance_name			     string	 racdb2

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 10 12:34:59 2015

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL> 
NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
instance_name			     string	 racdb2
SQL> 
OPEN_MODE
----------
READ WRITE

SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R500003=.5


B: READ WRITE


******************** TOPIC 6 ********************
DATABASE

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 10 12:34:59 2015

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL> 
LOG_MODE
------------
ARCHIVELOG

SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R600000=0.5


A: ARCHIVELOG


******************** TOPIC 7 ********************


R700001=0


A: 0


R700002=0


A: 0


R700003=0


A: 0
DATABASE

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 10 12:35:01 2015

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL> SQL> SQL> SQL> 
NAME		     FAILOVER_METHOD	  FAILOVER_TYPE        FAILOVER_RETRIES FAILOVER_DELAY
-------------------- -------------------- -------------------- ---------------- --------------
racdb_serv

SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R700004=0


A: 0
SERVICE

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 10 12:35:01 2015

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


Enter user-name: SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon>  ::= <username>[/<password>][@<connect_identifier>] | /
Enter user-name: SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon>  ::= <username>[/<password>][@<connect_identifier>] | /
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus


R700004=0


B: 0


******************** TOPIC 8 ********************


R800000=0


A: 0


******************** TOPIC 9 ********************
DATABASE

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 10 12:35:21 2015

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL> 
SEQUENCE_OWNER		       SEQUENCE_NAME		       MIN_VALUE  MAX_VALUE INCREMENT_BY C O CACHE_SIZE LAST_NUMBER
------------------------------ ------------------------------ ---------- ---------- ------------ - - ---------- -----------
SYSTEM			       SEQ1				       1      99999	       1 N N	     20 	 41

SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R900001=0


A: 0
INSTANCE1

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 10 12:35:22 2015

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL> 
   NEXTVAL
----------
	 3

SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
INSTANCE2

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 10 12:35:22 2015

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL> 
   NEXTVAL
----------
	23

SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
A: 3
B: 23
C: 20


R900002=0




******************** TOPIC 10 ********************
NULL
*****************************************************************************************************


R100001: 0.66 full is 0.66 0.66
R100002: 0.66 full is 0.66 1.32
R200000: .66 full is 0.66 1.98
R300000: 0.66 full is 0.66 2.64
R400000: 0.5 full is 0.5 3.14
R500001: .5 full is 0.5 3.64
R500002: .5 full is 0.5 4.14
R500003: .5 full is 0.5 4.64
R600000: 0.5 full is 0.5 5.14
R700001: 0 full is 0.33 5.47
R700002: 0 full is 0.33 5.8
R700003: 0 full is 0.34 6.14
R700004: 0 full is 0.5 6.64
R800000: 0 full is 0.36 7
R900001: 0 full is 0.3 7.3
R900002: 0 full is 0.2 7.5
full of this section:
RESULT:
5.14


*****************************************************************************************************
