Oracle tip #8 [Enable apex not only for localhost]
After installing Oracle 10g on an Ubuntu 9.04 system, i found that the Apex application was enabled only for the localhost.
Some time is necessary open or close the access of apex from remote. To do this is only need to access to your oracle system by a dba user and run this sql command:
to allow remote access:
1 |
EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE); |
to close remote access :
1 |
EXEC DBMS_XDB.SETLISTENERLOCALACCESS(TRUE); |
that’s all
regards
ivan