enable remote access to Oracle10g XE

by default remote access is not enabled for XE version. So we can only access db in our localhost. To enable remote access, connect as 'sysdba' or 'system' and enter command below:

EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);

reference: http://www.randomsupport.com/rs/blogs/index.php?title=oracle-10g-express-web-interface-remote-&more=1&c=1&tb=1&pb=1

0 comments:

Post a Comment