BookmarkSubscribeRSS Feed
rajdeep
Pyrite | Level 9

Hi Team,

 

I am trying to connect to Oracle 19C OCI database from ODBC Bridge through system DSN, but I am getting the below error. The system DSN basically I am going to use for Dataflux studio.

 

rajdeep_0-1632941940577.png

rajdeep_1-1632942130415.png

rajdeep_2-1632942148358.png

I had kept the settings as above snapshots and for other tabs I kept as default. I have taken the Oracle wire Protocol Driver.

 

I had updated the SQLNET.ORA file with below two lines as well.

SQLNET.ALLOWED_LOGON_VERSION_SERVER=11
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=11

 

Please suggest what work around I can follow to resolve this.

 

Thanks

2 REPLIES 2
rajdeep
Pyrite | Level 9
Hi Team,

Can anyone please guide something on this. The issue is in bit high priority.
Just wanted to know the the sqlnet.ora parameters need to be added in both server as well as client side or only server side.

Please help.

Thanks in advance.
gwootton
SAS Super FREQ
You may wish to engage Oracle support as this message is not related to the SAS software and the issue is critical.

Seems like the issue is a mismatch in versions between the client driver and the server, perhaps you can update the driver?
--
Greg Wootton | Principal Systems Technical Support Engineer

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1978 views
  • 0 likes
  • 2 in conversation