Section0评分系统输出

admin

192.168.0.3

1. Section0
   
2. --------------------------------------------TOPIC 0--------------------------------------------
   
3. # .bash_profile
   
4. 
   
5. # Get the aliases and functions
   
6. if [ -f ~/.bashrc ]; then
   
7.         . ~/.bashrc
   
8. fi
   
9. 
   
10. # User specific environment and startup programs
    
11. 
    
12. PATH=$PATH:$HOME/bin
    
13. 
    
14. export PATH
    
15. export ORACLE_BASE=/u01/app/oracle
    
16. export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
    
17. export ORACLE_SID=PROD
    
18. export PATH=$ORACLE_HOME/bin:$PATH
    
19. export LANG=en_US
    
20. --------------------------------------------TOPIC 1 2 3 4--------------------------------------------
    
21. 
    
22. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jul 5 20:12:35 2014
    
23. 
    
24. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
    
25. 
    
26. SQL> Connected.
    
27. SQL>
    
28. NAME                                     TYPE         VALUE
    
29. ------------------------------------ ----------- ------------------------------
    
30. db_name                              string         PROD
    
31. SQL>
    
32. NAME                                     TYPE         VALUE
    
33. ------------------------------------ ----------- ------------------------------
    
34. instance_name                             string         PROD
    
35. SQL> SQL> SQL> SQL> SQL> SQL> ****************************
    
36. SQL> The database open mode here:
    
37. SQL> ****************************
    
38. SQL> SQL>
    
39. D
    
40. -
    
41. X
    
42. SQL>
    
43. OPEN_MODE
    
44. ----------
    
45. READ WRITE
    
46. SQL> SQL> SQL> **********************************
    
47. SQL> The database archivelog mode here:
    
48. SQL> **********************************
    
49. SQL> SQL> Database log mode               No Archive Mode
    
50. Automatic archival               Disabled
    
51. Archive destination               USE_DB_RECOVERY_FILE_DEST
    
52. Oldest online log sequence     2
    
53. Current log sequence               4
    
54. SQL> SQL> SQL> ***************************
    
55. SQL> The database datafile here:
    
56. SQL> ***************************
    
57. SQL> SQL> SQL> SQL>
    
58. TABLESPACE_NAME                STATUS
    
59. ------------------------------ ---------------
    
60. SYSTEM                               ONLINE
    
61. UNDOTBS1                       ONLINE
    
62. SYSAUX                               ONLINE
    
63. TEMP01                               ONLINE
    
64. SQL>
    
65. NAME                                                                  STATUS
    
66. ----------------------------------------------------------------- ---------------
    
67. /u01/app/oracle/oradata/PROD/system01.dbf                          SYSTEM
    
68. /u01/app/oracle/oradata/PROD/Disk3/undotbs01.dbf                  ONLINE
    
69. /u01/app/oracle/oradata/PROD/Disk2/sysaux01.dbf                   ONLINE
    
70. SQL> SQL> SQL> ******************************
    
71. SQL> The database controlfile here:
    
72. SQL> ******************************
    
73. SQL> SQL> SQL>
    
74. NAME
    
75. -----------------------------------------------------------------
    
76. /u01/app/oracle/oradata/PROD/Disk1/control01.dbf
    
77. /u01/app/oracle/oradata/PROD/Disk2/control02.dbf
    
78. /u01/app/oracle/oradata/PROD/Disk3/control03.dbf
    
79. SQL> SQL> SQL> **************************
    
80. SQL> The database logfile here:
    
81. SQL> **************************
    
82. SQL> SQL> SQL>
    
83. MEMBER
    
84. --------------------------------------------------------------------------------
    
85. /u01/app/oracle/oradata/PROD/Disk1/redo01.log
    
86. /u01/app/oracle/oradata/PROD/Disk2/redo02.log
    
87. /u01/app/oracle/oradata/PROD/Disk3/redo03.log
    
88. SQL> SQL> SQL>
    
89. FILE_NAME             TABLESPACE_NAME          AUT
    
90. -------------------- -------------------- ---
    
91. /u01/app/oracle/orad SYSTEM                  YES
    
92. /u01/app/oracle/orad UNDOTBS1                  YES
    
93. /u01/app/oracle/orad SYSAUX                  YES
    
94. SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
    
95. With the Partitioning, OLAP and Data Mining options

复制代码