{"id":2583,"date":"2019-03-12T11:49:54","date_gmt":"2019-03-12T08:49:54","guid":{"rendered":"https:\/\/sysdba.org\/?p=2583"},"modified":"2025-07-02T06:01:07","modified_gmt":"2025-07-02T06:01:07","slug":"installing-an-oracle-11-2-0-3-database-on-an-aix-system","status":"publish","type":"post","link":"https:\/\/sysdba.org\/en\/installing-an-oracle-11-2-0-3-database-on-an-aix-system\/","title":{"rendered":"Installing an Oracle 11.2.0.3 Database on an AIX system"},"content":{"rendered":"<p>It&#8217;s worth reading all the headings before beginning the installation process:<\/p>\n<h3>Hardware requirements<\/h3>\n<p>Min 1GB RAM (recommended amount is 2GB or more)<\/p>\n<p>To find out the amount of installed RAM<\/p>\n<p>[crayon]#lsattr -E -l sys0 -a realmem[\/crayon]<\/p>\n<h3><\/h3>\n<h3>Swap requirements<\/h3>\n<p>For 1-2 GB Physical RAM, 1.5 the amount of RAM<br \/>\nFor 2-16 GB Physical RAM, the swap amount can be the same as the physical RAM<br \/>\nFor systems with more than 16GB Physical RAM, 16GB of swap space is sufficient<br \/>\nChecking the size of the swap amount:<br \/>\n[crayon]#lsps -a[\/crayon]<br \/>\nIf the amount of swap space is insufficient, instructions showing how to increase its size are provided at the end of the page.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Disk requirements<\/strong><\/p>\n<p>A minimum of 1GB for \/tmp.<\/p>\n<p>[crayon]df -g \/tmp \u00ab The -g option is for the size in gigabytes<br \/>\ndf -k \/tmp \u00ab The -k option is for the size in kilobytes<br \/>\nchfs -a size=+2G \/tmp \u00ab To increase the size of \/tmp<br \/>\n[\/crayon]<\/p>\n<p>Information about the system to be installed. Whether the operating system&#8217;s kernel architecture is 32 or 64 bit.<\/p>\n<p>&nbsp;<\/p>\n<p>[crayon]#getconf HARDWARE_BITMODE<br \/>\n64<br \/>\n[\/crayon]<\/p>\n<p>&nbsp;<\/p>\n<p>[crayon]The operating system should, at a minimum, be the versions below or higher<br \/>\nAIX 5L V5.3 TL 09 SP1 (&#8220;5300-09-01&#8221;), 64 bit kernel<br \/>\nAIX 6.1 TL 02 SP1 (&#8220;6100-02-01), 64-bit kernel<br \/>\nAIX 7.1 TL 0 SP1 (&#8220;7100-00-01&#8221;), 64-bit kernel[\/crayon]<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Operating system release<\/strong><br \/>\n[crayon]#oslevel -s<br \/>\n6100-06-05-1115<br \/>\n[\/crayon]<\/p>\n<p>The digits on line 2 indicate that this is AIX V6 TL6 service pack 5, released on the 15th week of 2011.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>The filesets that need to be installed for AIX 5L :<\/strong><\/p>\n<p>[crayon]bos.adt.base<br \/>\nbos.adt.lib<br \/>\nbos.adt.libm<br \/>\nbos.perf.libperfstat 5.3.9.0 or later<br \/>\nbos.perf.perfstat<br \/>\nbos.perf.proctools<br \/>\nxlC.aix50.rte.10.1.0.0 or later<br \/>\ngpfs.base 3.2.1.8 or later[\/crayon]<\/p>\n<p>&nbsp;<\/p>\n<p><strong>The filesets that need to be installed for AIX 6.1:<\/strong><\/p>\n<p>[crayon]bos.adt.base<br \/>\nbos.adt.lib<br \/>\nbos.adt.libm<br \/>\nbos.perf.libperfstat 6.1.2.1 or later<br \/>\nbos.perf.perfstat<br \/>\nbos.perf.proctools<br \/>\nxlC.aix61.rte.10.1.0.0 or later<br \/>\nxlC.rte.10.1.0.0 or later<br \/>\ngpfs.base 3.2.1.8 or later[\/crayon]<br \/>\n<strong> The filesets that need to be installed for AIX 7.1<\/strong><\/p>\n<p>[crayon]bos.adt.base<br \/>\nbos.adt.lib<br \/>\nbos.adt.libm<br \/>\nbos.perf.libperfstat<br \/>\nbos.perf.perfstat<br \/>\nbos.perf.proctools<br \/>\nxlC.aix61.rte:10.1.0.0 or later<br \/>\nxlC.rte.10.1.0.0 or later<br \/>\ngpfs.base 3.3.0.11 or later[\/crayon]<br \/>\n<strong>Checking to see whether or not they have been installed:<\/strong><\/p>\n<p>[crayon]lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.perfstat<br \/>\nbos.perf.libperfstat bos.perf.proctools[\/crayon]<\/p>\n<p><strong>Necessary patches:<\/strong><\/p>\n<p>If using the minimum os requirement&#8217;s TL (Technology Level) for AIX 6L as listed above then:<br \/>\nInstall all AIX 6L 6.1 Authorized Problem Analysis Reports (APARs) for AIX 6.1 TL 02 SP1, followed by these AIX fixes:<\/p>\n<p>[crayon]IZ41855<br \/>\nIZ51456<br \/>\nIZ52319[\/crayon]<\/p>\n<p>These 6.1 fixes are present in the following TLs:<\/p>\n<p>[crayon]AIX 6.1 TL-02 SP-04 and later<br \/>\nAIX 6.1 TL-03 SP-02 and later<br \/>\nAIX 6.1 TL-04[\/crayon]<\/p>\n<p>If you need to install a Service Pack, use the link below or the links at the end of the page<\/p>\n<p><a href=\"http:\/\/www.ibm.com\/developerworks\/aix\/library\/au-aixservicepacks\/#resources\">www.ibm.com\/developerworks\/aix\/library\/au-aixservicepacks\/#resources<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Checking to see whether or not they have been installed<\/p>\n<p>[crayon]instfix -ia|grep IZ52319<br \/>\n[\/crayon]<\/p>\n<p>As the installed operating systems is AIX V6 TL6 Service Pack 5 released on the 15th week of 2011, this means that the patches have been installed.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Creating Users and Groups:<\/strong><\/p>\n<p>[crayon]smit security<br \/>\n[\/crayon]<\/p>\n<p>[crayon]id oracle<br \/>\npasswd oracle<br \/>\nsmit chuser &#8211;soft &#8211;&gt; -1<br \/>\n[\/crayon]<\/p>\n<h3><\/h3>\n<h3>Kernel Parameters<\/h3>\n<p>Maximum number of PROCESSES (maxuprocs) 16384<br \/>\nARG\/ENV list size in 4K byte blocks (ncargs) 128<br \/>\nThe values on your system shouldn&#8217;t be lower than the numbers shown above.<\/p>\n<p>[crayon]smit chgsys \u00ab To change the maximum number of processes[\/crayon]<\/p>\n<p>alternatively<br \/>\n[crayon]chdev -l sys0 -a maxuproc=3000[\/crayon]<br \/>\nto query<br \/>\n[crayon]lsattr -E -l sys0 | grep maxuproc<br \/>\nmaxuproc 3000 Maximum number of PROCESSES allowed per user True<br \/>\n[\/crayon]<\/p>\n<h3><\/h3>\n<h3>Asynchronous Input Output Processes<\/h3>\n<p>To activate &#8220;Asynchronous Input Output Processes&#8221;, run the <strong>rootpre.sh<\/strong> file in the AIX 5 database directory (active by default in AIX 6).<\/p>\n<p>In AIX 5 and 6, the <strong>aio_maxreqs<\/strong> value is 65536.<\/p>\n<p>[crayon]#ioo \u2013o aio_maxreqs<br \/>\naio_maxreqs = 65536<br \/>\n#lsattr -El aio0 -a maxreqs<br \/>\nmaxreqs 65536 Maximum number of REQUESTS True[\/crayon]<\/p>\n<p>To view the AIO processes<\/p>\n<p>[crayon]ps -ek|grep -v grep|grep -v posix_aioserver|grep -c aioserver<\/p>\n<p>[\/crayon]<\/p>\n<p>If many parallel queries are expected to be run simultaneously, it may be necessary to widen the UDP-TCP port.<\/p>\n<p>&nbsp;<\/p>\n<p>The default values:<\/p>\n<p>[crayon]#\/usr\/sbin\/no -a | fgrep ephemeral<br \/>\ntcp_ephemeral_low = 32768<br \/>\ntcp_ephemeral_high = 65535<br \/>\nudp_ephemeral_low = 32768<br \/>\nudp_ephemeral_high = 65535[\/crayon]<br \/>\nTo widen the port range:http:\/\/sysdba.org\/wp-admin\/post.php?lang=en&amp;action=edit&amp;post_type=post&amp;post=5005<\/p>\n<p>[crayon]#\/usr\/sbin\/no -p -o tcp_ephemeral_low=9000 -o tcp_ephemeral_high=65500<br \/>\n#\/usr\/sbin\/no -p -o udp_ephemeral_low=9000 -o udp_ephemeral_high=65500<\/p>\n<p>[\/crayon]<br \/>\nTo widen the port range:<\/p>\n<p>[crayon]mkdir -p \/oracle\/11G (Yada mkdir -p \/u01\/app\/ &#8211;diskleri nereye mount etti\u011finizle ya da kurulum prosedurunuzle ilgili)<br \/>\nchown -R \/oracle\/11G<br \/>\nchmod -R 755 \/oracle\/11G[\/crayon]<br \/>\nTo be added to the <strong>\/home\/oracle\/.profile<\/strong> file:<\/p>\n<p>[crayon]ORACLE_HOSTNAME=sunucu_ismi.domain.com; export ORACLE_HOSTNAME<br \/>\nORACLE_BASE=\/oracle; export ORACLE_BASE<br \/>\nORACLE_HOME=$ORACLE_BASE\/11G; export ORACLE_HOME<br \/>\nORACLE_SID=hidiv; export ORACLE_SID<br \/>\nPATH=\/usr\/sbin:$PATH; export PATH<br \/>\nPATH=$ORACLE_HOME\/bin:$PATH; export PATHhostname[\/crayon]<\/p>\n<p>The root.sh script in \/&#8230;\/database\/rootpre is run as the root user.<\/p>\n<p>Connecting using xmanager or similar software and running &#8220;runInstaller&#8221; in the \/..\/database\/ directory starts the installation process.<\/p>\n<div id=\"attachment_6535\" style=\"width: 871px\" class=\"wp-caption alignnone\"><a href=\"\/wp-content\/old_uploads\/0-Root-Sh.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6535\" class=\"wp-image-6535 size-full\" src=\"\/wp-content\/old_uploads\/0-Root-Sh.png\" alt=\"Installing an Oracle \" width=\"861\" height=\"661\" \/><\/a><p id=\"caption-attachment-6535\" class=\"wp-caption-text\">Installing an Oracle<\/p><\/div>\n<div id=\"attachment_6538\" style=\"width: 1051px\" class=\"wp-caption alignnone\"><a href=\"\/wp-content\/old_uploads\/128.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6538\" class=\"wp-image-6538 size-full\" src=\"\/wp-content\/old_uploads\/128.png\" alt=\"Installing an Oracle\" width=\"1041\" height=\"657\" \/><\/a><p id=\"caption-attachment-6538\" class=\"wp-caption-text\">Installing an Oracle<\/p><\/div>\n<p><a href=\"\/wp-content\/old_uploads\/215.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6540\" src=\"\/wp-content\/old_uploads\/215.png\" alt=\"2\" width=\"802\" height=\"603\" \/><\/a><\/p>\n<div id=\"attachment_6542\" style=\"width: 815px\" class=\"wp-caption alignnone\"><a href=\"\/wp-content\/old_uploads\/39.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6542\" class=\"wp-image-6542 size-full\" src=\"\/wp-content\/old_uploads\/39.png\" alt=\"Installing an Oracle\" width=\"805\" height=\"601\" \/><\/a><p id=\"caption-attachment-6542\" class=\"wp-caption-text\">Installing an Oracle<\/p><\/div>\n<div id=\"attachment_6544\" style=\"width: 815px\" class=\"wp-caption alignnone\"><a href=\"\/wp-content\/old_uploads\/49.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6544\" class=\"wp-image-6544 size-full\" src=\"\/wp-content\/old_uploads\/49.png\" alt=\"Installing an Oracle\" width=\"805\" height=\"600\" \/><\/a><p id=\"caption-attachment-6544\" class=\"wp-caption-text\">Installing an Oracle<\/p><\/div>\n<div id=\"attachment_6546\" style=\"width: 814px\" class=\"wp-caption alignnone\"><a href=\"\/wp-content\/old_uploads\/59.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6546\" class=\"wp-image-6546 size-full\" src=\"\/wp-content\/old_uploads\/59.png\" alt=\"Installing an Oracle\" width=\"804\" height=\"603\" \/><\/a><p id=\"caption-attachment-6546\" class=\"wp-caption-text\">Installing an Oracle<\/p><\/div>\n<div id=\"attachment_6548\" style=\"width: 815px\" class=\"wp-caption alignnone\"><a href=\"\/wp-content\/old_uploads\/66.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6548\" class=\"wp-image-6548 size-full\" src=\"\/wp-content\/old_uploads\/66.png\" alt=\"Installing an Oracle\" width=\"805\" height=\"605\" \/><\/a><p id=\"caption-attachment-6548\" class=\"wp-caption-text\">Installing an Oracle<\/p><\/div>\n<div id=\"attachment_6550\" style=\"width: 814px\" class=\"wp-caption alignnone\"><a href=\"\/wp-content\/old_uploads\/77.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6550\" class=\"wp-image-6550 size-full\" src=\"\/wp-content\/old_uploads\/77.png\" alt=\"Installing an Oracle\" width=\"804\" height=\"603\" \/><\/a><p id=\"caption-attachment-6550\" class=\"wp-caption-text\">Installing an Oracle<\/p><\/div>\n<div id=\"attachment_6552\" style=\"width: 816px\" class=\"wp-caption alignnone\"><a href=\"\/wp-content\/old_uploads\/88.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6552\" class=\"wp-image-6552 size-full\" src=\"\/wp-content\/old_uploads\/88.png\" alt=\"Installing an Oracle\" width=\"806\" height=\"607\" \/><\/a><p id=\"caption-attachment-6552\" class=\"wp-caption-text\">Installing an Oracle<\/p><\/div>\n<div id=\"attachment_6552\" style=\"width: 816px\" class=\"wp-caption alignnone\"><a href=\"\/wp-content\/old_uploads\/88.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6552\" class=\"wp-image-6552 size-full\" src=\"\/wp-content\/old_uploads\/88.png\" alt=\"Installing an Oracle\" width=\"806\" height=\"607\" \/><\/a><p id=\"caption-attachment-6552\" class=\"wp-caption-text\">Installing an Oracle<\/p><\/div>\n<div id=\"attachment_6554\" style=\"width: 813px\" class=\"wp-caption alignnone\"><a href=\"\/wp-content\/old_uploads\/96.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6554\" class=\"wp-image-6554 size-full\" src=\"\/wp-content\/old_uploads\/96.png\" alt=\"Installing an Oracle\" width=\"803\" height=\"604\" \/><\/a><p id=\"caption-attachment-6554\" class=\"wp-caption-text\">Installing an Oracle<\/p><\/div>\n<div id=\"attachment_6556\" style=\"width: 952px\" class=\"wp-caption alignnone\"><a href=\"\/wp-content\/old_uploads\/107.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6556\" class=\"wp-image-6556 size-full\" src=\"\/wp-content\/old_uploads\/107.png\" alt=\"Installing an Oracle\" width=\"942\" height=\"780\" \/><\/a><p id=\"caption-attachment-6556\" class=\"wp-caption-text\">Installing an Oracle<\/p><\/div>\n<div id=\"attachment_6558\" style=\"width: 1290px\" class=\"wp-caption alignnone\"><a href=\"\/wp-content\/old_uploads\/10-1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6558\" class=\"wp-image-6558 size-full\" src=\"\/wp-content\/old_uploads\/10-1.png\" alt=\"Installing an Oracle\" width=\"1280\" height=\"1024\" \/><\/a><p id=\"caption-attachment-6558\" class=\"wp-caption-text\">Installing an Oracle<\/p><\/div>\n<div id=\"attachment_6560\" style=\"width: 947px\" class=\"wp-caption alignnone\"><a href=\"\/wp-content\/old_uploads\/1111.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6560\" class=\"wp-image-6560 size-full\" src=\"\/wp-content\/old_uploads\/1111.png\" alt=\"Installing an Oracle\" width=\"937\" height=\"774\" \/><\/a><p id=\"caption-attachment-6560\" class=\"wp-caption-text\">Installing an Oracle<\/p><\/div>\n<div id=\"attachment_6562\" style=\"width: 815px\" class=\"wp-caption alignnone\"><a href=\"\/wp-content\/old_uploads\/129.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6562\" class=\"wp-image-6562 size-full\" src=\"\/wp-content\/old_uploads\/129.png\" alt=\"Installing an Oracle\" width=\"805\" height=\"605\" \/><\/a><p id=\"caption-attachment-6562\" class=\"wp-caption-text\">Installing an Oracle<\/p><\/div>\n<div id=\"attachment_6564\" style=\"width: 973px\" class=\"wp-caption alignnone\"><a href=\"\/wp-content\/old_uploads\/12-1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6564\" class=\"wp-image-6564 size-full\" src=\"\/wp-content\/old_uploads\/12-1.png\" alt=\"Installing an Oracle\" width=\"963\" height=\"600\" \/><\/a><p id=\"caption-attachment-6564\" class=\"wp-caption-text\">Installing an Oracle<\/p><\/div>\n<h3>Installation and settings<\/h3>\n<p>Loading SSH<\/p>\n<p>[crayon]geninstall -I&#8221;Y&#8221; -d\/dev\/cd0 I:openssh.base[\/crayon]<br \/>\n[crayon]startsrc -s sshd veya startsrc -g ssh (group)<br \/>\nstopsrc -s sshd veya stopsrc -g ssh<br \/>\nlssrc -s sshd veya lssrc -s ssh[\/crayon]<br \/>\n[crayon]\/etc\/rc.d\/rc2.d\/Ksshd start<br \/>\n\/etc\/rc.d\/rc2.d\/Ssshd start<br \/>\n\/etc\/rc.d\/rc2.d\/Ksshd stop<br \/>\n\/etc\/rc.d\/rc2.d\/Ssshd stop[\/crayon]<\/p>\n<p><strong>Installing bash and unzip<\/strong><\/p>\n<p>Download from <a href=\"http:\/\/www-03.ibm.com\/systems\/power\/software\/aix\/linux\/toolbox\/ezinstall.html\">ibm.com\/systems\/power\/software\/aix\/linux\/toolbox\/ezinstall.html<\/a><\/p>\n<p>[crayon]rpm -i bash-3.2-1.aix5.2.ppc.rpm<br \/>\nrpm -i unzip-5.51-1.aix5.1.ppc.rpm[\/crayon]<\/p>\n<p><strong>Patch level and\/or installed patches<\/strong><\/p>\n<p>To list installed patches<\/p>\n<p>[crayon]instfix -ivq<\/p>\n<p>[\/crayon]<br \/>\nInstalled filesets<\/p>\n<p>[crayon]lslpp -L<\/p>\n<p>[\/crayon]<br \/>\nUpdating the server (futher details in the link below)<\/p>\n<p>[crayon]smit suma<\/p>\n<p>[\/crayon]<\/p>\n<p>The path where images files are downloaded to is \/usr\/sys\/inst.images<\/p>\n<p>To update the system.<\/p>\n<p>[crayon]smit update_all<\/p>\n<p>[\/crayon]<\/p>\n<p>Guide for installing service packs at the IBM website<\/p>\n<p><a href=\"http:\/\/www.ibm.com\/developerworks\/aix\/library\/au-aixservicepacks\/\">ibm.com\/developerworks\/aix\/library\/au-aixservicepacks<\/a><\/p>\n<p><a href=\"http:\/\/www.ibm.com\/developerworks\/aix\/library\/au-aixservicepacks\/#resources\">ibm.com\/developerworks\/aix\/library\/au-aixservicepacks\/#resources<\/a><\/p>\n<p>Fix Center<\/p>\n<p><a href=\"http:\/\/www-933.ibm.com\/support\/fixcentral\/main\/System+p\/AIX\">ibm.com\/support\/fixcentral\/main\/System+p\/AIX<\/a><\/p>\n<p>[crayon]bash-3.2#lspv<br \/>\nhdisk0 00f6f61c679c5344 rootvg active<br \/>\nhdisk1 00f6f61cf7ee6c60 vg00 active<br \/>\nlsvg -l rootvg<br \/>\nlsvg -l vg00[\/crayon]<br \/>\n[crayon]lspv hdisk0<\/p>\n<p>[\/crayon]<br \/>\n[crayon]lsvg -o | lsvg -i -l<\/p>\n<p>[\/crayon]<\/p>\n<h3>Disk\/File System Tasks<\/h3>\n<p>Volume Group and File System information<\/p>\n<p>[crayon]crfs -v jfs2 -g vg00 -a size=10M -m \/fs1<\/p>\n<p>[\/crayon]<\/p>\n<p>Note: In order to mount automatically at startup, the<strong> \/fs1 <\/strong>mount parameter in<strong> \/etc\/filesystems <\/strong>needs to be set to true.<\/p>\n<p>The mount -a (or mount all) command should be used to mount volumes that have their mount parameters set to true.<\/p>\n<p><strong>umount \/fs1<\/strong> unmounts the volume.<\/p>\n<p>Adding a 10GB storage are to the 10MB storage area.<\/p>\n<p>[crayon]hfs -a size=+10G \/fs1<\/p>\n<p>[\/crayon]<br \/>\nThis syntax creates a 10M read-only file system mounted on \/fs2in volume group 00:<\/p>\n<p>[crayon]crfs -v jfs2 -g vg00 -a size=10M -p ro -m \/fs2 #olu\u015fturduktan sonra \u201cmount \/fs2\u201d ile mount emek laz\u0131m.<\/p>\n<p>[\/crayon]<br \/>\nTo delete the file system.<\/p>\n<p>[crayon]rmfs \/fs1<\/p>\n<p>[\/crayon]<br \/>\ndefragment<\/p>\n<p>[crayon]defragfs \/home<\/p>\n<p>[\/crayon]<br \/>\nFile system mount<\/p>\n<p>[crayon]mount \/dev\/fslv01 \/u01 &#8212; \/dev\/fslv1 i \/u01 e mount eder.<\/p>\n<p>[\/crayon]<br \/>\nIncreasing the Swap size<\/p>\n<p>[crayon]lsps -a<br \/>\nPage Space Physical Volume Volume Group Size %Used Active Auto Type Chksum<br \/>\nhd6 hdisk0 rootvg 512MB 3 yes yes lv 0<\/p>\n<p>[\/crayon]<br \/>\n[crayon]extendlv hd6 2G<\/p>\n<p>[\/crayon]<\/p>\n<p>[crayon]lsps -a<br \/>\nPage Space Physical Volume Volume Group Size %Used Active Auto Type Chksum<br \/>\nhd6 hdisk0 rootvg 2560MB 3 yes yes lv 0<\/p>\n<p>[\/crayon]<br \/>\nDisk Performance<\/p>\n<p>[crayon]iostat<br \/>\nnmon ? (d-&gt;disk, c-&gt;cpu, n-&gt;network)<\/p>\n<p>[\/crayon]<\/p>\n<h3>LVM and RAID1<\/h3>\n<p>There are 2 disks on the system, hdisk0 and hdisk1. hdisk0 is active in the &#8220;rootvg&#8221; volume group.<\/p>\n<p>We&#8217;ll now add hdisk1 to the <strong>rootvg<\/strong> volume group and place both disks in mirror mode.<\/p>\n<p>[crayon]<\/p>\n<p>extendvg rootvg hdisk1<br \/>\nmirror rootvg hdisk1<br \/>\nbosboot \u2013ad \/dev\/hdisk1<br \/>\nbootlist \u2013m normal hdisk0 hdisk1 \u00ab Writing this to the bootlist is necessary otherwise hdisk 1 won&#8217;t be bootable<br \/>\n[\/crayon]<\/p>\n<p>[crayon]bash-3.2# lsvg -l rootvg[\/crayon]<\/p>\n<table style=\"width: 600px;\" border=\"0\" cellspacing=\"0\" cellpadding=\"5\" align=\"left\">\n<tbody>\n<tr>\n<td><span style=\"font-size: 10pt;\"><strong>LVNAME<\/strong><\/span><\/td>\n<td><span style=\"font-size: 10pt;\"><strong>TYPE <\/strong><\/span><\/td>\n<td><span style=\"font-size: 10pt;\"><strong>LPS <\/strong><\/span><\/td>\n<td><span style=\"font-size: 10pt;\"><strong>PPS <\/strong><\/span><\/td>\n<td><span style=\"font-size: 10pt;\"><strong>PVS <\/strong><\/span><\/td>\n<td><span style=\"font-size: 10pt;\"><strong>LV STATE<\/strong><\/span><\/td>\n<td><span style=\"font-size: 10pt;\"><strong>MOUNT POINT<\/strong><\/span><\/td>\n<\/tr>\n<tr>\n<td>hd5<\/td>\n<td>boot<\/td>\n<td>1<\/td>\n<td>2<\/td>\n<td>2<\/td>\n<td>CLOSED\/SYNCED<\/td>\n<td>N\/A<\/td>\n<\/tr>\n<tr>\n<td>hd6<\/td>\n<td>paging<\/td>\n<td>10<\/td>\n<td>20<\/td>\n<td>2<\/td>\n<td>OPEN\/SYNCED<\/td>\n<td>N\/A<\/td>\n<\/tr>\n<tr>\n<td>hd4<\/td>\n<td>jf2<\/td>\n<td>40<\/td>\n<td>80<\/td>\n<td>2<\/td>\n<td>OPEN\/SYNCED<\/td>\n<td>\/<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Entries in the output where the PPS is double the amount of PPS indicate that the mirroring is active.<\/p>\n<p>This can be used in situations where there aren&#8217;t RAID controllers, however applying RAID 10 with this method would substantially decrease the database&#8217;s performance.<\/p>\n<p>&nbsp;<\/p>\n<p>Mounting the CD<\/p>\n<p>&nbsp;<\/p>\n<p>[crayon]mount -V cdrfs -o ro \/dev\/cd0 \/cdrom<\/p>\n<p>[\/crayon]<br \/>\nThe fileset that the binary is from<\/p>\n<p>[crayon]lslpp -w \/usr\/bin\/vmstat<br \/>\nveya<br \/>\nwhich_fileset ssh<br \/>\nlslpp -l |grep ssh[\/crayon]<br \/>\nInstalled filesets<\/p>\n<p>[crayon]instfix -i | grep ML<br \/>\ninstfix -ik IY24043[\/crayon]<br \/>\nDetailed system information<\/p>\n<p>[crayon]lscfg<br \/>\nlscfg -p<br \/>\nlscfg-v[\/crayon]<br \/>\nProcessor count<\/p>\n<p>[crayon]lscfg | grep proc<\/p>\n<p>[\/crayon]<br \/>\nSMT (Simultaneous Multi-Threading)<\/p>\n<p>[crayon]smtctl<br \/>\nsmtctl<br \/>\nsmtctl \u2013m off \u00ab switches off multithreading<br \/>\n[\/crayon]<\/p>\n<p>Performance<\/p>\n<p>[crayon]nmon<br \/>\ntopas<br \/>\ntopas -P<br \/>\ntopas \u2013D<br \/>\ntopas \u2013F<br \/>\ntopas \u2013L<br \/>\niostat[\/crayon]<br \/>\nSaving all of the configuration information under \/tmp<\/p>\n<p>[crayon]snap -ac<\/p>\n<p>[\/crayon]<\/p>\n<h3>Display<\/h3>\n<p>If you&#8217;ll be performing the installation over a network using a different machine, you&#8217;ll want to see what&#8217;s happening.<\/p>\n<p>&nbsp;<\/p>\n<p>To do this use Display Config<\/p>\n<p>[crayon]DISPLAY=local_IP:0.0<br \/>\nexport DISPLAY<br \/>\nxhost + remote_machine_IP (The IP of the machine where the setup screen is going to work)<br \/>\nsu &#8211; oracle<br \/>\nDISPLAY=192.168.45.1:0.0<br \/>\nexport DISPLAY<br \/>\nNote: This sometimes doesn&#8217;t work, which is why I prefer xmanager<br \/>\n[\/crayon]<\/p>\n<p><strong>Some problems that may be encountered <\/strong><\/p>\n<p>OS Kernel Version &#8211; This is a prerequisite condition to test whether the system kernel version is at least &#8220;6.1-6100.02.01&#8221;.<\/p>\n<p>Expected Value<\/p>\n<p>: 6.1-6100.02.01<\/p>\n<p>Actual Value<\/p>\n<p>: 1 6 oslevel: Error processing cache, return code 215.\/bin\/sh[2]: oslevel:: not found<\/p>\n<p>Details:<\/p>\n<p>&#8211;<\/p>\n<p>Kernel of proper version is not found on node &#8220;ibmaix6&#8221; [Expected = &#8220;6.1-6100.02.01&#8221; ; Found = &#8220;1 6 oslevel: Error processing cache, return code 215.\/bin\/sh[2]: oslevel:: not found&#8221;] &#8211; Cause: Cause Of Problem Not Available &#8211; Action: User Action Not Available<\/p>\n<p>OS Patch:IZ97457 &#8211; This is a prerequisite condition to test whether the patch &#8220;IZ97457&#8221; is available on the system.<\/p>\n<p>Expected Value<\/p>\n<p>: Patch IZ97457<\/p>\n<p>Actual Value<\/p>\n<p>: missing<\/p>\n<p>Details:<\/p>\n<p>&#8211;<\/p>\n<p>PRVF-9809 : Proper OS Patch is not found on node &#8220;ibmaix6&#8221; [Expected = &#8220;IZ97457&#8221; ; Found = &#8220;missing&#8221;] &#8211; Cause: Required OS Patch is not applied. &#8211; Action: Apply the required OS Patch.<\/p>\n<p>We get these errors while installing Oracle, but our current OS level 6100-06-05-1115 already contains these patches.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Resources<\/strong><\/p>\n<p>http:\/\/www.ibm.com\/developerworks\/aix\/library\/au-aixservicepacks\/#resources<\/p>\n<p>http:\/\/www.ibm.com\/developerworks\/wikis\/display\/WikiPtype\/AIX<\/p>\n<p>http:\/\/docs.oracle.com\/cd\/E11882_01\/install.112\/e24335.pdf<\/p>\n<p>http:\/\/docs.oracle.com\/cd\/E11882_01\/install.112\/e24332.pdf<\/p>\n<p>http:\/\/www.ibm.com\/developerworks\/aix\/library\/au-aix_cmds\/index.html?S_TACT=105AGX20&#038;;S_CMP=EDU<\/p>\n<p>http:\/\/docs.oracle.com\/cd\/B16240_01\/doc\/em.102\/e10953\/app_platform_pkg_req.htm<\/p>\n<p>http:\/\/ramses.smeyers.be\/varia\/aix\/mirrorrootvg\/<\/p>\n<p>&nbsp;<\/p>\n<p><strong>How to mirror an AIX rootvg<\/strong><\/p>\n<p>The following steps will guide you trough the mirroring of an AIX rootvg.<\/p>\n<p>This info is valid for AIX 4.3.3, AIX 5.1, AIX 5.2 and AIX 5.3.<\/p>\n<p>Make sure you have an empty disk, in this example its <strong>hdisk1<\/strong><\/p>\n<ol>\n<li>Add the disk to the vg via &#8220;extendvg rootvg hdisk1<\/li>\n<li>Mirror the vg via: &#8220;mirrorvg rootvg&#8221;<\/li>\n<li>Adapt the bootlist to add the current disk, the system will then fall to hdisk1 if hdisk0 fails during startup<\/li>\n<li>do bootlist -o -m normal , this will list currently 1 disk, in this exaple hdisk0<\/li>\n<li>do bootlist -m normal hdisk0 hdisk1<\/li>\n<li>Run a bosboot on both new disks, this will install all software needed for boot on the disk:<\/li>\n<\/ol>\n<p>a. bosboot -ad hdisk0<\/p>\n<p>b. bosboot -ad hdisk1<\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<\/p>\n<p><a href=\"http:\/\/publib.boulder.ibm.com\/infocenter\/aix\/v6r1\/index.jsp\">http:\/\/publib.boulder.ibm.com\/infocenter\/aix\/v6r1\/index.jsp<\/a><\/p>\n<p><a href=\"http:\/\/publib.boulder.ibm.com\/infocenter\/aix\/v7r1\/index.jsp\">http:\/\/publib.boulder.ibm.com\/infocenter\/aix\/v7r1\/index.jsp<\/a><\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<\/p>\n<p><a href=\"http:\/\/publib.boulder.ibm.com\/infocenter\/aix\/v6r1\/index.jsp?topic=%2Fcom.ibm.aix.commadmn%2Fdoc%2Fcommadmndita%2Fiscsi_intro.htm\">http:\/\/publib.boulder.ibm.com\/infocenter\/aix\/v6r1\/index.jsp?topic=%2Fcom.ibm.aix.commadmn%2Fdoc%2Fcommadmndita%2Fiscsi_intro.htm<\/a><\/p>\n<p><a href=\"http:\/\/publib.boulder.ibm.com\/infocenter\/aix\/v6r1\/advanced\/print.jsp?topic=\/com.ibm.aix.commadmn\/doc\/commadmndita\/iscsi_intro.htm&amp;;topicIndexId=t0_6_4_3_29&amp;confirmed=true\">http:\/\/publib.boulder.ibm.com\/infocenter\/aix\/v6r1\/advanced\/print.jsp?topic=\/com.ibm.aix.commadmn\/doc\/commadmndita\/iscsi_intro.htm&amp;;topicIndexId=t0_6_4_3_29&amp;confirmed=true<\/a><\/p>\n<p><a href=\"http:\/\/publib.boulder.ibm.com\/infocenter\/aix\/v6r1\/index.jsp?topic=%2Fcom.ibm.aix.baseadmn%2Fdoc%2Fbaseadmndita%2Fadd_iscsi_targets_odm.htm\">http:\/\/publib.boulder.ibm.com\/infocenter\/aix\/v6r1\/index.jsp?topic=%2Fcom.ibm.aix.baseadmn%2Fdoc%2Fbaseadmndita%2Fadd_iscsi_targets_odm.htm<\/a><\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<\/p>\n<p><a href=\"http:\/\/publib.boulder.ibm.com\/infocenter\/powersys\/v3r1m5\/index.jsp?topic=\/p7eab\/p7-placement-kickoff_8202.htm\">http:\/\/publib.boulder.ibm.com\/infocenter\/powersys\/v3r1m5\/index.jsp?topic=\/p7eab\/p7-placement-kickoff_8202.htm<\/a><\/p>\n<p><a href=\"http:\/\/publib.boulder.ibm.com\/infocenter\/powersys\/v3r1m5\/index.jsp?topic=\/p7hcd\/fc2053.htm\">http:\/\/publib.boulder.ibm.com\/infocenter\/powersys\/v3r1m5\/index.jsp?topic=\/p7hcd\/fc2053.htm<\/a><\/p>\n<p><a href=\"http:\/\/publib.boulder.ibm.com\/infocenter\/powersys\/v3r1m5\/index.jsp?topic=\/p7hcd\/fc2053.htm\">http:\/\/publib.boulder.ibm.com\/infocenter\/powersys\/v3r1m5\/index.jsp?topic=\/p7hcd\/fc2053.htm<\/a><\/p>\n<p>&nbsp;<\/p>\n<h3>AIX Best Practices<\/h3>\n<p>An explanation of the best practices after installing AIX can be found in the following link. It includes what the applicable practices are, why they are so and how to apply them.<\/p>\n<p><a href=\"http:\/\/www.ibm.com\/developerworks\/wikis\/display\/WikiPtype\/AIXV53AdminBestPractice\">http:\/\/www.ibm.com\/developerworks\/wikis\/display\/WikiPtype\/AIXV53AdminBestPractice<\/a><\/p>\n<p>&#8211; This page contains useful commands: <a href=\"http:\/\/www.ibm.com\/developerworks\/aix\/library\/au-dutta_cmds.html\">http:\/\/www.ibm.com\/developerworks\/aix\/library\/au-dutta_cmds.html<\/a><\/p>\n<p>&#8211; With every installation try to get the latest patches, but before applying the patches check online to see if any there have been any problems with them.<\/p>\n<p>&nbsp;<\/p>\n<h3>Hands-On tips<\/h3>\n<p><strong>1. <\/strong>Adjusting the Paging Space<\/p>\n<p>The suggested size of the paging space hd6 can be determined by the amount of RAM on the system and by using the following table.<\/p>\n<p>Please note that these values are only an initial suggestion for the paging space size with the default system settings, you may be required to resize when necessary.<\/p>\n<table>\n<tbody>\n<tr>\n<td>RAM (GB)<\/td>\n<td>Paging Space Size<\/td>\n<\/tr>\n<tr>\n<td>1 to 32GB<\/td>\n<td>1\/2 of total RAM (512MB to 16GB)<\/td>\n<\/tr>\n<tr>\n<td>32 to 64GB<\/td>\n<td>1\/4 of total RAM (8 to 16GB)<\/td>\n<\/tr>\n<tr>\n<td>64 to 128GB<\/td>\n<td>1\/8 of total RAM (8 to 16GB)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>2.<\/strong> Increase the size of the Oracle fs. (for example: chfs -a size=+2G \/var)<\/p>\n<p><strong>3.<\/strong> Arrange the size of the dump device, the sysdumpdev -K command enables sysdump.<\/p>\n<p><strong>4.<\/strong> Install open source programs such as OpenSSL, OpenSSH, BASH, GNU Screen, VNC, LSOF.<\/p>\n<p><strong>5.<\/strong> Before changing any file under \/etc, first make a copy using cp -p.<\/p>\n<p><strong>6.<\/strong> Remove the default user limits:<\/p>\n<p>vi \/etc\/security\/limits<\/p>\n<p>fsize=-1<\/p>\n<p><strong>7.<\/strong> If rootvg is the local (internal disk) check the bootlist by mirroring (mirrorvg rootvg).<\/p>\n<p><strong>8.<\/strong> Arrange the SCSI and hdisk attributes.<\/p>\n<p><strong>a)<\/strong> Through vio, do the following in Lpar:<\/p>\n<p>chdev -a hcheck_interval=60 -a hcheck_mode=nonactive -l hdisk0 -P (requires a restart)<\/p>\n<p>chdev -a hcheck_interval=60 -a hcheck_mode=nonactive -l hdisk1;<\/p>\n<p>chdev -l vscsi0 -a vscsi_path_to=30 -a vscsi_err_recov=fast_fail -P (requires a restart)<\/p>\n<p>chdev -l vscsi1 -a vscsi_path_to=30 -a vscsi_err_recov=fast_fail -P (requires a restart)<\/p>\n<p>chpath -l hdisk0 -p vscsi1 -a priority=2 (hdisk0, should go from vscsi0)<\/p>\n<p>chpath -l hdisk1 -p vscsi0 -a priority=2 (hdisk1, goes from hdisk1)<\/p>\n<p><strong>b)<\/strong> Physical SCSI (Fiber Channel)<\/p>\n<p>chdev -l fscsi0 -a fc_err_recov=fast_fail -a dyntrk=yes -P<\/p>\n<p>chdev -l fscsi1 -a fc_err_recov=fast_fail -a dyntrk=yes -P<\/p>\n<p><strong>9.<\/strong> Adjust the TimeZone, enable daylisgt saving, restart and set the datetime.<\/p>\n<p><strong>10.<\/strong> If a dns is present, set the ntp<\/p>\n<p><strong>11.<\/strong> Add a PS1 to \/etc\/profile<\/p>\n<p>vi \/etc\/profile;<\/p>\n<p>PS1=&#8221;$LOGNAME@$(hostname):\\$PWD&gt; &#8221;<\/p>\n<p>set -o vi<\/p>\n<p>&nbsp;<\/p>\n<p>This is a list of the best practices for the time being.<\/p>\n<p>&#8211; Information regarding the RAID levels that SAS cards support is available at the link below. This link applies to P710\/730 servers.<\/p>\n<p>&nbsp;<\/p>\n<p>For configuration information regarding other machines please check the relevant documentation.<\/p>\n<p><a href=\"http:\/\/publib.boulder.ibm.com\/infocenter\/powersys\/v3r1m5\/index.jsp?topic=\/p7hcd\/fc2053.htm\">http:\/\/publib.boulder.ibm.com\/infocenter\/powersys\/v3r1m5\/index.jsp?topic=\/p7hcd\/fc2053.htm<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&#8211; NIM (Network Installation Management) has a Linux version called NIMOL (Network Installation Management on Linux).<\/p>\n<p>&nbsp;<\/p>\n<p>This is a guide on installing and configuring:<\/p>\n<p><a href=\"http:\/\/www.ibm.com\/developerworks\/aix\/library\/au-install-aix.html#instlinim\">http:\/\/www.ibm.com\/developerworks\/aix\/library\/au-install-aix.html#instlinim<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&#8211; To increase bandwidth<\/p>\n<p><a href=\"http:\/\/publib.boulder.ibm.com\/infocenter\/aix\/v6r1\/index.jsp?topic=%2Fcom.ibm.aix.commadmn%2Fdoc%2Fcommadmndita%2Fetherchannel_consider.htm\">http:\/\/publib.boulder.ibm.com\/infocenter\/aix\/v6r1\/index.jsp?topic=%2Fcom.ibm.aix.commadmn%2Fdoc%2Fcommadmndita%2Fetherchannel_consider.htm<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>It&#8217;s worth reading all the headings before beginning the installation process<\/p>\n","protected":false},"author":1,"featured_media":3426,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[383,338],"tags":[345],"class_list":["post-2583","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dba_i","category-oracle-tr","tag-oracle"],"_links":{"self":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/posts\/2583","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/comments?post=2583"}],"version-history":[{"count":1,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/posts\/2583\/revisions"}],"predecessor-version":[{"id":4827,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/posts\/2583\/revisions\/4827"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/media?parent=2583"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/categories?post=2583"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/tags?post=2583"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}