OBIEE 11.1.1.3 - Fatal NI connect error 12157
Hi,
I installed OBIEE 11.1.1.3 on linux 64 bit machine. I am not able to start the scheduler process. The scheduler is not able to connect to the database for some reason. I get following error in my sqlnet.log.
Fatal NI connect error 12157, connecting to...
I ensured that tnsnames.ora file in Oracle_BI1/network/admin has the correct sid defined.
I also entered valid connection settings in coreapplications/deployment/scheduler page in the Enterprise manager.
If I turn on tracing in my sqlnet.ora file, I get
1083935040) [18-OCT-2010 15:13:14:905] niotns: niotns failed to create NS ctx, error code 12157
(1083935040) [18-OCT-2010 15:13:14:905] niotns: Couldn't connect, returning 12157
If I try to run tnsping from Oracle_BI1/bin directory, i get error
TNS-12538: TNS:no such protocol adapter
even though the protocol has been specified correctly as tcp.
Any, ideas what may be wrong ? Here are my scheduler page settings in enterprise manager
Database Oralce 11g
Call Interface OCI 10g R1/R2
Data Source mytnsentry
Username myusername
Password xxxx
Confirm Password xxxx
Note that my database is Oracle 11g but I am using OCI 10g R1/R2 as that is the max oci version available in the dropdown. Can this be my problem? If yes, can anybody tell me how to let scheduler use different set of drivers ?