Problem with multitenant in Direct mode

[ecullen]

Hi,
We are using dotConnect for Oracle in Direct Mode and are experimenting problems with multitenant servers. When connecting to a PDB using a LOCAL user granted SysDba, we get an error:

Code: Select all

Devart.Data.Oracle.OracleException (0x80004005): ORA-01017: invalid username/password; logon denied

This only happens in Direct Mode with local users granted SYSDBA (neither normal local users nor common users have problems). Latest versions of SqlPlus and SQLDeveloper can connect correctly, but it seems previous versions of oracle tools had the same problem.

We need to use Direct Mode, so we are stuck with this. Any workaround/ETA for a fix?

Thanks in advance

Ernesto Cullen

[Pinturiccio]

Please provide us the following information:
1. Your connection string in the OCI and in the Direct connection mode (roughly, without login/password);
2. Record in the tnsname.ora file, that is used in the connection string in the OCI connection mode;
3. the command, that you use to connect to SQL*Plus;
4. the connection string, that you use in SQL Developer.

[ecullen]

***dotConnect for Oracle
connection string - direct mode:
User Id=sysdbatest;Password=*****;Server=pdbserver;Connect Mode=SysDba;Unicode=True;Connection Timeout=300;Pooling=True;Direct=True;Service Name=PDBORCL;Port=1521

oci mode - with instant client 11:
User Id=sysdbatest;Password=*****;Server="(DESCRIPTION=(ADDRESS=
(PROTOCOL=TCP)(HOST=pdbserver)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PDBORCL)))";Connect Mode=SysDba;Unicode=True;Connection Timeout=300;
Pooling=True;Direct=False

***sqldeveloper
data is set in gui. This is what it shows as connection details
sysdbatest@//pdbserver:1521/PDBORCL

***sqlplus
sqlplus sysdbatest/passwd@//pdbserver:1521/PDBORCL as sysdba

The only option that fails is the direct one.

[Pinturiccio]

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

[ecullen]

Any news on this issue? we have a new release of our product blocked by this, started looking for alternatives or workarounds now

[Pinturiccio]

Oracle Multitenant is a feature of Oracle 12c. This feature is not implemented in the Direct mode and we can't provide any timeframe when it would be.

started looking for alternatives or workarounds now

As a workaround you can use the OCI mode.