53 reputation
17
bio website
location
age
visits member for 1 year, 7 months
seen Sep 14 '13 at 19:54

Sep
14
awarded  Notable Question
May
30
comment Oracle database link via ODBC to SQL Server does not recover automatically
OK, I will try to analyse the logfiles, and come back to you after that. Do you have a link which lists the 12+ ODBC errors?
May
29
revised Oracle database link via ODBC to SQL Server does not recover automatically
added 399 characters in body
May
29
comment Oracle database link via ODBC to SQL Server does not recover automatically
"Hence drop and recreate the dblink does not affect or change the network or ODBC problem": my practical experience proves this wrong. The only remedy for the persisting error messages is a drop and re-create of the database link. But you are right: Oracle does not open or check the connection when the link is created; only when the first statement is executed, a connection is created. I've updated the post according to this fact.
May
29
comment Oracle database link via ODBC to SQL Server does not recover automatically
the setting seems OK, HS=OK was set. Can you clarify the second point in your post? What do you mean by "without causing any issue"? Also "when the link is requested again", do you mean reused by a query? And "drop and re-creation does not have any sense", in which way? To me it works, but in my oppinion it should not be the route to go.
May
29
asked Oracle database link via ODBC to SQL Server does not recover automatically
May
25
awarded  Informed
Feb
20
awarded  Popular Question
Sep
20
revised ora-01410 invalid RowID sporadically in a select statement
added 114 characters in body
Sep
20
awarded  Scholar
Sep
20
accepted ora-01410 invalid RowID sporadically in a select statement
Sep
20
comment ora-01410 invalid RowID sporadically in a select statement
That's it! The system started an index rebuild while the select statement ran.
Sep
18
awarded  Supporter
Sep
17
comment ora-01410 invalid RowID sporadically in a select statement
Nice pointer, I will investigate this in more detail, and come back to you in a short while.
Sep
17
comment ora-01410 invalid RowID sporadically in a select statement
@ypercube: yes I am sure, our exception handling writes the error code and the causing statement into a log-file.
Sep
17
revised ora-01410 invalid RowID sporadically in a select statement
added 37 characters in body
Sep
17
awarded  Editor
Sep
17
revised ora-01410 invalid RowID sporadically in a select statement
added 3 characters in body
Sep
17
awarded  Student
Sep
17
asked ora-01410 invalid RowID sporadically in a select statement