开启辅助访问

Bo's Oracle Station

Bo's Oracle Station»社区 › 培训进行时（结课后图标变灰，但是欢迎继续发帖！） › 10002-11g管理类OCM认证班第一期 › Section1
返回列表 发新帖
查看: 899|回复: 0

Section1

[复制链接]
admin

75

主题

115

帖子

2772

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
2772
发表于 2015-9-26 16:56:33 | 显示全部楼层 |阅读模式
第1-5单时我的输出：


  3. ----------------------------------------------------------------------------------------------------
  4. ----------------------------------------------------------------------------------------------------
  5. ----------------------------------------------------------------------------------------------------
  6. ******************** Section1 ********************
  7. ----------------------------------------------------------------------------------------------------
  8. ----------------------------------------------------------------------------------------------------
  9. ----------------------------------------------------------------------------------------------------


  12. ******************** TOPIC 1 ********************
  13. export ORACLE_SID=PROD
  14. .bash_profile OK



  18. # .bash_profile

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

  25. # User specific environment and startup programs

  27. PATH=$PATH:$HOME/bin

  29. export PATH
  30. export ORACLE_BASE=/u01/app/oracle
  31. export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
  32. export ORACLE_SID=PROD
  33. export PATH=$ORACLE_HOME/bin:$PATH
  34. export LANG=en_US


  37. ******************** TOPIC 1.1 ********************


  40. ******************** TOPIC 1.1.1 ********************

  42. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:01 2015

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

  46. SQL> Connected.
  47. SQL> SQL>
  48. NAME                                     TYPE         VALUE
  49. ------------------------------------ ----------- ------------------------------
  50. undo_retention                             integer         5400
  51. 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
  52. With the Partitioning, OLAP and Data Mining options


  55. R101011=0.15


  58. A: undo_retention                             integer         5400

  60. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:01 2015

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

  64. SQL> Connected.
  65. SQL> SQL>
  66. PL/SQL procedure successfully completed.

  68. SQL>
  69. PL/SQL procedure successfully completed.

  71. SQL>
  72. PL/SQL procedure successfully completed.

  74. SQL>
  75. PL/SQL procedure successfully completed.

  77. SQL>
  78. PL/SQL procedure successfully completed.

  80. SQL> SQL> SQL> SQL>
  81. no rows selected

  83. SQL>   2  
  84. no rows selected

  86. SQL>
  87. TABLESPACE_NAME                STATUS               RETENTION
  88. ------------------------------ --------------- -----------
  89. UNDOTBS1                       ONLINE               GUARANTEE

  91. SQL>
  92. FILE_NAME                                                          STATUS
  93. ----------------------------------------------------------------- ---------------
  94. /u01/app/oracle/oradata/PROD/Disk3/undotbs1.dbf                   AVAILABLE

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


  100. R101012=0.4


  103. A: UNDOTBS1                       ONLINE               GUARANTEE


  106. ******************** TOPIC 1.1.2 ********************

  108. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:02 2015

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

  112. SQL> Connected.
  113. SQL> SQL>
  114. VALUE
  115. --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  116. 300

  118. 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
  119. With the Partitioning, OLAP and Data Mining options
  120. VALUE_A: 300


  123. R101021=0.3



  127. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:02 2015

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

  131. SQL> Connected.
  132. SQL> SQL>
  133. VALUE
  134. --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  135. 15

  137. 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
  138. With the Partitioning, OLAP and Data Mining options
  139. VALUE_A: 15


  142. R101022=0.15




  147. ******************** TOPIC 2 ********************


  150. ******************** TOPIC 2.1 ********************


  153. ******************** TOPIC 2.1.1 ********************

  155. LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:02

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

  159. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1521)))
  160. STATUS of the LISTENER
  161. ------------------------
  162. Alias                     LISTENER
  163. Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
  164. Start Date                12-SEP-2015 15:31:24
  165. Uptime                    0 days 0 hr. 53 min. 38 sec
  166. Trace Level               user
  167. Security                  ON: Local OS Authentication
  168. SNMP                      OFF
  169. Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
  170. Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
  171. Listener Trace File       /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
  172. Listening Endpoints Summary...
  173.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1521)))
  174.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
  175. Services Summary...
  176. Service "PROD" has 1 instance(s).
  177.   Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  178. Service "plsextproc" has 1 instance(s).
  179.   Instance "plsextproc", status UNKNOWN, has 1 handler(s) for this service...
  180. The command completed successfully


  183. R201010=0.05


  186. A: 0

  188. LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:02

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

  192. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1521)))
  193. STATUS of the LISTENER
  194. ------------------------
  195. Alias                     LISTENER
  196. Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
  197. Start Date                12-SEP-2015 15:31:24
  198. Uptime                    0 days 0 hr. 53 min. 38 sec
  199. Trace Level               user
  200. Security                  ON: Local OS Authentication
  201. SNMP                      OFF
  202. Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
  203. Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
  204. Listener Trace File       /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
  205. Listening Endpoints Summary...
  206.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1521)))
  207.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
  208. Services Summary...
  209. Service "PROD" has 1 instance(s).
  210.   Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  211. Service "plsextproc" has 1 instance(s).
  212.   Instance "plsextproc", status UNKNOWN, has 1 handler(s) for this service...
  213. The command completed successfully


  216. R201010=.10


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


  223. ******************** TOPIC 2.1.2 ********************

  225. LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:03

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

  229. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1521)))
  230. STATUS of the LISTENER
  231. ------------------------
  232. Alias                     LISTENER
  233. Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
  234. Start Date                12-SEP-2015 15:31:24
  235. Uptime                    0 days 0 hr. 53 min. 38 sec
  236. Trace Level               user
  237. Security                  ON: Local OS Authentication
  238. SNMP                      OFF
  239. Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
  240. Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
  241. Listener Trace File       /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
  242. Listening Endpoints Summary...
  243.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1521)))
  244.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
  245. Services Summary...
  246. Service "PROD" has 1 instance(s).
  247.   Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  248. Service "plsextproc" has 1 instance(s).
  249.   Instance "plsextproc", status UNKNOWN, has 1 handler(s) for this service...
  250. The command completed successfully


  253. R201020=0.05


  256. A: 0

  258. LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:03

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

  262. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1521)))
  263. STATUS of the LISTENER
  264. ------------------------
  265. Alias                     LISTENER
  266. Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
  267. Start Date                12-SEP-2015 15:31:24
  268. Uptime                    0 days 0 hr. 53 min. 38 sec
  269. Trace Level               user
  270. Security                  ON: Local OS Authentication
  271. SNMP                      OFF
  272. Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
  273. Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
  274. Listener Trace File       /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
  275. Listening Endpoints Summary...
  276.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1521)))
  277.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
  278. Services Summary...
  279. Service "PROD" has 1 instance(s).
  280.   Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  281. Service "plsextproc" has 1 instance(s).
  282.   Instance "plsextproc", status UNKNOWN, has 1 handler(s) for this service...
  283. The command completed successfully


  286. R201020=.10


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


  293. ******************** TOPIC 2.1.3 ********************

  295. LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:03

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

  299. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1521)))
  300. STATUS of the LISTENER
  301. ------------------------
  302. Alias                     LISTENER
  303. Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
  304. Start Date                12-SEP-2015 15:31:24
  305. Uptime                    0 days 0 hr. 53 min. 39 sec
  306. Trace Level               user
  307. Security                  ON: Local OS Authentication
  308. SNMP                      OFF
  309. Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
  310. Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
  311. Listener Trace File       /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
  312. Listening Endpoints Summary...
  313.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1521)))
  314.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
  315. Services Summary...
  316. Service "PROD" has 1 instance(s).
  317.   Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  318. Service "plsextproc" has 1 instance(s).
  319.   Instance "plsextproc", status UNKNOWN, has 1 handler(s) for this service...
  320. The command completed successfully


  323. R201030=0.05


  326. A: 0

  328. LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:03

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

  332. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1521)))
  333. STATUS of the LISTENER
  334. ------------------------
  335. Alias                     LISTENER
  336. Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
  337. Start Date                12-SEP-2015 15:31:24
  338. Uptime                    0 days 0 hr. 53 min. 39 sec
  339. Trace Level               user
  340. Security                  ON: Local OS Authentication
  341. SNMP                      OFF
  342. Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
  343. Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
  344. Listener Trace File       /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
  345. Listening Endpoints Summary...
  346.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1521)))
  347.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
  348. Services Summary...
  349. Service "PROD" has 1 instance(s).
  350.   Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  351. Service "plsextproc" has 1 instance(s).
  352.   Instance "plsextproc", status UNKNOWN, has 1 handler(s) for this service...
  353. The command completed successfully


  356. R201030=.33


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


  362. ******************** TOPIC 2.1.4 ********************

  364. LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:04

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

  368. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1521)))
  369. STATUS of the LISTENER
  370. ------------------------
  371. Alias                     LISTENER
  372. Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
  373. Start Date                12-SEP-2015 15:31:24
  374. Uptime                    0 days 0 hr. 53 min. 39 sec
  375. Trace Level               user
  376. Security                  ON: Local OS Authentication
  377. SNMP                      OFF
  378. Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
  379. Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
  380. Listener Trace File       /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
  381. Listening Endpoints Summary...
  382.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1521)))
  383.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
  384. Services Summary...
  385. Service "PROD" has 1 instance(s).
  386.   Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  387. Service "plsextproc" has 1 instance(s).
  388.   Instance "plsextproc", status UNKNOWN, has 1 handler(s) for this service...
  389. The command completed successfully


  392. R201040=0.05


  395. A: 0

  397. LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:04

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

  401. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1521)))
  402. STATUS of the LISTENER
  403. ------------------------
  404. Alias                     LISTENER
  405. Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
  406. Start Date                12-SEP-2015 15:31:24
  407. Uptime                    0 days 0 hr. 53 min. 39 sec
  408. Trace Level               user
  409. Security                  ON: Local OS Authentication
  410. SNMP                      OFF
  411. Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
  412. Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
  413. Listener Trace File       /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
  414. Listening Endpoints Summary...
  415.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1521)))
  416.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
  417. Services Summary...
  418. Service "PROD" has 1 instance(s).
  419.   Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  420. Service "plsextproc" has 1 instance(s).
  421.   Instance "plsextproc", status UNKNOWN, has 1 handler(s) for this service...
  422. The command completed successfully


  425. R201040=.24


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


  431. ******************** TOPIC 2.1.5 ********************

  433. LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:04

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

  437. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1521)))
  438. STATUS of the LISTENER
  439. ------------------------
  440. Alias                     LISTENER
  441. Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
  442. Start Date                12-SEP-2015 15:31:24
  443. Uptime                    0 days 0 hr. 53 min. 40 sec
  444. Trace Level               user
  445. Security                  ON: Local OS Authentication
  446. SNMP                      OFF
  447. Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
  448. Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
  449. Listener Trace File       /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
  450. Listening Endpoints Summary...
  451.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1521)))
  452.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
  453. Services Summary...
  454. Service "PROD" has 1 instance(s).
  455.   Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  456. Service "plsextproc" has 1 instance(s).
  457.   Instance "plsextproc", status UNKNOWN, has 1 handler(s) for this service...
  458. The command completed successfully


  461. R201051=0.05


  464. A: 0

  466. LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:04

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

  470. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1521)))
  471. STATUS of the LISTENER
  472. ------------------------
  473. Alias                     LISTENER
  474. Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
  475. Start Date                12-SEP-2015 15:31:24
  476. Uptime                    0 days 0 hr. 53 min. 40 sec
  477. Trace Level               user
  478. Security                  ON: Local OS Authentication
  479. SNMP                      OFF
  480. Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
  481. Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
  482. Listener Trace File       /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
  483. Listening Endpoints Summary...
  484.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1521)))
  485.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
  486. Services Summary...
  487. Service "PROD" has 1 instance(s).
  488.   Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  489. Service "plsextproc" has 1 instance(s).
  490.   Instance "plsextproc", status UNKNOWN, has 1 handler(s) for this service...
  491. The command completed successfully


  494. R201051=.23


  497. B: Trace Level               user
  498. nsevdansw: exit
  499. nsrdr: got NSPTMK packet
  500. nsglauthorized: Authenticated user: 602
  501. nsgcsss: ons_subscriber_status=1
  502. nsdo: 506 bytes to NS buffer
  503. nsdo: 667 bytes to NS buffer
  504. nstimarmed: no timer allocated
  505. nsclose: closing transport
  506. nsclose: global context check-out (from slot 5) complete
  507. nsgldissolve: Deallocating cxd 0x84a5018.


  510. R201052=0.1




  515. ******************** TOPIC 2.2 ********************

  517. LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:05

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

  521. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1526)))
  522. STATUS of the LISTENER
  523. ------------------------
  524. Alias                     lsnr2
  525. Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
  526. Start Date                12-SEP-2015 12:10:31
  527. Uptime                    0 days 4 hr. 14 min. 33 sec
  528. Trace Level               off
  529. Security                  ON: Local OS Authentication
  530. SNMP                      OFF
  531. Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
  532. Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/lsnr2.log
  533. Listening Endpoints Summary...
  534.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1526)))
  535.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc1)))
  536. Services Summary...
  537. Service "PROD" has 1 instance(s).
  538.   Instance "PROD", status READY, has 4 handler(s) for this service...
  539. Service "PROD_XPT" has 1 instance(s).
  540.   Instance "PROD", status READY, has 4 handler(s) for this service...
  541. The command completed successfully


  544. R202001=0.05


  547. A: 0

  549. LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:05

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

  553. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1526)))
  554. STATUS of the LISTENER
  555. ------------------------
  556. Alias                     lsnr2
  557. Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
  558. Start Date                12-SEP-2015 12:10:31
  559. Uptime                    0 days 4 hr. 14 min. 33 sec
  560. Trace Level               off
  561. Security                  ON: Local OS Authentication
  562. SNMP                      OFF
  563. Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
  564. Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/lsnr2.log
  565. Listening Endpoints Summary...
  566.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1526)))
  567.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc1)))
  568. Services Summary...
  569. Service "PROD" has 1 instance(s).
  570.   Instance "PROD", status READY, has 4 handler(s) for this service...
  571. Service "PROD_XPT" has 1 instance(s).
  572.   Instance "PROD", status READY, has 4 handler(s) for this service...
  573. The command completed successfully


  576. R202001=.10


  579. B: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1526)))
  580.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1526)))

  582. LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:05

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

  586. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1526)))
  587. STATUS of the LISTENER
  588. ------------------------
  589. Alias                     lsnr2
  590. Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
  591. Start Date                12-SEP-2015 12:10:31
  592. Uptime                    0 days 4 hr. 14 min. 34 sec
  593. Trace Level               off
  594. Security                  ON: Local OS Authentication
  595. SNMP                      OFF
  596. Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
  597. Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/lsnr2.log
  598. Listening Endpoints Summary...
  599.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1526)))
  600.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc1)))
  601. Services Summary...
  602. Service "PROD" has 1 instance(s).
  603.   Instance "PROD", status READY, has 4 handler(s) for this service...
  604. Service "PROD_XPT" has 1 instance(s).
  605.   Instance "PROD", status READY, has 4 handler(s) for this service...
  606. The command completed successfully


  609. R202002=0.05


  612. A: 0

  614. LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:05

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

  618. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1526)))
  619. STATUS of the LISTENER
  620. ------------------------
  621. Alias                     lsnr2
  622. Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
  623. Start Date                12-SEP-2015 12:10:31
  624. Uptime                    0 days 4 hr. 14 min. 34 sec
  625. Trace Level               off
  626. Security                  ON: Local OS Authentication
  627. SNMP                      OFF
  628. Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
  629. Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/lsnr2.log
  630. Listening Endpoints Summary...
  631.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1526)))
  632.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc1)))
  633. Services Summary...
  634. Service "PROD" has 1 instance(s).
  635.   Instance "PROD", status READY, has 4 handler(s) for this service...
  636. Service "PROD_XPT" has 1 instance(s).
  637.   Instance "PROD", status READY, has 4 handler(s) for this service...
  638. The command completed successfully


  641. R202002=.30


  644. B: 0


  647. ******************** TOPIC 2.3 ********************

  649. LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:05

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

  653. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1526)))
  654. STATUS of the LISTENER
  655. ------------------------
  656. Alias                     lsnr2
  657. Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
  658. Start Date                12-SEP-2015 12:10:31
  659. Uptime                    0 days 4 hr. 14 min. 34 sec
  660. Trace Level               off
  661. Security                  ON: Local OS Authentication
  662. SNMP                      OFF
  663. Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
  664. Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/lsnr2.log
  665. Listening Endpoints Summary...
  666.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1526)))
  667.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc1)))
  668. Services Summary...
  669. Service "PROD" has 1 instance(s).
  670.   Instance "PROD", status READY, has 4 handler(s) for this service...
  671. Service "PROD_XPT" has 1 instance(s).
  672.   Instance "PROD", status READY, has 4 handler(s) for this service...
  673. The command completed successfully


  676. R203000=0.05


  679. A: 0

  681. LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:05

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

  685. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1526)))
  686. STATUS of the LISTENER
  687. ------------------------
  688. Alias                     lsnr2
  689. Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
  690. Start Date                12-SEP-2015 12:10:31
  691. Uptime                    0 days 4 hr. 14 min. 34 sec
  692. Trace Level               off
  693. Security                  ON: Local OS Authentication
  694. SNMP                      OFF
  695. Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
  696. Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/lsnr2.log
  697. Listening Endpoints Summary...
  698.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1526)))
  699.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc1)))
  700. Services Summary...
  701. Service "PROD" has 1 instance(s).
  702.   Instance "PROD", status READY, has 4 handler(s) for this service...
  703. Service "PROD_XPT" has 1 instance(s).
  704.   Instance "PROD", status READY, has 4 handler(s) for this service...
  705. The command completed successfully


  708. R203000=.15


  711. B: LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:05
  712. Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
  713. Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
  714. Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/lsnr2.log
  715. Service "PROD" has 1 instance(s).
  716.   Instance "PROD", status READY, has 4 handler(s) for this service...
  717. Service "PROD_XPT" has 1 instance(s).
  718.   Instance "PROD", status READY, has 4 handler(s) for this service...


  721. ******************** TOPIC 2.4 ********************

  723. LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:05

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

  727. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1526)))
  728. STATUS of the LISTENER
  729. ------------------------
  730. Alias                     lsnr2
  731. Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
  732. Start Date                12-SEP-2015 12:10:31
  733. Uptime                    0 days 4 hr. 14 min. 34 sec
  734. Trace Level               off
  735. Security                  ON: Local OS Authentication
  736. SNMP                      OFF
  737. Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
  738. Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/lsnr2.log
  739. Listening Endpoints Summary...
  740.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1526)))
  741.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc1)))
  742. Services Summary...
  743. Service "PROD" has 1 instance(s).
  744.   Instance "PROD", status READY, has 4 handler(s) for this service...
  745. Service "PROD_XPT" has 1 instance(s).
  746.   Instance "PROD", status READY, has 4 handler(s) for this service...
  747. The command completed successfully


  750. R204001=0.1


  753. A: tcp        0      0 0.0.0.0:1521                0.0.0.0:*                   LISTEN      19215/tnslsnr      

  755. LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:05

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

  759. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1526)))
  760. STATUS of the LISTENER
  761. ------------------------
  762. Alias                     lsnr2
  763. Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
  764. Start Date                12-SEP-2015 12:10:31
  765. Uptime                    0 days 4 hr. 14 min. 34 sec
  766. Trace Level               off
  767. Security                  ON: Local OS Authentication
  768. SNMP                      OFF
  769. Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
  770. Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/lsnr2.log
  771. Listening Endpoints Summary...
  772.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1526)))
  773.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc1)))
  774. Services Summary...
  775. Service "PROD" has 1 instance(s).
  776.   Instance "PROD", status READY, has 4 handler(s) for this service...
  777. Service "PROD_XPT" has 1 instance(s).
  778.   Instance "PROD", status READY, has 4 handler(s) for this service...
  779. The command completed successfully


  782. R204002=0.1


  785. A: tcp        0      0 0.0.0.0:1526                0.0.0.0:*                   LISTEN      18597/tnslsnr      


  788. ******************** TOPIC 3 ********************


  791. ******************** TOPIC 3.1 ********************

  793. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:06 2015

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

  797. SQL> Connected.
  798. SQL> SQL>
  799. VALUE
  800. --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  801. 300

  803. 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
  804. With the Partitioning, OLAP and Data Mining options
  805. VALUE_A: 300


  808. R301001=0.1



  812. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:07 2015

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

  816. SQL> Connected.
  817. SQL> SQL>
  818. VALUE
  819. --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  820. 200

  822. 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
  823. With the Partitioning, OLAP and Data Mining options


  826. R301002=0.2




  831. ******************** TOPIC 3.2 ********************


  834. ******************** TOPIC 3.2.1 ********************

  836. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:07 2015

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

  840. SQL> Connected.
  841. SQL> SQL>
  842. VALUE
  843. --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  844. (protocol=tcp)(dispatchers=3)

  846. 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
  847. With the Partitioning, OLAP and Data Mining options
  848. VALUE_A: 3


  851. R302010=0.15




  856. ******************** TOPIC 3.2.2 ********************

  858. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:07 2015

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

  862. SQL> Connected.
  863. SQL> SQL>
  864. VALUE
  865. --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  866. 10

  868. 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
  869. With the Partitioning, OLAP and Data Mining options
  870. VALUE_A: 10


  873. R302020=0.1




  878. ******************** TOPIC 3.3 ********************


  881. ******************** TOPIC 3.3.1 ********************

  883. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:07 2015

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

  887. SQL> Connected.
  888. SQL> SQL>
  889. VALUE
  890. --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  891. 10

  893. 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
  894. With the Partitioning, OLAP and Data Mining options
  895. VALUE_A: 10


  898. R303010=0.15




  903. ******************** TOPIC 3.3.2 ********************

  905. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:08 2015

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

  909. SQL> Connected.
  910. SQL> SQL>
  911. VALUE
  912. --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  913. 30

  915. 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
  916. With the Partitioning, OLAP and Data Mining options
  917. VALUE_A: 30


  920. R303020=0.05



  924. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:08 2015

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

  928. SQL> Connected.
  929. SQL> SQL>
  930. VALUE
  931. --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  932. 30

  934. 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
  935. With the Partitioning, OLAP and Data Mining options
  936. VALUE_A: 30


  939. R303020=0.1




  944. ******************** TOPIC 4 ********************


  947. ******************** TOPIC 4.1 ********************

  949. TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:08

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

  953. Used parameter files:
  954. /u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

  956. Used EZCONNECT adapter to resolve the alias
  957. Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=PROD))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.37)(PORT=1521)))
  958. OK (0 msec)


  961. R401000=0.1




  966. ******************** TOPIC 4.2 ********************

  968. TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:08

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

  972. Used parameter files:
  973. /u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora


  976. Used TNSNAMES adapter to resolve the alias
  977. Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1521)) ( CONNECT_DATA=(SERVICE_NAME=PROD)))
  978. OK (0 msec)

  980. TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:08

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

  984. Used parameter files:
  985. /u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora


  988. Used TNSNAMES adapter to resolve the alias
  989. Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1521)) ( CONNECT_DATA=(SERVICE_NAME=PROD)))
  990. OK (0 msec)


  993. R402000=0.1


  996. A: Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1521)) ( CONNECT_DATA=(SERVICE_NAME=PROD)))


  999. ******************** TOPIC 4.3 ********************

  1001. TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:09

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

  1005. Used parameter files:
  1006. /u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora


  1009. Used TNSNAMES adapter to resolve the alias
  1010. Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1526)) ( CONNECT_DATA=(SERVICE_NAME=PROD) (server=shared)))
  1011. OK (10 msec)

  1013. TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:09

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

  1017. Used parameter files:
  1018. /u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora


  1021. Used TNSNAMES adapter to resolve the alias
  1022. Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1526)) ( CONNECT_DATA=(SERVICE_NAME=PROD) (server=shared)))
  1023. OK (10 msec)


  1026. R403000=0.1


  1029. A: Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1526)) ( CONNECT_DATA=(SERVICE_NAME=PROD) (server=shared)))


  1032. ******************** TOPIC 4.4 ********************

  1034. TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:09

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

  1038. Used parameter files:
  1039. /u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora


  1042. Used TNSNAMES adapter to resolve the alias
  1043. Attempting to contact (DESCRIPTION= (LOAD_BALANCE=on) (FAILOVER=on) (ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=rac1.example.com)(PORT=1521)) (ADDRESS=(PROTOCOL=tcp)(HOST=rac2.example.com)(PORT=1521))) ( CONNECT_DATA=(SERVICE_NAME=RACDB)))
  1044. OK (0 msec)

  1046. TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:09

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

  1050. Used parameter files:
  1051. /u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora


  1054. Used TNSNAMES adapter to resolve the alias
  1055. Attempting to contact (DESCRIPTION= (LOAD_BALANCE=on) (FAILOVER=on) (ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=rac1.example.com)(PORT=1521)) (ADDRESS=(PROTOCOL=tcp)(HOST=rac2.example.com)(PORT=1521))) ( CONNECT_DATA=(SERVICE_NAME=RACDB)))
  1056. OK (0 msec)


  1059. R404000=0.1


  1062. A: Attempting to contact (DESCRIPTION= (LOAD_BALANCE=on) (FAILOVER=on) (ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=rac1.example.com)(PORT=1521)) (ADDRESS=(PROTOCOL=tcp)(HOST=rac2.example.com)(PORT=1521))) ( CONNECT_DATA=(SERVICE_NAME=RACDB)))


  1065. ******************** TOPIC 4.5 ********************

  1067. TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:09

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

  1071. Used parameter files:
  1072. /u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora


  1075. Used TNSNAMES adapter to resolve the alias
  1076. Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=station38.example.com)(PORT=1521)) ( CONNECT_DATA=(SERVICE_NAME=EMREP)))
  1077. TNS-12541: TNS:no listener
  1078. 192.168.0.38
  1079. station38.example.com

  1081. TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:09

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

  1085. Used parameter files:
  1086. /u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora


  1089. Used TNSNAMES adapter to resolve the alias
  1090. Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=station38.example.com)(PORT=1521)) ( CONNECT_DATA=(SERVICE_NAME=EMREP)))
  1091. TNS-12541: TNS:no listener


  1094. R405000=0


  1097. A: 0

  1099. TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:09

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

  1103. Used parameter files:
  1104. /u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora


  1107. Used TNSNAMES adapter to resolve the alias
  1108. Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=station38.example.com)(PORT=1521)) ( CONNECT_DATA=(SERVICE_NAME=EMREP)))
  1109. TNS-12541: TNS:no listener


  1112. R405000=0.1


  1115. A: Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=station38.example.com)(PORT=1521)) ( CONNECT_DATA=(SERVICE_NAME=EMREP)))


  1118. ******************** TOPIC 4.6 ********************

  1120. TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:10

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

  1124. Used parameter files:
  1125. /u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora


  1128. Used TNSNAMES adapter to resolve the alias
  1129. Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=station38.example.com)(PORT=1521)) ( CONNECT_DATA=(SERVICE_NAME=EMREP) (FAILOVER_MODE= (TYPE=select) (METHOD=basic) (RETRIES=50) (DELAY=5))))
  1130. TNS-12541: TNS:no listener

  1132. TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:10

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

  1136. Used parameter files:
  1137. /u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora


  1140. Used TNSNAMES adapter to resolve the alias
  1141. Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=station38.example.com)(PORT=1521)) ( CONNECT_DATA=(SERVICE_NAME=EMREP) (FAILOVER_MODE= (TYPE=select) (METHOD=basic) (RETRIES=50) (DELAY=5))))
  1142. TNS-12541: TNS:no listener


  1145. R406000=0


  1148. A: 0

  1150. TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 12-SEP-2015 16:25:10

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

  1154. Used parameter files:
  1155. /u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora


  1158. Used TNSNAMES adapter to resolve the alias
  1159. Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=station38.example.com)(PORT=1521)) ( CONNECT_DATA=(SERVICE_NAME=EMREP) (FAILOVER_MODE= (TYPE=select) (METHOD=basic) (RETRIES=50) (DELAY=5))))
  1160. TNS-12541: TNS:no listener


  1163. R406000=0.4


  1166. A: Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=station38.example.com)(PORT=1521)) ( CONNECT_DATA=(SERVICE_NAME=EMREP) (FAILOVER_MODE= (TYPE=select) (METHOD=basic) (RETRIES=50) (DELAY=5))))


  1169. ******************** TOPIC 5 ********************


  1172. ******************** TOPIC 5.1 ********************


  1175. ******************** TOPIC 5.1.1 ********************

  1177. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:10 2015

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

  1181. SQL> Connected.
  1182. SQL> SQL>
  1183. GROUP_NAME                       TABLESPACE_NAME
  1184. ------------------------------ ------------------------------
  1185. TEMP_GRP                       TEMP1
  1186. TEMP_GRP                       TEMP2

  1188. 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
  1189. With the Partitioning, OLAP and Data Mining options


  1192. R501010=0.25


  1195. A: TEMP_GRP                       TEMP1

  1197. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:10 2015

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

  1201. SQL> Connected.
  1202. SQL> SQL>
  1203. GROUP_NAME                       TABLESPACE_NAME
  1204. ------------------------------ ------------------------------
  1205. TEMP_GRP                       TEMP1
  1206. TEMP_GRP                       TEMP2

  1208. 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
  1209. With the Partitioning, OLAP and Data Mining options


  1212. R501010=.50


  1215. B: TEMP_GRP                       TEMP2


  1218. ******************** TOPIC 5.1.2 ********************

  1220. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:11 2015

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

  1224. SQL> Connected.
  1225. SQL> SQL> SQL>
  1226. PROPERTY_NAME                       PROPERTY_VALUE
  1227. ------------------------------ ------------------------------------------------------------
  1228. DEFAULT_TEMP_TABLESPACE        TEMP_GRP

  1230. 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
  1231. With the Partitioning, OLAP and Data Mining options


  1234. R501020=0.4


  1237. A: DEFAULT_TEMP_TABLESPACE        TEMP_GRP


  1240. ******************** TOPIC 6 ********************


  1243. ******************** TOPIC 6.1 ********************

  1245. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:11 2015

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

  1249. SQL> Connected.
  1250. SQL> SQL>
  1251. TABLESPACE_NAME                     BYTES   MAXBYTES
  1252. ------------------------------ ---------- ----------
  1253. EXAMPLE                         419430400 4.3980E+12

  1255. 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
  1256. With the Partitioning, OLAP and Data Mining options


  1259. R601000=0.3


  1262. A: 0


  1265. ******************** TOPIC 6.2 ********************

  1267. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:11 2015

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

  1271. SQL> Connected.
  1272. SQL> SQL>
  1273. TABLESPACE_NAME                     BYTES   MAXBYTES
  1274. ------------------------------ ---------- ----------
  1275. EXAMPLE                         419430400 4.3980E+12

  1277. 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
  1278. With the Partitioning, OLAP and Data Mining options


  1281. R602001=0.3


  1284. A: EXAMPLE                         419430400 4.3980E+12

  1286. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:11 2015

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

  1290. SQL> Connected.
  1291. SQL> SQL>
  1292. TABLESPACE_NAME                     BYTES   MAXBYTES
  1293. ------------------------------ ---------- ----------
  1294. EXAMPLE                         419430400 4.3980E+12

  1296. 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
  1297. With the Partitioning, OLAP and Data Mining options


  1300. R602002=0.1


  1303. A: EXAMPLE                         419430400 4.3980E+12


  1306. ******************** TOPIC 6.3 ********************

  1308. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:11 2015

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

  1312. SQL> Connected.
  1313. SQL> SQL>
  1314. TABLESPACE_NAME                INITIAL_EXTENT ALLOCATIO BIG
  1315. ------------------------------ -------------- --------- ---
  1316. EXAMPLE                               1048576 UNIFORM        YES

  1318. 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
  1319. With the Partitioning, OLAP and Data Mining options


  1322. R603000=0.2


  1325. A: EXAMPLE                               1048576 UNIFORM        YES


  1328. ******************** TOPIC 6.4 ********************

  1330. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:12 2015

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

  1334. SQL> Connected.
  1335. SQL> SQL>
  1336. TABLESPACE_NAME                NEXT_EXTENT ALLOCATIO BIG
  1337. ------------------------------ ----------- --------- ---
  1338. EXAMPLE                            1048576 UNIFORM   YES

  1340. 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
  1341. With the Partitioning, OLAP and Data Mining options


  1344. R604000=0.2


  1347. A: EXAMPLE                            1048576 UNIFORM   YES


  1350. ******************** TOPIC 7 ********************


  1353. ******************** TOPIC 7.1 ********************


  1356. ******************** TOPIC 7.2 ********************

  1358. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:12 2015

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

  1362. SQL> Connected.
  1363. SQL> SQL>
  1364. TABLESPACE_NAME                     BYTES
  1365. ------------------------------ ----------
  1366. INDX                                 41943040

  1368. 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
  1369. With the Partitioning, OLAP and Data Mining options


  1372. R700000=0.05


  1375. A: 0

  1377. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:12 2015

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

  1381. SQL> Connected.
  1382. SQL> SQL>
  1383. TABLESPACE_NAME                     BYTES
  1384. ------------------------------ ----------
  1385. INDX                                 41943040

  1387. 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
  1388. With the Partitioning, OLAP and Data Mining options


  1391. R700000=.10


  1394. B: INDX                                 41943040


  1397. ******************** TOPIC 8 ********************


  1400. ******************** TOPIC 8.1 ********************


  1403. ******************** TOPIC 8.2 ********************

  1405. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:12 2015

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

  1409. SQL> Connected.
  1410. SQL> SQL>
  1411. TABLESPACE_NAME                     BYTES
  1412. ------------------------------ ----------
  1413. TOOLS                                 10485760

  1415. 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
  1416. With the Partitioning, OLAP and Data Mining options


  1419. R800000=0.05


  1422. A: 0

  1424. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:12 2015

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

  1428. SQL> Connected.
  1429. SQL> SQL>
  1430. TABLESPACE_NAME                     BYTES
  1431. ------------------------------ ----------
  1432. TOOLS                                 10485760

  1434. 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
  1435. With the Partitioning, OLAP and Data Mining options


  1438. R800000=.20


  1441. B: TOOLS                                 10485760


  1444. ******************** TOPIC 9 ********************

  1446. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:13 2015

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

  1450. SQL> Connected.
  1451. SQL> SQL> SQL>
  1452. PROPERTY_NAME                       PROPERTY_VALUE
  1453. ------------------------------ ------------------------------------------------------------
  1454. DEFAULT_PERMANENT_TABLESPACE   USERS

  1456. 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
  1457. With the Partitioning, OLAP and Data Mining options


  1460. R900000=0.05


  1463. A: 0

  1465. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:13 2015

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

  1469. SQL> Connected.
  1470. SQL> SQL> SQL>
  1471. PROPERTY_NAME                       PROPERTY_VALUE
  1472. ------------------------------ ------------------------------------------------------------
  1473. DEFAULT_PERMANENT_TABLESPACE   USERS

  1475. 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
  1476. With the Partitioning, OLAP and Data Mining options


  1479. R900000=.30


  1482. B: DEFAULT_PERMANENT_TABLESPACE   USERS


  1485. ******************** TOPIC 9.1 ********************

  1487. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:13 2015

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

  1491. SQL> Connected.
  1492. SQL> SQL>
  1493. TABLESPACE_NAME                     BYTES
  1494. ------------------------------ ----------
  1495. USERS                                 50331648

  1497. 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
  1498. With the Partitioning, OLAP and Data Mining options


  1501. R901000=0.1


  1504. A: 0


  1507. ******************** TOPIC 9.2 ********************

  1509. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:13 2015

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

  1513. SQL> Connected.
  1514. SQL> SQL>
  1515. TABLESPACE_NAME                     BYTES
  1516. ------------------------------ ----------
  1517. USERS                                 50331648

  1519. 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
  1520. With the Partitioning, OLAP and Data Mining options


  1523. R902000=0.1


  1526. A: USERS                                 50331648


  1529. ******************** TOPIC 9.3 ********************

  1531. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:14 2015

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

  1535. SQL> Connected.
  1536. SQL> SQL>
  1537. TABLESPACE_NAME                INITIAL_EXTENT ALLOCATIO BIG
  1538. ------------------------------ -------------- --------- ---
  1539. USERS                                      4194304 UNIFORM        NO

  1541. 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
  1542. With the Partitioning, OLAP and Data Mining options


  1545. R903000=0.2


  1548. A: USERS                                      4194304 UNIFORM        NO


  1551. ******************** TOPIC 9.4 ********************

  1553. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:14 2015

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

  1557. SQL> Connected.
  1558. SQL> SQL>
  1559. TABLESPACE_NAME                NEXT_EXTENT ALLOCATIO BIG
  1560. ------------------------------ ----------- --------- ---
  1561. USERS                                   4194304 UNIFORM   NO

  1563. 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
  1564. With the Partitioning, OLAP and Data Mining options


  1567. R904000=0.2


  1570. A: USERS                                   4194304 UNIFORM   NO


  1573. ******************** TOPIC 10 ********************


  1576. ******************** TOPIC 10.1 ********************

  1578. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:14 2015

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

  1582. SQL> Connected.
  1583. SQL> SQL>
  1584. TABLESPACE_NAME                     BYTES
  1585. ------------------------------ ----------
  1586. OLTP                                 50331648

  1588. 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
  1589. With the Partitioning, OLAP and Data Mining options


  1592. R1001000=0.1


  1595. A: 0


  1598. ******************** TOPIC 10.2 ********************

  1600. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:14 2015

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

  1604. SQL> Connected.
  1605. SQL> SQL>
  1606. TABLESPACE_NAME                     BYTES
  1607. ------------------------------ ----------
  1608. OLTP                                 50331648

  1610. 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
  1611. With the Partitioning, OLAP and Data Mining options


  1614. R1002000=0.05


  1617. A: 0

  1619. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:14 2015

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

  1623. SQL> Connected.
  1624. SQL> SQL>
  1625. TABLESPACE_NAME                     BYTES
  1626. ------------------------------ ----------
  1627. OLTP                                 50331648

  1629. 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
  1630. With the Partitioning, OLAP and Data Mining options


  1633. R1002000=.10


  1636. B: OLTP                                 50331648


  1639. ******************** TOPIC 10.3 ********************

  1641. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:15 2015

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

  1645. SQL> Connected.
  1646. SQL> SQL>
  1647. TABLESPACE_NAME                INITIAL_EXTENT ALLOCATIO BIG
  1648. ------------------------------ -------------- --------- ---
  1649. OLTP                                      2097152 UNIFORM        NO

  1651. 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
  1652. With the Partitioning, OLAP and Data Mining options


  1655. R1003000=0.05


  1658. A: 0

  1660. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:15 2015

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

  1664. SQL> Connected.
  1665. SQL> SQL>
  1666. TABLESPACE_NAME                INITIAL_EXTENT ALLOCATIO BIG
  1667. ------------------------------ -------------- --------- ---
  1668. OLTP                                      2097152 UNIFORM        NO

  1670. 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
  1671. With the Partitioning, OLAP and Data Mining options


  1674. R1003000=.15


  1677. B: OLTP                                      2097152 UNIFORM        NO


  1680. ******************** TOPIC 10.4 ********************

  1682. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:15 2015

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

  1686. SQL> Connected.
  1687. SQL> SQL>
  1688. TABLESPACE_NAME                NEXT_EXTENT ALLOCATIO BIG
  1689. ------------------------------ ----------- --------- ---
  1690. OLTP                                   2097152 UNIFORM   NO

  1692. 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
  1693. With the Partitioning, OLAP and Data Mining options


  1696. R1004001=0.05


  1699. A: 0

  1701. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:15 2015

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

  1705. SQL> Connected.
  1706. SQL> SQL>
  1707. TABLESPACE_NAME                NEXT_EXTENT ALLOCATIO BIG
  1708. ------------------------------ ----------- --------- ---
  1709. OLTP                                   2097152 UNIFORM   NO

  1711. 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
  1712. With the Partitioning, OLAP and Data Mining options


  1715. R1004001=.15


  1718. B: OLTP                                   2097152 UNIFORM   NO

  1720. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:16 2015

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

  1724. SQL> Connected.
  1725. SQL> SQL>
  1726. SEGMEN
  1727. ------
  1728. AUTO

  1730. 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
  1731. With the Partitioning, OLAP and Data Mining options


  1734. R1004002=0.05


  1737. A: 0

  1739. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:16 2015

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

  1743. SQL> Connected.
  1744. SQL> SQL>
  1745. SEGMEN
  1746. ------
  1747. AUTO

  1749. 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
  1750. With the Partitioning, OLAP and Data Mining options


  1753. R1004002=.10


  1756. B: AUTO


  1759. ******************** TOPIC 11 ********************


  1762. ******************** TOPIC 11.1 ********************


  1765. ******************** TOPIC 11.2 ********************

  1767. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:16 2015

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

  1771. SQL> Connected.
  1772. SQL> SQL> SQL>
  1773.     GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS            FIRST_CHANGE# FIRST_TIM
  1774. ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
  1775.          1            1               4  104857600             2 YES INACTIVE                   126289 12-SEP-15
  1776.          2            1               5  104857600             2 YES INACTIVE                   158620 12-SEP-15
  1777.          3            1               8  104857600             2 NO  CURRENT                   210363 12-SEP-15
  1778.          4            1               6  104857600             2 YES INACTIVE                   207525 12-SEP-15
  1779.          5            1               7  104857600             2 YES INACTIVE                   210351 12-SEP-15

  1781. SQL>
  1782.   COUNT(*)
  1783. ----------
  1784.          5

  1786. 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
  1787. With the Partitioning, OLAP and Data Mining options
  1788. VALUE_A:          5


  1791. R1102000=0.5




  1796. ******************** TOPIC 11.3 ********************
  1797. 2
  1798. 2
  1799. 2
  1800. 2
  1801. 2
  1802. R1103000=1.00


  1805. ******************** TOPIC 11.4 ********************
  1806. 5
  1807. 0
  1808. R1104000=.50


  1811. ******************** TOPIC 11.5 ********************
  1812.       2 Disk1
  1813.       2 Disk2
  1814.       2 Disk3
  1815.       2 Disk4
  1816.       2 Disk5

  1818. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:18 2015

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

  1822. SQL> Connected.
  1823. SQL> SQL>
  1824.      BYTES
  1825. ----------
  1826. 104857600
  1827. 104857600
  1828. 104857600
  1829. 104857600
  1830. 104857600

  1832. 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
  1833. With the Partitioning, OLAP and Data Mining options
  1834. VALUE_A: 2


  1837. R1105000=0.5




  1842. ******************** TOPIC 12 ********************

  1844. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:18 2015

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

  1848. SQL> Connected.
  1849. SQL> SQL> SQL>
  1850. PL/SQL procedure successfully completed.

  1852. SQL> ******************************

  1854. PL/SQL procedure successfully completed.

  1856. SQL> The database controlfile here:

  1858. PL/SQL procedure successfully completed.

  1860. SQL> ******************************

  1862. PL/SQL procedure successfully completed.

  1864. SQL>
  1865. PL/SQL procedure successfully completed.

  1867. SQL> SQL>
  1868. NAME
  1869. -----------------------------------------------------------------
  1870. /u01/app/oracle/oradata/PROD/Disk1/control01.ctl
  1871. /u01/app/oracle/oradata/PROD/Disk2/control02.ctl
  1872. /u01/app/oracle/product/10.2.0/db_1/dbs/and
  1873. /u01/app/oracle/oradata/PROD/Disk3/control03.ctl

  1875. 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
  1876. With the Partitioning, OLAP and Data Mining options
  1877. VALUE_A: 3


  1880. R1200000=0.5




  1885. ******************** TOPIC 13 ********************

  1887. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:18 2015

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

  1891. SQL> Connected.
  1892. SQL> SQL> SQL>
  1893.   COUNT(*)
  1894. ----------
  1895.          3

  1897. 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
  1898. With the Partitioning, OLAP and Data Mining options
  1899. VALUE_A:          3


  1902. R1300000=0.1




  1907. ******************** TOPIC 14 ********************


  1910. ******************** TOPIC 14.1 ********************

  1912. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:19 2015

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

  1916. SQL> Connected.
  1917. SQL> SQL> SQL>
  1918. ANALYZEDT
  1919. ----------
  1920. .010046296

  1922. 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
  1923. With the Partitioning, OLAP and Data Mining options
  1924. VALUE_A: 0


  1927. R1400010=0.5



  1931. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:19 2015

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

  1935. SQL> Connected.
  1936. SQL> SQL> SQL>
  1937. ANALYZEDT
  1938. ----------
  1939. .010046296

  1941. 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
  1942. With the Partitioning, OLAP and Data Mining options


  1945. R1400010=0.5


  1948. A: 010046296


  1951. ******************** TOPIC 14.2 ********************

  1953. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:19 2015

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

  1957. SQL> Connected.
  1958. SQL> SQL>
  1959. VALUE
  1960. --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


  1963. 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
  1964. With the Partitioning, OLAP and Data Mining options


  1967. R1402001=0.4


  1970. A: 0

  1972. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:19 2015

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

  1976. SQL> Connected.
  1977. SQL> SQL>
  1978. VALUE
  1979. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  1980. /home/oracle
  1981. /home/oracle/temp
  1982. /home/oracle/scripts

  1984. 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
  1985. With the Partitioning, OLAP and Data Mining options


  1988. R1402002=0.2


  1991. A: /home/oracle

  1993. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:19 2015

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

  1997. SQL> Connected.
  1998. SQL> SQL>
  1999. VALUE
  2000. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  2001. /home/oracle
  2002. /home/oracle/temp
  2003. /home/oracle/scripts

  2005. 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
  2006. With the Partitioning, OLAP and Data Mining options


  2009. R1402002=.3


  2012. B: /home/oracle/temp

  2014. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:19 2015

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

  2018. SQL> Connected.
  2019. SQL> SQL>
  2020. VALUE
  2021. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  2022. /home/oracle
  2023. /home/oracle/temp
  2024. /home/oracle/scripts

  2026. 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
  2027. With the Partitioning, OLAP and Data Mining options


  2030. R1402002=.4


  2033. C: /home/oracle/scripts


  2036. ******************** TOPIC 15 ********************

  2038. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 16:25:20 2015

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

  2042. SQL> Connected.
  2043. SQL> SQL>
  2044. LOG_MODE
  2045. ------------
  2046. ARCHIVELOG

  2048. 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
  2049. With the Partitioning, OLAP and Data Mining options


  2052. R1500000=0.25


  2055. A: ARCHIVELOG

  2057. ****************************************************************************************************


  2060. R1001000: 0.1 full is 0.1 0.1
  2061. R1002000: .10 full is 0.1 0.2
  2062. R1003000: .15 full is 0.15 0.35
  2063. R1004001: .15 full is 0.15 0.5
  2064. R1004002: .10 full is 0.1 0.6
  2065. R101011: 0.15 full is 0.15 0.75
  2066. R101012: 0.4 full is 0.4 1.15
  2067. R101021: 0.3 full is 0.3 1.45
  2068. R101022: 0.15 full is 0.15 1.6
  2069. R1102000: 0.5 full is 0.5 2.1
  2070. R1103000: 1.00 full is 1.00 3.1
  2071. R1104000: .50 full is .50 3.6
  2072. R1105000: 0.5 full is 0.5 4.1
  2073. R1200000: 0.5 full is 0.5 4.6
  2074. R1300000: 0.1 full is 0.1 4.7
  2075. R1400010: 0.5 full is 0.5 5.2
  2076. R1402001: 0.4 full is 0.4 5.6
  2077. R1402002: .4 full is 0.4 6.0
  2078. R1500000: 0.25 full is 0.25 6.25
  2079. R201010: .10 full is 0.1 6.35
  2080. R201020: .10 full is 0.1 6.45
  2081. R201030: .33 full is 0.33 6.78
  2082. R201040: .24 full is 0.24 7.02
  2083. R201051: .23 full is 0.23 7.25
  2084. R201052: 0.1 full is 0.1 7.35
  2085. R202001: .10 full is 0.1 7.45
  2086. R202002: .30 full is 0.3 7.75
  2087. R203000: .15 full is 0.15 7.9
  2088. R204001: 0.1 full is 0.1 8.0
  2089. R204002: 0.1 full is 0.1 8.1
  2090. R301001: 0.1 full is 0.1 8.2
  2091. R301002: 0.2 full is 0.2 8.4
  2092. R302010: 0.15 full is 0.15 8.55
  2093. R302020: 0.1 full is 0.1 8.65
  2094. R303010: 0.15 full is 0.15 8.8
  2095. R303020: 0.1 full is 0.1 8.9
  2096. R401000: 0.1 full is 0.1 9.0
  2097. R402000: 0.1 full is 0.1 9.1
  2098. R403000: 0.1 full is 0.1 9.2
  2099. R404000: 0.1 full is 0.1 9.3
  2100. R405000: 0.1 full is 0.1 9.4
  2101. R406000: 0.4 full is 0.4 9.8
  2102. R501010: .50 full is 0.5 10.3
  2103. R501020: 0.4 full is 0.4 10.7
  2104. R601000: 0.3 full is 0.3 11.0
  2105. R602001: 0.3 full is 0.3 11.3
  2106. R602002: 0.1 full is 0.1 11.4
  2107. R603000: 0.2 full is 0.2 11.6
  2108. R604000: 0.2 full is 0.2 11.8
  2109. R700000: .10 full is 0.1 11.9
  2110. R800000: .20 full is 0.2 12.1
  2111. R900000: .30 full is 0.3 12.4
  2112. R901000: 0.1 full is 0.1 12.5
  2113. R902000: 0.1 full is 0.1 12.6
  2114. R903000: 0.2 full is 0.2 12.8
  2115. R904000: 0.2 full is 0.2 13.0
  2116. full of this section:
  2117. RESULT:
  2118. 13.00


  2121. ****************************************************************************************************
复制代码



Section1.zip

26.89 KB, 下载次数: 52
回复

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-12-5 03:19 , Processed in 0.048286 second(s), 27 queries .

快速回复 返回顶部 返回列表