Wednesday, November 17, 2010

Enabling remote acess for Oracle XE in console

Just installed Oracle XE on Ubuntu 10.10 server but found out that remote user cannot manage the database using Web. Most of the guide out there are suggesting to use the web to allow remote access, but since Ubuntu servers by default does not have any GUI install, we can just forget about web.

Here's the command in sqlplus:

EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);

Then try to access using web from remote again.