Wednesday, October 11, 2017

ORA-00600: internal error code, arguments: [17285], [0x1109F69A0]

ORA-00600: internal error code, arguments: [17285], [0x1109F69A0], [1], [0x700000ED7586810], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Wed Oct 11 16:37:11 2017
Sweep [inc][1123699]: completed

Cause: It was due to Bug 17984204.

Solution: Change the value of parameter _session_cached_instantiations set it to open_cursors+1 . Restart the instance. Note that this is not an official workaround so it may not work in some environments. 


SQL> show parameter open_cursors

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
open_cursors                         integer     6000

SQL> alter system set "_session_cached_instantiations"= 6001 scope=spfile;

System altered.


SQL>
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area 3.9272E+10 bytes
Fixed Size                  2593640 bytes
Variable Size            5100276888 bytes
Database Buffers         3.4158E+10 bytes
Redo Buffers               10874880 bytes
Database mounted.
Database opened.
SQL>
SQL> exit

7 comments:

  1. Nice post. By reading your blog, i get inspired and this provides some useful information. Thank you for posting this exclusive post for our vision. 
    Authorized macbook pro service center in Chennai | Macbook pro service center in chennai | iMac service center in chennai | Mac service center in chennai | Macbook pro service center in chennai |

    ReplyDelete

  2. I just use pass4sure Oracle dumps from Dumpspass4sure and prepare my final exam for the Oracle. You know what I got same questions in final paper just 2 or 3 questions were variant but the concept was same as it’s given in that PDF dumps. I passed my exam week ago and looking for other certification which can help me in my career. Of course I’ll use this source full platform again and will keep using it. Ill recommend to everyone and Good luck guys.

    ReplyDelete
  3. On the off chance that your searching for Online Illinois tag sticker restorations, at that point you have to need to go to the privileged place.
    Data Analytics Training

    ReplyDelete
  4. This is quite charming post you shared, I like the post, an obligation of appreciation is all together for sharing..
    what is hrdf claimable

    ReplyDelete
  5. This is my first time visit here. From the tons of comments on your articles.I guess I am not only one having all the enjoyment right here!
    Data Science Training


    ReplyDelete