Search Form
Music
Oracle
Personal
Category Archives: Oracle
Linux + Oracle Apps + Sun JRE Plugin
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 […]
<span class="entry-utility-prep entry-utility-prep-cat-links">Posted in</span> Applications, Linux, Oracle
<span class="entry-utility-prep entry-utility-prep-tag-links">Tagged</span> 11i, e-business suite, java, jinitiator, jre, Linux, plugin
2 Comments
Custom SQL Developer Reports
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
<span class="entry-utility-prep entry-utility-prep-cat-links">Posted in</span> SQL Developer
Leave a comment
How To Change Oracle Apps System Passwords
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.
<span class="entry-utility-prep entry-utility-prep-cat-links">Posted in</span> Applications, Database, Oracle
Leave a comment
How To Move Online Redo Logs While Database Is Running
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 […]
<span class="entry-utility-prep entry-utility-prep-cat-links">Posted in</span> Database, Oracle
2 Comments