

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** Section1 ********************
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------


******************** 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 TNS_ADMIN=$ORACLE_HOME/network/admin
export PATH=$ORACLE_HOME/bin:$PATH
export LANG=en_US


******************** TOPIC 1.1 ********************


******************** TOPIC 1.1.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:03:39 2015

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

SQL> Connected.
SQL> SQL> 
NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
undo_retention			     integer	 5400
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


R101011=0.15


A: undo_retention			     integer	 5400

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:03:40 2015

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

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

*
ERROR at line 1:
ORA-06553: PLS-213: package STANDARD not accessible


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

*
ERROR at line 1:
ORA-06553: PLS-213: package STANDARD not accessible


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

*
ERROR at line 1:
ORA-06553: PLS-213: package STANDARD not accessible


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

*
ERROR at line 1:
ORA-06553: PLS-213: package STANDARD not accessible


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

*
ERROR at line 1:
ORA-06553: PLS-213: package STANDARD not accessible


SQL> SQL> SQL> SQL> select tablespace_name,status,retention from dba_tablespaces t, v$parameter p where t.tablespace_name=p.value and p.name='undo_tablespace'
                                             *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL>   2  select file_name,status from dba_data_files d, v$parameter p
                             *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select tablespace_name,status,retention from dba_tablespaces where tablespace_name like 'UNDO%'
                                             *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select file_name,status from dba_data_files where tablespace_name like 'UNDO%'
                             *
ERROR at line 1:
ORA-00942: table or view does not exist


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


R101012=0


A: 0


******************** TOPIC 1.1.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:03:40 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
40

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
VALUE_A: 40


R101021=0



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

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

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
16

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
VALUE_A: 16


R101022=0.15




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


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


******************** TOPIC 2.1.1 ********************

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:41

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 17:41:17
Uptime                    0 days 1 hr. 22 min. 23 sec
Trace Level               user
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listener Trace File       /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 2 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  Instance "PROD", status READY, has 2 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 2 handler(s) for this service...
The command completed successfully


R201010=0.05


A: 0

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:41

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 17:41:17
Uptime                    0 days 1 hr. 22 min. 23 sec
Trace Level               user
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listener Trace File       /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 2 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  Instance "PROD", status READY, has 2 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 2 handler(s) for this service...
The command completed successfully


R201010=.10


B: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))


******************** TOPIC 2.1.2 ********************

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:41

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 17:41:17
Uptime                    0 days 1 hr. 22 min. 23 sec
Trace Level               user
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listener Trace File       /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 2 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  Instance "PROD", status READY, has 2 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 2 handler(s) for this service...
The command completed successfully


R201020=0.05


A: 0

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:41

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 17:41:17
Uptime                    0 days 1 hr. 22 min. 23 sec
Trace Level               user
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listener Trace File       /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 2 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  Instance "PROD", status READY, has 2 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 2 handler(s) for this service...
The command completed successfully


R201020=.10


B: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))


******************** TOPIC 2.1.3 ********************

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:42

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 17:41:17
Uptime                    0 days 1 hr. 22 min. 24 sec
Trace Level               user
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listener Trace File       /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 2 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  Instance "PROD", status READY, has 2 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 2 handler(s) for this service...
The command completed successfully


R201030=0.05


A: 0

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:42

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 17:41:17
Uptime                    0 days 1 hr. 22 min. 24 sec
Trace Level               user
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listener Trace File       /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 2 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  Instance "PROD", status READY, has 2 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 2 handler(s) for this service...
The command completed successfully


R201030=.33


B:   Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...


******************** TOPIC 2.1.4 ********************

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:42

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 17:41:17
Uptime                    0 days 1 hr. 22 min. 24 sec
Trace Level               user
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listener Trace File       /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 2 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  Instance "PROD", status READY, has 2 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 2 handler(s) for this service...
The command completed successfully


R201040=0.05


A: 0

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:42

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 17:41:17
Uptime                    0 days 1 hr. 22 min. 24 sec
Trace Level               user
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listener Trace File       /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 2 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  Instance "PROD", status READY, has 2 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 2 handler(s) for this service...
The command completed successfully


R201040=.24


B:   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))


******************** TOPIC 2.1.5 ********************

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:43

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 17:41:17
Uptime                    0 days 1 hr. 22 min. 25 sec
Trace Level               user
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listener Trace File       /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 2 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  Instance "PROD", status READY, has 2 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 2 handler(s) for this service...
The command completed successfully


R201051=0.05


