Intresting articles on queue depth

While doing some research on understanding Queue depth from an Oracle database running on AIX perspective, I came across these two articles which have done an excellent job explaining it.

http://dsstos.blogspot.com/2008/12/hostlun-queue-depths-command-taq.html

http://www-01.ibm.com/support/docview.wss?uid=tss1td105745

http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/TD105745

Slow connection between the Oracle RAC nodes

While setting up our Oracle RAC hardware running AIX 7.1 we noticed that a simple 'rsh' between the nodes would take really long. In this case we were trying to see if we could rsh from one node to the other node using the private interconnect which were using 10 GigE NICs.

As you see here that something like "rsh 192.168.150.22 'date'" took an awful long time.

bash-4.2# time rsh 192.168.150.22 'date' Thu Apr 11 18:30:41 CDT 2013 real    1m11.372s user    0m0.002s sys     0m0.002s bash-4.2#

This thing was that we did not have a 'hosts' entry in the /etc/netsvc.conf file. The /etc/netsvc.conf file is used to specify the ordering of name resolution. The order we specify in the /etc/netsvc.conf will override the default ordering, and use the order specified by us for the 'hosts' keyword.

After we added the following line to the /etc/netsvc.conf, everything worked as expected.
hosts=local,bind

Here is the rsh after adding the hosts field to the /etc/netsvc.conf

bash-4.2# time rsh 192.168.150.22 'date' Thu Apr 11 18:31:58 CDT 2013 real    0m0.107s user    0m0.002s sys     0m0.002s bash-4.2#

ORA-09817: Write to audit file failed.

While trying to connect to our 11gR2 Oracle database this morning I got the
ORA-09817: Write to audit file failed. error message.

bash-3.2$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 14 10:29:19 2011 Copyright (c) 1982, 2009, Oracle. All rights reserved. ERROR: ORA-09817: Write to audit file failed. IBM AIX RISC System/6000 Error: 28: No space left on device Additional information: 12 ORA-09945: Unable to initialize the audit trail file IBM AIX RISC System/6000 Error: 28: No space left on device Enter user-name:

On doing a "df -m" at I noticed that the / had run out of space. It's on / that I had our ORACLE_HOME, so I seemed that that might have caused the problem.

$ df -m Filesystem MB blocks Free %Used Iused %Iused Mounted on /dev/hd4 25600.00 0.00 100% 70464 95% /

I increased the size of / from 25G to 50G by doing the following:

isvp14_ora> chfs -a size=50G / Filesystem size changed to 104857600 isvp14_ora> df -m Filesystem MB blocks Free %Used Iused %Iused Mounted on /dev/hd4 51200.00 25596.05 51% 70465 2% /

Now, I tried to connect to the database again, and everything worked fine.

bash-3.2$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 14 10:34:32 2011 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL>

Installing Oracle 11g R2 on AIX 7.1

On AIX 7.1 as root execute the rootpre.sh script which part of the Oracle zip files that you downloaded from the Oracle site. eg.

$ pwd
/home/oracle/database
$ ls
doc           response      rootpre.sh    runInstaller  stage
install       rootpre       rpm           sshsetup      welcome.html


Next as user oracle run runInstaller to start the installation of Oracle binaries using the GUI

$ ./runInstaller
********************************************************************************

Your platform requires the root user to perform certain pre-installation
OS preparation.  The root user should run the shell script 'rootpre.sh' before
you proceed with Oracle installation.  rootpre.sh can be found at the top level
of the CD or the stage area.

Answer 'y' if root has run 'rootpre.sh' so you can proceed with Oracle
installation.
Answer 'n' to abort installation and then ask root to run 'rootpre.sh'.

********************************************************************************

Has 'rootpre.sh' been run by root? [y/n] (n)
y


Next you'll get the below message even if you have met all the pre-reqs as per the Oracle docs.  I was told that this a know issue, so say Yes to it, and continue.

 Check the posting http://shettymayur.blogspot.com/2011/02/oracle-11g-r2-installation-fails-with.html for the getting around the below error message.

ORA-32004, ORA-32004 and ORA-07286 all in one

I was trying enable archive log for my database when I made a typo and entered the wrong path. When I tried to start database, I got ORA-32004, ORA-32004 and ORA-07286 all in one error message.

