Hi All,
I am trying to create a common user to enable db management and analytics on Oracle Base Database Service and validating through the creation of a connection under the CDB. There are other connections for either local or Sys connections also created that work correctly for both CDB and PDB's in the environment both in console, SQL Worksheet and via SQLcl.
The code used to create the user is as follows:
CREATE USER C##BLA IDENTIFIED BY "BLABLABLABLABLABLA"
PROFILE DEFAULT
CONTAINER = ALL;
When attempting to validate the connection the following error is displayed:
and when logged in through SYS can be seen to have created a user account through
select * from dba_users where username like 'C##%'
and
select * from cdb_users where username like 'C##%' where all cdb/pdb con_id's are showing and have the ‘Common’ field set to Yes.
The password has been tried on the console side both with and without ‘"’
The connection string has had gibberish added to check that and it failed on a different error.
Local users in the PDB's are no issue and create and work immediately.
The account is unlocked.
Any help/ideas to resolve is much appreciated