Noticed a breaking change with version 12.1.0.2.4. I have the following in my sqlnet.ora:
SQLNET.AUTHENTICATION_SERVICES= (NONE)
NAMES.DIRECTORY_PATH= (TNSNAMES)
NAMES.DEFAULT_DOMAIN = yourdomain.com
Powershell script to test connection:
#Download http://download.oracle.com/otn/other/ole-oo4o/ODP.NET_Managed_ODAC12cR4.zip, unzip to location:
Add-Type -Path "C:\orainstall\ODAC12cR4\Oracle.ManagedDataAccess.dll"
$userID = "yourUser"
$password = "yourPassword"
$server = "yourTNSalias"
$con = New-Object Oracle.ManagedDataAccess.Client.OracleConnection("User Id=$userID;Password=$password;Data Source=$server")
$con.open()
$con.Close()
Exception calling "Open" with "0" argument(s): "ORA-12154: TNS:could not resolve the connect identifier specified"
If I comment out
# NAMES.DEFAULT_DOMAIN = yourdomain.com
Connection works fine.
Previous versions of Managed Driver, including 12.1.0.2.1 does not have issue, this works fine without commenting out NAMES.DEFAULT_DOMAIN (new Powershell window to load older assembly):
#Download http://download.oracle.com/otn/other/ole-oo4o/ODP.NET_Managed121020.zip, unzip to location:
Add-Type -Path "C:\orainstall\ODAC121020\Oracle.ManagedDataAccess.dll"
$userID = "yourUser"
$password = "yourPassword"
$server = "yourTNSalias"
$con = New-Object Oracle.ManagedDataAccess.Client.OracleConnection("User Id=$userID;Password=$password;Data Source=$server")
$con.open()
$con.Close()