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

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

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

Received Response
271
Views
5
Comments
2887836
2887836 Rank 1 - Community Starter
edited Aug 13, 2024 7:04PM in Oracle Analytics Cloud and Server

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,

Answers

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

    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, 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.

    Kknd regards

  • 2887836
    2887836 Rank 1 - Community Starter

    Hi,

    In my local machine i tried oracle database client to import the data by using connection pool of physical layer of my rpd working fine.just iam using Scott schema.

    in server machine database details add into tns entries into this path D:\Oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN tns entries in my local machine.after that

    confiure Oracle ODBC driver configuration server database details iam enter its show

    error unable to coonect:

    SQL State=08004 

    ORA-12154: TNS:could not resolve the connect identifier Specified.

    This erroe iam getting

    Could you please let me know what is the exact procedure i am follow.

  • Felipe_Idalgo
    Felipe_Idalgo Rank 5 - Community Champion

    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

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

    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.

  • Nagarajeshob
    Nagarajeshob Rank 1 - Community Starter

    Hi,

    One of the solution

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