Databases Reference
In-Depth Information
First, we need to enable the web server component, since it is disabled by default. You can check the
current status of the web server component by running the following query:
system@ae1> select dbms xdb.gethttpport from dual;
GETHTTPPORT
-----------
0
If the returned value is 0 then it means the web server component is not configured yet. You can set
the port that you want it to run on, in a similar way to the
Listen
directive in the
httpd.conf
file you saw
earlier, by running the following command:
system@ae1> call dbms xdb.setHttpPort(8080);
Call completed.
system@ae1> alter system register;
System altered.
Here we have used port 8080 and then registered with the listener (the standard Oracle listener, not
to be confused with the APEX listener, which we cover in the next section).
We can now check that the EPG is running on the port by reissuing the command we ran earlier:
system@ae1> select dbms xdb.gethttpport from dual;
GETHTTPPORT
-----------
8080
We can also check the status of the listener:
[oracle@ae1 ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-JAN-2011 09:02:33
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 17-JAN-2011 13:32:45
Uptime 0 days 19 hr. 29 min. 48 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u1/app/oracle/product/11.2.0/dbhome 1/network/admin/listener.ora
Listener Log File /u1/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
