ORA-27300 ORA-27301 ORA-27302

ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
Sun Mar 27 08:45:52 2011
This problem is most likely due to swap space being less. Ask your system administrator to increase the swap space. The rule of thumb is swap space should be twice that of physical memory. We faced this issue on AIX 5L box running Oracle Database 10gR2 10.2.0.1
Alternately you can run the HCVE script which is now part of RDA to do health check of database and confirm this.
1. Download RDA package for your OS from metalink.
2. Unzip the RDA package.
3. Go to the RDA directory and type below command to run. For an AIX system you will see options. Select your database version.
$ ./rda.sh -T hcve
Processing HCVE tests …
Available Pre-Installation Rule Sets:
1. Oracle Database 10g R1 (10.1.0) Preinstall (AIX)
2. Oracle Database 10g R2 (10.2.0) Preinstall (AIX)
3. Oracle Database 11g R1 (11.1.0) Preinstall (AIX)
4. Oracle Database 11g R2 (11.2.0) Preinstall (AIX)
5. Oracle Application Server 10g (9.0.4) Preinstall (AIX)
6. Oracle Fusion Middleware 11g R1 (11.1.1) Preinstall (AIX)
7. Oracle Portal Preinstall (Generic)
8. Oracle Identity Management 10g (10.1.4) Preinstall (AIX)
9. Oracle E-Business Suite Release 11i (11.5.10) Preinstall (AIX)
10. Oracle E-Business Suite Release 12 (12.1.1) Preinstall (AIX)
Available Post-Installation Rule Sets:
11. Oracle Portal Postinstall (generic)
12. Data Guard Postinstall (Generic)
Enter the HCVE rule set number
Hit ‘Return’ to accept the default (1)
> 2
Enter value for < Planned ORACLE_HOME location >
Hit ‘Return’ to accept the default
(/oradb/u01/app/oracle/oracle/product/10.2.0/db_1)
4. Once you select a test the step above you will see the test results on the screen. The test results are also written to a HTML file that is located in the RDA output directory. You can review the test results by using a Web Browser to open the following file located in:
Test “Oracle Database 10g R1 (10.1.0)  Preinstall (AIX)” executed at 28-Mar-2011 14:33:03
Test Results
~~~~~~~~~~~~
ID     NAME                 RESULT  VALUE
====== ==================== ======= ==========================================
A00010 OS Certified?        PASSED  Certified with Oracle Database 10g
A00020 User in “/etc/passw PASSED  userOK
A00030 Group in “/etc/grou PASSED  GroupOK
A00040 Enter ORACLE_HOME    RECORD  /oradb/u01/app/oracle/oracle/product/..>
A00050 ORACLE_HOME Valid?   PASSED  OHexists
A00060 O_H Permissions OK?  PASSED  CorrectPerms
A00070 Umask Set to 022?    PASSED  UmaskOK
A00080 LDLIBRARYPATH Unset? PASSED  UnSet
A00090 LIBPATH Unset?       PASSED  UnSet
A00100 Other O_Hs in PATH?  FAILED  OratabEntryInPath
A00110 oraInventory Permiss PASSED  oraInventoryOK
A00120 /tmp Adequate?       PASSED  TempSpaceOK
A00130 Swap (in MB)         RECORD  5632
A00140 RAM (in MB)          PASSED  7712
A00150 SwapToRAM OK?        FAILED  SwapLessThanRAM
A00160 Disk Space OK?       PASSED  DiskSpaceOK
A00170 AIXTHREAD_SCOPE=S?   PASSED  AIXTHREAD_SCOPEOK
A00175 LINK_CNTRL is Unset? PASSED  LINK_CNTRLunset
A00180 Got Software Tools?  PASSED  ld_nm_ar_make_found
A00190 ulimits OK?          PASSED  ulimitOK
A00200 Got OS Packages?     PASSED  All required OS packages are installed
A00210 Got OS Patches?      PASSED  PatchesFound
A00220 Other OUI Up?        PASSED  NoOtherOUI
Result file: /oradb/u01/app/oracle/rda/output/RDA_HCVE_A200DB10R1_aix_res.htm
Note: There are NO tests currently available for the Windows Platform.

Category: DatabaseTuning

Tags:

Leave a Reply

Article by: Shadab Mohammad