Tuesday, June 9, 2009

Oracle XE change http port and enable remote access to web console

To change the http port use the following command in sqlplus

call dbms_xdb.cfg_update( updateXML(dbms_xdb.cfg_get(), '/xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text()', 8090))

or

EXEC DBMS_XDB.SETHTTPPORT(8090);

To enable remote access use the following command in sqlplus

EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);

No comments:

Post a Comment

Subscribe