BODI-1111341

[#1]

Hi

While trying to create new datastore in BODS 4.1, i;m getting below error.

I'm trying to connect to Oracle database. DB version: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bits using "TNS" connection.

I'm able to connect to oracle database using SQL Plus.

[Former Member · Accepted solution]

Hi,

Make sure you have the full Oracle client installed on the DS designer as well as DS job server server machine.

For DS designer 32bit you need Oracle Client 32bit

For the DS job server you need Oracle client 64bit.

Check also your ORACLE_HOME env variable to pint to the correct path

Thanks

[Former Member]

Hi Gaurav,

I think you are using 32 bit version of BODS Designer client tool on your machine. Please install 32 bit of Oracle client for TNS entries. Then it will connect to the oracle.

Cheers

Nag

[Former Member]

Hii Gaurav ,

If the error occurs in the log after execution:  This means that the ODBC connection has not been established correctly (or at all) on the SERVER where Data Services is installed.  Request that your DBA or someone with access to the server validate/create the ODBC connection. If you can view the data on your local machine, share with them the ODBC setup you have your machine.  Also make sure that the name of Data Store matches the name of the ODBC connection.

And If the error occurs when trying to view the data or external metadata: The ODBC connection has not been established correctly (or at all) on the LOCAL MACHINE where Data Services DESIGNER is installed. Validate/create the ODBC connection.  If you can execute the job, request the ODBC connection information from you DBA or anyone with access to the server (or of course access to the same datastore with a working ODBC connection).  Also, make sure that the name of Data Store matches the name of the ODBC connection.

Regards

Jeetan Jagtap

[Former Member]

I think the OCI.DLL file is missing in the path. You need to save the file in the LIB folder. You still can connect from SQL Developer but you will get this error if you have the TNS host name missing in the TSN.ORA file or the OCI.DLL file is missing. You should be able to fix this error if you make sure the file is saved in the correct directory.