Installation Of Oracle9i

INSTALLATION OF ORACLE9i INSTALLATION OF ORACLE9i....................................................................................I Certification.........................................................................................................................II Interoperability Patch..........................................................................................................II Hardware Requirements......................................................................................................II Software Requirements.......................................................................................................II Disk Space Requirements..................................................................................................III Staging Software................................................................................................................III Steps to be performed as Root user....................................................................................III Setting up kernel parameters......................................................................................III Steps to be performed as an oracle user.............................................................................IV Installation...........................................................................................................................V Obervations after installation:.............................................................................................V

Document Prepared by: Nikhil Rangaraju Oracle NAIO

I

Certification Go to metalink.oracle.com and click on Certify tab and check the certification of oracle9i with redhat linux AS release3. Interoperability Patch As any oracle software requires Operating system interoperability patch to be installed to be compatible. So download and instal the following interoperability patch from metalink.oracle.com. Click on patches tab Select simple search and search for p3006854_9204_LINUX.zip patch Download the patch and install it as a root user. Hardware Requirements Check that operating system should meet the following hardware requirements. RAM size----It should be minimum 512MB Command to check: grep MemTotal /proc/meminfo Swap size-----It should be half the RAM size Command to check: top Software Requirements See that all precompilers and packages are installed in machine. Follwing are some of the packages necessary for 9i installation. Command to check: rpm –qa <packagename> Packages List: make-3.79.1 gcc-3.2.3-34 glibc-2.3.2-95.20 glibc-devel-2.3.2-95.20 glibc-devel-2.3.2-95.20 (32 bit) compat-db-4.0.14-5 compat-gcc-7.3-2.96.128 compat-gcc-c++-7.3-2.96.128 compat-libstdc++-7.3-2.96.128 compat-libstdc++-devel-7.3-2.96.128 gnome-libs-1.4.1.2.90-34.1 (32 bit) openmotif21-2.1.30-8

II

setarch-1.3-1 libaio-0.3.96-3 libaio-devel-0.3.96-3 Disk Space Requirements See that oracle database requires 3.5 GB of Free disk space. Also Temporary space is required upto 400 MB. Command to check: df -h Staging Software Download Oracle9i software from otn.oracle.com and stage it to any location of your harddisk. Steps to be performed as Root user Setting up kernel parameters Why? Oracle9i uses UNIX resources such as shared memory, swap memory, and semaphore extensively for interprocess communication. If your parameter settings are insufficient for Oracle9i, then you will experience problems during installation and instance startup. The greater the amount of data you can store in memory, the faster your database will operate. In addition, by maintaining data in memory, the UNIX kernel reduces disk I/O activity. These are the recommended kernel parameter requirements for Oracle9i environment. a) Just create a startup script and put the script in init file. Include below parameters in the script. echo 100 32000 100 100 > sem echo 2147483648 > shmmax echo 4096 > shmmni echo 2097152 > shmall b) Set the File Handles by using ulimit -n and /proc/sys/fs/file-max. # echo 65536 > /proc/sys/fs/file-max ulimit -n 65536 c) Set the Sockets to /proc/sys/net/ipv4/ip_local_port_range # echo 1024 65000 > /proc/sys/net/ipv4/ip_local_port_range

III

d) Set the Process limit by using ulimit -u. This will give you the number of Processes per user. ulimit -u 16384 Create OSDBA and OSOPER groups using the following command groupadd dba------OSDBA group groupadd oper------OSOPER group Why? SYSDBA privileges include the right to grant or revoke system privileges, as well as all other administrative privileges. OSDBA group membership must be granted only to database administrators. SYSOPER include database startup and shutdown, and other privileges required for database operation. Users granted access to OSOPER group privileges include application developers, application administrators, database users, and network administrators. Create UNIX account to own ORACLE software using the following Command. Useradd –G dba,oper –d /u01/oracle9i –p welcome oracle9i Where Oracle9i is user. Change the permissons of the user to its respective directory. Make sure that user and group have read, write and executable permissions. Chmod –R 775 /u01/oracle9i Change the ownership of user to its respective directory. Chown –R oracle9i:dba /u01/oracle9i Steps to be performed as an oracle user Login to terminal as an Oracle9i user and set the envitomental variables by creating an .env file. Commands:

IV

Su – oracle9i Vi db01.env export ORACLE_BASE=/u01/oracle9i export ORACLE_HOME=$ORACLE_BASE/product export ORACLE_SID=db01 export LD_ASSUME_KERNEL=2.4.19 export LD_LIBRARY_PATH=$ORACLE_HOME/lib export PATH=$ORACLE_HOME/bin:$PATH export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data umask 022 :wq--- save and quit Now run the script using following command . .db01.env

Installation Go to the staged software directory and run “.runInstaller” script and hence the Installation starts. Windows that appears while installations: a) Asks Oracle SID and Global SID b) Asks to run /tmp/orainstRoot.sh script as a root user to see that orainventory has access to oracle user. c) After installation it asks to run Oracle_home/root.sh script as a root user which sets the necessary file permissions for Oracle products and performs other root-related configuration activities. Obervations after installation: Oracle User: oracle9i Database/ SID name: db01 Global SID name: db01.us.oracle.com LISTENER name: LISTENER Spfile/Pfile naming convention: spfiledb01.ora/initdb01.ora Location of Software: /u01/oracle9i/product Naming convention of Env file: db01.env (/u01/oracle9i/db01.env) Location of Database: /u01/oracle9i/oradata Location of Web server: ORACLE_HOME/Apache/Apache/http Problems faced:

V

Dint set ORACLE_HOME Environmental path correctly. Set up was interrupted. Web access to SQL: http://ocvmrh2149:7777 http://ocvmrh2149:7778 https://ocvmrh2149:4443 SGA Observed after installation: Total System Global Area 236000356 bytes Fixed Size 451684 bytes Variable Size 201326592 bytes Database Buffers 33554432 bytes Redo Buffers 67648 bytes

VI