Oracle Business Intelligence

Products Banner

Admintool not showing tables to Import.

Received Response
33
Views
7
Comments

Hello All,

We have installed 64 bit OBIEE Admin tool (11.1.1.7.150120) on our 64 bit windows 7 machine And we are trying to get data from Oracle Database. So we have set the  Connection Type as OCI 10g/11g. Then when we try to import the tables it's not showing any tables under the schema as in the pic below.

pastedImage_0.png

1. I checked and enabled the OCI library while installing Oracle 11g client.

2. Path in Environment variable is Set as C:\ora64\product\11.2.0\client_1\bin;

3. I checked the bi_init.bat file and set the path.

4. oracore11.dll is available in directory.

I still don't understand why is it not showing the tables in database schema to import.

I checked the NQSAdminlog file and it has the below error.

[2017-11-29T17:38:36.000-08:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 2780]  [46153] The configuration file (security.xml) was not found or is inaccessible.

[2017-11-29T17:42:55.000-08:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 2148]  [46153] The configuration file (security.xml) was not found or is inaccessible.

[2017-11-29T17:43:17.000-08:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 2148]  [16020] Metadata Database Type:  [[

Data Source Name: EDWP

Data Source Type: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64b

Please Help.

Thanks.

Answers