SQL> -- get current status SQL> select dbms_xdb.gethttpport as "HTTP-Port", dbms_xdb.getftpport as "FTP-Port" from dual;
HTTP-Port FTP-Port ---------- ---------- 8080 0
You can change the http port and the ftp port to whatever you like (keep in mind that you need special privileges for ports < 1024 on Unix/Linux systems).
SQL> -- set http port and ftp port SQL> begin 2 dbms_xdb.sethttpport('80'); 3 dbms_xdb.setftpport('2100'); 4 end; 5 /
PL/SQL procedure successfully completed.
SQL> select dbms_xdb.gethttpport as "HTTP-Port", dbms_xdb.getftpport as "FTP-Port" from dual;
HTTP-Port FTP-Port ---------- ---------- 80 2100
If you only want to use the database without allowing access via http or ftp then you can disable both:
SQL> -- disable http and ftp access SQL> begin 2 dbms_xdb.sethttpport('0'); 3 dbms_xdb.setftpport('0'); 4 end; 5 /
PL/SQL procedure successfully completed.
SQL> -- get current status SQL> select dbms_xdb.gethttpport as "HTTP-Port", dbms_xdb.getftpport as "FTP-Port" from dual;