Hi Oracle Experts,
I have installed OracleXE 10g on a server for an application and has been running for 3 years. The installation is based on default configuration where:
Destination Folder: C:\oraclexe\
Port for Oracle Database Listener: 1521
Port for Oracle Services for Microsoft Transaction Server: 2030
Port for HTTP Listener: 8080
The installation work well and able to view the database homepage. The problem arises when local ICT urge to change the Oracle Database Listener port to another port instead of 1521 in order to comply with their security policy.
I have changed the port using below method:
1) Update the port number in listener.ora to desired port
2) Ensure that SID_name(XE) is registered in listener.ora by adding this line to SID_LIST
(SID_NAME = XE)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
3) Reload the listener and restart the service.
I am able to connect to the database using SQL Plus using port the assigned port but when I tried to view the database homepage, I cannot load the page with Internet Explorer connection problem error.
I have changed the default HTTP port to 8089 but still unable to connect. But when I switched to the default listener port(1521), I am able to view the database homepage.
Does anyone know how to solve this issue?
Thank you in advance.
I missed out the part of altering the local listener on the oracle database listener. But for the HTTP port number change before this it did not write to listener.ora for the line of
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST=MDLSERVER)(PORT=8090)(PRESENTATION=HTTP)(Session=RAW))
but now it did write even I have used the same command before. I am able to view the webpage now but I cannot change the default port at the URL of the homepage. How to do this?
I am able to view the webpage now but I cannot change the default port at the URL of the homepage.
That is, you can access the Homepage if you type the URL directly on the browser, but the URL from the Windows menu still has the old port ?
If so, just change the properties in C:\oraclexe\app\oracle\product\10.2.0\server\Database_homepage.url
I can access the URL when I typed directly from the browser. Now I am trying to change the Database_homepage.url but got the error of "Cannot apply changes to this Internet Shortcut."
Of course I don't have that problem. Looks like you don't have adequate permissions on that file, or it's read-only.
P.S. Couldn't you add the working URL to favorites ?