12.1.1 rapidwiz - libmwat.so libXext.so.6 libXtst.so.6 not found on OEL6U3:

Errors:

[root@hpc1pw7prd1 rapidwiz]# ./rapidwiz

Rapid Install Wizard is validating your file system......
4 dvd labels found

Rapid Install Wizard will now launch the Java Interface.....

[root@hpc1pw7prd1 rapidwiz]# Exception in thread "main" java.lang.UnsatisfiedLinkError: /tmp/stage/startCD/Disk1/rapidwiz/jre/Linux_x64/1.6.0/lib/i386/xawt/libmawt.so: libXext.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.ClassLoader.loadLibrary(Unknown Source)
                at java.lang.Runtime.loadLibrary0(Unknown Source)
                at java.lang.System.loadLibrary(Unknown Source)
                at sun.security.action.LoadLibraryAction.run(Unknown Source)
                at java.security.AccessController.doPrivileged(Native Method)
                at sun.awt.NativeLibLoader.loadLibraries(Unknown Source)
                at sun.awt.DebugHelper.<clinit>(Unknown Source)
                at java.awt.Component.<clinit>(Unknown Source)

[root@hpc1pw7prd1 rapidwiz]#

[root@hpc1pw7prd1 rapidwiz]# Exception in thread "main" java.lang.UnsatisfiedLinkError: /tmp/stage/startCD/Disk1/rapidwiz/jre/Linux_x64/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.ClassLoader.loadLibrary(Unknown Source)
                at java.lang.Runtime.loadLibrary0(Unknown Source)
                at java.lang.System.loadLibrary(Unknown Source)
                at sun.security.action.LoadLibraryAction.run(Unknown Source)
                at java.security.AccessController.doPrivileged(Native Method)
                at sun.awt.NativeLibLoader.loadLibraries(Unknown Source)
                at sun.awt.DebugHelper.<clinit>(Unknown Source)
                at java.awt.Component.<clinit>(Unknown Source)

[root@hpc1pw7prd1 rapidwiz]#

Solution:

Install the below RPM’s from the OEL6 installation DVD

rpm -Uhv /mnt/cdrom/Packages/libXext-1.1-3.el6* /mnt/cdrom/Packages/libXext-devel-1.1-3.el6* /mnt/cdrom/Packages/libX11-*.rpm /mnt/cdrom/Packages/libxcb-*.rpm /mnt/cdrom/Packages/libXau-*.rpm --replacepkgs

[root@hpc1pw7prd1 rapidwiz]# rpm -Uhv /mnt/cdrom/Packages/libXext-1.1-3.el6* /mnt/cdrom/Packages/libXext-devel-1.1-3.el6* /mnt/cdrom/Packages/libX11-*.rpm /mnt/cdrom/Packages/libxcb-*.rpm /mnt/cdrom/Packages/libXau-*.rpm --replacepkgs

warning: /mnt/cdrom/Packages/libXext-1.1-3.el6.i686.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY

Preparing...                ########################################### [100%]
   1:libXau                 ########################################### [  6%]
   2:libxcb                 ########################################### [ 12%]
   3:libX11-common          ########################################### [ 18%]
   4:libX11                 ########################################### [ 24%]
   5:libXext                ########################################### [ 29%]
   6:libXau                 ########################################### [ 35%]
   7:libXau-devel           ########################################### [ 41%]
   8:libXau-devel           ########################################### [ 47%]
   9:libxcb                 ########################################### [ 53%]
  10:libxcb-devel           ########################################### [ 59%]
  11:libX11                 ########################################### [ 65%]
  12:libX11-devel           ########################################### [ 71%]
  13:libXext-devel          ########################################### [ 76%]
  14:libX11-devel           ########################################### [ 82%]
  15:libxcb-devel           ########################################### [ 88%]
  16:libXext                ########################################### [ 94%]
  17:libXext-devel          ########################################### [100%]

[root@hpc1pw7prd1 rapidwiz]#

and also

[root@hpc1pw7prd1 rapidwiz]# rpm -Uhv /mnt/cdrom/Packages/libXtst-* /mnt/cdrom/Packages/libXi-* --replacepkgs

warning: /mnt/cdrom/Packages/libXtst-1.0.99.2-3.el6.i686.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY

Preparing...                ########################################### [100%]
   1:libXi                  ########################################### [ 13%]
   2:libXtst                ########################################### [ 25%]
   3:libXi                  ########################################### [ 38%]
   4:libXi-devel            ########################################### [ 50%]
   5:libXtst-devel          ########################################### [ 63%]
   6:libXi-devel            ########################################### [ 75%]
   7:libXtst                ########################################### [ 88%]
   8:libXtst-devel          ########################################### [100%]

[root@hpc1pw7prd1 rapidwiz]#

Starting now without any errors:

Include rpm packages

[root@oel6u4x64pw7 ~]# rpm -qa | grep libx
libxml2-2.7.6-4.0.1.el6_2.4.x86_64
libxml2-python-2.7.6-4.0.1.el6_2.4.x86_64
libxcb-devel-1.5-1.el6.x86_64
perl-libxml-perl-0.08-10.el6.noarch
libxkbfile-1.0.6-1.1.el6.x86_64
libxml2-devel-2.7.6-4.0.1.el6_2.4.x86_64
libxklavier-4.0-9.el6.x86_64
libxslt-devel-1.1.26-2.0.2.el6.x86_64
libxslt-1.1.26-2.0.2.el6.x86_64
libxcb-1.5-1.el6.x86_64
[root@oel6u3pw7 ~]# rpm -qa | grep libX
libXcomposite-0.4.1-2.el6.x86_64
libXxf86misc-1.0.2-1.el6.x86_64
libXft-devel-2.1.13-4.1.el6.x86_64
libXau-1.0.5-1.el6.x86_64
libXext-1.1-3.el6.x86_64
libXv-1.0.5-1.el6.x86_64
libXrandr-devel-1.3.0-4.el6.x86_64
libX11-common-1.3-2.el6.noarch
libXpm-3.5.8-2.el6.x86_64
libXdmcp-devel-1.0.3-1.el6.x86_64
libXxf86vm-devel-1.1.0-1.el6.x86_64
libXvMC-1.0.4-8.1.el6.x86_64
libXi-1.3-3.el6.x86_64
libXrender-devel-0.9.5-1.el6.x86_64
libXres-1.0.4-1.el6.x86_64
libXrender-0.9.5-1.el6.x86_64
libXmu-1.0.5-1.el6.x86_64
libXaw-1.0.6-4.1.el6.x86_64
libXext-devel-1.1-3.el6.x86_64
libXi-devel-1.3-3.el6.x86_64
libXt-1.0.7-1.el6.x86_64
libXxf86vm-1.1.0-1.el6.x86_64
libXau-devel-1.0.5-1.el6.x86_64
libXfont-1.4.1-2.el6_1.x86_64
libX11-1.3-2.el6.x86_64
libXtst-1.0.99.2-3.el6.x86_64
libXfixes-devel-4.0.4-1.el6.x86_64
libXmu-devel-1.0.5-1.el6.x86_64
libXft-2.1.13-4.1.el6.x86_64
libXdmcp-1.0.3-1.el6.x86_64
libXrandr-1.3.0-4.el6.x86_64
libXinerama-1.1-1.el6.x86_64
libXScrnSaver-1.2.0-1.el6.x86_64
libXt-devel-1.0.7-1.el6.x86_64
libXdamage-devel-1.1.2-1.el6.x86_64
libXtst-devel-1.0.99.2-3.el6.x86_64
libXfixes-4.0.4-1.el6.x86_64
libXcomposite-devel-0.4.1-2.el6.x86_64
libXp-1.0.0-15.1.el6.x86_64
libXcursor-1.1.10-2.el6.x86_64
libX11-devel-1.3-2.el6.x86_64
libXp-devel-1.0.0-15.1.el6.x86_64
libXxf86dga-1.1.1-1.el6.x86_64
libXdamage-1.1.2-1.el6.x86_64
libXcursor-devel-1.1.10-2.el6.x86_64
libXinerama-devel-1.1-1.el6.x86_64
[root@oel6u4x64pw7 ~]#  

Oracle DBA

http://myoracleworld.hobby-electronics.net/DB2-conf-DRDA-11G.html

EBS R12.2 installation steps Vision Database

Pre-Installation steps:

Kernel parameter:

vi /etc/sysctl.conf

kernel.shmall = 4294967296

kernel.shmmax=2147483648

kernel.sem=250 32000 100 128

fs.file-max=65536

net.ipv4.ip_local_port_range = 2024 65000

vi /etc/security/limit.conf

oracle hard nofile 4096

oracle soft nofile 4096

vi /etc/pam.d/login

session    required     pam_limits.so

User and Group Creation:

