Install Oracle 10g on AIX

Start with a gz file, uncompress it and then use cpio to unpack it:

gunzip 10gr2_aix5l64_database.cpio.gz
cpio -idcmv < 10gr2_aix5l64_database.cpio

I had to use the 'c' flag because I got a cpio error when I tried without.

In a wierd coincidence, I found this on a site almost like my own:
Life After Coffee

This will make a 'Disk1' subdirectory, a painful reminder that this is just code from a CD that got shuffled over here:

#cd Disk1/rootpre
#./rootpre.sh
./rootpre.sh output will be logged in /tmp/rootpre.out_09-11-19.10:54:06
Saving the original files in /etc/ora_save_09-11-19.10:54:06....
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: 0x4525300
 Successfully configured /etc/pw-syscall.64bit_kernel with kmid: 0x4525300
The kernel extension was successfuly loaded.

Configuring Asynchronous I/O....

Configuring POSIX Asynchronous I/O....

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

Now create an oracle userid and a dba and oinstall group:

mkuser -a groups=dba,oinstall oracle
mkdir /apps/oracle
chown ora.dba /apps/oracle

The rest is a little tricky, you now have to set an x-environment. Since AIX stopped making machines where you could just beebop into the data center and log into CDE, you will probably be using something on your client PC to do this. I use cygwin. Setting up cygwin is almost a different post, but I set up the default for X11 and got an error that twm wasn't found. From my cygwin bash shell I went to /etc/X11/xinit and eventually just replaced my xinitrc by doing this:

echo "xterm" > xinitrc

It is ugly, but I get an x environment with a shell that works.

From that shell, I run 'xhost +' and then 'ipconfig' to get my ip.

From the AIX session, I create a new /apps filesystem, become the 'oracle' user, and then export my display:

# crfs -v jfs2 -g rootvg -m /apps -a size=5G
File system created successfully.
5242516 kilobytes total disk space.
New File System size is 10485760
# mount /apps
# chown oracle.dba /apps
# su - oracle
$ export DISPLAY=10.32.32.95:0.0
$ xclock

I see a clock in my xterm, so I control-C in AIX to kill it. I now have my environment set up to run the installer:

$ cd /tmp/Disk1
$ ./runInstaller
**************************************************************************
******

Your platform requires the root user to perform certain pre-installation
OS preparation.  The root user should run the shell script 'rootpre.sh' be
fore
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

Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2009-11-19_11-11-29AM. Please wait ...$ Nov 19, 2009 11:11:36 AM java.util.prefs.FileSystemPreferences$2 run
INFO: Created user preferences directory.
Nov 19, 2009 11:11:38 AM java.util.prefs.FileSystemPreferences$3 run
INFO: Created system preferences directory in java.home.

Now I am in the gui, but I don't feel like posting GUI screen shots, so I will just talk you through it, I change the install path to be under /apps/oracle. Ditto with the next question about the inventory directory:

/apps/oracle
/apps/oracle/oraInventory
I set the operating system group to 'dba'

I can't cut and paste from the gui window, but there checks give me one warning:

bos.adt.prof 5.3.0.1
bos.cifs_fs.rte 5.3.0.1 <---- this didn't install correctly with NIM, I had to move to my local system and run installp. I pulled out my media and installed them, no problem. The retry button doesn't work, so I had to hit back and forward on the gui to get it to really retry the tests and be successful. Looks like to install everything requires 3.46G. After it all runs, I am asked to run as root:

# /apps/oracle/oraInventory/orainstRoot.sh
# ./orainstRoot.sh
Changing permissions of /apps/oracle/oraInventory to 775.
Changing groupname of /apps/oracle/oraInventory to dba.
The execution of the script is complete

and also:

# /apps/oracle/product/10.2.0/db_1/root.sh
Running Oracle10 root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /apps/oracle/product/10.2.0/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
Creating /usr/local/bin directory...
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...


Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.

I am just going to start with the default instance:
cd /apps/oracle/product/10.2.0/db_1/dbs/
cp init.ora initoracle.ora

Default shared memory isn’t enough:

$ sqlplus “/ as sysdba”

SQL*Plus: Release 10.2.0.1.0 – Production on Thu Nov 19 12:26:24 2009

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

Connected to an idle instance.

SQL> startup
ORA-00371: not enough shared pool memory, should be atleast 123232153 bytes
SQL>

Remove these:

shared_pool_size = 3500000                                            # SMALL
# shared_pool_size = 5000000                                          # MEDIUM
# shared_pool_size = 9000000                                          # LARGE

Replace with:

shared_pool_size = 123232153                                    # Required

$ sqlplus “/ as sysdba”

SQL*Plus: Release 10.2.0.1.0 – Production on Thu Nov 19 12:32:33 2009

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 163577856 bytes
Fixed Size 2019328 bytes
Variable Size 150994944 bytes
Database Buffers 8388608 bytes
Redo Buffers 2174976 bytes
ORA-00205: error in identifying control file, check alert log for more info

I then become oracle and try to get into sqlplus:

. /usr/local/bin/oraenv
ORACLE_SID = [oracle] ?
ksh: dbhome: not found.
ORACLE_HOME = [] ? /apps/oracle/product/10.2.0/db_1
$ sqlplus “/ as SYSDBA”

SQL*Plus: Release 10.2.0.1.0 – Production on Thu Nov 19 12:05:34 2009

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

Connected to an idle instance.

SQL>

Leave a Reply

Your email address will not be published. Required fields are marked *