XDB:How to change XDB in XE to enable remote listener.

To enable XDB to listen on remote listener, use following:

exec DBMS_XDB.setListenerEndPoint('1','hostname','8080','1');

 

To enable XDB to listen on local listener only, use following:

exec DBMS_XDB.setListenerEndPoint('1','localhost','8080','1');

 

 

To set FTP port , use following:

exec DBMS_XDB.SETFTPPORT(21);

 

To set HTTP port , use following:

exec DBMS_XDB.SETHTTPPORT(8080);

 

To disable , just pass 0 as port.

 

Then run following to refresh

exec dbms_xdb.cfg_refresh

 

use following to get config.

select dbms_xdb.cfg_get from dual;