useradd oracle

groupadd dba

usermod -G dba -a oracle

Create password for oracle (in my case both apps and database are oracle user) user,

#passwd oracle

Create ORACLE_BASE directory:

mkdir -p /oracle/product

Create oraInventory directory in /oracle location

Create oraInst.loc file in oraInventory directory and /etc

Enter the below text in oraInst.loc file

inventory_loc=/oracle/oraInventory

Create softlink if libdb.so.2 is not there, (for avoid login page issue in post installation steps)

ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

libdb.so.2 -> /usr/lib/libgdbm.so.2.0.0

Set up the Stage Area:-

Ø  Kindly Read the below instruction before running buildstage.sh script,

================================================================

The staging area should consist of a top-level directory with subdirectories startCD, EBSInstallMedia, TechInstallMedia, and TechPatches.

The startCD directory contains Rapid Install itself (in a subdirectory called Disk1), plus supporting files and documentation.

The EBSInstallMedia directory should contain the following subdirectories:

    AppDB (Oracle E-Business Suite Database)

    Apps (Oracle E-Business Suite products)

    AS10.1.2 (Oracle Application Server 10.1.2)

The TechInstallMedia directory should contain the following subdirectories:

    database (Oracle11gR2 ORACLE_HOME)

    ohs11116 (Oracle HTTP Server)

    wls1036_generic (Oracle WebLogic Server, part of Oracle Fusion Middleware)

The TechPatches directory should contain the following subdirectories:

    MiddleTier (Application tier patches)

    DB (Database Tier patches)

Please note that you should NOT download the following files while creating the R12.2 Rapid install Stage: (for avoid "Fatal Error: TXK Install Service" issue during the installation)

1.    Oracle Database Lite 10g Release 3 (10.3.0.3.0) for Linux x86 V20223-01.zip

2. Oracle SOA Suite 11g Patch Set 5 (11.1.1.6.0) for Price Protection

V29672-01_1of2.zip

V29672-01_2of2.zip

3. Oracle Data Integrator 11g (11.1.1.6.0) for Generic

V29762-01_1of2.zip

V29762-01_2of2.zip

4. Oracle Portal, Forms, Reports and Discoverer 11g (11.1.1.2.0) for Linux x86-64

V18772-01_1of4.zip

V18772-01_2of4.zip

V18772-01_3of4.zip

V18772-01_4of4.zip

5. Oracle Portal, Forms, Reports and Discoverer 11g Patch Set 5 (11.1.1.6.0) for Linux x86-64

V29883-01.zip

These files DO NOT belong to the R12.2 shiphome.

They should be downloaded to a different location than the R12.2 Rapid install stage.

============================================================

unzip V35215-01_1of3 to V35215-01_1of3 (Rapid_install_starts_here_part (1 to 3))

It will create startCD folder....

[oracle@testvm bin]$ ./buildStage.sh


                Build Stage Menu

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

1.     Create new stage area

2.     Copy new patches to current stage area.

3.     Display existing files in stage TechPatches.

4.     Exit menu


Enter your choice [4]: 1


         Rapid Install Platform Menu

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

1.    Oracle Solaris SPARC (64-bit)

2.    Linux x86-64

3.    IBM AIX on Power Systems (64-bit)

4.    HP-UX Itanium

5.    Exit Menu


Enter your choice [5]: 2

/mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../jre/Linux_x64/1.6.0/bin/java -classpath /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../jlib/emocmutl.jar:/mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../jlib/ewt-3_4_22.jar:/mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../jlib/share-1_1_18.jar:/mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../jlib/jnls.jar:/mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../jlib/ACC.JAR:/mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../jlib/netcfg.jar:/mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../jlib/ojdbc14.jar:/mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../jlib/OraInstaller.jar:/mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../jlib/java oracle.apps.ad.rapidwiz.util.StageBuilder /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin


Please enter the directory containing the zipped installation media:
/mnt/hgfs/Software/R122vision
Unzipping V29764-01.zip
Unzipping V29856-01.zip
Unzipping V35215-01_1of3.zip
Unzipping V35215-01_2of3.zip
Unzipping V35215-01_3of3.zip
Unzipping V35230-01_1of2.zip
Unzipping V35230-01_2of2.zip
Unzipping V35231-01_1of5.zip
Unzipping V35231-01_2of5.zip
Unzipping V35231-01_3of5.zip
Unzipping V35231-01_4of5.zip
Unzipping V35231-01_5of5.zip
Unzipping V35802-01.zip
Unzipping V35803-01_1of3.zip
Unzipping V35803-01_2of3.zip
Unzipping V35803-01_3of3.zip
Unzipping V35804-01_1of2.zip
Unzipping V35804-01_2of2.zip
Unzipping V35807-01.zip
Unzipping V35808-01.zip
Unzipping V35809-01.zip
Unzipping V35810-01.zip
Unzipping V35811-01.zip
Unzipping V35812-01.zip
Unzipping V35813-01.zip
Unzipping V37515-01_1of6.zip
Unzipping V37515-01_2of6.zip
Unzipping V37515-01_3of6.zip
Unzipping V37515-01_4of6.zip
Unzipping V37515-01_5of6.zip
Unzipping V37515-01_6of6.zip
Unzipping V39571-01.zip
Unzipping V39615-01.zip
Applying one-off patches
All files have been unzipped.
Stage area is complete.

Done Unzipping shiphome ...


StageBuilder will now stage the tech patches for Linux_x64...


Copying one-off patches to shiphome

/mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../unzip/Linux_x64/unzip -o /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../Xpatches/Linux_x64.zip -d /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches


Archive:  /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../Xpatches/Linux_x64.zip
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16303726/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16303726/p16303726_112030_Linux-x86-64.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14123213/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14123213/p14123213_112030_Linux-x86-64.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/13923995/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/13923995/p13923995_112030_Linux-x86-64.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14751895/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14751895/p14751895_112030_Linux-x86-64.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16163946/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16163946/p16163946_112030_Linux-x86-64.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14207902/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14207902/p14207902_112030_Linux-x86-64.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/15967134/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/15967134/p15967134_112030_Linux-x86-64.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16438289/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16438289/p16438289_112030_Linux-x86-64.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/13931044/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/13931044/p13931044_112030_Linux-x86-64.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16342486/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16342486/p16342486_112030_Linux-x86-64.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14398795/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14398795/p14398795_112030_Linux-x86-64.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/12951696/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/12951696/p12951696_112030_Generic.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/12942119/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/12942119/p12942119_112030_Linux-x86-64.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14698700/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14698700/p14698700_112030_Generic.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16587934/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16587934/p16587934_112030_Linux-x86-64.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16105745/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16105745/p16105745_112030_Generic.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16040940/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16040940/p16040940_112030_Linux-x86-64.zip  
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/13583235/p13583235_1036_Generic.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14825718/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14825718/p14825718_10123_LINUX.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14353879/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14353879/p14353879_10123_LINUX.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14614795/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14614795/p14614795_101231_LINUX.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16209520/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16209520/p16209520_10123_GENERIC.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16275529/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16275529/p16275529_10105_LINUX.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14597598/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14597598/p14597598_1036_Generic.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14577216/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14577216/p14577216_101231_Generic.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16784403/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16784403/p16784403_101232_LINUX.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14386347/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14386347/p14386347_111160_Generic.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16199894/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16199894/p16199894_111160_Generic.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14374587/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14374587/p14374587_10123_GENERIC.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/10152652/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/10152652/p10152652_10123_LINUX.zip  
   creating: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/11669923/
 extracting: /mnt/hgfs/Software/R122vision/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/11669923/p11669923_10123_GENERIC.zip  

Done Copying additional patches

Verifying stage area...

Directory /mnt/hgfs/Software/R122vision/TechInstallMedia is valid
Directory /mnt/hgfs/Software/R122vision/TechPatches/DB is valid
Directory /mnt/hgfs/Software/R122vision/TechPatches/MiddleTier is valid
Directory /mnt/hgfs/Software/R122vision/EBSInstallMedia/AppDB is valid
Directory /mnt/hgfs/Software/R122vision/EBSInstallMedia/Apps is valid
Directory /mnt/hgfs/Software/R122vision/EBSInstallMedia/AS10.1.2 is valid
Directory /mnt/hgfs/Software/R122vision/TechInstallMedia/database is valid
Directory /mnt/hgfs/Software/R122vision/TechInstallMedia/ohs11116 is valid
Directory /mnt/hgfs/Software/R122vision/TechInstallMedia/wls1036_generic is valid


Stage area verified.

Next run the rapidwiz file.........

Regards
Goraknath

Database does not start up or ORA-600 error during startup

Case:  Database does not start after a fail-over test did not work on a two-nodes cluster.

SQL> startup nomount

ORA-24324: service handle not initialized

