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>
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
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.
ReplyDeleteAuthorized 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 |
Thank you for your attention to this matter.
ReplyDeleteMobile phone Battery replacement|Mobile phone unlocking service | 100% genuine mobile parts | Mobile service center in chennai | Mobile service center in chennai | Mobile phone glass replacement | Mobile service center in chennai | Mobile phone unlocking service
ReplyDeleteI 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.
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.
ReplyDeleteData Analytics Training
This is quite charming post you shared, I like the post, an obligation of appreciation is all together for sharing..
ReplyDeletewhat is hrdf claimable
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!
ReplyDeleteData Science Training
Thanks for sharing this blog.
ReplyDeleteLow budget cottages in Ooty