Showing posts with label oracle xe 11g port. Show all posts
Showing posts with label oracle xe 11g port. Show all posts

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