A: 0

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:43

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 17:41:17
Uptime                    0 days 1 hr. 22 min. 25 sec
Trace Level               user
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listener Trace File       /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 2 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  Instance "PROD", status READY, has 2 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 2 handler(s) for this service...
The command completed successfully


R201051=.23


B: Trace Level               user
nsevdansw: exit
nsrdr: got NSPTMK packet
nsglauthorized: Authenticated user: 602
nsgcsss: ons_subscriber_status=1
nsdo: 506 bytes to NS buffer
nsdo: 682 bytes to NS buffer
nstimarmed: no timer allocated
nsclose: closing transport
nsclose: global context check-out (from slot 6) complete
nsgldissolve: Deallocating cxd 0x8c0f478.


R201052=0.1




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

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:43

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1526)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 17:41:17
Uptime                    0 days 1 hr. 22 min. 25 sec
Trace Level               user
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listener Trace File       /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 2 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  Instance "PROD", status READY, has 2 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 2 handler(s) for this service...
The command completed successfully


R202001=0


A: TNS-12541: TNS:no listener

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:43

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1526)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 17:41:17
Uptime                    0 days 1 hr. 22 min. 25 sec
Trace Level               user
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listener Trace File       /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 2 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  Instance "PROD", status READY, has 2 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 2 handler(s) for this service...
The command completed successfully


R202002=0


A: TNS-12541: TNS:no listener


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

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:44

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1526)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 17:41:17
Uptime                    0 days 1 hr. 22 min. 26 sec
Trace Level               user
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listener Trace File       /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 2 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  Instance "PROD", status READY, has 2 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 2 handler(s) for this service...
The command completed successfully


R203000=0


A: TNS-12541: TNS:no listener


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

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:44

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1526)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 17:41:17
Uptime                    0 days 1 hr. 22 min. 26 sec
Trace Level               user
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listener Trace File       /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 2 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  Instance "PROD", status READY, has 2 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 2 handler(s) for this service...
The command completed successfully


R204001=0.1


A: tcp        0      0 0.0.0.0:1521                0.0.0.0:*                   LISTEN      12300/tnslsnr       

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:44

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1526)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                10-JAN-2015 17:41:17
Uptime                    0 days 1 hr. 22 min. 26 sec
Trace Level               user
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listener Trace File       /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station11.example.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "PROD" has 2 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  Instance "PROD", status READY, has 2 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 2 handler(s) for this service...
The command completed successfully


R204002=0


A: 0


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


******************** TOPIC 3.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:03:44 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
40

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
VALUE_A: 40


R301001=0



SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:03:45 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


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


R301002=0




******************** TOPIC 3.2 ********************


******************** TOPIC 3.2.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:03:45 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
(PROTOCOL=TCP)

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
VALUE_A: 0


R302010=0




******************** TOPIC 3.2.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:03:45 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
10

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
VALUE_A: 10


R302020=0.1




******************** TOPIC 3.3 ********************


******************** TOPIC 3.3.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:03:46 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
10

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
VALUE_A: 10


R303010=0.15




******************** TOPIC 3.3.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:03:46 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
30

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
VALUE_A: 30


R303020=0.05



SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:03:46 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
30

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
VALUE_A: 30


R303020=0.1




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


******************** TOPIC 4.1 ********************

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:47

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

Used parameter files:

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=PROD))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.11)(PORT=1521)))
OK (0 msec)


R401000=0.1




******************** TOPIC 4.2 ********************

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:47

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

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact ( DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=station11.example.com)(PORT=1521)) ( CONNECT_DATA= ( SERVER=SHARED) (SERVICE_NAME=PROD)))
OK (10 msec)

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:47

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

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact ( DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=station11.example.com)(PORT=1521)) ( CONNECT_DATA= ( SERVER=SHARED) (SERVICE_NAME=PROD)))
OK (10 msec)


R402000=0


A: 0


******************** TOPIC 4.3 ********************

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:47

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

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact ( DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=station11.example.com)(PORT=1521)) ( CONNECT_DATA= ( SERVER=SHARED) (SERVICE_NAME=PROD)))
OK (0 msec)

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:47

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

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact ( DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=station11.example.com)(PORT=1521)) ( CONNECT_DATA= ( SERVER=SHARED) (SERVICE_NAME=PROD)))
OK (0 msec)


R403000=0


A: 0


******************** TOPIC 4.4 ********************

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:48

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

Used parameter files:

TNS-03505: Failed to resolve name

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:03:48

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

Used parameter files:

TNS-03505: Failed to resolve name


R404000=0


A: 0


******************** TOPIC 4.5 ********************

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:04:08

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

Used parameter files:

