Monday, September 13, 2010

OBIEE 11g: Import metadata, connection problems.

Importing metadata aught to be a simple: Hit File - > Import Metadata, punching in db and user name and finish it of with password then select what you want to import. It is if your lucky. The pitfall that got me was that OBIEE 11g install it's own Oracle client.
Fine, so what? It is in this clients tnsnames.ora that it looks up servicenames. Which means that you have to have the correct tnsnames entries in {Oracle_BI1}\network\admin\tnsnames.ora and not that of your database.

No comments: