Post

3 followers Follow
0
Avatar

problem with DBID

how fix this errors???

(replicate oracle to mysql)

 

 

[root@giep /]#  /root/omi/omi-pre-all.sh
Supplemental logging for database omi...
This check fails if the DBID is not the expected one...


Ok, check passed.
[root@giep /]# /root/omi/omi-all.sh
Setting up Dbvisit Replicate configuration
Configure database omi...
This check fails if the DBID is not the expected one...


Ok, check passed.
create user dbvrep identified by "dbvpasswd" default tablespace USERS temporary tablespace TEMP
            *
ERROR at line 1:
ORA-65096: invalid common user or role name

Daniel Answered

Official comment

Avatar

The problem is not with Dbvisit Replicate, DBID - the check passed as "OK".

If you are running Oracle 12C this is common.

ORA-65096: invalid common user or role name

Cause: An attempt was made to create a common user or role with a name that was not valid for common users or roles. In addition to the usual rules for user and role names, common user and role names must start with C## or c## and consist only of ASCII characters.

Action: Specify a valid common user or role name.

This is because of the multitenant architecture in Oracle 12c. You need to have an understanding on multitenant container database (CDB) and Pluggable databases (PDB) to appreciate the need for this error. An attempt was made to create a user in CDB to manage multiple PDB's and for some reason Oracle does not like the syntax that has been provided.

Solution - Create a CDB user

If the intention is to create a user is CDB then prefix "C##"  to the user name as shown below :

CDB$ROOT@ORCL> create user c##hr identified by hr;



Charmaigne Bezuidenhout
Comment actions Permalink

Please sign in to leave a comment.

1 comment