Page 1 of 1
Problem with multitenant in Direct mode
Posted: Mon 22 Dec 2014 23:49
by 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
Re: Problem with multitenant in Direct mode
Posted: Wed 24 Dec 2014 14:36
by 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.
Re: Problem with multitenant in Direct mode
Posted: Tue 30 Dec 2014 21:38
by 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.
Re: Problem with multitenant in Direct mode
Posted: Tue 06 Jan 2015 15:30
by Pinturiccio
We have reproduced the issue. We will investigate it and post here about the results as soon as possible.
Re: Problem with multitenant in Direct mode
Posted: Thu 22 Jan 2015 13:50
by ecullen
Any news on this issue? we have a new release of our product blocked by this, started looking for alternatives or workarounds now
Re: Problem with multitenant in Direct mode
Posted: Thu 22 Jan 2015 16:44
by 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.
ecullen wrote:started looking for alternatives or workarounds now
As a workaround you can use the OCI mode.