Sometime back I discussed about Apex (earlier HTMLDB) Installation, Click Here to know more about apex Installation . Today I am going to cover how to configure Single Sign-On for Apex Applications. If you are new to Oracle SSO (Single Sign-On) and want to know more about Oracle SSO Click Here for Overview of Oracle SSO
There are mainly three major steps in configuring Apex / HTMLDB
–Register Apex as Partner Application in SSO Server
–Install SSO SDK on Apex Server
–Register SSO details on Apex Middle Tier
Assumptions in below configuration
Below configuration is based on following assumptions, You may need to change things as per your apex/sso version.
— Apex version discussed below is for 2.0.2.0.0 (Change schema name flows_020200 according to your version)
— Apex is installed on 10g AS , if you don’t see ssosdk902.zip then get it from 10g AS middle tier — You have access to Oracle SSO Server with Admin privileges (orcladmin) account
–You have access to schema under which Apex was installed , In my discussion below database schema name for Apex is “apex”
— URL to access Apex Application is http: // apex_server_name/pls/apex
Configure Apex as Partner application in Oracle SSO Server
Type URL as http: // ssoserver.com/pls/orasso & login as orcladmin, you will see screen like
Click on SSO Server Administration & then you will get Administration Screen
Under that click on “Administer Partner Application ”
Click on Add Partner Application
You will come to Partner application Login Screen enter following details & click on “OK”
Name : SSO Apex
HOME URL : http: // apex_server_name/pls/apex
Success URL : http: // apex_server_name/pls/apex/wwv_flow_custom_auth_sso.process_success
Log Out URL : http: // apex_server_name/pls/apex/apex
and click on OK, you will get screen with values like ID, Token, Encryption Key, Login URL, Single Sign-Off URL … Keep a note of these values as these will be used during Apex Registration process in Next Steps
Remaining Steps: Installing SSO SDK in Apex & Registering Apex with SSO Partner Application created above coming in Next Topic …