TNS-03505: Failed to resolve name
192.168.0.12
station12.example.com

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:04:08

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

Used parameter files:

TNS-03505: Failed to resolve name


R405000=0


A: 0

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:04:08

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

Used parameter files:

TNS-03505: Failed to resolve name


R405000=0


A: 0


******************** TOPIC 4.6 ********************

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:04:29

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

Used parameter files:

TNS-03505: Failed to resolve name

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:04:29

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

Used parameter files:

TNS-03505: Failed to resolve name


R406000=0


A: 0

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 10-JAN-2015 19:04:29

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

Used parameter files:

TNS-03505: Failed to resolve name


R406000=0


A: 0


******************** TOPIC 5 ********************


******************** TOPIC 5.1 ********************


******************** TOPIC 5.1.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:49 2015

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

SQL> Connected.
SQL> SQL> select * from dba_tablespace_groups
              *
ERROR at line 1:
ORA-00942: table or view does not exist


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


R501010=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:49 2015

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

SQL> Connected.
SQL> SQL> select * from dba_tablespace_groups
              *
ERROR at line 1:
ORA-00942: table or view does not exist


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


R501010=0


B: 0


******************** TOPIC 5.1.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:49 2015

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

SQL> Connected.
SQL> SQL> SQL> 
PROPERTY_NAME		       PROPERTY_VALUE
------------------------------ ------------------------------------------------------------
DEFAULT_TEMP_TABLESPACE        TEMPTS1

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


R501020=0


A: 0


******************** TOPIC 6 ********************


******************** TOPIC 6.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:50 2015

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

SQL> Connected.
SQL> SQL> select TABLESPACE_NAME,BYTES,MAXBYTES from dba_data_files where tablespace_name='EXAMPLE'
                                           *
ERROR at line 1:
ORA-00942: table or view does not exist


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


R601000=0


A: 0


******************** TOPIC 6.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:50 2015

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

SQL> Connected.
SQL> SQL> select TABLESPACE_NAME,BYTES,MAXBYTES from dba_data_files where tablespace_name='EXAMPLE'
                                           *
ERROR at line 1:
ORA-00942: table or view does not exist


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


R602001=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:50 2015

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

SQL> Connected.
SQL> SQL> select TABLESPACE_NAME,BYTES,MAXBYTES from dba_data_files where tablespace_name='EXAMPLE'
                                           *
ERROR at line 1:
ORA-00942: table or view does not exist


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


R602002=0


A: 0


******************** TOPIC 6.3 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:50 2015

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

SQL> Connected.
SQL> SQL> select TABLESPACE_NAME,INITIAL_EXTENT,ALLOCATION_TYPE,bigfile from dba_tablespaces where tablespace_name='EXAMPLE'
                                                                   *
ERROR at line 1:
ORA-00942: table or view does not exist


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


R603000=0


A: 0


******************** TOPIC 6.4 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:51 2015

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

SQL> Connected.
SQL> SQL> select TABLESPACE_NAME,NEXT_EXTENT,ALLOCATION_TYPE,bigfile from dba_tablespaces where tablespace_name='EXAMPLE'
                                                                *
ERROR at line 1:
ORA-00942: table or view does not exist


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


R604000=0


A: 0


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


******************** TOPIC 7.1 ********************


******************** TOPIC 7.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:51 2015

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

SQL> Connected.
SQL> SQL> select TABLESPACE_NAME,BYTES from dba_data_files where tablespace_name='INDX'
                                  *
ERROR at line 1:
ORA-00942: table or view does not exist


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


R700000=0


A: 0


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


******************** TOPIC 8.1 ********************


******************** TOPIC 8.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:51 2015

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

SQL> Connected.
SQL> SQL> select TABLESPACE_NAME,BYTES from dba_data_files where tablespace_name='TOOLS'
                                  *
ERROR at line 1:
ORA-00942: table or view does not exist


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


R800000=0


A: 0


******************** TOPIC 9 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:52 2015

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

SQL> Connected.
SQL> SQL> SQL> 
PROPERTY_NAME		       PROPERTY_VALUE
------------------------------ ------------------------------------------------------------
DEFAULT_PERMANENT_TABLESPACE   USERS

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


R900000=0.05


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:52 2015

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

SQL> Connected.
SQL> SQL> SQL> 
PROPERTY_NAME		       PROPERTY_VALUE
------------------------------ ------------------------------------------------------------
DEFAULT_PERMANENT_TABLESPACE   USERS

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


R900000=.30


B: DEFAULT_PERMANENT_TABLESPACE   USERS


