Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
ODBC error Ora 12170 (connect time out) OBIEE 12.2.1.2

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
-
Hi,
Can you access your database from the OBI application server?0 -
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!
0 -
Check firewall rules between BI Server and DB ...
0 -
Thanks Thomas,
How do I do that (check for firewall rules)?
0 -
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
0 -
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.
0 -
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...
0