Amazon books

Wednesday, March 2, 2011

Change hostname | IP address of an APEX Server

If you need to change IP address or | and hostname of server that hosts Oracle Application Express just run the command below after changing IP and hostname:

begin

dbms_xdb.setlistenerendpoint(
endpoint => dbms_xdb.XDB_ENDPOINT_HTTP
, host => '10.10.10.18'
, port => 8080
, protocol => dbms_xdb.XDB_PROTOCOL_TCP);
end;
/


After that, access your Apex site like http://10.10.10.18:8080/apex/apex_admin

Best Regards,
Paulo Portugal

1 comment:

  1. What is the alternative for dbms_xdb.setlistenerendpoint in database standard edition? Because i could not find the proc setlistenerendpoint in SE but ican able to find in XE and EE. Thanks in avance

    ReplyDelete