Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Error when importing metadata with OBIEE 12c Admin Tool using variables

Any assistance is appreciated.
Thanks!
Answers
-
The Admin tool uses its own tnsnames file. Create or copy your tnsnames.ora file to
<DOMAIN_HOME>/config/fmwconfig/bienv/core
0 -
The Admin tool uses its own tnsnames file. Create or copy your tnsnames.ora file to
/config/fmwconfig/bienv/core
Sent from my iPhone
0 -
Joel,
I have tried that already after reading one of the support Doc IDs. It works just fine if the actual DSN and username is entered instead of the variables. But with the variables it doesn't for some reason. Thoughts?
0 -
Hardcode the connection details, import your metadata, and then switch the connection back to variable-based.
0 -
Is that the only way? I'm doing that already but it becomes cumbersome after a certain number of imports.
Thanks for taking the time to respond.
0 -
You can script that...
0 -
Some pointers on how to script that piece would help. Thanks Christian.
0 -
Something along these lines:
http://www.rittmanmead.com/2011/11/obiee11g-scripting-–-generate-xudml-and-change-the-password-of-the-connection-pools/
0 -
A proof for what @rmoff said: OBIEE 11g Information About the Use of Variables in the Connection Pool (Doc ID 1925713.1)
PS. I know that this note is for 11g, but the cause won't change for 12c
0 -
Yeah you already got 2 pointers. I thought the input was enough to google "obiee script connection pool"...
0
