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

ORA-12154: TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach

Received Response
1166
Views
9
Comments
Maahjoor
Maahjoor Rank 3 - Community Apprentice
edited Aug 13, 2024 6:03PM in Oracle Analytics Cloud and Server

Dear all,

i am following the below tutorial

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1221/rpd/rpd.html#section4s4

i am using OBIEE 12c.

under the section, Creating and Running Analysis, under step 8, i receive the following error message

   Odbc driver returned an error (SQLExecDirectW).

  Error Details

Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)

State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)

State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach. (HY000)

State: HY000. Code: 17014. [nQSError: 17014] Could not connect to Oracle database. (HY000)

SQL Issued: SELECT 0 s_0, "Students"."D Colleges"."College Name Ara" s_1, "Students"."D Degrees"."Degree Desc Arb" s_2, "Students"."D Departments"."Department Name Ara" s_3, "Students"."D Fascal Years"."Year Description" s_4, "Students"."D Students"."Count Female" s_5, "Students"."D Students"."Count Male" s_6, "Students"."F Student Graduation"."Avg GPA" s_7, "Students"."F Student Graduation"."Max GPA" s_8, "Students"."F Student Graduation"."Min GPA" s_9 FROM "Students" FETCH FIRST 65001 ROWS ONLY

pastedImage_3.png

i have load the repositary using the following command.

Cd C:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\bitools\bin

datamodel.cmd uploadrpd -I C:\Oracle\Middleware\Oracle_Home2\bi\bifoundation\server\Student_Repository.rpd -W Oracle_123 -U weblogic -P Oracle_123 -SI pdborcl

how could i fix it?

Thank you.

Answers

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Hi,

    The OCI error clearly states database connectivity problem. Are you using OCI in OBIEE RPD to connect to your database ? If so, check your tns entries and make sure you can establish a successful connection to the database from the OBIEE server.

    https://docs.oracle.com/middleware/1221/biee/BIEMG/datasource.htm#BIEMG1215

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    PEBOAD - Problem Exists Between OBI And Database ;-)

    No OBIEE issue. Your BI server can simply not talk to the database / database server. Can ping the database server? Can you tnsping the Oracle DB you're trying to access? Since you're using OCI this definitely must work.

  • Maahjoor
    Maahjoor Rank 3 - Community Apprentice

    yes, i could ping the server.

    the tnsping is also working. i could connect to bi admin tool with the same database string, in my case, it is PDBORCL.

    i dont know how to fix it.

    Please guide further.

    Regards.

  • Maahjoor
    Maahjoor Rank 3 - Community Apprentice

    i will go through the link and will update you tomorow.

    Thank you so much for your kind guidance.

    Regards.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    That doesn't make sense . Are you using variables in the connection pool and you're all of a sudden connecting with a different username/password?

  • Maahjoor
    Maahjoor Rank 3 - Community Apprentice

    i myself is wondered. why it is happening. may be i do some mistake in installing the OBIEE 12C. may be i never configure the tnsnames.ora files in OBIEE installation directory. but i could connect using the bi admin tool. when it comes to analysis, i cant connect.

    Regards

  • Joel
    Joel Rank 8 - Analytics Strategist

    Because the Admin Tool installation is technically a standalone implementation, it comes with its own tnsnames file which is independent of the file used by OBIEE itself.

    The Admin tool uses its own tnsnames file.

    ADMIN_TOOL_HOME/network/admin

    For connections to data sources used in OBIEE, the file should be located at

    DOMAIN_HOME}/config/fmwconfig/bienv/core

  • Maahjoor
    Maahjoor Rank 3 - Community Apprentice

    Thank you so much Joel. Much appreciated.

  • Joel
    Joel Rank 8 - Analytics Strategist

    You're very welcome!