Oracle 10g Installation

INSTALLATION OF ORACLE10g

INSTALLATION OF ORACLE10g.................................................................1 Certification.........................................................................................................................2 Interoperability Patch...........................................................................................................2 Hardware Requirements.......................................................................................................2 Software Requirements........................................................................................................2 Disk Space Requirements....................................................................................................3 Staging Software..................................................................................................................3 Steps to be performed as Root user......................................................................................3 Setting up kernel parameters................................................................................................3 Steps to be performed as an oracle user...............................................................................4 Installation............................................................................................................................5 Obervations after installation...............................................................................................5

Document Prepared by: Nikhil Rangaraju Oracle NAIO

Certification Go to metalink.oracle.com and click on Certify tab and check the certification of oracle10g 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 10g 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

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. semmsl semmns semopm semmni 250 32000 100 128 /proc/sys/kernel/sem shmall 2097152 /proc/sys/kernel/shmall shmmax 2147483648 /proc/sys/kernel/shmmax shmmni 4096 /proc/sys/kernel/shmmni 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

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/oracle10g –p welcome oracle10g Where Oracle10g 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/oracle10g Change the ownership of user to its respective directory. Chown –R oracle9i:dba /u01/oracle10g Steps to be performed as an oracle user Login to terminal as an Oracle10g user and set the envitomental variables by creating an .env file. Commands:

Su – oracle10g Vi ofdb1.env export ORACLE_BASE=/u01/oracle10g export ORACLE_HOME=$ORACLE_BASE/product export ORACLE_SID=ofdb1 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 . .ofdb1.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: oracle10g Database/ SID name: ofdb1 Global SID name: ofdb1.us.oracle.com LISTENER name: LISTENER Spfile/Pfile naming convention: spfileofdb1.ora/intofdb1.ora Location of Software: /u01/oracle10g/product Naming convention of Env file: ofdb1.env (/u01/oracle10g/ofdbdb1.env) Location of Database: /u01/oracle10g/oradata Location of Web server: ORACLE_HOME/Apache/Apache/http All URL:

The following J2EE Applications have been deployed and are accessible at the URLs listed below. iSQL*Plus URL: http://ocvmrh2149.us.oracle.com:5560/isqlplus iSQL*Plus DBA URL: http://ocvmrh2149.us.oracle.com:5560/isqlplus/dba Enterprise Manager 10g Database Control URL: http://ocvmrh2149.us.oracle.com:1158/em SGA size: Total System Global Area Fixed Size Variable Size Database Buffers Redo Buffers

599785472 bytes 1220796 bytes 167776068 bytes 427819008 bytes 2969600 bytes