Googled around and found something similar at:
http://savaskulah.wordpress.com/2010/09/05/log_archive_dest_2-destination-string-cannot-be-translated/

Here is how I got the error message in the first place. The highlighted path did not exit, and that is what caused all the bother.

SQL> startup mount; ORACLE instance started. Total System Global Area 1.0289E+10 bytes Fixed Size                  2215712 bytes Variable Size            5268046048 bytes Database Buffers         4999610368 bytes Redo Buffers               18743296 bytes Database mounted. SQL> select name, log_mode from v$database; NAME      LOG_MODE --------- ------------ TESTGM    NOARCHIVELOG SQL> show parameter spfile; NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ spfile                               string      /u01/app/oracle/product/11.2.0                                                  /dbhome_1/dbs/spfiletestgm.ora SQL> alter system set log_archive_start=TRUE   2  scope=spfile; System altered. SQL> alter system set log_archive_dest_1='location=/gm_oraarc/testgm' scope=spfile; System altered. SQL> shutdown immediate; ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> startup mount; ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORA-16032: parameter LOG_ARCHIVE_DEST_1 destination string cannot be translated ORA-07286: sksagdi: cannot obtain device information. IBM AIX RISC System/6000 Error: 2: No such file or directory SQL> startup nomount; ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORA-16032: parameter LOG_ARCHIVE_DEST_1 destination string cannot be translated ORA-07286: sksagdi: cannot obtain device information. IBM AIX RISC System/6000 Error: 2: No such file or directory SQL> quit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

Here is what I did to fix the issue:

$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Mon Feb 28 13:54:56 2011 Copyright (c) 1982, 2009, Oracle.  All rights reserved. Connected to an idle instance. SQL> create pfile from spfile; File created. SQL> quit Disconnected

I then edited the inittestgm.ora file under $ORACLE_HOME/dbs , and corrected the archive log destination path of *.log_archive_dest_1='location=/gm_oraarch/testgm'

$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Mon Feb 28 14:27:11 2011 Copyright (c) 1982, 2009, Oracle.  All rights reserved. Connected to an idle instance. SQL> startup nomount pfile='$ORACLE_HOME/dbs/inittestgm.ora'; ORA-32006: LOG_ARCHIVE_START initialization parameter has been deprecated ORACLE instance started. Total System Global Area 1.0289E+10 bytes Fixed Size                  2215712 bytes Variable Size            5268046048 bytes Database Buffers         4999610368 bytes Redo Buffers               18743296 bytes SQL> create spfile from pfile; File created. SQL> shutdown immediate; ORA-01507: database not mounted ORACLE instance shut down. SQL> startup; ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System Global Area 1.0289E+10 bytes Fixed Size                  2215712 bytes Variable Size            5268046048 bytes Database Buffers         4999610368 bytes Redo Buffers               18743296 bytes Database mounted. Database opened. SQL> SELECT value from v$parameter where name='spfile'; VALUE -------------------------------------------------------------------------------- /u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfiletestgm.ora SQL>

Accessing Oracle database volumes that were backedup using FlashCopy feature of the Storwize V7000

Backing up an Oracle database using FlashCopy is all very simple. The Storwize GUI is really cool, and with
a click of a few buttons we are up and going.

The tricky part is once the backup has completed. The new volumes now have the LVM data structures, which means now they will belong to the original volume group as the source volumes.

Let see how all this happens. In my case, I had my Oracle file on the physical disks hdisk1, hdisk2 , and hdisk2. The physical volumes each belonged to volume groups test_copy1, test_copy2, and test_copy3 respectively. I have created 3 file systems /oradata , /oralog , and /oraarch on these volume groups, to be used by Oracle.

After the FlashCopy Backup/Clone on the volumes complete, we see that the new volumes belong to the volume groups that they are clones of.

svp18> lspv
hdisk0          00f65d52a5abd459                    rootvg          active
hdisk2          00f65d5108ffefb6                    test_copy2
hdisk3          00f65d51bfba4e2e                    test_copy3
hdisk4          00f65d51c465f8eb                    metro
hdisk5          00f65d52ce125f70                    swap            active
hdisk1          00f65d5108ff9043                    test_copy1
hdisk6          00f65d51c465f8eb                    metro
hdisk7          00f65d5108ff9043                    test_copy1
hdisk8          00f65d5108ffefb6                    test_copy2
hdisk9          00f65d51bfba4e2e                    test_copy3
isvp18>

