topic Re: TNS: connect Timeout Occured in QlikView

TNS: connect Timeout Occured

Sat, 07 Jan 2017 06:15:10 GMT

Today some reloads get failed and in log its showing

this error,

Error: SQL##f - SqlState: S1000, ErrorCode: 12170, ErrorMsg: [Oracle][ODBC][Ora]ORA-12170: TNS:Connect timeout occurred

I have reloaded the task manually and its working fine.

But want to know why this error occur.

Thanks in Advance

Regards,

Swati

Re: TNS: connect Timeout Occured

Sat, 07 Jan 2017 11:14:48 GMT

In the other , i found the below Error

07/01/2017 4:31:42 AM: Error: SQL##f - SqlState: 08004, ErrorCode: 1034, ErrorMsg: [Oracle][ODBC][Ora]ORA-01034: ORACLE not available

07/01/2017 4:31:42 AM: ORA-27101: shared memory realm does not exist

07/01/2017 4:31:42 AM: IBM AIX RISC System/6000 Error: 2: No such file or directory

Re: TNS: connect Timeout Occured

vinieme12 — Sat, 07 Jan 2017 15:41:22 GMT

These messages are returned by the database and not qlikview related errors, so you might want to check with the database team as to why they occured.

Re: TNS: connect Timeout Occured

Chip_Matejowsky — Sat, 07 Jan 2017 16:01:37 GMT

I agree with Vineeth

A Google search on the error returns the following:
ORA-01034 - Oracle not availabe | Oracle Community

ORA-01034: ORACLE not available ORA-27101: shar... | Oracle Community

ORA-01034: ORACLE not available tips

Hope this helps

-Chip

Re: TNS: connect Timeout Occured

Anonymous — Sat, 07 Jan 2017 16:15:09 GMT

You can often get those Oracle errors if the Oracle database is down or in a seriously poorly way.

Probably one for your dba to investigate.