Recently I was trying to understand the AUTOMATIC MEMORY MANAGEMENT feature of 11g onwards database & ended up in a drastic situation where I changed MEMORY_TARGET parameter with a value higher than MEMORY_MAX_TARGET
This has blocked the database from starting & a quick googling brought me to correct solution
As sys, connect to idle database
#sqlplus / as sysdba
SQL> create pfile from spfile;
–Applies to where spfile is used instead of pfile
Edit the pfile & comment/delete the MEMORY_MAX_TARGET parameter, get back to SQL>
SQL>create spfile from pfile;
SQL>startup;
This should resolve the error ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
Our Oracle application R12 (12.0.6) instance has JDK 6 environment & We don’t have any plans to migrate to any recent versions of Oracle Application those are supported by later Java environments.
Almost all users those use Oracle applications are using JRE for many other engineering programs (Calculations programs by Vendors) & frequent updates of the JRE happens automatically at the user ends. We have a significant crowd that is still using JRE 1.6_20 as base JRE, who seldom have the following issue(s) discussed below.
Over Windows 10, Internet Explorer 11 fails to load HTML pages properly & many times after the logon to the application, the HTML menu page is loaded in the explorer, leaving a 4-5 white space lines. Refer the image below
Basically this issue is observed with boxes those have latest JRE (x86) installed and used with parameter -Djava.vendor=”Sun Microsystems Inc.”
Oracle blogs strictly says, Compatibility view for Oracle applications R12 shouldn’t be enabled for Internet Explorer 11. I have tried enabling the Compatibility view for the Oracle applications, without any positive changes.
As a last resort, I reset the Internet Explorer 11
and after restarting the computer, Oracle Application HTML pages started loading correctly, without leaving white spaces between the IE Window and application top frame.
After long interval I am doing a Windows OS related topic, for which actually I started this blog. Once after ironing out most of the dreaded issues with Windows 7, I needed to continue blogging & whole attention was shifted to Oracle. Alas! Long years!
WSUS is Microsoft’s solution for enterprises those need to update their Windows boxes without consuming Internet bandwidth. Ie, the updates are downloaded to a centralized repository & clients receive the updates periodically without going to INTERNET. Rest you can read about WSUS from knowledge bases.
Now, we have a problem. We are a super hybrid environment where many machines are still running Windows XP, few laptops held by management running Windows 7, 8.x & rest running Windows 10. We spent months before going online with WSUS. We had lost count of times we made everything from scratches. Thank GOD, today we have a very balanced WSUS environment that does the intended job for us!
Our issues are mostly related to the updates not being installed, failing throughout the attempts & blocking new updates being distributed to the client machine that has an already failed update in the pipe.
The solution to this awkward situation is simple.
As Administrator go to Windows Services, stop and Windows Update service & disable it. By default Windows Update service has a startup mode “Manual”.
Go go C:\Windows (or to the Windows installation folder), located the “SoftwareDistribution” folder & rename/delete it. Don’t worry about the list of updates those appear from your regular “View Installed update history” page. You can still see the list of updates previous installed by going to “Control Panel\All Control Panel Items\Programs and Features” & click on “View installed updates” menu
Once the “SoftwareDistribution” folder is renamed or deleted, get back to the Services MMC & change the start mode back to “Manual” and start the Windows Update Service.
Normal conditions, this should initiate the Windows Update service afresh without any residues from the previous failed attempts & pending updates should get installed successfully.