The recreatevg command overcomes the problem of duplicated LVM data structures and identifiers caused by a disk duplication process such as FlashCopy. It is used to recreate an AIX Volume Group (VG) on a set of target volumes that are copied from a set of source volumes belonging to a specific VG. The command will allocate new physical volume identifiers (PVIDs) for the member disks and a new Volume Group identifier (VGID) to the Volume Group. The command also provides options to rename the logical volumes with a
prefix you specify, and options to rename labels to specify different mount points for file systems.

isvp18> varyoffvg test_cp1
isvp18> varyoffvg test_cp2
isvp18> varyoffvg test_cp3
isvp18> lspv
hdisk0          00f65d52a5abd459                    rootvg          active
hdisk2          00f65d5108ffefb6                    test_cp2
hdisk3          00f65d51bfba4e2e                    test_cp3
hdisk4          00f65d51c465f8eb                    metro
hdisk5          00f65d52ce125f70                    swap            active
hdisk1          00f65d5108ff9043                    test_cp1
hdisk6          00f65d51c465f8eb                    metro
hdisk7          00f65d5108ff9043                    test_cp1
hdisk8          00f65d5108ffefb6                    test_cp2
hdisk9          00f65d51bfba4e2e                    test_cp3
isvp18> chdev -l hdisk7 -a pv=clear
hdisk7 changed
isvp18> chdev -l hdisk8 -a pv=clear
hdisk8 changed
isvp18> chdev -l hdisk9 -a pv=clear
hdisk9 changed
isvp18> lspv
hdisk0          00f65d52a5abd459                    rootvg          active
hdisk2          00f65d5108ffefb6                    test_cp2
hdisk3          00f65d51bfba4e2e                    test_cp3
hdisk4          00f65d51c465f8eb                    metro
hdisk5          00f65d52ce125f70                    swap            active
hdisk1          00f65d5108ff9043                    test_cp1
hdisk6          00f65d51c465f8eb                    metro
hdisk7          none                                None
hdisk8          none                                None
hdisk9          none                                None
isvp18>
isvp18> recreatevg -y fc_test_cp1 -L /backup -Y bkup hdisk7
fc_test_cp1
isvp18>
isvp18> recreatevg -y fc_test_cp2 -L /backup -Y bkup hdisk8
fc_test_cp2
isvp18> recreatevg -y fc_test_cp3 -L /backup -Y bkup hdisk9
isvp18> lspv
hdisk0          00f65d52a5abd459                    rootvg          active
hdisk2          00f65d5108ffefb6                    test_cp2        active
hdisk3          00f65d51bfba4e2e                    test_cp3        active
hdisk4          00f65d51c465f8eb                    metro
hdisk5          00f65d52ce125f70                    swap            active
hdisk1          00f65d5108ff9043                    test_cp1        active
hdisk6          00f65d5226de2253                    fc_metro        active
hdisk7          00f65d5226bdf18a                    fc_test_cp1     active
hdisk8          00f65d5226c876f6                    fc_test_cp2     active
hdisk9          00f65d5226ca8c57                    fc_test_cp3     active
In /etc/filesystems:
/backup/oralog:
        dev             = /dev/bkuplv02
        vfs             = jfs
        log             = /dev/bkuploglv02
        mount           = true
        check           = false
        options         = rw
        account         = false

/backup/oraarch:
        dev             = /dev/bkuplv03
        vfs             = jfs
        log             = /dev/bkuploglv03
        mount           = true
        check           = false
        options         = rw
        account         = false

/backup/oradata:
        dev             = /dev/bkuplv01
        vfs             = jfs
        log             = /dev/bkuploglv00
        mount           = true
        check           = false
        options         = rw
        account         = false

isvp18> mount /backup/oradata
isvp18> mount /backup/oralog
isvp18> mount /backup/oraarch
isvp18>
isvp18> ln -s /backup/oradata /oradata
isvp18> ln -s /backup/oralog /oralog
isvp18> ln -s /backup/oraarch /oraarch
isvp18> ls -l /oradata
lrwxrwxrwx    1 root     system           15 Feb 14 23:25 /oradata -> /backup/oradata
isvp18> su - sqlplus
3004-500 User "sqlplus" does not exist.
isvp18> su - oracle
$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Feb 14 23:26:52 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.


SQL> startup;
ORACLE instance started.

Total System Global Area 1.0289E+10 bytes
Fixed Size                  2215712 bytes
Variable Size            5268046048 bytes
Database Buffers         4999610368 bytes
Redo Buffers               18743296 bytes
Database mounted.
Database opened.
SQL>
The database is now accessible for test, backup, or other development purposes. It is important to note that while the clone is accessing the remote copy replicas, it will not be updated with the latest updates happening to the Metro or Global mirror target volumes.

Adding swap space in AIX7.1 for running Oracle 11gR2

The swap requirement for running Oracle 11g R2 on AIX7.1 is as follows:
For 4 GB to 8 GB Memory the swap requirement is 2 times the size of RAM, for 8 GB to 32 GB the requirement is 1.5 times the size of RAM, and if the Memory is more than 32 GB then the swap space required is 32 GB.

isvp17> lsps -a
Page Space      Physical Volume   Volume Group Size %Used Active  Auto  Type Chksum
hd6             hdisk0            rootvg         512MB     3   yes   yes    lv     0
Ok, we are not doing good in that front. We'll have to find a way to increase the size of swap from 512MB to 
36GB.


So let us see how this can be done on AIX 7.1 .

isvp18> lspv
hdisk0          00f65d52a5abd459                    rootvg          active
hdisk1          00f65d52c3d3cfa6                    oradata         active
hdisk2          none                                None
hdisk3          none                                None
hdisk4          00f65d51c465f8eb                    metro
hdisk5          none                                None
isvp18> mkvg -y swap hdisk5


isvp17> lspv
hdisk0          00f65d51a5aa3cf1                    rootvg          active
hdisk1          00f65d51bfba4e2e                    test1           active
hdisk2          none                                None
hdisk3          none                                None
hdisk4          00f65d51c465f8eb                    metro           active
hdisk5          00f65d51cdf2c48c                    swap            active
isvp17> smitty mkps
+--------------------------------------------------------------------------+
|                            VOLUME GROUP name                             |
|                                                                          |
| Move cursor to desired item and press Enter.                             |
|                                                                          |
|   rootvg                                                                 |
|   test1                                                                  |
|   metro                                                                  |
|   swap                                                                   |
|                                                                          |
| F1=Help                 F2=Refresh              F3=Cancel                |
| F8=Image                F10=Exit                Enter=Do                 |
| /=Find                  n=Find Next                                      |
+--------------------------------------------------------------------------+



Add Another Paging Space

Type or select values in entry fields.
Press Enter AFTER making all desired changes.

[Entry Fields]
Volume group name                                   swap
SIZE of paging space (in logical partitions)       [564]                   #
PHYSICAL VOLUME name                                                       +
Start using this paging space NOW?                  yes                    +
Use this paging space each time the system is       yes                    +
RESTARTED?
Checksum Size                                      []                      +#








F1=Help             F2=Refresh          F3=Cancel           F4=List
F5=Reset            F6=Command          F7=Edit             F8=Image
F9=Shell            F10=Exit            Enter=Do





COMMAND STATUS

Command: OK            stdout: yes           stderr: no

Before command completion, additional instructions may appear below.

paging00



isvp17> lsps -a
Page Space      Physical Volume   Volume Group Size %Used Active  Auto  Type Chksum
paging00        hdisk5            swap         36096MB     1   yes   yes    lv     0
hd6             hdisk0            rootvg         512MB     3   yes   yes    lv     0
isvp17>

There we go, we now have more than enough swap to run Oracle 11gR2 on AIX7.1

Creating an Oracle database on AIX 7.1 using dbca

Add $ORACLE_HOME/bin to your PATH.  Then, as user oracle, run dbca.

