Oracle Communities

Oracle Analytics and AI

Child Item

How to Configuring Oracle HTTP Server to Route Requests to the Application Tier

bin.lei-Oracle

Oracle Analytics Server information:

OAS version: 5.9

Admin server: AdminServer

Admin port: 9500

Managed server: bi_server1

port:9502

cluster: bi_cluster

Before SSO: users can access url " http://oas-test.vida.com:9502/analytics" to request BI application.

After SSO:

Oracle http server information:

OHS version: 12.2.1.4

httpd.conf location: /app/weblogic/Oracle/fmw/user_projects/domains/base_domain/config/fmwconfig/components/OHS/instances/ohs1/httpd.conf

httpd.conf content:

Listen 37777

ServerName oas-test.vida.com

include "mod_wl_ohs.conf"

include "ssl.conf"

include "admin.conf"

IncludeOptional "moduleconf/*.conf"

include "webgate.conf"

bi_vh.conf under moduleconf:

ServerName oas-test.vida.com

UseCanonicalName On

ServerAdmin you@your.address

RewriteEngine On

RewriteOptions inherit

#redirect browser requests that omit document/dir

RedirectMatch 301 /analytics$ /analytics/

# Analytics

SetHandler weblogic-handler

WebLogicHost oas-test.vida.com

WebLogicPort 9502

</Location>

</VirtualHost>

When i use IE browser and type "http://oas-test.vida.com:37777/", which ohs can redirect to oam login page.

But when type " http://oas-test.vida.com:37777/analytics" and submit in browser, it will be changed to "http://oas-test.vida.com/analytics" soon in browser address bar, and can't be redirected to oam login page(The page prompts Unable to connect). I am not sure if above bi_vh.conf file configuration correct.

So how to configure bi_vh.conf or other configuration files so that ohs redirect to login page then could access BI application?

Thanks

Brian

Find more posts tagged with

SSO

Accepted answers

bin.lei-Oracle

If delete this line "RedirectMatch 301 /analytics$ /analytics/" , finish to restart OHS and try to access "http://oas-test.vida.com:37777/analytics" it will redirect to OAM login page successfully.

Below is additinal reference doc:

"Creating the Virtual Host Configuration Files for Oracle Analytics Server"

https://docs.oracle.com/en/middleware/bi/analytics-server/enterprise-deploy-oas/installing-and-configuring-oracle-http-server.html#GUID-355836D6-377B-46A2-A4FB-51CCC9B2BACD

All comments

Steve F-2

Hi Brian,

Welcome to the Oracle Analytics Online Forum!

We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.

Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!

No need to respond for this statement: I just want to follow-up with a reminder that OAS 5.9 is out of Error Correction Support since March 2023. You may want to consider planning your upgrade to OAS 2023.

Oracle Analytics Server Error Correction Support Policy and Dates (Doc ID 2775561.1)

Just a minor reference point, that the older MS Internet Explorer (IE) browser is not supported with any version of OAS (Safari,Chrome,FireFox, and Edge are certified and supported).

Your redirect looks OK for single node implementation, for only the /analytics URL; however, you should include all the URL's (maybe you just gave a snippet). The reason is there are internal redirects.

See all the directives here: Configuring Oracle HTTP Server to Route Requests to the Application Tier

The above is just one portion of the configuration. You mentioned SSO, so if you are using Oracle Access Manager, then that configuration needs reviewed for protected URL's

Parent topic: Registering the Oracle HTTP Server WebGate with Oracle Access Manager

Updating the Protected, Public, and Excluded Resources for an Enterprise Deployment

If you are using another SSO, then that may need reviewed, and may require a service request for collecting your data, details etc.

Other comments are welcomed.

Madasamy -Oracle

I believe that the redirection is not set properly.

Please revisit your OHS access/error logs, and verify if all the context roots are properly configured for the redirection. It looks to be a config issue.

bin.lei-Oracle

If delete this line "RedirectMatch 301 /analytics$ /analytics/" , finish to restart OHS and try to access "http://oas-test.vida.com:37777/analytics" it will redirect to OAM login page successfully.

Below is additinal reference doc:

"Creating the Virtual Host Configuration Files for Oracle Analytics Server"

https://docs.oracle.com/en/middleware/bi/analytics-server/enterprise-deploy-oas/installing-and-configuring-oracle-http-server.html#GUID-355836D6-377B-46A2-A4FB-51CCC9B2BACD

Steve F-2

Hi Brian (@bin.lei-Oracle )

Thank you for sharing your specific solution.

If you would be so kind as to mark the accepted answer to close the thread

Steve F-2

I think this was similar, but different from your prior post:

https://community.oracle.com/products/oracleanalytics/discussion/20045/how-to-configure-oracle-analytics-server-with-oracle-access-manager-sso-using-ohs-webgate#latest