Tuesday 11 June 2013

how to change oracle xe 11g port step by step

run> cmd type
SQL*Plus: Release - Production on Mi Jan 25 11:44:33 2006 Copyright (c) 1982, 2004, Oracle. All rights reserved.
 Enter username:system
 Enter password:(it will not appear)
 Connected to: Oracle Database 10g Express Edition Release - Beta

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

 then go here 

 follow this step 

 don't follow above step in that website follow after--------------> test the application!
We're hoping that the installation has gone well and nothing is wrong--not anymore. But to make sure, let's test the database application. So, please head to Start and locate the Oracle XE folder.

 just change

1 comment:

  1. This comment has been removed by a blog administrator.