Making Oracle Database XE Server Available to Remote Clients

After you install Oracle Database XE Server, its graphical user interface is only available from the local server, not remotely.

Security Note:

With remote HTTP access to Oracle Database XE, all information exchanged between the browser and the database is in clear text—that is, unencrypted—including database user names and passwords. If this is cause for concern, do not enable remote HTTP connection to the database.

If you want to use a Web browser, follow these steps:

1. Start Oracle Database XE.
   Click the Application menu (on Gnome) or the K menu (on KDE), then point to Oracle Database 10g Express Edition, and then Go To Database Home Page.
2. In the Database Login page, log in as SYSTEM, enter the password, and then click Login.
3. In the Oracle Database XE home page, click Administration.
4. Under Tasks, click Manage HTTP Access.
5. Under Manage HTTP Access, select Available from local server and remove clients.
6. Click Apply Changes.

If you prefer to use the SQL Command Line, follow these steps:

1. Start SQL*Plus and log in as SYSTEM:

   $ sqlplus system
   Enter password: SYSTEM_password
   

   Or, if you are logging in remotely:

   $ sqlplus system@xe_server_host_name
   Enter password: SYSTEM_password
   

2. At the SQL prompt, enter the following command:

   SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);