Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Obi connection issue

Anbarasan-OracleJan 11 2014 — edited Jan 17 2014

HI All,

I installed OBIEE 10.1.3.4.2 sucessfully on windows 7 ultimate OS and database Oracle 11g R2 11.2.0.1.0 64 bit

but when I tried to Import SH schema from OBIEE Admin Tool the SH schema is not appearing in the select data source under connection type ODBC 3.5.

I can see only DSN:Analyticsweb and Driver:Oracle BI server in select datasource under ODBC 3.5.

and even I cannot see the SH schema under any connection types(ODBC 2.0,DB2 CLI(unicode),XML,OCI 10g/11g.

but when I checked System DSN in ODBC Data Source Administrator even the SH schema was added as (Name:SH Driver:Oracle in OraDb11g_home1).

I have tried

File--> Import --> from database-->select OCI 10/11g--> selected TNS name:orcl and Username:SH and password:SH.

user is active/unloked only

but it has given following error

0xc1

[nQSError:46029]Failed to load the DLL

C:\OracleBI\server\Bin\nqsdbgatewayoci10g.dll. Check if 'Oracle OCI

10G' database client is installed.

Please hlep me on this bit urgent

Regards

Anbarasan

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 14 2014

Added on Jan 11 2014

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

5 comments

522 views