Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APEX 4.2.6: SSO Authentication using windows login

user13267146Feb 9 2015 — edited Feb 11 2015

Hi,

Use case:

From OBIEE dashboard we want to create action links to APEX. We do not want users to login again in APEX. Looking for some sort of SSO either using AD or Windows login (NTLM)

Our setup:

APex 4.2.6 (DB 11.2.0.4) installed on Weblogic  of an existing OBIEE domain using APEX listener. Now we want to achieve SSO either using AD or windows login. Referred a lot of links , docs. Somehow NTLM does not seem to be possible in APEX listener ( Not able to find the dad.conf). Not sure how to achieve the SSO without setting up Oracle Access Manager.

http://jastraub.blogspot.com.au/2008/03/ntlm-http-authentication-and.html

http://www.greenit.li/greenIT/Willkommen_files/Oracle_APEX_ProofOfConceptNTLMPLSQL.pdf

http://www.yenlo.nl/nl/how-to-implement-single-sign-on-using-ntlm/

http://www.inside-oracle-apex.com/using-windows-login-credentials-for-single-sign-on-ntlm-authentication/

http://oracle-base.com/articles/misc/oracle-application-express-apex-4-2-ldap-authentication.php

https://identityandaccessmgmt.wordpress.com/category/apex-4-2-3/

If there are any APEX SSO solutions without using OAM, please advise. Either through AD/NTLM or through OBIEE credentials.

Regards,

Vara

Comments

SeanKilleen
Answer

Hi all,

In this case, the error was resolved by restarting the PC. Something must have gotten a lock on a folder Oracle was trying to access somehow, and nothing was telling in the task manager.

Should have known to check before posting something like this.

Marked as Answer by SeanKilleen · Sep 27 2020
Antonyro-Oracle

<moderator edit - deleted contents of MOS Doc 1569962.1 - pl do not post such content - it is a violation of your Support agreement>

user13491090

This hint did the trick! Thanks.

user11974656

I had the same situation, when I was running the installer 2nd time (installing both 32-bit and 64-bit drivers for some reason). I found following articles on metalink:

  • "[INS-30131] The initial setup that is required to run the installation program validation was not successful " Error While Installing 12.1 (Doc ID 1569962.1)
  • Installation of 11gR2 on Windows Fails Checking Requirements (Doc ID 1133495.1)

Neither of them was helpful. After some time of poking around I noticed service OracleRemExecServiceV2 running from location C:\Users\<MyUsername>\AppData\Local\Temp\2\\oraremservicev2\RemoteExecService.exe - I stopped it and re-ran Oracle client installer. It solved the problem for me.

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 11 2015
Added on Feb 9 2015
3 comments
1,910 views