

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** 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)      :       3796
	 Available space (kbytes) :    1000180
	 ID                       :  177096156
	 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    station12   
ora....b1.inst application    ONLINE    ONLINE    station11   
ora....b2.inst application    ONLINE    ONLINE    station12   
ora....SM1.asm application    ONLINE    ONLINE    station11   
ora....11.lsnr application    ONLINE    ONLINE    station11   
ora....n11.gsd application    ONLINE    ONLINE    station11   
ora....n11.ons application    ONLINE    ONLINE    station11   
ora....n11.vip application    ONLINE    ONLINE    station11   
ora....SM2.asm application    ONLINE    ONLINE    station12   
ora....12.lsnr application    ONLINE    ONLINE    station12   
ora....n12.gsd application    ONLINE    ONLINE    station12   
ora....n12.ons application    ONLINE    ONLINE    station12   
ora....n12.vip application    ONLINE    ONLINE    station12   


R400000=0.03


A: ora.racdb.db   application    ONLINE    ONLINE    station12   


R400000=.06


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


R400000=.10


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

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 10 12:35:17 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:35:18 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:35:18 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)
-----------
	  0

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: 0
R400000=0.4


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

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 10 12:35:19 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.868622995
+DATADG/racdb/datafile/undotbs1.258.868622997
+DATADG/racdb/datafile/sysaux.257.868622995
+DATADG/racdb/datafile/users.259.868622997
+DATADG/racdb/datafile/undotbs2.264.868623397

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.868622995
+DATADG/racdb/datafile/undotbs1.258.868622997
+DATADG/racdb/datafile/sysaux.257.868622995
+DATADG/racdb/datafile/users.259.868622997
+DATADG/racdb/datafile/undotbs2.264.868623397

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 10 12:35:19 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.868622995
+DATADG/racdb/datafile/undotbs1.258.868622997
+DATADG/racdb/datafile/sysaux.257.868622995
+DATADG/racdb/datafile/users.259.868622997
+DATADG/racdb/datafile/undotbs2.264.868623397

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:35:19 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.868622995
+DATADG/racdb/datafile/undotbs1.258.868622997
+DATADG/racdb/datafile/sysaux.257.868622995
+DATADG/racdb/datafile/users.259.868622997
+DATADG/racdb/datafile/undotbs2.264.868623397

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:35:19 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.868622995
+DATADG/racdb/datafile/undotbs1.258.868622997
+DATADG/racdb/datafile/sysaux.257.868622995
+DATADG/racdb/datafile/users.259.868622997
+DATADG/racdb/datafile/undotbs2.264.868623397

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:35:19 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:35:19 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:35:20 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:35:20 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: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> 
LOG_MODE
------------
NOARCHIVELOG

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


A: 0


******************** 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: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> SQL> SQL> SQL> 
no rows selected

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:23 2015

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

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


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:36:03 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> 
no rows selected

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:36:03 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> select system.seq1.nextval from dual
              *
ERROR at line 1:
ORA-02289: sequence does not exist


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:36:04 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> select system.seq1.nextval from dual
              *
ERROR at line 1:
ORA-02289: sequence does not exist


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: 0
B: 0
C: 0


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.4 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 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:
4.54


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