isvp17> ps -ef | grep test1
  oracle  6226048        1   0 15:33:10      -  0:00 ora_ckpt_test1
  oracle  6750276        1   0 15:33:10      -  0:00 ora_dbw1_test1
  oracle  6815788        1   0 15:33:10      -  0:00 ora_lgwr_test1
  oracle  6881376        1   0 15:33:10      -  0:00 ora_dbw0_test1
  oracle  7077968        1   0 15:33:09      -  0:00 ora_mman_test1
  oracle  7274686        1   0 15:33:16      -  0:00 ora_qmnc_test1
  oracle  7405818        1   0 15:33:09      -  0:00 ora_dia0_test1
  oracle  7536806        1   0 15:33:09      -  0:00 ora_psp0_test1
  oracle  7733266        1   0 15:33:09      -  0:00 ora_dbrm_test1
  oracle  7929936        1   0 15:33:26      -  0:00 ora_q000_test1
  oracle  7995638        1   0 15:33:10      -  0:00 ora_reco_test1
  oracle  8060940        1   0 15:33:10      -  0:00 ora_smon_test1
  oracle  8126588        1   0 16:28:21      -  0:00 ora_w000_test1
  oracle  8257780        1   0 15:33:09      -  0:00 ora_diag_test1
  oracle  8388706        1   0 15:33:09      -  0:00 ora_pmon_test1
  oracle  8519756        1   0 15:33:09      -  0:00 ora_gen0_test1
  oracle  8585246        1   0 15:33:10      -  0:00 ora_dbw2_test1
  oracle  8716448        1   0 15:33:09      -  0:00 ora_vktm_test1
  oracle  8781918        1   0 15:33:10      -  0:00 ora_mmnl_test1
  oracle  9109568        1   0 15:33:10      -  0:00 ora_mmon_test1
  oracle  9240606        1   0 15:33:10      -  0:00 ora_d000_test1
  oracle  9830446        1   0 15:33:10      -  0:00 ora_s000_test1
  oracle 54853772        1   0 15:38:18      -  0:00 ora_smco_test1
  oracle 56033458        1   0 15:33:26      -  0:00 ora_q001_test1
  oracle 56098994        1   0 15:33:18      -  0:00 ora_cjq0_test1
isvp17>
$ export ORACLE_SID=test1
$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 3 16:35:55 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

$ cd /home/test
$ ls
lost+found  test1
$ cd test1
$ ls
control01.ctl  redo01.log     redo03.log     system01.dbf   undotbs01.dbf
control02.ctl  redo02.log     sysaux01.dbf   temp01.dbf     users01.dbf
$

Oracle 11g R2 installation fails with 'Error in invoking target' message on AIX 7.1

I was installing Oracle database 11g R2 on a Power system running AIX 7.1 using runInstaller when I got the following error message during the linking of the binaries.

The exact error message was:

"Error in invoking target 'agent nmb nmo nmhs' of makefile '/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk'. See '/u01/app/oraInventory/logs/installActions2011-02-01_02-56-05PM.log' for details"

The log file had the following message:

isvp17> ls
installActions2011-02-01_02-56-05PM.log
oraInstall2011-02-01_02-56-05PM.err
oraInstall2011-02-01_02-56-05PM.out

isvp17> grep Segmentation *.log
ld: 0706-010 The binder was killed by a signal: Segmentation fault
        Check for binder messages or use local problem reporting procedures.

It looks like the AIX bug  "IZ89165" , which was originated from AIX 6.1 bug "IZ88711".
https://www-304.ibm.com/support/docview.wss?uid=isg1IZ89165
https://www-304.ibm.com/support/docview.wss?uid=isg1IZ88711

Though the bug had been identified with AIX6.1 TL06. It looks like the same issue can be seen AIX7.1 too.


Fix/Workaround:

isvp17> cd /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/
isvp17> grep blazy *.*
env_emagent.mk:LIB_JVM_LINK = -L$(JRE_LIB_DIR)/classic -L$(JRE_LIB_DIR) -blazy -ljava -ljvm

Backup the original file:

isvp17> cp env_emagent.mk env_emagent.mk.orig

isvp17> vi env_emagent.mk 
<delete -blazy> from the above line. 

