nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

ODBC error Ora 12170 (connect time out) OBIEE 12.2.1.2

Khalid Ibrahim

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.

Find more posts tagged with

Accepted answers

All comments

3310714

Hi,

Can you access your database from the OBI application server?

[Deleted User]

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

Check firewall rules between BI Server and DB ...

Khalid Ibrahim

Thanks Thomas,

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

Sherry George

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

Gianni Ceresa

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

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