******************** TOPIC 9.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:52 2015

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

SQL> Connected.
SQL> SQL> select TABLESPACE_NAME,BYTES from dba_data_files where tablespace_name='USERS'
                                  *
ERROR at line 1:
ORA-00942: table or view does not exist


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


R901000=0


A: 0


******************** TOPIC 9.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:52 2015

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

SQL> Connected.
SQL> SQL> select TABLESPACE_NAME,BYTES from dba_data_files where tablespace_name='USERS'
                                  *
ERROR at line 1:
ORA-00942: table or view does not exist


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


R902000=0


A: 0


******************** TOPIC 9.3 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:53 2015

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

SQL> Connected.
SQL> SQL> select TABLESPACE_NAME,INITIAL_EXTENT,ALLOCATION_TYPE,bigfile from dba_tablespaces where tablespace_name='USERS'
                                                                   *
ERROR at line 1:
ORA-00942: table or view does not exist


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


R903000=0


A: 0


******************** TOPIC 9.4 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:53 2015

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

SQL> Connected.
SQL> SQL> select TABLESPACE_NAME,NEXT_EXTENT,ALLOCATION_TYPE,bigfile from dba_tablespaces where tablespace_name='USERS'
                                                                *
ERROR at line 1:
ORA-00942: table or view does not exist


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


R904000=0


A: 0


******************** TOPIC 10 ********************


******************** TOPIC 10.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:53 2015

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

SQL> Connected.
SQL> SQL> select TABLESPACE_NAME,BYTES from dba_data_files where tablespace_name='OLTP'
                                  *
ERROR at line 1:
ORA-00942: table or view does not exist


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


R1001000=0


A: 0


******************** TOPIC 10.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:53 2015

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

SQL> Connected.
SQL> SQL> select TABLESPACE_NAME,BYTES from dba_data_files where tablespace_name='OLTP'
                                  *
ERROR at line 1:
ORA-00942: table or view does not exist


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


R1002000=0


A: 0


******************** TOPIC 10.3 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:54 2015

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

SQL> Connected.
SQL> SQL> select TABLESPACE_NAME,INITIAL_EXTENT,ALLOCATION_TYPE,bigfile from dba_tablespaces where tablespace_name='OLTP'
                                                                   *
ERROR at line 1:
ORA-00942: table or view does not exist


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


R1003000=0


A: 0


******************** TOPIC 10.4 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:54 2015

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

SQL> Connected.
SQL> SQL> select TABLESPACE_NAME,NEXT_EXTENT,ALLOCATION_TYPE,bigfile from dba_tablespaces where tablespace_name='OLTP'
                                                                *
ERROR at line 1:
ORA-00942: table or view does not exist


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


R1004001=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:55 2015

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

SQL> Connected.
SQL> SQL> select SEGMENT_SPACE_MANAGEMENT from dba_tablespaces where tablespace_name='OLTP'
                                     *
ERROR at line 1:
ORA-00942: table or view does not exist


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


R1004002=0


A: 0


******************** TOPIC 11 ********************


******************** TOPIC 11.1 ********************


******************** TOPIC 11.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:55 2015

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

SQL> Connected.
SQL> SQL> ERROR:
ORA-06553: PLS-213: package STANDARD not accessible


SQL> 
    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS	    FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
	 1	    1	       4  104857600	     1 YES INACTIVE		   170988 10-JAN-15
	 2	    1	       5  104857600	     1 NO  CURRENT		   191076 10-JAN-15
	 3	    1	       3  104857600	     1 YES INACTIVE		   150726 10-JAN-15
	 4	    1	       0  104857600	     1 YES UNUSED			0
	 5	    1	       0  104857600	     1 YES UNUSED			0

SQL> 
  COUNT(*)
----------
	 5

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


R1102000=0


VALUE_A: 	 5


R1102000=0.5




******************** TOPIC 11.3 ********************
1
1
1
1
1
R1103000=0


******************** TOPIC 11.4 ********************
5
0
R1104000=.50


******************** TOPIC 11.5 ********************
      1 Disk1
      1 Disk2
      1 Disk3
      1 Disk4
      1 Disk5

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:57 2015

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

SQL> Connected.
SQL> SQL> 
     BYTES
----------
 104857600
 104857600
 104857600
 104857600
 104857600

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
VALUE_A: 1


R1105000=0.5




******************** TOPIC 12 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:58 2015

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

SQL> Connected.
SQL> SQL> ERROR:
ORA-06553: PLS-213: package STANDARD not accessible


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

