Oracle Apps DBA Info

Monday, July 7, 2014

VirtualBox-4.2 installation on OEL 5

1. Download Virtaulbox software by running the below command.

wget http://download.virtualbox.org/virtualbox/4.2.16/VirtualBox-4.2-4.2.16_86992_el5-1.x86_64.rpm

[root@appsR12 ~]# wget http://download.virtualbox.org/virtualbox/4.2.16/VirtualBox-4.2-4.2.16_86992_el5-1.x86_64.rpm
--2014-07-07 09:22:24--  http://download.virtualbox.org/virtualbox/4.2.16/VirtualBox-4.2-4.2.16_86992_el5-1.x86_64.rpm
Resolving download.virtualbox.org... 137.254.120.26
Connecting to download.virtualbox.org|137.254.120.26|:80... connected.
HTTP request sent, awaiting response... 302 Moved Temporarily
Location: http://dlc.sun.com.edgesuite.net/virtualbox/4.2.16/VirtualBox-4.2-4.2.16_86992_el5-1.x86_64.rpm [following]
--2014-07-07 09:22:25--  http://dlc.sun.com.edgesuite.net/virtualbox/4.2.16/VirtualBox-4.2-4.2.16_86992_el5-1.x86_64.rpm
Resolving dlc.sun.com.edgesuite.net... 122.165.249.8, 122.165.249.40
Connecting to dlc.sun.com.edgesuite.net|122.165.249.8|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 87237668 (83M) [application/x-redhat-package-manager]
Saving to: `VirtualBox-4.2-4.2.16_86992_el5-1.x86_64.rpm.1'

 100% [                                                                                                                 ] 756,155      151K/s  eta 9m 18s  
[root@appsR12 ~]#

2. Now install it.

[root@appsR12 ~]# rpm -iUvH VirtualBox-4.2-4.2.16_86992_el5-1.x86_64.rpm
warning: VirtualBox-4.2-4.2.16_86992_el5-1.x86_64.rpm: Header V4 DSA signature: NOKEY, key ID 98ab5139
Preparing packages for installation...
VirtualBox-4.2-4.2.16_86992_el5-1

Creating group 'vboxusers'. VM users must be member of that group!

No precompiled module for this kernel found -- trying to build one. Messages
emitted during module compilation will be logged to /var/log/vbox-install.log.

Stopping VirtualBox kernel modules [  OK  ]
Recompiling VirtualBox kernel modules [  OK  ]
Starting VirtualBox kernel modules [  OK  ]

Saturday, July 5, 2014

ERROR: ORA-12162: TNS:net service name is incorrectly specified

I just installed oracle software and trying to connect sqlplus
When I say sqlplus, it was giving an error.

-bash-3.00$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jul 6 00:54:32 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-12162: TNS:net service name is incorrectly specified


Enter user-name:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified


Enter user-name:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

I forgot to export ORACLE_SID
I exported the ORACLE_SID and tried again, it was successful


-bash-3.00$ export ORACLE_SID=prod


-bash-3.00$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jul 6 01:04:52 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> exit
Disconnected

It was just a thought to share, to those who forgets like me !

Error 6 initializing SQL*Plus

When I tried to connect sqlplus was giving an error.

-bash-3.00$ sqlplus '/as sysdba'
Error 6 initializing SQL*Plus
Message file sp1.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

Log out from the user and login again. Don't source any environment variables yet.
Check the location of your correct oracle home by going into the directory. Export the oracle home

-bash-3.00$ export ORACLE_HOME=/u01/oracle/product/10.2.0/db_1
-bash-3.00$ export PATH=$ORACLE_HOME/bin:$PATH:.

Now try log in again


-bash-3.00$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jul 6 01:04:52 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> exit

Thursday, July 3, 2014

Concurrent Manager Status from Sql

How to find all the concurrent managers status from sql prompt?

To find this I need to launch oracle application forms which almost takes 5minutes for me. So I was thinking a way which gives the info quicker and also without launching forms.

Below is the query somehow I found somewhere and I want to share this with you all.

select q.concurrent_queue_name || ' - ' || target_node qname,
       q.running_processes actual,
       q.max_processes target,
       sum(decode(r.phase_code,'R',1,0)) - sum(decode(r.status_code,'W',1,0)) running,
       sum(decode(r.phase_code,'P',1,0)) pending,
       nvl(sum(decode(r.status_code,'W',1,'H',1,'S',1,'A',1,'Z',1,0)),0) paused,
       nvl(sum(decode(r.status_code,'F',1,'Q',1,'B',1,'T',0)),0) influx,
       avg((nvl(r.actual_start_date,r.requested_start_date) - r.requested_start_date)*1440) avgqtime
  from applsys.fnd_concurrent_requests r,
       applsys.fnd_concurrent_processes p,
       applsys.fnd_concurrent_queues q
 where r.controlling_manager (+) = p.concurrent_process_id
   and p.queue_application_id = q.application_id
   and p.concurrent_queue_id = q.concurrent_queue_id
   and q.max_processes > 0
   group by q.concurrent_queue_name || ' - ' || target_node, q.running_processes, q.max_processes;
   
Activated Concurrent Queue           Actual  Target  Running  Pending   Paused   InFlux  AvgQtime
----------------------------------- ------- ------- -------- -------- -------- -------- ---------
INVMGR - DEVCM                           3       3        0        0        0        0       .56
Alerts - DEVCM                           4       4        0        0        0        0    248.44
PODAMGR - DEVCM                          6       6        0        0        0        0
INVTMRPM - DEVCM                         5       5        0        0        0        0
RCVOLTM - DEVCM                          3       3        0        0        0        0
IEU_WL_CS - DEVCM                        1       1        0        0        0        0
FNDICM - DEVCM                           1       1        0        0        0        0
WFMLRSVC - DEVCM                         1       1        0        0        0        0
Debug_Service - DEVCM                    1       1        0        0        0        0
MRPMGR - DEVCM                           1       1        0        1        0        1  -1307.38
WFALSNRSVC - DEVCM                       1       1        0        0        0        0
OAMCOLMGR - DEVCM                        1       1        0        0        0        0
IEXCONMGR - DEVCM                        1       1        0        0        0        0
XDP_Q_EVENT_SVC - DEVCM                  1       1        0        0        0        0
FNDCRM - DEVCM                           1       1        0        0        0        0
XDP_MANAGER - DEVCM                      2       2        0        0        0        0    279.66
FNDCPOPP - DEVCM                         5       5        0        0        0        0
XDP_Q_IN_MSG_SVC - DEVCM                 1       1        0        0        0        0
STANDARD - DEVCM                        30      30        0        1        0        0     61.78
CEMLIQM - DEVCM                         10      10        0        0        0        0       .17
IEU_SH_CS - DEVCM                        1       1        0        0        0        0
WFWSSVC - DEVCM                          1       1        0        0        0        0
PASMGR - DEVCM                           1       1        0        0        0        0    -12.54
C_AQCT_SVC - DEVCM                       1       1        0        0        0        0
FNDSM_DEVCM - DEVCM                     1       1        0        0        0        0
                                    ------- ------- -------- --------
sum                                      84      84        0        2

Monday, June 30, 2014

Estimate RMAN Backup Size

I got a task to estimate RMAN backup size.

How much 3days RMAN backup occupy?

How long it will take to complete?

Is the backup size is reasonable?

Is there a way to reduce the backup size?

I have used the below query to find the size and time taken for backup.

set lines 220
set pages 1000
col cf for 9,999
col df for 9,999
col elapsed_seconds heading "ELAPSED|SECONDS"
col i0 for 9,999
col i1 for 9,999
col l for 9,999
col output_mbytes for 9,999,999 heading "OUTPUT|MBYTES"
col session_recid for 999999 heading "SESSION|RECID"
col session_stamp for 99999999999 heading "SESSION|STAMP"
col status for a10 trunc
col time_taken_display for a10 heading "TIME|TAKEN"
col output_instance for 9999 heading "OUT|INST"
select
  to_char(j.start_time, 'yyyy-mm-dd hh24:mi:ss') start_time,
  to_char(j.end_time, 'yyyy-mm-dd hh24:mi:ss') end_time,
  (j.output_bytes/1024/1024) output_mbytes, j.status, j.input_type,
  decode(to_char(j.start_time, 'd'), 1, 'Sunday', 2, 'Monday',
                                     3, 'Tuesday', 4, 'Wednesday',
                                     5, 'Thursday', 6, 'Friday',
                                     7, 'Saturday') dow,
  j.elapsed_seconds, j.time_taken_display,
  x.cf, x.df, x.i0, x.i1, x.l,
  ro.inst_id output_instance
from v$RMAN_BACKUP_JOB_DETAILS j
  left outer join (select
                     d.session_recid, d.session_stamp,
                     sum(case when d.controlfile_included = 'YES' then d.pieces else 0 end) CF,
                     sum(case when d.controlfile_included = 'NO'
                               and d.backup_type||d.incremental_level = 'D' then d.pieces else 0 end) DF,
                     sum(case when d.backup_type||d.incremental_level = 'D0' then d.pieces else 0 end) I0,
                     sum(case when d.backup_type||d.incremental_level = 'I1' then d.pieces else 0 end) I1,
                     sum(case when d.backup_type = 'L' then d.pieces else 0 end) L
                   from
                     v$BACKUP_SET_DETAILS d
                     join v$BACKUP_SET s on s.set_stamp = d.set_stamp and s.set_count = d.set_count
                   where s.input_file_scan_only = 'NO'
                   group by d.session_recid, d.session_stamp) x
    on x.session_recid = j.session_recid and x.session_stamp = j.session_stamp
  left outer join (select o.session_recid, o.session_stamp, min(inst_id) inst_id
                   from Gv$RMAN_OUTPUT o
                   group by o.session_recid, o.session_stamp)
    ro on ro.session_recid = j.session_recid and ro.session_stamp = j.session_stamp
where j.start_time > trunc(sysdate)-&NUMBER_OF_DAYS
order by j.start_time
/

Enter value for number_of_days: 1                                                                                                                                                           
                                                                                                                                                           
                                            OUTPUT                                       ELAPSED TIME                                            OUT       
START_TIME          END_TIME                MBYTES STATUS     INPUT_TYPE    DOW          SECONDS TAKEN          CF     DF     I0     I1      L  INST       
------------------- ------------------- ---------- ---------- ------------- --------- ---------- ---------- ------ ------ ------ ------ ------ -----       
2014-06-28 13:18:05 2014-06-28 13:18:08     13,512 FAILED     DB FULL       Saturday           3 00:00:03        1      0      0      0      0     1       
2014-06-28 13:26:11 2014-06-28 13:26:15     11,348 FAILED     DB FULL       Saturday           4 00:00:04        1      0      0      0      0     1       
2014-06-28 17:30:58 2014-06-28 19:07:44     21,370 COMPLETED  DB FULL       Saturday        5806 01:36:46        3      4      0      0      0     1       
2014-06-28 19:08:09 2014-06-28 19:08:16          0 FAILED     ARCHIVELOG    Saturday           7 00:00:07                                          1       
2014-06-28 20:26:00 2014-06-28 20:51:46      5,112 COMPLETED  ARCHIVELOG    Saturday        1546 00:25:46        1      0      0      0      4     1

This is how estimated the size of the backup from Database.

SQL> select sum(bytes)/1024/1024 from v$datafile;                                                                                                          
                                                                                                                                                           
SUM(BYTES)/1024/1024                                                                                                                                       
--------------------                                                                                                                                       
             50387.5                                                                                                                                       
                                                                                                                                                           
SQL> select sum(bytes)/1024/1024 from dba_free_space;                                                                                                      
                                                                                                                                                           
SUM(BYTES)/1024/1024                                                                                                                                       
--------------------                                                                                                                                       
          23501.5625                                                                                                                                       
                                                                                                                                                           
SQL>                           

50387.5 - 23501.5625 = 26885.9375 = 26GB

I reviewed the below notes for the same.
How to estimate the size of an RMAN database backup (Doc ID 1274720.1)
A Complete Understanding of RMAN Compression (Doc ID 563427.1)

Sunday, June 29, 2014

ouicli.pl INSTE8_APPLY 255 (or) ERROR: Failed to execute adclone.pl

I got the below issue while Cloning ORACLE HOME from source to target. I have copied the binaries from source and initiated adcfclone. It failed
with below errror.





[oradev@host01 bin]$ perl adcfgclone.pl dbTechStack



                     Copyright (c) 2002 Oracle Corporation

                        Redwood Shores, California, USA



                        Oracle Applications Rapid Clone



                                 Version 12.0.0



                      adcfgclone Version 120.31.12010000.8



Enter the APPS password :



Running:

/u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone/bin/../jre/bin/java

u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone/jlib/xmlparserv2.jar:

pps.ad.context.CloneContext -e /u01/app/oradev/product/11.2.0/dbhome_1/apps

29191.lst -stage /u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone -db



Log file located at /u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone/



Provide the values required for creation of the new Database Context file.



Beginning rdbms home Apply - Sat Jun 28 16:27:21 2014



/u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true  -Doracle.installer.oui_loc=/u01/app/oradev/product/11.2.0/dbhome_1/oui -classpath /u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone/jlib/xmlparserv2.jar:/u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone/jlib/ojdbc5.jar:/u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone/jlib/java:/u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone/jlib/oui/OraInstaller.jar:/u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone/jlib/oui/ewt3.jar:/u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone/jlib/oui/share.jar:/u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone/jlib/oui/srvm.jar:/u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone/jlib/ojmisc.jar   oracle.apps.ad.clone.ApplyDBTechStack -e /u01/app/oradev/product/11.2.0/dbhome_1/appsutil/DEV_host01.xml -stage /u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone   -showProgress

APPS Password : Log file located at /u01/app/oradev/product/11.2.0/dbhome_1/appsutil/log/DEV_host01/ApplyDBTechStack_06281527.log

  \      0% completed       RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack



ERROR while running Apply...

Sat Jun 28 16:27:53 2014



 ERROR: Failed to execute /u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone/bin/adclone.pl

Checked for the exact log file located u01/app/oradev/product/11.2.0/dbhome_1/appsutil/log/DEV_host01/ApplyDBTechStack_06281527.log


  [APPLY PHASE]

  AutoConfig could not successfully execute the following scripts:

    Directory: /u01/app/oradev/product/11.2.0/dbhome_1/perl/bin/perl -I /u01/app/oradev/product/11.2.0/dbhome_1/perl/lib/5.8.3 -I /u01/app/oradev/product/11.2.0/dbhome_1/perl/lib/site_perl/5.8.3 -I /u01/app/oradev/product/11.2.0/dbhome_1/appsutil/perl /u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone

      ouicli.pl               INSTE8_APPLY       255


AutoConfig is exiting with status 1



RC-50013: Fatal: Instantiate driver did not complete successfully.

I have checked the perl version installed in ORACLE HOME and on the /usr/bin.
The versions are different.





[oradev@host01 bin]$ /u01/app/oradev/product/11.2.0/dbhome_1/perl/bin/perl --version



This is perl, v5.10.0 built for x86_64-linux-thread-multi



Copyright 1987-2007, Larry Wall



Perl may be copied only under the terms of either the Artistic License or the

GNU General Public License, which may be found in the Perl 5 source kit.



Complete documentation for Perl, including FAQ lists, should be found on

this system using "man perl" or "perldoc perl".  If you have access to the

Internet, point your browser at http://www.perl.org/, the Perl Home Page.



[oradev@host01 bin]$ perl --version



This is perl, v5.10.1 (*) built for x86_64-linux-thread-multi



Copyright 1987-2009, Larry Wall



Perl may be copied only under the terms of either the Artistic License or the

GNU General Public License, which may be found in the Perl 5 source kit.



Complete documentation for Perl, including FAQ lists, should be found on

this system using "man perl" or "perldoc perl".  If you have access to the

Internet, point your browser at http://www.perl.org/, the Perl Home Page.



[oradev@host01 clone]$ echo $PATH

/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/u01/app/oradev/bin

[oradev@host01 clone]$ which perl

/usr/bin/perl

Exported the ORACLE_HOME perl into PATH variable and the issue was resolved.





Solution:

---------

[oradev@host01 bin]$ export PATH=/u01/app/oradev/product/11.2.0/dbhome_1/perl/bin/perl:$PATH:.



[oradev@host01 bin]$ echo $PATH

/u01/app/oradev/product/11.2.0/dbhome_1/perl/bin/perl:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/u01/app/oradev/bin:.

And then dbTechStack went successful.


[oradev@host01 bin]$ perl adcfgclone.pl dbTechStack /u01/app/oradev/product/11.2.0/dbhome_1/appsutil/DEV_host01.xml



                     Copyright (c) 2002 Oracle Corporation

                        Redwood Shores, California, USA



                        Oracle Applications Rapid Clone



                                 Version 12.0.0



                      adcfgclone Version 120.31.12010000.8



Enter the APPS password :





Running Rapid Clone with command:

perl /u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone/bin/adclone.pl java=/u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone/bin/../jre mode=apply stage=/u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone component=dbTechStack method=CUSTOM dbctxtg=/u01/app/oradev/product/11.2.0/dbhome_1/appsutil/DEV_host01.xml showProgress contextValidated=false

Running:

perl /u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone/bin/adclone.pl java=/u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone/bin/../jre mode=apply stage=/u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone component=dbTechStack method=CUSTOM dbctxtg=/u01/app/oradev/product/11.2.0/dbhome_1/appsutil/DEV_host01.xml showProgress contextValidated=false

APPS Password :



Beginning rdbms home Apply - Sat Jun 28 16:39:08 2014



/u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false  -Doracle.installer.oui_loc=/u01/app/oradev/product/11.2.0/dbhome_1/oui -classpath /u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone/jlib/xmlparserv2.jar:/u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone/jlib/ojdbc5.jar:/u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone/jlib/java:/u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone/jlib/oui/OraInstaller.jar:/u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone/jlib/oui/ewt3.jar:/u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone/jlib/oui/share.jar:/u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone/jlib/oui/srvm.jar:/u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone/jlib/ojmisc.jar   oracle.apps.ad.clone.ApplyDBTechStack -e /u01/app/oradev/product/11.2.0/dbhome_1/appsutil/DEV_host01.xml -stage /u01/app/oradev/product/11.2.0/dbhome_1/appsutil/clone   -showProgress

APPS Password : Log file located at /u01/app/oradev/product/11.2.0/dbhome_1/appsutil/log/DEV_host01/ApplyDBTechStack_06281539.log

  |      0% completed

Log file located at /u01/app/oradev/product/11.2.0/dbhome_1/appsutil/log/DEV_host01/ApplyDBTechStack_06281539.log

  \      0% completed



Completed Apply...

Sat Jun 28 16:41:08 2014



Starting database listener for DEV:

Running:

/u01/app/oradev/product/11.2.0/dbhome_1/appsutil/scripts/DEV_host01/addlnctl.sh start DEV

Logfile: /u01/app/oradev/product/11.2.0/dbhome_1/appsutil/log/DEV_host01/addlnctl.txt



You are running addlnctl.sh version 120.1.12010000.4





Starting listener process DEV ...





LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 28-JUN-2014 16:41:10



Copyright (c) 1991, 2011, Oracle.  All rights reserved.



Starting /u01/app/oradev/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...



TNSLSNR for Linux: Version 11.2.0.3.0 - Production

System parameter file is /u01/app/oradev/product/11.2.0/dbhome_1/network/admin/DEV_host01/listener.ora

Log messages written to /u01/app/oradev/product/11.2.0/dbhome_1/admin/DEV_host01/diag/tnslsnr/host01/DEV/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host01.demo.com)(PORT=1534)))



Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host01.demo.com)(PORT=1534)))

STATUS of the LISTENER

------------------------

Alias                     DEV

Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production

Start Date                28-JUN-2014 16:41:11

Uptime                    0 days 0 hr. 0 min. 0 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/oradev/product/11.2.0/dbhome_1/network/admin/DEV_host01/listener.ora

Listener Log File         /u01/app/oradev/product/11.2.0/dbhome_1/admin/DEV_host01/diag/tnslsnr/host01/DEV/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host01.demo.com)(PORT=1534)))

Services Summary...

Service "DEV" has 1 instance(s).

  Instance "DEV", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully



addlnctl.sh: exiting with status 0



addlnctl.sh: check the logfile /u01/app/oradev/product/11.2.0/dbhome_1/appsutil/log/DEV_host01/addlnctl.txt for more information ...

Friday, June 27, 2014

Clear Cache in Oracle Apps R12

Follow the below navigation to clear all middle tier cache in Oracle Apps R12.

Functional Administrator-->Core Services-->Caching Framework-->Global Configuration-->Clear All Cache-->Click on Yes. You will get a confirmation that all middle tier cache is cleared.