Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Admintool not showing tables to Import.
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.
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 ...
0 -
use the same connection details and try it in SQL developer ... rule out the install/config of your oracle client.
0 -
I Updated the pic, Please take a look. I'm able to access the Schema and tables from SQLDeveloper with the same credentials.
0 -
This is not my personal Computer. I didn't even find the OPMNctl.bat File.
0 -
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)
0 -
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)))
This will test that you can connect from the OBIEE server to the DB server either using tnsnames or directly
0