Category Archives: Oracle
I recently upgraded my production instance to 11i.ATG_PF.H RUP 5 and replaced JInitiator with the Sun JRE Plugin. To be able to use Linux with the application’s applets, just perform the following steps: Install Mozilla Firefox if you don’t already have it. Download the supported JRE. In my case, it is 1.5.0_12. Because Oracle cannot […]
As I come across useful scripts, I create SQL Developer reports to retain them. Some of my reports may not work in your environment, but please feel free to download them and try them out using the link below. SQL Developer User Defined Reports
Issue You need to change the SYSTEM, APPS, and Oracle Applications schema passwords. Solution Run the linked Apps Change Passwords Script on an application tier.After changing the passwords, run Autoconfig on each of the Application Tier Nodes.
Issue You have online redo log files in the wrong place and want to move them. Solution Run the following SQL to locate the current redo log groups and their members: select l.group# group_number , l.status group_status , f.member group_member , f.status file_status from v$log l , v$logfile f where l.group# = f.group# order by […]