Printable View
hi everybody,
I get
ORA-00600: internal error code, arguments: [17182], [211804268], [], [], [],[], [], []
whenever i do
SELECT TO_CHAR(sysdate,'mm/dd/yyyy') FROM DUAL;
In init.ora i have set
CURSOR_SHARING = FORCE .
when i remove this line from init.ora i do not get the error.
can anyone tell why is this error coming?
What is your database version? What is the OS?
You may be hitting the BUG#1365873.
Sam
I am using Oracle 8.1.7 with Windows NT(Workstaion) SP6.
Thanks and Regards
This could be due to some memory corruption on the server. Interms of oracle it was a heap corruption. Run a memory check on the server. If you find it all to be in a good shape, try applying the Oracle patchset. Though it was said that oracle 8.1.7.2.6 fixed
"Bug:1752554
RDBMS: ORA-600 [17182] When selecting DB2 data type of CHAR in a JAVA application "
I don't know how much this would apply to your problem. So try applying the latest patchset for Oracle and then monitor to see whether this problem still exists and if it were to exists still then contact oracle.
Sam
hi sam,
I applied Patch 8.1.7.1.5 and that did the magic, now I can run all queries with to_char conversion.
Thanks a lot