I'm using dotConnect express for Oracle with OCI 11gR2 instant client. It can successfully connect to cdb$root and pluggable databases. Running DML, DDL statements against the PDB works. DML against the cdb$root also works. Some of the DDL against the cdb$root that I tried also seems to work, but when I try to create a 'common' user I get an error
ORA-12828: Can't start parallel transaction at a remote site
Looking up in Oracle doc on this error, I get this
Cause: PDML transaction cannot be started because we are not in the coordinator site of the distributed transaction.
Action: Do not use PDML at remote sites.
The create user statement I'm trying to run is
CREATE USER c##common_user1 identified by <pass> container = all
Also, I found that this statement works when issued via SQLPlus (which uses the same version of OCI instant client)
Oracle12c : Creating 'common' user fails
-
- Posts: 2
- Joined: Tue 15 Jul 2014 13:08
Re: Oracle12c : Creating 'common' user fails
I have some update on this - it seems that even a simple 'grant' statement fails with the same error. It seems to me any SQL that supports and uses 'container = all' clause will fail with the same error
The grant statement I attempted to run was something like this
grant dba to c##common_user container = all
[*] Makes me wonder whether dotConnect has full support for Oracle 12c multi-tenant CDB ?
The grant statement I attempted to run was something like this
grant dba to c##common_user container = all
[*] Makes me wonder whether dotConnect has full support for Oracle 12c multi-tenant CDB ?
Re: Oracle12c : Creating 'common' user fails
Thank you for your report. We will investigate the issue and notify you about the result.
Re: Oracle12c : Creating 'common' user fails
Please set the "Enlist=false;Transaction Scope Local=true;" options in your connection string and notify us about the result.