Next, go back and press the Retry button twice(don't ask me why :-) in the GUI to continue with the installation.

cksum cksum cksum!!!

When downloading Oracle binaries across machines using ftp, there are couple of things that you might want to pay attention to get the checksum right.
1. ftp in binary mode.
2. make sure the ulimit is set correctly.

Oracle Database 11g Release 2 (11.2.0.1.0) for AIX (PPC64)
		aix.ppc64_11gR2_database_1of2.zip (1,564,425,851 bytes) (cksum - 1915658395)
		aix.ppc64_11gR2_database_2of2.zip (1,007,010,341 bytes) (cksum - 1152318705)

eg:

isvp18> ftp isvx7.storage.tucson.ibm.com
Connected to isvx7.storage.tucson.ibm.com.
220 (vsFTPd 2.0.5)
Name (isvx7.storage.tucson.ibm.com:root): mayur
331 Please specify the password.
Password:
230 Login successful.
ftp> binary
200 Switching to Binary mode.
ftp> get aix.ppc64_11gR2_database_1of2.zip
200 PORT command successful. Consider using PASV.
150 Opening BINARY mode data connection for aix.ppc64_11gR2_database_1of2.zip (1564425851 bytes).
aix.ppc64_11gR2_database_1of2.zip: short write
No space left on device/filesize limit exceeded.
226 File send OK.
500 Unknown command.
1073742400 bytes received in 9.44 seconds (1.111e+05 Kbytes/s)
local: aix.ppc64_11gR2_database_1of2.zip remote: aix.ppc64_11gR2_database_1of2.zip
ftp> get aix.ppc64_11gR2_database_2of2.zip
200 PORT command successful. Consider using PASV.
150 Opening BINARY mode data connection for aix.ppc64_11gR2_database_2of2.zip (1007010341 bytes).
226 File send OK.
1007010341 bytes received in 9.018 seconds (1.091e+05 Kbytes/s)
local: aix.ppc64_11gR2_database_2of2.zip remote: aix.ppc64_11gR2_database_2of2.zip
ftp> quit
221 Goodbye. 

isvp18> cksum aix.ppc64_11gR2_database_1of2.zip
416192092 1073741312 aix.ppc64_11gR2_database_1of2.zip
isvp18> ulimit -a
time(seconds)        unlimited
file(blocks)         2097151
data(kbytes)         131072
stack(kbytes)        32768
memory(kbytes)       32768
coredump(blocks)     2097151
nofiles(descriptors) 2000
threads(per process) unlimited
processes(per user)  unlimited
isvp18> ulimit -c unlimited
isvp18> ulimit -n unlimited
isvp18> ulimit -d unlimited
isvp18> ulimit -f unlimited
isvp18> ulimit -a
time(seconds)        unlimited
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        32768
memory(kbytes)       32768
coredump(blocks)     unlimited
nofiles(descriptors) unlimited
threads(per process) unlimited
processes(per user)  unlimited
isvp18> rm *.zip
rm: Remove aix.ppc64_11gR2_database_1of2.zip? yes
rm: Remove aix.ppc64_11gR2_database_2of2.zip? yes 

isvp18> ftp isvx7.storage.tucson.ibm.com
Connected to isvx7.storage.tucson.ibm.com.
220 (vsFTPd 2.0.5)
Name (isvx7.storage.tucson.ibm.com:root): mayur
331 Please specify the password.
Password:
230 Login successful.
ftp> binary
200 Switching to Binary mode.
ftp> get aix.ppc64_11gR2_database_1of2.zip
200 PORT command successful. Consider using PASV.
150 Opening BINARY mode data connection for aix.ppc64_11gR2_database_1of2.zip (1564425851 bytes).
226 File send OK.
1564425851 bytes received in 13.64 seconds (1.12e+05 Kbytes/s)
local: aix.ppc64_11gR2_database_1of2.zip remote: aix.ppc64_11gR2_database_1of2.zip
ftp> get aix.ppc64_11gR2_database_2of2.zip
200 PORT command successful. Consider using PASV.
150 Opening BINARY mode data connection for aix.ppc64_11gR2_database_2of2.zip (1007010341 bytes).
226 File send OK.
1007010341 bytes received in 8.968 seconds (1.097e+05 Kbytes/s)
local: aix.ppc64_11gR2_database_2of2.zip remote: aix.ppc64_11gR2_database_2of2.zip
ftp> quit
221 Goodbye.
isvp18> cksum aix.ppc64_11gR2_database_1of2.zip
1915658395 1564425851 aix.ppc64_11gR2_database_1of2.zip
isvp18> cksum aix.ppc64_11gR2_database_2of2.zip
1152318705 1007010341 aix.ppc64_11gR2_database_2of2.zip
isvp18>

Checklist for installing Oracle 11g R2 on AIX 7.1

Checking the Hardware requirements for installing Oracle 11g R2 on AIX 7.1

Memory requirements: Oracle needs at least 4 GB of RAM, and yes we have 24 GB so we are good on that.

isvp17> lsattr -E -l sys0 -a realmem
realmem 25165824 Amount of usable physical memory in Kbytes False

Swap requirements: For 4 GB to 8 GB Memory the swap requirement is 2 times the size of RAM, for 8 GB to 32 GB the requirement is 1.5 times the size of RAM, and if the Memory is more than 32 GB then the swap space required is 32 GB.

isvp17> lsps -a
Page Space      Physical Volume   Volume Group Size %Used Active  Auto  Type Chksum
hd6             hdisk0            rootvg         512MB     3   yes   yes    lv     0

Ok, we not doing good in that front. We'll have to find a way to increase the size of swap from 512MB to
36GB.So let us see how this can be done on AIX 7.1 . There we go, I just added 3

isvp17> lsps -a
Page Space      Physical Volume   Volume Group Size %Used Active  Auto  Type Chksum
paging00        hdisk5            swap         36096MB     1   yes   yes    lv     0
hd6             hdisk0            rootvg         512MB     3   yes   yes    lv     0

Hardware mode: What next, ok we need to know what our hardware is in 32-bit or 64-bit mode.

isvp17> /usr/bin/getconf HARDWARE_BITMODE
64

/tmp size: Now what, yeah what is the disk space requirement. First off /tmp needs to be at least 1 GB. We are ok
with that.

isvp17> df -m /tmp
Filesystem    MB blocks      Free %Used    Iused %Iused Mounted on
/dev/hd3        3584.00   3581.39    1%       41     1% /tmp

So what is the space required for the Oracle binaries, and it's datafiles? For Enterprise Edition 7.44 GB (just say 8 GB) is required, and for the data files require 1.55 GB ( you mean 2 GB).

Run Level: Oracle also needs the system run level to be 2. So, how do we find that in AIX

isvp17> who -r
.        run-level 2 Jan 28 11:38       2    0    S

Now that we are done with checking to see if our system meets the hardware requirements for Oracle, let us go ahead and check to see

Service Pack: The OS level needs to be AIX 7.1 with SP 1 or above, with 64-bit kernel. What I currently have is the base AIX 7.1 without the Service Pack, so I downloaded SP2 from http://www-933.ibm.com/support/fixcentral/

isvp17> oslevel -s
7100-00-00-0000

After the installation of the Service Pack(SP2) the oslevel is as follows:

isvp17> oslevel -s
7100-00-02-1041

Additional filesets: Next we have to check if the following filesets are installed Hmmm, it looks like one guy is missing. Can we do without him, I don't know.

isvp17> lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.perfstat \
> bos.perf.libperfstat bos.perf.proctools
Fileset                      Level  State      Description
----------------------------------------------------------------------------
Path: /usr/lib/objrepos
bos.adt.base               7.1.0.1  COMMITTED  Base Application Development
Toolkit
bos.adt.lib                7.1.0.0  COMMITTED  Base Application Development
Libraries
bos.perf.libperfstat       7.1.0.1  COMMITTED  Performance Statistics Library
Interface
bos.perf.perfstat          7.1.0.0  COMMITTED  Performance Statistics
Interface
bos.perf.proctools         7.1.0.0  COMMITTED  Proc Filesystem Tools

Path: /etc/objrepos
bos.adt.base               7.1.0.0  COMMITTED  Base Application Development
Toolkit
bos.perf.libperfstat       7.1.0.0  COMMITTED  Performance Statistics Library
Interface
bos.perf.perfstat          7.1.0.0  COMMITTED  Performance Statistics
Interface
lslpp: 0504-132  Fileset bos.adt.libm not installed.
isvp17>

Ok, went on to install bos.adt.libm from the original AIX 7.1 base dvd.

isvp17> lslpp -l bos.adt.libm
Fileset                      Level  State      Description
----------------------------------------------------------------------------
Path: /usr/lib/objrepos
bos.adt.libm               7.1.0.0  COMMITTED  Base Application Development
Math Library

Once the above is done, go and install SP1 or later service pack. In my case I installed SP2 which I had saved under /usr/sys/inst.images

AIX maintainance packages are available from the following web site:
http://www-933.ibm.com/support/fixcentral/

Kernel mode: Next find if the kernel mode is 64

isvp17> getconf KERNEL_BITMODE
64

Compiler: There are some compiler requirements for installing Oracle. I installed the The minimum recommended runtime environment:
IBM XL C/C++ for AIX, V10.1 Runtime Environment
http://www-01.ibm.com/support/docview.wss?rs=2239&uid=swg24019829

UDP and TCP Kernel Parameters:
Use NDD to ensure that the kernel TCP/IP ephemeral port range parameters are set to 9000-65500.

Let me check to see what my current values are:

isvp17> /usr/sbin/no -a | fgrep ephemeral
tcp_ephemeral_high = 65535
tcp_ephemeral_low = 32768
udp_ephemeral_high = 65535
udp_ephemeral_low = 32768

Ok, I need this to bumped.

isvp17> /usr/sbin/no -o tcp_ephemeral_low=9000 -o tcp_ephemeral_high=65500
Setting tcp_ephemeral_low to 9000
Setting tcp_ephemeral_high to 65500
isvp17> /usr/sbin/no -o udp_ephemeral_low=9000 -o udp_ephemeral_high=65500
Setting udp_ephemeral_low to 9000
Setting udp_ephemeral_high to 65500
isvp17>

The options you set with no must be done each time the system starts up. One way to do that is to edit /etc/rc.tcpip and insert your no commands just before the script starts running the server daemons.

Enable core file creation:

isvp17> ulimit -a
time(seconds)        unlimited
file(blocks)         2097151
data(kbytes)         131072
stack(kbytes)        32768
memory(kbytes)       32768
coredump(blocks)     2097151
nofiles(descriptors) 2000
threads(per process) unlimited
processes(per user)  unlimited
isvp17> ulimit -c unlimited  #turn on corefiles with unlimited size
isvp17> ulimit -n unlimited  #allows an unlimited number of open file descriptors
isvp17> ulimit -d unlimited  #sets the user data limit to unlimited
isvp17> ulimit -f unlimited  #sets the file limit to unlimited
isvp17> ulimit -a
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        32768
memory(kbytes)       32768
coredump(blocks)     unlimited
nofiles(descriptors) unlimited
threads(per process) unlimited
processes(per user)  unlimited

These values are the "soft" limit, and are applied for each user. These values cannot exceed the "hard" limit value. To display and change the hard limits, you can run the ulimit commands using the additional -H command-line option.

Creating users and groups:

isvp17> mkgroup -'A' id='1000' adms='root' oinstall
isvp17> mkgroup -'A' id='2000' adms='root' dba
isvp17> mkgroup -'A' id='4000' adms='root' oper
isvp17> mkuser id='1101' pgrp='oinstall' groups='dba,oper' home='/home/oracle' oracle                        

Create ORACLE_HOME: Create a directory (ORACLE_HOME), for the Oracle Database software.

isvp17> mkdir –p /u01/app/112/dbhome
isvp17> chown –R oracle:oinstall /u01/app/112/dbhome

Run rootpre.sh script: run the rootper.sh script as user root.

 
# cd /home/oracle/database
# ls
doc           response      rootpre.sh    runInstaller  stage
install       rootpre       rpm           sshsetup      welcome.html
# ./rootpre.sh
./rootpre.sh output will be logged in /tmp/rootpre.out_11-02-01.10:21:55
Saving the original files in /etc/ora_save_11-02-01.10:21:55....
Copying new kernel extension to /etc....
Loading the kernel extension from /etc

 Oracle Kernel Extension Loader for AIX
       Copyright (c) 1998,1999 Oracle Corporation


 Successfully loaded /etc/pw-syscall.64bit_kernel with kmid: 0x50a96000
 Successfully configured /etc/pw-syscall.64bit_kernel with kmid: 0x50a96000
The kernel extension was successfuly loaded.

Checking if group services should be configured....
Nothing to configure.
#
#