Creation Of A Common external User OPS$ and C##
(Doc ID 1603784.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
Trouble to create a user with os authentication in the new 12c release.
Here's the case:
In the older oracle version below 12c we were able to create a user with the "ops$" prefix (or something else which has been set with the os_authent_prefix parameter) and use the os authentication to connect to the oracle database.
os_authent_prefix is set to "ops$"
OS Username is "oracle"
So if we create a user called "ops$oracle" identified by externally. And so we were able to connect to the database with "sqlplus /" without any extra password.
So now, trying to copy this behaviour to a 12c container base and with try to create a common user with the same information, it fails with the error ORA-65096.
Reason is simple: because all common user in 12c needs the prefix "c##". So Trying with anew user called "c##ops$oracle" but the user is still not able to connect to the database=> ora-01017.
How is it possible to create a common user for the container database without a password who is authenticated by the OS?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document