| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> application dump core after running statement "alter system flush shared_pool"
After upgrading oracle server to 9.2.0.8.0 from 9.2.0.4.0 our
application running on other machine is dumping core because of SEGV
signal after running the following statement on DB machine:
SQL> alter system flush shared_pool;
As client stack got corrupted after running the above statement on DB machine ,so we could not specify the exact location of core in the stack from the core file.
Our application continuously do DB heart Beat query using OCI library.
We are using following OCI calls in doing DB heart beat....
OCIDefineByPos(stmthp, &dfnhp[ 0 ], errhp, (ub4) 1 , (dvoid *)
dummyvar, (sb4) 2, SQLT_STR, (dvoid *)0, (ub2 *)0, (ub2 *)0,
(ub4)OCI_DEFAULT))
OCIStmtExecute(svchp, stmthp, errhp, (ub4)1, (ub4)0,(CONST OCISnapshot
*)0, (OCISnapshot *)0,OCI_DEFAULT);
OCIStmt is "SELECT DUMMY FROM DUAL"
what had changed in the version 9.2.0.8.0 which could have resulted in core probably due to OCI library which is still using older client i.e. 9.2.0.4.0. This problem is readily reproducible with new oracle version as given below:
 |
 |