Sunday, January 8, 2017

DB Web Services Port Open [8080] in Oracle 11g Release 2

Configure HTTP Access





Step: 1
lsnrctl status


Step: 2
sqlplus connection 
sqlplus / as sysdba

Step: 3
Check http port status 
SQL> SELECT dbms_xdb.gethttpport FROM dual;

Step: 4
update port as 8080. you can change port as your required.
SQL> EXEC dbms_xdb.sethttpport(8080);

Wait for success return message 
PL/SQL procedure successfully completed.


Step: 5
Check http port status after config
SQL> SELECT dbms_xdb.gethttpport FROM dual;

Step: 6
disconnect sql connection
SQL> exit;

Step: 7
check again your system 
lsnrctl status

No comments:

Post a Comment