Apps DBA Workshop

In oracle database 11gR2 there is new feature has - High Availability Services . I am writing this article to describe how do we use it to check status/stop/start of has - high availability service. crsctl binary will exists in your 11.2.0.x Grid Infra home bin dir. So make sure you have set correct $ORACLE_HOME and $PATH env. variable. To check whether has configured to be started when the server restarts: bash-3.00$ crsctl config has CRS-4622: Oracle High Availability Services autostart is enabled. To Stop has (High Availability Service) service: bash-3.00$ crsctl stop has CRS-2791: Starting shutdown of Oracle High Availability Services-managed resourc es on 'nodedb' CRS-2673: Attempting to stop 'ora.evmd' on 'nodedb' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'nodedb' CRS-2673: Attempting to stop 'ora.ASMDATA1.dg' on 'nodedb' CRS-2677: Stop

I encountered this error while running dbua from 11gr2 Home and could not proceed further :( Error Message: $ORACLE_HOME/bin/sqlplus -S /NOLOG After lot of Investigation we found that the problem is setting the env. variables for 11gR2 ORACLE_HOME. Solution: Do not set any env variable related to both oracle homes 10g nor 11g and execute dbua manually from 11gR2 home path cd /11gR2_Home/bin ./dbua The env where dbua worked for me: HOME=/export/home/oratest HZ= LANG=C LOGNAME=oratest MAIL=/var/mail/oratest PATH=/usr/bin: SHELL=/bin/sh Hope this should solve the issue. Thanks for reading :)

The Below article illustrate all step by step methods Involved in performing out of place upgrade (11.2.0.2) in Oracle E-Business suite 11i Environment. For more Information on "Inplace and Out-of-place Upgrade" please refer http://appsdbaworkshop.blogspot.com/2011/03/oracle-11gr2-inplace-and-out-of-place.html Steps: 1) Perform all OS specific requirement for Installing 11gR2 Database. 2) Install 11.2.0.2 $ORACLE_HOME in separate home. 3) Install examples CD in 11.2.0.2 HOME 4) Copy Context_name.env, Initilization parameter files and oracle network configuration files to NEW home and update 11.2.0.2 settings 5) Source new env file and verify all variables 6) Create nls/data/9idata directory 7) Add ORA_NLS10 env variable to env file and verify the env variable 8) Apply additional interoperability database patches (Opatches) 9) Run Pre-upgrade tool 10) Update changes as recommended by pre-upgrade tool 11) Verify INVALID components 12) Check time zone file

I am writing this article to explain what actaully the terms "In place and Out of Place upgrade" . As so many Individuals keep on asking me this question and has been asked on forums too very frequently. This terms "In place and Out of Place upgrade" has been Introduced from 11.2.0.2 patchset. Explanation: If we look into prior release of oracle database's (9i/10g), the traditional upgrade method will be: --> Install base release. --> Install latest available patchset on top of base release --> proceed with your database upgrade. Consider a situation that you are upgrading from 9.2.0.8 to 10.2.0.5 the steps involved are: 1) Install oracle 10.2.0.1 base release software in a separate home. 2) Install oracle 10.2.0.5 patchset on top of 10.2.0.1 3) Proceed with the upgrade process. Now from release of 11.2.0.2 patchset the things have changed, you need not have to Install the base release i.e., 11.2.0.1 to apply the 11.2.0.2 patchset. You can Straight a

Hi, Recently we configured LUN from EMC Storage on one of our Apps 11i Staging Instance and ended up with root file system full. On investigation i found out there are heavy logfiles generating under directory /var/fm/fmd/ Output of df -h command: bash-3.00# df -h Filesystem size used avail capacity Mounted on /dev/dsk/c1t2d0s0 9.6G 9.5G 14M 100% / /devices 0K 0K 0K 0% /devices ctfs 0K 0K 0K 0% /system/contract File size under /var/fm/fmd directory: bash-3.00# ls -lrt total 2220152 drwx------ 2 root sys 512 Jun 20 2010 ckpt drwx------ 2 root sys 512 Jun 20 2010 rsrc drwx------ 2 root sys 512 Jun 20 2010 xprt -rw-r--r-- 1 root root 351 Jun 20 2010 fltlog -rw-r--r-- 1 root root 10083895 Mar 6 10:52 errlog.4 -rw-r--r-- 1 root root 161641879 Mar 7 20:31 errlog.3 -rw-r--r-- 1 root root 141316343 Mar 9

R12.1.1 rapidwiz not able to open Installation window on Oracle Enterprise Linux 5.5 even after successful completion of all pre-requisites. The error message while running rapidwiz: [root@erptest01 rapidwiz]# ./rapidwiz 4 dvd labels found Rapid Install Wizard will now launch the Java Interface..... [root@erptest01 rapidwiz]# Exception in thread "main" java.lang.UnsatisfiedLinkError: /R12_Dumps/StageR12/startCD/Disk1/rapidwiz/jre/Linux/1.6.0/lib/i386/xawt/libmawt.so: libXtst.so.6: cannot open shared object file: No such file or directory at java.lang.ClassLoader$NativeLibrary.load(Native Method) at java.lang.ClassLoader.loadLibrary0(Unknown Source) at java.lang.ClassLoader.loadLibrary(Unknown Source) at java.lang.Runtime.load0(Unknown Source) at java.lang.System.load(Unknown Source) at java.lang.ClassLoader$NativeLibrary.load(Native Method) at java.lang.ClassLoader.loadLibrary0(Unknown Source) at java.lang.ClassL