Skip to Main Content

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 19c (19.3) Silent Install Prompting for Oracle Home User Password Using MSA

User_YLH7JMar 3 2022 — edited Mar 4 2022

Windows 2012/2019
Hello gurus, according to the Oracle on-line system/installation help documentation, if you use an existing Managed Service Account (MSA) as the Oracle Home User (OHU), you don't need to specify a password during installation - so Oracle installers need not know MSA pwds during install. This works when I go thru the interactive install ("setup.exe"); the "Oracle Home User" section accepts/finds my domain MSA account and proceeds to install the software.
However when I try to run the install in batch mode/using the response file it generates from the GUI install, I get prompted for the OHU password. I notice that even after the GUI install tho, the Registry setting "ORACLE_SVCUSER_PWDREQ" shows a value of "1". The Oracle services (where we'll use the OHU acct as log-on cred) haven't even been created yet. I can see the need for the pwd later/during the service set-up, but why would this Reg value be "1" at any time, if Oracle supposedly doesn't need it.
I did find this interesting article about the issue, tho he used the GUI/his problem came post-install:
Managed Service Account vs Oracle Home User (0 Bytes)
Seems like after his steps the Reg value correctly stayed at "0" by itself post-install. So 1.) why does the silent install prompt for the pwd (when interactive doesn't), and 2.) why is the value set to "1"? Thx for your help!

Comments

Isn't the legend in approx_percentile picture incorrect?

Shouldn't it be "Exact | Deterministic | Non-deterministic"?

Dude!

Isn't the legend in approx_percentile picture incorrect?

Shouldn't it be "Exact | Deterministic | Non-deterministic"?

You missed an 'n' in Loooooooooooooooog Names

Hendrik Schmidt

Hello,

for the link: "here's the script" I receive Page Not Found error

Non-deterministic results are around 5x faster than deterministic. And nearly 15x faster than exact results. So if an estimate is all you need, you can save yourself a lot of time using approx_percentile. If you want to check this for yourself, here's the script I used.

Evening,

I'm working on mvc projects using mean stack how can i integrate these projects without using mongodb. take for example using sql server..any tips will be helpful.

Peter Schlaeger

Hallo

I must worn everyone for trusting in Oracle Json Support. I have very very very painfull experiences  with Json in Oracle.

In 12.1 it took more than one year and lots of support calls before I was able to use it without bugs ( including full database crashes ).

And now I test on 12.2 and I am again back at the state  where I was in March 2016. Again the same bugs and the solution still not include in any windows bundle patch.

So I suggest that everyone should carefully test his Oracle Version and Patch level if it is capable of running Json without bugs before you decide to use Json.

blessed DBA

We are going start some project on this JSON So it is more useful for us

martin_olivia

The Oracle Database 12c is a high-performance, enterprise-class database.

1 - 7

Post Details

Added on Mar 3 2022
0 comments
815 views