{"id":527,"date":"2008-12-23T16:51:21","date_gmt":"2008-12-23T14:51:21","guid":{"rendered":"http:\/\/www.ora-solutions.net\/web\/?p=527"},"modified":"2008-12-23T16:51:21","modified_gmt":"2008-12-23T14:51:21","slug":"installation-prerequisites-for-oracle-databases","status":"publish","type":"post","link":"https:\/\/www.ora-solutions.net\/web\/2008\/12\/23\/installation-prerequisites-for-oracle-databases\/","title":{"rendered":"Installation Prerequisites for Oracle Databases"},"content":{"rendered":"<p>More often than not, I see installations, where either shared memory parameters or ulimit settings are not set as required for an optimal Oracle database installation.<\/p>\n<p>The tool RDA, commonly known as a support tool to gather diagnostic information for Oracle Support for service requests, can do these checks quite nicely.<\/p>\n<p><strong>Steps:<\/strong><\/p>\n<ul>\n<li>Download RDA from MetaLink Note <span style=\"font-family: helvetica;\"><strong>314422.1.<\/strong><\/span><\/li>\n<li>unzip in working directory<\/li>\n<li>run <strong>H<\/strong>ealth <strong>C<\/strong>heck <strong>V<\/strong>alidation <strong>E<\/strong>ngine of RDA\n<\/li>\n<blockquote><p><code>$ .\/rda.pl -T hcve<br \/>\nProcessing HCVE tests ...<br \/>\nAvailable Pre-Installation Rule Sets:<br \/>\n   1. Oracle Database 10g (10.1.0) PreInstall(HP-UX)<br \/>\n   2. Oracle Database 10g R1 (10.1.0) PreInstall (HP-UX Itanium)<br \/>\n   3. Oracle Database 10g R2 (10.2.0) PreInstall (HPUX)<br \/>\n   4. Oracle Database 11g R1 (11.1.0) PreInstall (HPUX)<br \/>\n   5. Oracle Application Server 10g (9.0.4) PreInstall (HP-UX)<br \/>\n   6. Oracle Application Server 10g R2 (10.1.2) PreInstall (HP-UX)<br \/>\n   7. Oracle Portal PreInstall (Generic)<br \/>\nAvailable Post-Installation Rule Sets:<br \/>\n   8. Oracle Portal PostInstall (generic)<br \/>\n   9. Data Guard PostInstall (Generic)<br \/>\nEnter the HCVE rule set number<br \/>\nHit 'Return' to accept the default (1)<br \/>\n> 3<\/p>\n<p>Enter value for < Planned ORACLE_HOME location or if set ><br \/>\nHit 'Return' to accept the default ($ORACLE_HOME)<br \/>\n><\/p>\n<p>Test \"Oracle Database 10g R2 (10.2.0) PreInstall (HPUX)\" executed at Tue Dec 23 15:26:31 2008<\/p>\n<p>Test Results<br \/>\n~~~~~~~~~~~~<\/p>\n<p>   ID NAME                 RESULT VALUE<br \/>\n===== ==================== ====== ========================================<br \/>\n   10 OS Certified?        PASSED Certified with 10g R2 RDBMS<br \/>\n   20 User in \/etc\/passwd? PASSED userOK<br \/>\n   25 Got EXTJOB User?     FAILED ExtjobNotFound<br \/>\n   30 Group in \/etc\/group? PASSED GroupOK<br \/>\n   40 Input ORACLE_HOME    RECORD $ORACLE_HOME<br \/>\n   50 ORACLE_HOME Valid?   PASSED OHexists<br \/>\n   60 O_H Permissions OK?  PASSED CorrectPerms<br \/>\n   70 Umask Set to 022?    PASSED UmaskOK<br \/>\n   80 LDLIBRARYPATH Unset? PASSED UnSet<br \/>\n   90 SHLIB_PATH Unset?    PASSED UnSet<br \/>\n  100 Other O_Hs in PATH?  PASSED NotFound<br \/>\n  110 oraInventory Permiss FAILED oraInventoryNotOK<br \/>\n  120 \/tmp Adequate?       PASSED TempSpaceOK<br \/>\n  130 Swap (in MB)         RECORD 15144<br \/>\n  140 RAM (in MB)          PASSED 14334<br \/>\n  150 SwapToRAM OK?        PASSED SwapToRAMOK<br \/>\n  160 Disk Space OK?       FAILED OnlySpaceForOne<br \/>\n  170 Kernel Parameters OK FAILED [EXECUTABLE_STACK=1] too large [MAXUP..><br \/>\n  175 Links and Libs OK?   PASSED AllExist<br \/>\n  180 Got ld,nm,ar,make?   PASSED ld_nm_ar_make_found<br \/>\n  190 ulimits OK?          PASSED ulimitOK<br \/>\n  200 Got OS Bundles?      PASSED GOLDAPPS11iandGOLDBASE11iAdequate<br \/>\n  210 Got OS Patches?      FAILED [PHNE_31097 or its successor PHNE_324..><br \/>\n  220 Other OUI Up?        PASSED NoOtherOUI<br \/>\n<\/code><\/p><\/blockquote>\n<p>The output file contains detailed information, about why a specific check failed.<\/p>\n<blockquote><p><code>[PHNE_31097 or its successor PHNE_32477 or its successor PHNE_33498 or its successor PHNE_35418] not installed<br \/>\n[PHSS_31221 or its successor PHSS_33263 or its successor PHSS_33944] not installed<br \/>\n[PHSS_30970 or its successor PHSS_33033 or its successor PHSS_35379] not installed<br \/>\n[PHSS_32508 or its successor PHSS_34411 or its successor PHSS_35099] not installed<br \/>\n[PHSS_32509 or its successor PHSS_34412 or its successor PHSS_35098] not installed<br \/>\n[PHSS_32510 or its successor PHSS_34413 or its successor PHSS_35100] not installed<\/p>\n<p>FAILED<br \/>\n[EXECUTABLE_STACK=1] too large<br \/>\n[MAXUPRC=1024] too small<br \/>\n[MSGMNI=50] too small<br \/>\n[MSGTQL=40] too small<br \/>\n[NCSIZE=9964] too small<br \/>\n[NFILE=5000] too small<br \/>\n[NINODE=4844] too small<br \/>\n[SHMMAX=1024000000] too small<br \/>\n[MAXSWAPCHUNKS=2048] too small<br \/>\n[MSGMAP=42] too small == KernelOK<br \/>\n<\/code> <\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>More often than not, I see installations, where either shared memory parameters or ulimit settings are not set as required for an optimal Oracle database installation. The tool RDA, commonly known as a support tool to gather diagnostic information for Oracle Support for service requests, can do these checks quite nicely. Steps: Download RDA from [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[13,14,15,5],"tags":[],"class_list":["post-527","post","type-post","status-publish","format-standard","hentry","category-10g","category-11g","category-9ir2","category-oracle-database"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/527","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/comments?post=527"}],"version-history":[{"count":5,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/527\/revisions"}],"predecessor-version":[{"id":532,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/527\/revisions\/532"}],"wp:attachment":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/media?parent=527"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/categories?post=527"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/tags?post=527"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}