Creation Of A Common external User OPS$ and C##

(Doc ID 1603784.1)

Last updated on APRIL 13, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 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.

For Example:
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