The connection has failed” Error when trying to Import Metadata into Administrator file

Question

Hi All,

OBIEE software installed server machine. I.I have installed Oracle BI client installer in my local machine,when i am trying to import meta data its showing the connection has failed.

This is exact issue i am facing my local machine.is there any configuration require please let me know.

Thanks,

Nagarajeshob · Answer

Hi,

One of the solution

All about BI Publisher and OBIEE: connection failed while importing metadata in obiee 11g

cesar.advincula.o · Answer

Hello,

Your question.is.about to setting Oracle database is bc driver. If you want.you should follow this steps.

1. Check you have a well installed Oracle database client

2. Check your setting in your tnsname.ora.. In your tnsname.ora put your setting.if your database.

3. Setting your is bc database.

If.you want to.import data please follow up the s

1. First do you have to check if you have a Oracle database client to import metadata.

2. Check your tnsname user and pwd in your connection pool of your physical layer of your RPD. Please there is another.different tnsname.ora this tnsname is used by Oracle bi admin tool setting in that.

Please, ensure the format of the sourcename.

- you could use your tnsname

- host:port\sid

3. Ensure there is not firewall in your clientes and your server.

4. Check if you could ping for your ip database machine.

Felipe_Idalgo · Answer

Hi,

Are you trying to import metadata on a offline or online connection?

If you're trying to import that in online mode, you have sure your OBIEE server can see your DB server.

Try to add your TNSNAMES.ora at {DOMAIN_HOME}/config/fmwconfig/bienv/core

e.g. /.../Oracle_Home/user_projects/domains/bi_dev/config/fmwconfig/bienv/core/tnsnames.ora

Using on your RPD your tnsnames connection alias from file, like DB_OBIEE_PRD....

Felipe Idalgo