

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** Section2 ********************
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------


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


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


******************** TOPIC 1.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:55 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> 
D
-
X
SQL> 
OPEN_MODE
----------
READ WRITE
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


R102000=2


A: READ WRITE


******************** TOPIC 1.3 ********************
telnet: connect to address 127.0.0.1: Connection refused
telnet: Unable to connect to remote host: Connection refused
Trying 127.0.0.1...


R103001=0


A: 0


R103002=0

******************** TOPIC 1.4 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:56 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL>   2    3  select	 m.key_value  from sysman.MGMT_CREDENTIALS2 m, sysman.mgmt_targets t
                                                              *
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> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R104000=0


A: 0


******************** TOPIC 1.5 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:56 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL>   2    3  select	 m.key_value  from sysman.MGMT_CREDENTIALS2 m, sysman.mgmt_targets t
                                                              *
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> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R105000=0


A: 0


******************** TOPIC 1.6 ********************

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

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> select * from sysman.MGMT_CREATED_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> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R106000=0


A: 0


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


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

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

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R201001=0


A: 0

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

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R201002=0


A: 0


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

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

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R202001=0


A: 0

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

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R202002=0


A: 0


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

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

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL>   2  SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R203001=0


A: 0

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

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL>   2  SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R203002=0


A: 0


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

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

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> select	 email_address	 from sysman.MGMT_NOTIFY_DEVICES
                                     *
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> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R204000=0


A: 0


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

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

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R205000=0


A: 0


******************** TOPIC 2.5.1 ********************


R205010=0




******************** TOPIC 2.5.2 ********************

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

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R205020=0


A: 0


******************** TOPIC 2.5.3 ********************

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

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R205030=0


A: 0


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


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


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:23:00 2015

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R302000=0


A: 0


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:23:00 2015

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R303000=0


A: 0


******************** TOPIC 3.4 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:23:00 2015

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R304001=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:23:01 2015

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R304002=0


VALUE_A: 


R304002=0.55
R304002=0




******************** TOPIC 3.5 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:23:01 2015

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R305001=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:23:01 2015

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R305002=0


A: 0


******************** TOPIC 3.6 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:23:02 2015

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R306000=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:23:02 2015

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R306000=0


B: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:23:02 2015

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R306000=0


C: 0


******************** TOPIC 3.7 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:23:02 2015

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R307001=0


VALUE_A: 


R307001=0



SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:23:03 2015

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R307002=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:23:03 2015

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

SQL> SQL> ERROR:
ORA-12541: TNS:no listener


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R307003=0


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


R102000: 2 full is 2 2
R103001: 0 full is 0.5 2.5
R103002: 0 full is 2.5 5
R104000: 0 full is 0.2 5.2
R105000: 0 full is 0.2 5.4
R106000: 0 full is 0.2 5.6
R201001: 0 full is 0.1 5.7
R201002: 0 full is 0.1 5.8
R202001: 0 full is 0.1 5.9
R202002: 0 full is 0.1 6
R203001: 0 full is 0.15 6.15
R203002: 0 full is 0.15 6.3
R204000: 0 full is 0.3 6.6
R205000: 0 full is 0.1 6.7
R205010: 0 full is 0.1 6.8
R205020: 0 full is 0.1 6.9
R205030: 0 full is 0.1 7
R302000: 0 full is 0.2 7.2
R303000: 0 full is 0.3 7.5
R304001: 0 full is 0.2 7.7
R304002: 0 full is 0.55 8.25
R305001: 0 full is 0.2 8.45
R305002: 0 full is 0.25 8.7
R306000: 0 full is 0.2 8.9
R307001: 0 full is 0.5 9.4
R307002: 0 full is 0.3 9.7
R307003: 0 full is 0.3 10
full of this section:
RESULT:
2

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