

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** 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:24 2015

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

SQL> Connected to an idle instance.
SQL> SQL> ORA-01012: not logged on


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected


R100001=0


A: 0

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

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

SQL> Connected to an idle instance.
SQL> SQL> ORA-01012: not logged on


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected


R100002=0


A: 0


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


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

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

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

SQL> Connected to an idle instance.
SQL> SQL> SQL> SQL> ERROR:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('**************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('The database open mode here: '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('**************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> select	* from dual
*
ERROR at line 1:
ORA-01012: not logged on


SQL> select	open_mode from v$database
*
ERROR at line 1:
ORA-01012: not logged on


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected


R200101=0


A: 0

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

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

SQL> Connected to an idle instance.
SQL> SQL> SQL> SQL> ERROR:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('**************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('The database archivelog mode here: '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('********************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> ORA-01034: ORACLE not available
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected


R200102=0


A: 0

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

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

SQL> Connected to an idle instance.
SQL> SQL> SQL> SQL> ERROR:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('**************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('The database controlfile here: '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('****************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> SQL> select name from v$controlfile
*
ERROR at line 1:
ORA-01012: not logged on


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected


R200103=0


A: 0

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

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

SQL> Connected to an idle instance.
SQL> SQL> SQL> SQL> ERROR:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('**************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('The database controlfile here: '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('****************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> SQL> select name from v$controlfile
*
ERROR at line 1:
ORA-01012: not logged on


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected


R200104=0


A: 0

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

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

SQL> Connected to an idle instance.
SQL> SQL> SQL> SQL> ERROR:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('**************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('The database controlfile here: '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('****************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> SQL> select name from v$controlfile
*
ERROR at line 1:
ORA-01012: not logged on


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected


R200105=0


A: 0


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

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

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

SQL> Connected to an idle instance.
SQL> SQL> SQL> SQL> ERROR:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('*************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('The database datafile here: '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('*************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> SQL> SQL> SQL> select tablespace_name,status from dba_tablespaces where tablespace_name='SYSTEM'
*
ERROR at line 1:
ORA-01012: not logged on


SQL> select file_name,status from dba_data_files where tablespace_name='SYSTEM'
*
ERROR at line 1:
ORA-01012: not logged on


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected


R200201=0


A: 0

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

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

SQL> Connected to an idle instance.
SQL> SQL> SQL> SQL> ERROR:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('*************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('The database datafile here: '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('*************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> SQL> SQL> SQL> select tablespace_name,status from dba_tablespaces where tablespace_name='SYSTEM'
*
ERROR at line 1:
ORA-01012: not logged on


SQL> select file_name,status from dba_data_files where tablespace_name='SYSTEM'
*
ERROR at line 1:
ORA-01012: not logged on


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected


R200202=0


A: 0


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

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

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

SQL> Connected to an idle instance.
SQL> SQL> SQL> SQL> ERROR:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('*************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('The database datafile here: '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('*************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> SQL> SQL> SQL> select tablespace_name,status from dba_tablespaces where tablespace_name='SYSAUX'
*
ERROR at line 1:
ORA-01012: not logged on


SQL> select file_name,status from dba_data_files where tablespace_name='SYSAUX'
*
ERROR at line 1:
ORA-01012: not logged on


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected


R200301=0


A: 0

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

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

SQL> Connected to an idle instance.
SQL> SQL> SQL> SQL> ERROR:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('*************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('The database datafile here: '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('*************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> SQL> SQL> SQL> select tablespace_name,status from dba_tablespaces where tablespace_name='SYSAUX'
*
ERROR at line 1:
ORA-01012: not logged on


SQL> select file_name,status from dba_data_files where tablespace_name='SYSAUX'
*
ERROR at line 1:
ORA-01012: not logged on


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected


R200302=0


A: 0


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

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

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

SQL> Connected to an idle instance.
SQL> SQL> SQL> SQL> ERROR:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('*************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('The database datafile here: '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('*************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


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-01012: not logged on


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-01012: not logged on


SQL> select tablespace_name,status from dba_tablespaces where tablespace_name like 'UNDO%'
*
ERROR at line 1:
ORA-01012: not logged on


SQL> select file_name,status from dba_data_files where tablespace_name like 'UNDO%'
*
ERROR at line 1:
ORA-01012: not logged on


SQL> SQL> SQL> SQL> SQL> SQL> Disconnected


R200401=0


A: 0

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

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

SQL> Connected to an idle instance.
SQL> SQL> SQL> SQL> ERROR:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('*************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('The database datafile here: '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('*************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


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-01012: not logged on


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-01012: not logged on


SQL> select tablespace_name,status from dba_tablespaces where tablespace_name like 'UNDO%'
*
ERROR at line 1:
ORA-01012: not logged on


SQL> select file_name,status from dba_data_files where tablespace_name like 'UNDO%'
*
ERROR at line 1:
ORA-01012: not logged on


SQL> SQL> SQL> SQL> SQL> SQL> Disconnected


R200402=0


A: 0


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

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

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

SQL> Connected to an idle instance.
SQL> SQL> SQL> SQL> ERROR:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('The database tempfile here: '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> SQL> select	name from v$tempfile
*
ERROR at line 1:
ORA-01012: not logged on


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected


R200500=0


A: 0


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

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

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

SQL> Connected to an idle instance.
SQL> SQL> SQL> SQL> ERROR:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('The database logfile here: '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> SQL> select	member from v$logfile
*
ERROR at line 1:
ORA-01012: not logged on


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected


R200601=0


A: 0

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

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

SQL> Connected to an idle instance.
SQL> SQL> SQL> SQL> ERROR:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('The database logfile here: '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> SQL> select	member from v$logfile
*
ERROR at line 1:
ORA-01012: not logged on


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected


R200602=0


A: 0

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

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

SQL> Connected to an idle instance.
SQL> SQL> SQL> SQL> ERROR:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('The database logfile here: '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line('************************** '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> BEGIN dbms_output.put_line(' '); END;

*
ERROR at line 1:
ORA-01012: not logged on


SQL> SQL> select	member from v$logfile
*
ERROR at line 1:
ORA-01012: not logged on


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected


R200603=0


A: 0


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

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

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

SQL> Connected to an idle instance.
SQL> SQL> select	username from dba_users where username='DBSNMP'
*
ERROR at line 1:
ORA-01012: not logged on


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected


R300000=0


A: 0


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

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

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

SQL> Connected to an idle instance.
SQL> SQL> SQL> SQL> select FILE_NAME, TABLESPACE_NAME, AUTOEXTENSIBLE from dba_data_files
*
ERROR at line 1:
ORA-01012: not logged on


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected


R400000=0


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


R100001: 0 full is 1 1
R100002: 0 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:
0


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