Oracle connectivity issue
Posted: Wed Jan 24, 2018 7:57 am
Dear All,
One of the Datastage job was accessing Oracle DB through ODBC connector stage. It is Oracle 11g version. Now as per new requirement we should switch to new Oracle DB that is 12C version. DB team kept user name and password same as old DB. We have updated existing Oracle DB entry of odbc.ini and change the hostname and port number entry for new DB as follows
--------------------------------
[XXXXX]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMora25.so
Description=DataDirect Oracle Wire Protocol
ApplicationUsingThreads=1
ArraySize=60000
CachedCursorLimit=32
CachedDescLimit=0
CatalogIncludesSynonyms=1
CatalogOptions=0
DefaultLongDataBuffLen=1024
DescribeAtPrepare=0
EnableDescribeParam=0
EnableNcharSupport=0
EnableScrollableCursors=1
EnableStaticCursorsForLongData=0
EnableTimestampWithTimeZone=0
HostName=XX.XX.XXX.XXX
LocalTimeZoneOffset=
LockTimeOut=220
LogonID=xxxx
Password=xxxx
PortNumber=1531
ProcedureRetResults=0
ServiceName=edhprod
UseCurrentSchema=0
------------------------------------------
We are facing following error on job run
"
PKG_CHANGE: ODBC function "SQLConnect" reported: SQLSTATE = HY000: Native Error Code = 28,040: Msg = [IBM(DataDirect OEM)][ODBC Oracle Wire Protocol driver][Oracle]ORA-28040: No matching authentication protocol (CC_OdbcConnection::connect, file CC_OdbcConnection.cpp, line 598)
"
Please let me know how to fix it.
Thanks,
One of the Datastage job was accessing Oracle DB through ODBC connector stage. It is Oracle 11g version. Now as per new requirement we should switch to new Oracle DB that is 12C version. DB team kept user name and password same as old DB. We have updated existing Oracle DB entry of odbc.ini and change the hostname and port number entry for new DB as follows
--------------------------------
[XXXXX]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMora25.so
Description=DataDirect Oracle Wire Protocol
ApplicationUsingThreads=1
ArraySize=60000
CachedCursorLimit=32
CachedDescLimit=0
CatalogIncludesSynonyms=1
CatalogOptions=0
DefaultLongDataBuffLen=1024
DescribeAtPrepare=0
EnableDescribeParam=0
EnableNcharSupport=0
EnableScrollableCursors=1
EnableStaticCursorsForLongData=0
EnableTimestampWithTimeZone=0
HostName=XX.XX.XXX.XXX
LocalTimeZoneOffset=
LockTimeOut=220
LogonID=xxxx
Password=xxxx
PortNumber=1531
ProcedureRetResults=0
ServiceName=edhprod
UseCurrentSchema=0
------------------------------------------
We are facing following error on job run
"
PKG_CHANGE: ODBC function "SQLConnect" reported: SQLSTATE = HY000: Native Error Code = 28,040: Msg = [IBM(DataDirect OEM)][ODBC Oracle Wire Protocol driver][Oracle]ORA-28040: No matching authentication protocol (CC_OdbcConnection::connect, file CC_OdbcConnection.cpp, line 598)
"
Please let me know how to fix it.
Thanks,