Error accessing package DBMS_APPLICATION_INFO

Noticed the below error when I try to connect the database through client.

ERROR:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_OUTPUT.DISABLE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

ERROR:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_APPLICATION_INFO.SET_MODULE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


Error accessing package DBMS_APPLICATION_INFO
SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.

Solution I tried:

I executed the below files after logging in as SYSDBA

SQL>@$ORACLE_HOME/rdbms/admin/dbmsotpt.sql
SQL>@$ORACLE_HOME/rdbms/admin/dbmsapin.sql

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