I am unable to connect to the oracle database using kerberos authentication on ACE 12.0.0.5 and getting following error while migrating from IIB10 to ACE12.
Has anyone faced similar issue in the past.
--------------------
BIP8299I: User '
user@test.domain.com' from security resource name 'odbc::testdb' will be used for the connection to datasource 'testdb'.
BIP8290I: Verification passed for the ODBC environment.
BIP2393E: Database error: ODBC return code '-1' from data source ''testdb'' using ODBC driver manager ''/app/ace-12.0.5.0/ie02/lib/libodbcinterface.so''.
The integration node received an error when processing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database about this error.
Use the following messages to determine the cause of the error. Typical problems are an incorrect data source, or table names. Correct either the database or the integration node configuration. Use the mqsicvp command to test connectivity to this database.
BIP2322E: Database error: SQL State ''HY000''; Native Error Code '2755'; Error Text ''[unixODBC][IBM][ODBC Oracle Wire Protocol driver]Security Services Error: Unspecified error at the GSS layer. There may be other messages with more info.''.
The error has the following diagnostic information: SQL State ''HY000'' SQL Native Error Code '2755' SQL Error Text ''[unixODBC][IBM][ODBC Oracle Wire Protocol driver]Security Services Error: Unspecified error at the GSS layer. There may be other messages with more info.''
This message may be accompanied by other messages describing the effect on the integration node itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error. Use the mqsicvp command to test connectivity to this database.
BIP2322E: Database error: SQL State ''HY000''; Native Error Code '2763'; Error Text ''[unixODBC][IBM][ODBC Oracle Wire Protocol driver]Security Services Error: Matching credential not found.''.
The error has the following diagnostic information: SQL State ''HY000'' SQL Native Error Code '2763' SQL Error Text ''[unixODBC][IBM][ODBC Oracle Wire Protocol driver]Security Services Error: Matching credential not found.''
This message may be accompanied by other messages describing the effect on the integration node itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error. Use the mqsicvp command to test connectivity to this database.
BIP8040E: Unable to connect to the database.
The database cannot be accessed with the specified user Id and password pair.
- Check that the database is running.
- Check that the database has an adequate number of database connections available for use.
- On Windows, check that an ODBC connection has been created.
- On systems that use $ODBCINI, check that the file pointed to by $ODBCINI has been correctly updated.
- On z/OS check the BIPDSNAO member of the component's dataset, and check the DB2 64bit ODBC driver (DSNAO64C) is in the STEPLIB.
- Use mqsisetdbparms or mqsicredentials to set the password to the correct value and try again.
--------------------
------------------------------
Deepak Sharma
------------------------------