*
ERROR at line 1:
ORA-06553: PLS-213: package STANDARD not accessible


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

*
ERROR at line 1:
ORA-06553: PLS-213: package STANDARD not accessible


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

*
ERROR at line 1:
ORA-06553: PLS-213: package STANDARD not accessible


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

*
ERROR at line 1:
ORA-06553: PLS-213: package STANDARD not accessible


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

*
ERROR at line 1:
ORA-06553: PLS-213: package STANDARD not accessible


SQL> SQL> 
NAME
-----------------------------------------------------------------
/u01/app/oracle/oradata/PROD/Disk1/control01.ctl
/u01/app/oracle/oradata/PROD/Disk2/control02.ctl
/u01/app/oracle/oradata/PROD/Disk3/control03.ctl

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


R1200000=0


VALUE_A: 3


R1200000=0.5




******************** TOPIC 13 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:58 2015

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

SQL> Connected.
SQL> SQL> ERROR:
ORA-06553: PLS-213: package STANDARD not accessible


SQL> 
  COUNT(*)
----------
	 3

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


R1300000=0


VALUE_A: 	 3


R1300000=0.1




******************** TOPIC 14 ********************


******************** TOPIC 14.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:59 2015

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

SQL> Connected.
SQL> SQL> ERROR:
ORA-06553: PLS-213: package STANDARD not accessible


SQL> 
 ANALYZEDT
----------
16445.7951

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


R1400010=0


VALUE_A: 16445


R1400010=0




******************** TOPIC 14.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:04:59 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


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


R1402001=0.4


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:05:00 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


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


R1402002=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:05:00 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


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


R1402002=0


B: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:05:00 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


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


R1402002=0


C: 0


******************** TOPIC 15 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 19:05:00 2015

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

SQL> Connected.
SQL> SQL> 
LOG_MODE
------------
ARCHIVELOG

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


R1500000=0.25


A: ARCHIVELOG

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


R1001000: 0 full is 0.1 0.1
R1002000: 0 full is 0.1 0.2
R1003000: 0 full is 0.15 0.35
R1004001: 0 full is 0.15 0.5
R1004002: 0 full is 0.1 0.6
R101011: 0.15 full is 0.15 0.75
R101012: 0 full is 0.4 1.15
R101021: 0 full is 0.3 1.45
R101022: 0.15 full is 0.15 1.6
R1102000: 0.5 full is 0.5 2.1
R1103000: 0 full is 1.00 3.1
R1104000: .50 full is .50 3.6
R1105000: 0.5 full is 0.5 4.1
R1200000: 0.5 full is 0.5 4.6
R1300000: 0.1 full is 0.1 4.7
R1400010: 0 full is 0.5 5.2
R1402001: 0.4 full is 0.4 5.6
R1402002: 0 full is 0.4 6.0
R1500000: 0.25 full is 0.25 6.25
R201010: .10 full is 0.1 6.35
R201020: .10 full is 0.1 6.45
R201030: .33 full is 0.33 6.78
R201040: .24 full is 0.24 7.02
R201051: .23 full is 0.23 7.25
R201052: 0.1 full is 0.1 7.35
R202001: 0 full is 0.1 7.45
R202002: 0 full is 0.3 7.75
R203000: 0 full is 0.15 7.9
R204001: 0.1 full is 0.1 8.0
R204002: 0 full is 0.1 8.1
R301001: 0 full is 0.1 8.2
R301002: 0 full is 0.2 8.4
R302010: 0 full is 0.15 8.55
R302020: 0.1 full is 0.1 8.65
R303010: 0.15 full is 0.15 8.8
R303020: 0.1 full is 0.1 8.9
R401000: 0.1 full is 0.1 9.0
R402000: 0 full is 0.1 9.1
R403000: 0 full is 0.1 9.2
R404000: 0 full is 0.1 9.3
R405000: 0 full is 0.1 9.4
R406000: 0 full is 0.4 9.8
R501010: 0 full is 0.5 10.3
R501020: 0 full is 0.4 10.7
R601000: 0 full is 0.3 11.0
R602001: 0 full is 0.3 11.3
R602002: 0 full is 0.1 11.4
R603000: 0 full is 0.2 11.6
R604000: 0 full is 0.2 11.8
R700000: 0 full is 0.1 11.9
R800000: 0 full is 0.2 12.1
R900000: .30 full is 0.3 12.4
R901000: 0 full is 0.1 12.5
R902000: 0 full is 0.1 12.6
R903000: 0 full is 0.2 12.8
R904000: 0 full is 0.2 13.0
full of this section:
RESULT:
5.00


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