ODBC error Ora 12170 (connect time out) OBIEE 12.2.1.2 — Oracle Analytics

Oracle Analytics Cloud and Server

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

ODBC error Ora 12170 (connect time out) OBIEE 12.2.1.2

Received Response
285
Views
7
Comments
Khalid Ibrahim
Khalid Ibrahim Rank 4 - Community Specialist

After restarting services when I run my report I get an odbc error and

the main error code appears to be ORA-12170 TNS:Connect timeout occurred at OCI call OCIServerAttach.

My tnsnames.ora  file under .../fmwconfig/bienv/core is just the way it should be.

When I do a rowcount in the rpd in offline mode I can get results and the database is up when checked in sqldeveloper.

all responses would be appreciated.

Answers

  • 3310714
    3310714 Rank 6 - Analytics Lead

    Hi,


    Can you access your database from the OBI application server?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner
    Khalid Ibrahim wrote:My tnsnames.ora file under .../fmwconfig/bienv/core is just the way it should be.When I do a rowcount in the rpd in offline mode

    So you're talking about a 'nix server that can't connect but your Windows-based Admin Tool can connect?

    Looks like your server is having issues connecting to the database. Just because your client can connect does not mean your server can!

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Check firewall rules between BI Server and DB ...

  • Khalid Ibrahim
    Khalid Ibrahim Rank 4 - Community Specialist

    Thanks Thomas,

    How do I do that (check for firewall rules)?

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    From the OBIEE server you can check the following

    tnsping <net_service_name>

    eg: TNSPING ORCL

    and do a telnet as well

    telnet <dbhostname> <port number>

    eg:telnet mylaptop 1521

  • Khalid Ibrahim wrote:After restarting services ...

    So it was working before!

    Who is managing that server? Who is managing the DB? Who is managing the network? Ask these people who changed what and you will also find out why you can't connect your DB anymore from the BI server.

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Try a tnsping from the server to the DB ... if you get timeout there - it's usually (not always) because a firewall rule is in place. 

    Have your network team open up the DB server and port to your BI server...