Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Admintool not showing tables to Import.

Received Response
31
Views
7
Comments
User_IP06I
User_IP06I Rank 4 - Community Specialist

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

  • Picture? Which picture?

    Do you see tables in any other schema? Maybe you just don't have the permissions, with the user you connect to the DB, to see tables in that schema ...

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    use the same connection details and try it in SQL developer ... rule out the install/config of your oracle client.

  • User_IP06I
    User_IP06I Rank 4 - Community Specialist

    I Updated the pic, Please take a look. I'm able to access the Schema and tables from SQLDeveloper with the same credentials.

  • User_IP06I
    User_IP06I Rank 4 - Community Specialist

    This is not my personal Computer. I didn't even find the OPMNctl.bat File.

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    It could be a lot of possibilities but it will be related with the Oracle DB Connection, dont know if you use a Oracle Client which can be produced the conflicts between them. Have you seen that? If you have a clean installation you cannot have that trouble (As you mentioned that the SQL DEVELOPER user/password credentials are you using in your OBIEE Connection Pool, this is not a privilege issues)

  • Joel
    Joel Rank 8 - Analytics Strategist

    In addition to all other suggestions, can you tnsping the Oracle DB from the OBIEE server?

    Can you connect if you modify your data source in connection pool to

    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=HOST_NAME)(PORT=PORT_NUMBER)))(CONNECT_DATA=(SID=SID)))

    pastedImage_3.png

    This will test that you can connect from the OBIEE server to the DB server either using tnsnames or directly