KfWiki : OracleExpress

HomePage :: Categories :: PageIndex :: RecentChanges :: RecentlyCommented :: Login/Register
HomePage » Database » Oracle » OracleExpress


Changing oracle http port

SQL> select dbms_xdb.gethttpport as "HTTP-Port", dbms_xdb.getftpport as "FTP-Port" from dual;

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


To change it
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


To disable it
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;

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

There are no comments on this page. [Add comment]

Valid XHTML 1.0 Transitional :: Valid CSS :: Powered by WikkaWiki
Page was generated in 0.1878 seconds