Skip to main content

Posts

Showing posts from April, 2019

Online Patches for the RDBMS

Assume you are closing your month-end periods, running Create Accounting for Finance and OPM modules and finance stakeholders report this issue – So, first thing we do is check request logs for Journal Import program– Checking alert log gave me, After raising ticket with Oracle, they gave us Patch – 23268430. Readme gave us below information, online patchable may sound familiar to most of view, but was something new for me, so thought of documenting this. Going through 761111.1 got some key highlights that are worth noting – 1. Online RDBMS patches are special patches that are applied on live instance, no shutting down of database instance. 2. A shared library is constructed with relevant fixes. 3. They internally use oradebug to apply patch. 4. Oradebug is responsible to inform each process to map shared library into their address space, original function changes to jump to new version in shared library and resolve references to right m...