Problem with multitenant in Direct mode

Problem with multitenant in Direct mode

Postby ecullen » Mon 22 Dec 2014 23:49

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
ecullen
 
Posts: 3
Joined: Mon 22 Dec 2014 18:23

Re: Problem with multitenant in Direct mode

Postby Pinturiccio » Wed 24 Dec 2014 14:36

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.
Pinturiccio
Devart Team
 
Posts: 1893
Joined: Wed 02 Nov 2011 09:44

Re: Problem with multitenant in Direct mode

Postby ecullen » Tue 30 Dec 2014 21:38

***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.
ecullen
 
Posts: 3
Joined: Mon 22 Dec 2014 18:23

Re: Problem with multitenant in Direct mode

Postby Pinturiccio » Tue 06 Jan 2015 15:30

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.
Pinturiccio
Devart Team
 
Posts: 1893
Joined: Wed 02 Nov 2011 09:44

Re: Problem with multitenant in Direct mode

Postby ecullen » Thu 22 Jan 2015 13:50

Any news on this issue? we have a new release of our product blocked by this, started looking for alternatives or workarounds now
ecullen
 
Posts: 3
Joined: Mon 22 Dec 2014 18:23

Re: Problem with multitenant in Direct mode

Postby Pinturiccio » Thu 22 Jan 2015 16:44

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.

ecullen wrote:started looking for alternatives or workarounds now

As a workaround you can use the OCI mode.
Pinturiccio
Devart Team
 
Posts: 1893
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for Oracle