ORA-24323: value not allowed

ORA-03113: end-of-file on communication channel

1. checked and did not find any background processes related to this $ORACLE_SID

   $ ps -ef | grep ora_ | grep $ORACLE_SID

  

   Note: Doc ID 794293.1 recommends two more steps to check other OS processes.

         I did not do those because there are other Oracle instances were running on the same server.

2. $ sqlplus sqlplus "/ as sysdba"

   SQL> shutdown abort

3. Remove/rename three files belong to the $ORACLE_SID under $ORACLE_HOME/dbs, such as lk{$ORACLE_SID}

4. SQL> startup nomount;

   SQL>  alter database mount;

   SQL>  alter database open;



============================================

Case: ORA-00600: internal error code, arguments: [3712], [1], [1], [574], [3989605836], [574], [3989605835],[]

LGWR: terminating instance due to error 600

Instance terminated by LGWR, pid = 6487

SQL> startup mount

SQL> select group#, status from v$log;

    GROUP# STATUS

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

         1 UNUSED

         2 CURRENT

         3 UNUSED

         4 UNUSED

SQL> alter database clear unarchived logfile group 1;

Database altered.

SQL> alter database clear unarchived logfile group 3;

Database altered.

SQL> alter database clear unarchived logfile group 4;

Database altered.

SQL> select group#, status from v$log;

    GROUP# STATUS

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

         1 UNUSED

         2 CURRENT

         3 UNUSED

         4 UNUSED

SQL> alter database clear unarchived logfile group 2;

Database altered.

SQL> select group#, status from v$log;

    GROUP# STATUS

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

         1 CURRENT

         2 UNUSED

         3 UNUSED

         4 UNUSED

SQL> shutdown immediate

SQL> startup

SQL> select group#, status from v$log;

    GROUP# STATUS

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

         1 CURRENT

         2 INACTIVE

         3 INACTIVE

         4 INACTIVE

===========================================

Case: ora-600 errors after SAN server crashed

SQL> startup;
ORACLE instance started.  

Total System Global Area 3240689664 bytes
Fixed Size                  2225608 bytes
Variable Size            1543506488 bytes
Database Buffers         1610612736 bytes
Redo Buffers               84344832 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [],
[], [], [], [], [], [], [], []

Fix: It needed media recovery

SQL> startup mount;
ORACLE instance started.  

Total System Global Area 3240689664 bytes
Fixed Size                  2225608 bytes
Variable Size            1543506488 bytes
Database Buffers         1610612736 bytes
Redo Buffers               84344832 bytes
Database mounted.

SQL> recover database;
Media recovery complete.
SQL> alter database open;

Database altered.

===========================================
Case:  database dis not start up

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[54278], [610128], [610297], [], [], [], [], [], [], []

Fix: recover control file. Doc. 1296264.1 gives two methods. One of them is:

SQL>Startup mount ;
SQL>Show parameter control_files

Query 1
------------
SQL> select a.member, a.group#, b.status from v$logfile a ,v$log b where a.group#=b.group# and b.status='CURRENT' ;

Note down the name of the redo log

SQL> Shutdown abort ;

Take a OS Level backup of the controlfile (This is to ensure we have a backup of current state of controlfile)

SQL> Startup mount ;
SQL> recover database using backup controlfile until cancel ;

Enter location of redo log shown as current in Query 1 when prompted for recovery

Hit Enter

SQL> Alter database open resetlogs ;

