Skip to Main Content
Forums

Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle 21c Failing to install

Philip.BorchertSep 9 2022 — edited Sep 9 2022

I don't have a My Oracle Support account so I cannot open a ticket.

I've tried to install Oracle 21c 2 times so far. Windows 10 Enterprise 21H2 19044.1889 Windows Feature Experience Pack 120.2212.4180.0. ~I followed a guide to uninstall manually so I could install a second time. I'm surprised there isn't a clean utility or an uninstaller.~ I found that you can deinstall using the setup.exe. When I looked for other Oracle stuff I noticed that my Jet Brains Resharper had some Oracle stuff with it. So I have uninstalled it and will be retrying to install.
The configuring step was taking forever and got to 40% on Configuring Oracle XE Database component.
First error was "[FATAL] Error while executing "C:\app\2942197\product\21c\dbhomeXE\rdbms\admin\dbmssml.sql". Refer to "C:\app\2942197\product\21c\cfgtoollogs\dbca\XE\dbmssml0.log" for more details. Error in Process: C:\app\2942197\product\21c\dbhomeXE\perl\bin\perl.exe"
Second error was
OracleFailing.pngI'm a Microsoft SQL Server person but, I need this to work because a customer is using an oracle database I need to connect to.
Logs attached:

trace.log_2022-09-09_08-36-44AM.log (669.37 KB)XE.log (794 Bytes)
This post has been answered by Philip.Borchert on Sep 10 2022
Jump to Answer

Comments

Jared C

Ok, I came across this blog and got the function implemented for our environment. It works as expected, but now, I am wondering how to set it up within Oracle APEX itself.

Specifically, if I make a call to ldap_auth in the Create Authorization Scheme dialog, how do I capture the username / password? I am mainly confused since at this point, I am trying to get an authorization at some point after authentication.

Jared C
Answer

Alright, we figured it out.

Instead of passing the password to the ldap_auth function, we made a service account that has read-only permissions to all of the users attributes. We accomplished this by doing this:

Then I put those credentials in the function, and we pass in the username (:APP_USER is available in the Create Authorization Scheme dialog) and the group we want to check whether the user is in.

Marked as Answer by Jared C · Mar 7 2025
1 - 2

Post Details

Added on Sep 9 2022
#database, #database-installation, #error, #installation, #sql-developer
3 comments
3,932 views