My Oracle Support Banner

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 12.1.0.1 and later
Information in this document applies to any platform.

Goal

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?
 

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.