Wednesday, July 23, 2008

OBIEE running it on an other web port

On a default installation OBIEE runs on web port 9704. This means that the user will have the put the portnumber in the webadress. (http://myhostname:9704/analytics/saw.dll?Dashboard). If you want to run the websdervice on different portnumber or even better from the default port 80, this is what you have to do.

Step 1: Navigate to your OC4J config directory, ussally found in ..:\OracleBI\oc4j_bi\j2ee\home\config

Step 2: Add a new directory called: "backup_orignal". Copy the whole content of the config directory to the new directory. (better save then sorry......)

Step 3: Open the file named default-web-site.xml in a (XML) editor.

Step 4: between the {web-site} find the port= tag, change it to port = "80". Save the file.
Step 5: Add a new directory called: "backup_change_YYYYMMDDNNN" (fi:backup_change_20080723001. Copy the whole content of the config directory to the new directory. (Why?, if you not carefull during an upgrade you loose all your OC4J settings......)

Step 6: Stop and start your OC4J.

You can now run your OBIEE website from the new portnumber.

Of course you also have to alter the port number in the OBIEE config files:
...\OracleBI\oc4j_bi\j2ee\home\applications\bioffice\bioffice\WEB-INF\bioffice.xml
...\OracleBI\xmlp\XMLP\Admin\Configuration\xmlp-server-config.xml
...\OracleBIData\web\config\instanceconfig.xml

Till Next Time
This article is also published on: http://knowledge.ciber.nl/weblog/

10 comments:

Tim said...

Hello,
Thanks for creating this post. I have tried changing my port setting on in the default-web-site.xml file to 80 but continue to get the error below. Do you have any ideas? I have tried different ports and the only one I can get to work is the standard 9704.


Starting OC4J from /export/home/oracle/OBIEE/oc4j_bi/j2ee/home ...
2009-04-22 11:14:56.497 NOTIFICATION SAROOTDIR From System Property=/export/home/oracle/OBIEE/systemsmanagement/resources//attribute-definitions.xml
2009-04-22 11:14:56.506 NOTIFICATION Attribute file location is /export/home/oracle/OBIEE/systemsmanagement/resources//attribute-definitions.xml
2009-04-22 11:14:57.388 ERROR J2EE OJR-00010 Exception starting HTTP server: Permission denied
09/04/22 11:14:57 Error initializing server: Unable to start HTTP-Server. default-web-site configuartion may not be valid.

Thanks,
Tim

John Minkjan said...

Did you edit the other files to?

regards

John

Tim said...

Hello John,
I changed the following files: Changed default-web-site.xml at /OBIEE/oc4j_bi/j2ee/home/config
Changed instanceconfig at /OBIEE_ADCO/web/config
Changed bioffice.xml at /OBIEE/oc4j_bi/j2ee/home/applications/bioffice/bioffice/WEB-INF
Changed xmlp-server-config.xml at /OBIEE/xmlp/XMLP/Admin/Configuration

Tim said...

I have tried a few more random ports and it seems that the only ports that work are ports in the 4 digit range, such as 1234 or 8888, but anything with 2 or 3 digits does not work. Maybe it's a network thing and that something related to obiee....

Tim said...

Hello again,
I had a chance to take a closer look at this and figured out that my problem was related to the fact that only the root user has access to use ports under 1024.
Just wanted to follow up on this.
-Tim

John Minkjan said...

@Tim,

Thanks for sharing!

regards

puj4948 said...

hello john,

have u tried access the OBI Publisher using port 80? After changed the port using port 80, i can only access the OBI Answers & Dashboard. When I tried login to OBI Publisher, it return me login error.

Here the log file :
2009-11-20 11:31:15.810 NOTIFICATION connect to NQSSECONDARYCCS=;PORT=;SSLKEYSTOREPASSWORD=***;PRIMARYCCS=;USER=ADMINISTRATOR;PRIMARYCCSPORT=;TRUSTANYSERVER=;LOGFILEPATH=/tmp;SECONDARYCCSPORT=;TRUSTSTOREPASSWORD=***;LOGLEVEL=;SSL=;HOST=ainulnaim;CATALOG=;PASSWORD=***;
2009-11-20 11:31:18.830 WARNING java.net.NoRouteToHostException: No route to host
2009-11-20 11:31:18.833 NOTIFICATION connect to NQSSECONDARYCCS=;PORT=;SSLKEYSTOREPASSWORD=***;PRIMARYCCS=;USER=ADMINISTRATOR;PRIMARYCCSPORT=;TRUSTANYSERVER=;LOGFILEPATH=/tmp;SECONDARYCCSPORT=;TRUSTSTOREPASSWORD=***;LOGLEVEL=;SSL=;HOST=ainulnaim;CATALOG=;PASSWORD=***;
2009-11-20 11:31:21.836 WARNING java.net.NoRouteToHostException: No route to host
09/11/20 11:31:21 java.sql.SQLException: java.net.NoRouteToHostException: No route to host
.
.
.


Please advise.

John Minkjan said...

@puj4948

Your SSLKEYSTOREPASSWORD might be comprimezeid by changing tyhe port number, check the docs.

regards

John

Anonymous said...

hi, i try to change the name of hostname example: http://roberto:9704.... for http://lama:9704.... but no changing the name of the machine because is a server, any solutions or help please.

John Minkjan said...

@Anonymous,

you can do this in your webserver manager.

regards

John