>sqlplus / as sysdba

SQL*Plus: Release  10 . 2 . 0 . 1 . 0  - Production on Tue Oct  28   15 : 28 : 16   2008 

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


Connected to:
Oracle Database 10g Enterprise Edition Release  10 . 2 . 0 . 1 . 0  - Production
With the Partitioning, OLAP and Data Mining options

SQL> SHOW PARAMETER SHARED_POOL_SIZE

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
shared_pool_size                     big integer 100M

SQL> COLUMN comp_name FORMAT A30
SQL> select comp_name, status, version from dba_registry
   2   where comp_name='Oracle Text';

COMP_NAME                      STATUS      VERSION
------------------------------ ----------- ------------------------------
Oracle Text                    VALID        10 . 2 . 0 . 1 . 0 

SQL> select comp_name, status, version from dba_registry
   2   where comp_name='Oracle XML Database';

COMP_NAME                      STATUS      VERSION
------------------------------ ----------- ------------------------------
Oracle XML Database            VALID        10 . 2 . 0 . 1 . 0 

SQL> select owa_util.get_version from dual;

GET_VERSION
---------------------------------------------------------------------------

 10 . 1 . 2 . 0 . 6 

SQL> select username, account_status
   2   from dba_users
   3   where username in ('FLOWS_FILES', 'FLOWS_030100', 'APEX_PUBLIC_USER', 'ANONYMOUS');

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
FLOWS_FILES                    OPEN
FLOWS_030100                   OPEN
APEX_PUBLIC_USER               OPEN
ANONYMOUS                      OPEN

SQL> SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

GETHTTPPORT
-----------
        8080 

>lsnrctl status

LSNRCTL for  32 -bit Windows: Version  10 . 2 . 0 . 1 . 0  - Production on  28 -OCT- 2008   15 : 45 : 27 

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for  32 -bit Windows: Version  10 . 2 . 0 . 1 . 0  - Production
Start Date                 28 -OCT- 2008   14 : 47 : 40 
Uptime                     0  days  0  hr.  57  min.  47  sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   \db_1\network\admin\listener.ora
Listener Log File            \db_1\network\log\listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DrFloyd)(PORT= 1521 )))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DrFloyd)(PORT= 8080 ))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has  1  instance(s).
  Instance "PLSExtProc", status UNKNOWN, has  1  handler(s) for this service...
Service "orcl" has  1  instance(s).
  Instance "orcl", status READY, has  1  handler(s) for this service...
Service "orclXDB" has  1  instance(s).
  Instance "orcl", status READY, has  1  handler(s) for this service...
Service "orcl_XPT" has  1  instance(s).
  Instance "orcl", status READY, has  1  handler(s) for this service...
The command completed successfully

SQL> SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

GETHTTPPORT
-----------
        8080 

SQL> select comp_name, status, version from dba_registry
   2   where comp_name='Oracle XML Database';

COMP_NAME                      STATUS      VERSION
------------------------------ ----------- ------------------------------
Oracle XML Database            VALID        10 . 2 . 0 . 1 . 0