Install Oracle Database 10g on AIX-5.3

Install Oracle Database 10g on AIX-5.3

UNIX server details:

Version – AIX 5.3
Disk space – 6 GB
Temp space – 580 MB
Swap space – 2304 MB

STEP 1 - Pre installation check script

Download pre-installation check script from https://metalink.oracle.com and save as validate.tar
Ftp file on unix server and untar the file using command tar xvf validate.tar
“tar" file, which consists of the following:
validate - Shell script that executes the engine - Unix platforms
validate.pl - Actual rule engine
filename.txt - Rule text file. This file will be different for each rule set
Execute validate filename.txt from the command line, as in the following examples:# validate 10gr2_rdbms_aix_hcve_100705.txtOR# perl validate.pl 10gr2_rdbms_aix_hcve_100705.txt
Below is the ouput of script in log dir.

ID NAME RESULT C VALUE
----------------------------------- ----------------------- ------------------------------
10 OS Certified? PASSED = Certified with 10g RDBMS
20 User in /etc/passwd? FAILED = Can not read /etc/passwd
30 Group in /etc/group? PASSED = GroupOK
40 Input ORACLE_HOME RECORD $ORACLE_HOME
50 ORACLE_HOME valid? PASSED = OHNotSpecified
60 O_H perms OK? PASSED = OHNotSpecified
70 Umask set to 022? PASSED = UmaskOK
80 LDLIBRARYPATH unset? PASSED = UnSet
90 LIBPATH unset? PASSED = UnSet
100 Other O_Hs in PATH? PASSED = NoneFound
110 oraInventory perms PASSED = oraInventoryNotFound
120 /tmp adequate? FAILED = TMPDIRTooSmall
130 Swap (in Mb) RECORD 1280
140 RAM (in Mb) PASSED > 2048
150 SwapToRAM OK? FAILED = InsufficientSwap
160 Disk Space OK? PASSED = OHNotSpecified
170 AIXTHREAD_SCOPE=S? FAILED = AIXTHREADNotSet
175 LINK_CNTRL is unset? PASSED = LINK_CNTRLunset
180 Got ld,nm,ar,make? PASSED = ld_nm_ar_make_found
190 ulimits OK? FAILED = FileTooSmall
NoFilesTooSmall
MemoryTooSmall
200 Got OS packages? FAILED = bos.adt.libmNotInstalled
210 Got OS patches? PASSED = PatchesFound
220 other OUI up? PASSED = NoOtherOUI




Below modifications has been performed on the basis of above results.

STEP 2 – Action performed on pre-installation check report

1) User oracle and groups dba & oinstall has been created and added user in groups.
2) Swap memory increased from 1280MB to 2304MB.
3) Added one line “export AIXTHREAD_SCOPE=S” in .profile file using oracle login.
4) Previously ulimit for file was set to 1GB now it has been set to “unlimited”.
5) One OS package file was not found (bos.adt.libm ), Installed by requesting unix administrator.
6) Rerun the script and verified the results after changes.

STEP 3 – Software download

Download oracle 10g installation software from oracle download site and extract on server.
File : 10gr2_aix5l64_database.cpio.gz

Created one new dir by name “software” and copied setup files.
Extracted cpio file on server using below command:

cpio -idcmv < 10gr2_aix5l64_database.cpio

STEP 4 – Xmanager configuration

In order to do GUI based installation below are some setting needed to be done:
1) Installed Xmanager software on local computer.
2) Click on xstart and create new profile for our server with login details.
3) Check for xterm services running on server if not please get it start from AIX administrator.
4) Enter x display location details under x11 tab in putty ( Your desktop IP : 0.0 )
5) Check the same with running xclock command on server. ( Graphical clock should display )

STEP 5 – Oracle 10g installation

Create two directories under home dir.

1) /home/oracle/app
2) /home/oracle/orainventory


Go to install dir:
Start installation using script: runInstaller

Script asks for one script to be executed from root login before going ahead.



So executed rootpre.sh with the help of AIX administrator.

Continue with the “Basic Installation”

Ignored with below error:

In next window changed dir path for inventory directory.


/home/oracle/orainventory dir already created before starting of installation.

Select “Enterprise Edition” type of installation.

Please make sure once again for available free space on oracle home dir.

Please specify name of installation and location where software to be installed.

/home/oracle/app directory already created before starting of installation.

Click on checkbox “Checking recommended operating system patches”
And check the report generated.

Select “install database software only”.
Database will be created manually after installation gets finished.

Installation started ………..

Required below two scripts to be execute through root login.

Unix administrator executed above two scripts.

Oracle 10g installation on AIX – 5.3 finished successfully.



Added below two lines in .profile file by oracle login:

export ORACLE_HOME=/home/oracle/app/ora10g
export ORACLE_SID=ORCL10G


Name has given to instance is “ORCL10G”.

So created dir by the name : /u01/oracle/oradata/ORCL10G

STEP 6 – Oracle Database Creation

Created below seven directories under /u01/oracle/oradata/ORCL10G

bdump
udump
cdump
controlfile
datafile
logfile

Create password file for sys password on OS command line

orapwd file=$ORACLE_HOME/dbs/orapwORCL10G password=sysdba entries=5

Create initORCL10G.ora file at $ORACLE_HOME/dbs directory. Set appropriate parameters as per requirement.

Connect to sqlplus using sqlplus “/ as sysdba” command on OS command line

startup nomunt
execute create database command which is written below:

create database ORCL10G
logfile
group 1 ('/u01/oracle/oradata/ORCL10G/logfile/redo1.log') size 10M,
group 2 ('/u01/oracle/oradata/ORCL10G/logfile/redo2.log') size 10M,
group 3 ('/u01/oracle/oradata/ORCL10G/logfile/redo3.log') size 10M
character set WE8ISO8859P1
national character set utf8
datafile '/u01/oracle/oradata/ORCL10G/datafile/system01.dbf'
size 50M
autoextend on
next 10M maxsize unlimited
extent management local
sysaux datafile '/u01/oracle/oradata/ORCL10G/datafile/sysaux01.dbf'
size 10M
autoextend on
next 10M
maxsize unlimited
undo tablespace undotbs01
datafile '/u01/oracle/oradata/ORCL10G/datafile/undotbs01.dbf'
size 10M
default temporary tablespace temp
tempfile '/u01/oracle/oradata/ORCL10G/datafile/temp01.dbf'
size 10M;

Please execute below mention PL/SQL to create dictionary for that particular database only.
SQL> @?/rdbms/admin/catalog.sql
SQL> @?/rdbms/admin/catproc.sql

The user system might also want to run ?/sqlplus/admin/pupbld.sql. pupbld.sql creates a table that allows to block someone from using sql plus.
SQL> connect system/manager
SQL> @?/sqlplus/admin/pupbld
Installation & Database creation completes.