Oracle Analytics Cloud and Server

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

Unable to Connect db through RPD OBIEE 12 C

Received Response
252
Views
9
Comments
P G
P G Rank 3 - Community Apprentice

Hi All,

I have created one connection and trying to connect DB through RPD in Online mode but i am getting below error.

Also i have added TNS entry in tsnnames.ora

The connection has failed

[nQSEerror: 17014] could not connect to oracle database.

[nQSEerror: 17001] Oracle error code : 12170 , Message ORA-12170 TNS: Connect timeout occurred at OCI call OCIServerAttach

But if i was open RPD in Offline mode we are able to connect DB.

And Report level i am getting below error

ORA-01012: not logged on Process ID

please help

Thannks,

P G

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist
  • P G
    P G Rank 3 - Community Apprentice

    HI Joel,

    The tnsnames.ora file is in right location.

    One more things, i have create jdbc connection and i am able connect db successfully.

  • Michael Verzijl
    Michael Verzijl Rank 6 - Analytics Lead

    Is it now working or not?

    On which location did you store tnsnames.ora?

    Which version of Oracle-Bi are you running on which OS?

  • P G
    P G Rank 3 - Community Apprentice

    Hi Michael,

    Its not working through RPD.

    tnsnames.ora stored in below location

    OBIEE\Middleware\user_projects\domains\bi\config\fmwconfig\bienv\core

    OBIEE Version: Oracle Business Intelligence 12.2.1.3.0

    OS: Windows 10

  • Michael Verzijl
    Michael Verzijl Rank 6 - Analytics Lead

    Just a simple check: can you change the datasource name to a direct connection and try again?

    Direct connection is: server:PORT/SID

  • P G
    P G Rank 3 - Community Apprentice

    Hi Micael,

    As per your suggestion, i have tried to connect db by direct connection.

    But same error occurred.

    Thanks,

    PG

  • Joel
    Joel Rank 8 - Analytics Strategist

    Do you have an Oracle Client on your OBIEE server? If you do,can you connect via SQL  Plus to your DB? Can you try pinging the DB server from your OBIEE server as well?

  • P G
    P G Rank 3 - Community Apprentice

    HI Joel,

    By using SQL Developer, we are able to connect DB and also able to pinging the DB server from OBIEE server.

    Thanks

    P G

  • Avinash Pentyala
    Avinash Pentyala Rank 5 - Community Champion

    Place complete connection string into RPD and try.