OCIEnvCreate failed with return code -1

[I054124]

Hi

We have installed Oracle 10g on windows 2003 32 bit OS. We have installed oracle client also. After carrying out this we installed Nakisa 2.1 pre EHP4 and tried to setup Database connection. After selecting database type as oracle then Database name user and password we are getting Error OCIEnvCreate failed with return code -1

Request your help at the earliest.

Thanks and Regards

Shriraj

[lukemarson]

Hi Shriraj,

This is usually caused by the Oracle client not being correctly installed or configured. The client needs to be installed on the application server and you probably should ensure Microsoft's ODBC drivers are present and functionaing correctly.

I hope that helps! If you fix it please remember to post how you did it.

Luke

[I054124]

Dear Luke

Thanks for your prompt response. I have done installation with following sequence.

I have single server with Windows 2003 (32 bit OS)

1. Installed oracle software 10.2.0.1

2. Installed Oracle client 10.2.0.

3. Created Database with database configuration assistant.

4. Created system DNS in ODBC - Test is successful.

5. Changed TNSNAMES.ORA (added DB name)

5. tnsping <SID> successful.

6. Installed Nakisa 2.1 pre EHP4

7. In admin giving Destination details as Database type ->oracle, System name-> <SID>, user ->system, password-> xxxxxx

when i click on test connection i am getting above error.

8. Copied OCI.DLL & OCIW32.dll into Orgchart\bin folder.

As you suggested to install client on application server I have done it on same server. I hope I have done proper steps but still not getting success.

Thanks and Regards

Shriraj

[lukemarson]

Hi Shirarj,

Can you log into SQL Plus with your connection details? If so then it is a problem with OrgChart connecting to the database, which is done with the Microsoft .NET ODBC driver. That is likely to be the problem if the DB is configured correctly.

Luke

[I054124]

Hi Luke

I found surprise results. I did reinstallation of oracle without client installation and it worked properly.

Thanks for your prompt response.

Regards

Shriraj

[lukemarson]

Hi Shriraj,

That's great news. Good luck with the rest of your implementation.

Best regards,

Luke