ORA-04063: ORA-04063: package body "EXFSYS.DBMS_RLMGR_DR" has errors

Noticed Below error in Alert log file:

ORA-12012: error on auto execute of job 42585
ORA-04063: ORA-04063: package body "EXFSYS.DBMS_RLMGR_DR" has errors
ORA-06508: PL/SQL: could not find program unit being called: "EXFSYS.DBMS_RLMGR_DR"
ORA-06512: at line 1 has errors

Solution I tried:

Re-created "EXFSYS" sample schema using the below commmand.

Step 1: Login as SYSDBA
Step 2: @$ORACLE_HOME/rdbms/admin/catexf.sql

How do I install Sample Schema in Oracle 10g

You can you use the below step to install Sample schema (hr,oe etc) Oracle 10g

Execute the below script after login as SYSDBA.

SQL>$ORACLE_HOME/demo/schema/mksample.sql

ORA-38301: can not perform DDL/DML over objects in Recycle Bin

I noticed the below error while using drop user cascade;

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-38301: can not perform DDL/DML over objects in Recycle Bin

Solution I tried:

SQL>ALTER SESSION SET RECYCLEBIN=OFF;

Solaris Guest Addition Installation for x86 Solaris Virtual Machine

You can use the below steps to install Solaris Guest Addition Installation for x86 Solaris Virtual Machine

Step 1: Start the Solaris Virtual Machine (VirtualBox-3.0.10-54097-Win.exe)
Step 2: with Solaris Window selected, choose Devices -> Install Guest Additions.
Step 3: CD icon will show up from desktop
Step 4: Login as root using terminal window
Step 5: Go to VBoxSolarisAdditions.pkg using the below
#cd /cdrom/vboxadditions_3.0.10_54097
Step 6: Execute the below command to add Virtual Box Additions.
#pkgadd –d VBoxSolarisAdditions.pkg
Step 7: Final Message should show as “Installation of was successful”.

Oracle Database Performance Tuning Methods/Approaches

We can use the below Approaches to avoid Oracle Database Performance slowness:

Approach 1: Check the long running queries parallely collect the statistics all the queries running on DB
Approach 2: Do the Explain plan query by query
Approach 3: Analyze Tablescans and Index scan (Create index if necessary)
Approach 4: Create Partition if necessary and also if the license supports
Approach 5: Purge recycle bin (if it is 10g)
Approach 6: SQL trace with TKProf
Approach 7: we can go ahead with Optimizer hints if required
Approach 8: Analyze the whole database schemas
Approach 9: Coalesce the tablespace.
Approach 10: Rebuild mulitple objects if necessary.
Approach 11: Configure Statspack Report.
Approach 12: Analyze the Statspack Report.
Approach 13: We need to check whether all the database objects placed in USERS or Manually Created Tablespace (Some times all the objects will be placed on SYSTEM or SYSAUX Tablespace, this may cause performance slowness)
Approach 14: For network related performance issue we can use SDU and TDU parameters.

How do I set ORACLE Environment Variable

Execute the below steps to set Environment variable for UNIX:

Step 1: Login as oracle
Step 2: Execute the below command to set ORACLE_HOME and ORACLE_SID
. /usr/local/bin/oraenv

How do you enable Java Console trace options (Oracle Jinitiator) in Client Machine?

Description:
Jinitiator is a Java Virtual Machine (JVM) responsible for running the Forms Java client. We can enable trace information client machine for Forms.

Set the following Java runtime parameters in the Jinitiator Control Panel (tabs) will enable Jinitiator tracing

Start -> JInitiator Control Panel ->
Basic Tab:
Click on Enable JInitiator
Click on Java Console
Network access is Applet Host
Set Java Run Time Parameters as -mx64m -Dcache.size=50000000 -Djavaplugin.trace=true -Djavaplugin.trace.option=basic
Advanced Tab:
Java Run Time Environment as Use Jinitiator Default
Click on Enable Just In Time Compiler, Default JIT Path is symcjit
Click on Enable Debug, Default Debug Port 2502
Proxies Tab:
Click on Use browser settings
After changing all the values restart the client machine. This will produce a trace file, Jinitiator.trace in the User Home Directory. For example, if the User Home Directory is C:\Documents and Settings\username and Jinitiator version is used.
Or
Java Console window automatically opens with trace information.