Creation Of A Common external User OPS$ and C##
Last updated on APRIL 13, 2017
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms