

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** Section0 ********************
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------


******************** TOPIC 1 ********************
export ORACLE_SID=PROD
.bash_profile OK



# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
	. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=PROD
export PATH=$ORACLE_HOME/bin:$PATH
export LANG=en_US

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:41 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_name 			     string	 PROD
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R100001=1


A: db_name 			     string	 PROD

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:41 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
instance_name			     string	 PROD
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R100002=19


A: instance_name			     string	 PROD


******************** TOPIC 2 ********************


******************** TOPIC 2.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:42 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ****************************
SQL> The database open mode here:
SQL> ****************************
SQL> SQL> 
ADDR	       INDX    INST_ID D
-------- ---------- ---------- -
0C550094	  0	     1 X
SQL> select	open_mode from v$database
                       *
ERROR at line 1:
ORA-01507: database not mounted


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


R200101=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:42 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ****************************
SQL> The database archivelog mode here:
SQL> **********************************
SQL> SQL> ORA-01507: database not mounted
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R200102=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:43 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ****************************
SQL> The database controlfile here:
SQL> ******************************
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R200103=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:43 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ****************************
SQL> The database controlfile here:
SQL> ******************************
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R200104=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:43 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ****************************
SQL> The database controlfile here:
SQL> ******************************
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R200105=0


A: 0


******************** TOPIC 2.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:43 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ***************************
SQL> The database datafile here:
SQL> ***************************
SQL> SQL> SQL> SQL> SQL> select tablespace_name,status from dba_tablespaces where tablespace_name='SYSTEM'
                                   *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> select file_name,status from dba_data_files where tablespace_name='SYSTEM'
                             *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


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


R200201=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:43 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ***************************
SQL> The database datafile here:
SQL> ***************************
SQL> SQL> SQL> SQL> SQL> select tablespace_name,status from dba_tablespaces where tablespace_name='SYSTEM'
                                   *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> select file_name,status from dba_data_files where tablespace_name='SYSTEM'
                             *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


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


R200202=0


A: 0


******************** TOPIC 2.3 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:44 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ***************************
SQL> The database datafile here:
SQL> ***************************
SQL> SQL> SQL> SQL> SQL> select tablespace_name,status from dba_tablespaces where tablespace_name='SYSAUX'
                                   *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> select file_name,status from dba_data_files where tablespace_name='SYSAUX'
                             *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


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


R200301=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:44 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ***************************
SQL> The database datafile here:
SQL> ***************************
SQL> SQL> SQL> SQL> SQL> select tablespace_name,status from dba_tablespaces where tablespace_name='SYSAUX'
                                   *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> select file_name,status from dba_data_files where tablespace_name='SYSAUX'
                             *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


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


R200302=0


A: 0


******************** TOPIC 2.4 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:44 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ***************************
SQL> The database datafile here:
SQL> ***************************
SQL> SQL> SQL> SQL> SQL> select tablespace_name,status from dba_tablespaces t, v$parameter p where t.tablespace_name=p.value and p.name='undo_tablespace'
                                   *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> select file_name,status from dba_data_files d, v$parameter p where d.tablespace_name=p.value and p.name='undo_tablespace'
                             *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> select tablespace_name,status from dba_tablespaces where tablespace_name like 'UNDO%'
                                   *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> select file_name,status from dba_data_files where tablespace_name like 'UNDO%'
                             *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


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


R200401=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:44 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ***************************
SQL> The database datafile here:
SQL> ***************************
SQL> SQL> SQL> SQL> SQL> select tablespace_name,status from dba_tablespaces t, v$parameter p where t.tablespace_name=p.value and p.name='undo_tablespace'
                                   *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> select file_name,status from dba_data_files d, v$parameter p where d.tablespace_name=p.value and p.name='undo_tablespace'
                             *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> select tablespace_name,status from dba_tablespaces where tablespace_name like 'UNDO%'
                                   *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> select file_name,status from dba_data_files where tablespace_name like 'UNDO%'
                             *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


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


R200402=0


A: 0


******************** TOPIC 2.5 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:45 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> **************************
SQL> The database tempfile here:
SQL> **************************
SQL> SQL> SQL> select	name from v$tempfile
                  *
ERROR at line 1:
ORA-01507: database not mounted


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


R200500=0


A: 0


******************** TOPIC 2.6 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:45 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> **************************
SQL> The database logfile here:
SQL> **************************
SQL> SQL> SQL> select	member from v$logfile
                    *
ERROR at line 1:
ORA-01507: database not mounted


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


R200601=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:45 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> **************************
SQL> The database logfile here:
SQL> **************************
SQL> SQL> SQL> select	member from v$logfile
                    *
ERROR at line 1:
ORA-01507: database not mounted


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


R200602=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:45 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> **************************
SQL> The database logfile here:
SQL> **************************
SQL> SQL> SQL> select	member from v$logfile
                    *
ERROR at line 1:
ORA-01507: database not mounted


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


R200603=0


A: 0


******************** TOPIC 3 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:46 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> select	username from dba_users where username='DBSNMP'
                      *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


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


R300000=0


A: 0


******************** TOPIC 4 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 16:41:46 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> SQL> select FILE_NAME, TABLESPACE_NAME, AUTOEXTENSIBLE from dba_data_files
                                                       *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


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


R400000=0


A: 0
****************************************************************************************************


R100001: 1 full is 1 1
R100002: 19 full is 19 20
R200101: 0 full is 10 30
R200102: 0 full is 0 30
R200103: 0 full is 5 35
R200104: 0 full is 5 40
R200105: 0 full is 5 45
R200201: 0 full is 4 49
R200202: 0 full is 1 50
R200301: 0 full is 4 54
R200302: 0 full is 1 55
R200401: 0 full is 4 59
R200402: 0 full is 1 60
R200500: 0 full is 3 63
R200601: 0 full is 3 66
R200602: 0 full is 3 69
R200603: 0 full is 3 72
R300000: 0 full is 15 87
R400000: 0 full is 13 100
full of this section:
RESULT:
20


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