============================================
Case: Error in alert log file - ORA-00600: internal error code, arguments: [4194], [#], [#], [], [], [], [], []

This error indicates that a mismatch has been detected between redo records and rollback (undo) records.

ARGUMENTS:
Arg [a] - Maximum Undo record number in Undo block
Arg [b] - Undo record number from Redo block

Fix: It is related undo segment corruption. Doc ID 1428786.1 :

Best practice to create a new undo tablespace.
This method includes segment check.

Create pfile from spfile to edit
SQL> create pfile from spfile;

1. Shutdown the instance
2. set the following parameters in the pfile
    undo_management = manual
    event = '10513 trace name context forever, level 2'
3. SQL> startup restrict pfile=<initsid.ora>
4. SQL> select tablespace_name, status, segment_name from dba_rollback_segs where status != 'OFFLINE';
 
This is critical - we are looking for all undo segments to be offline - System will always be online.

If any are 'PARTLY AVAILABLE' or 'NEEDS RECOVERY' - Please open an issue with Oracle Support or update the current SR.  There are many options from this moment and Oracle Support Analyst can offer different solutions for the bad undo segments.

If all offline then continue to the next step

5. Create new undo tablespace - example
SQL> create undo tablespace <new undo tablespace> datafile <datafile> size 2000M;
6. Drop old undo tablespace
SQL> drop tablespace <old undo tablespace> including contents and datafiles;
7. SQL> shutdown immediate;
8. SQL> startup mount;
9. modify the pfile with the new undo tablespace name
SQL> alter system set undo_tablespace = '<new tablespace>' scope=pfile;
10. SQL> shutdown immediate;
11. SQL> startup;
Then, startup using the normal spfile

Call

Send SMS

Add to Skype

You'll need Skype CreditFree via Skype

Get AWR, ADDR, and ASH reports from SQL scripts

One way to identify the causes of poor performance in the database is to review AWR, ADDR, and ASH reports. They should be for a period of 60 or more minutes, covering the poor performance period.

. To generate the AWR report, execute the following script and select two snapshots:

SQL> @$ORACLE_HOME/rdbms/admin/awrrpt.sql

>> Choose the TXT format or the HTML format.

. To generate the ADDM report, execute:

SQL> @$ORACLE_HOME/rdbms/admin/addmrpt

>> Choose the TXT format or the HTML format.

. To generate the ASH report, execute:

SQL> @$ORACLE_HOME/rdbms/admin/ashrpt

>> Choose the TXT format or the HTML format.

Step by step recovery of oracle database on ORA-00214: control file incosistent

SQL> startup;
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 167775108 bytes
Database Buffers 436207616 bytes
Redo Buffers 7135232 bytes
ORA-00214: control file
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\JOHNSON\CONTROL02.CTL' version 23659
inconsistent with file 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\JOHNSON\CONTROL01.CTL'
version 2798
SQL> shutdown abort;
ORACLE instance shut down.
sQL>create pfile='c:/initnew.ora' from spfile;
File created.
SQL>shutdown abort;
-----Edit the pfile and delete the controlfile 02 and controlfile 03 from controlfiles parameter
-----Then boot the system from newly created pfile
SQL> startup nomount pfile='c:/initnew.ora';
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 167775108 bytes
Database Buffers 436207616 bytes
Redo Buffers 7135232 bytes
SQL>
SQL>
SQL>
SQL>
SQL> ho rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Fri Apr 29 11:15:50 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: johnson (not mounted)
RMAN>
RMAN> restore controlfile from autobackup;
Starting restore at 29-APR-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
recovery area destination: D:\oracle\product\10.2.0/flash_recovery_area
database name (or database unique name) used for search: JOHNSON
channel ORA_DISK_1: autobackup found in the recovery area
channel ORA_DISK_1: autobackup found: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AR
EA\JOHNSON\AUTOBACKUP\2011_04_29\O1_MF_N_749732909_6VNMPQVT_.BKP
channel ORA_DISK_1: control file restore from autobackup complete
output filename=D:\ORACLE\PRODUCT\10.2.0\ORADATA\JOHNSON\CONTROL01.CTL
Finished restore at 29-APR-11
RMAN> quit
Recovery Manager complete.
SQL> create spfile from pfile='c:/initnew.ora';
File created.
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 167775108 bytes
Database Buffers 436207616 bytes
Redo Buffers 7135232 bytes
Database mounted.
SQL> ho rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Fri Apr 29 11:17:11 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: JOHNSON (DBID=2710984504, not open)
RMAN> run{
2> recover database;
3> }
Starting recover at 29-APR-11
Starting implicit crosscheck backup at 29-APR-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=154 devtype=DISK
Crosschecked 23 objects
Finished implicit crosscheck backup at 29-APR-11
Starting implicit crosscheck copy at 29-APR-11
using channel ORA_DISK_1
Finished implicit crosscheck copy at 29-APR-11
searching for all files in the recovery area
cataloging files...
cataloging done
.
.
.
.
.
.
.
.
.
media recovery complete, elapsed time: 00:00:04
Finished recover at 29-APR-11
RMAN> quit
Recovery Manager complete.
SQL> alter database open resetlogs;
Database altered.
SQL> select status from v$instance;
STATUS
------------
OPEN
----For cross check whether your database was recovered successfully or not, shut it down and start
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 176163716 bytes
Database Buffers 427819008 bytes
Redo Buffers 7135232 bytes
Database mounted.
Database opened.
SQL>