Tuesday 11 June 2013

how to change oracle xe 11g port step by step

run> cmd type
C:\WINDOWS\system32>sqlplus
SQL*Plus: Release 10.1.0.2.0 - 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 10.2.0.1.0 - 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 http://127.0.0.1:88/apex/f?p=4950

1 comment:

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

    ReplyDelete