Thursday, April 23, 2009

Oracle XE change HTTP and FTP Port

Login on SQL*Plus with the system user:


SQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 23 11:40:05 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn system/[PASSWORD]
Connected.
SQL> select dbms_xdb.gethttpport as "HTTP-Port"
, dbms_xdb.getftpport as "FTP-Port" from dual;

HTTP-Port FTP-Port
---------- ----------
8080 0

SQL> begin
2 dbms_xdb.sethttpport('8585');
3 end;
4 /

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
---------- ----------
8585 0


Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

No comments:

Post a Comment

comment