DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ORA-00600: arguments: [17182] [211804268]

  1. #1
    Join Date
    Dec 2001
    Posts
    3
    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?
    Amar Subba

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    What is your database version? What is the OS?

    You may be hitting the BUG#1365873.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Dec 2001
    Posts
    3
    I am using Oracle 8.1.7 with Windows NT(Workstaion) SP6.
    Thanks and Regards
    Amar Subba

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Dec 2001
    Posts
    3
    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
    Amar Subba

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width