Oracle 10g Installation on Linux

Set hostname, see "/etc/hosts".

Set Oracle environment,

$ export ORACLE_HOSTNAME=bubu
$ export ORACLE_HOSTNAME

Add group and user for oracle,

	# groupadd oinstall
	# groupadd dba
	# groupadd oper
	# useradd -g oinstall -G dba,oper oracle
	# passwd oracle

Check if user nobody is exist, if not exist create one,
```
	# id nobody
	# useradd nobody
```

Configure kernel option based on your hardware specification. Edit "/etc/sysctl.conf",

# oracle configuration
kernel.shmall = 2097152
kernel.shmmax = 2097152
#kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
rmem_default = 262144
rmem_max = 262144
wmem_default = 262144
wmem_max = 262144

Setting shell limit for oracle user

	# /etc/security/limits.conf

	oracle  soft    nproc   2047
	oracle  hard    nproc   16384
	oracle  soft    nofile  1024
	oracle  hard    nofile  65536

	# /etc/pam.d/login

	session  required       /lib/security/pam_limits.so

	# /etc/profile or /etc/profile.local
	# oracle user

	if [ $USER = "oracle" ]; then
        	if [ $SHELL = "/bin/ksh" ]; then
                	ulimit -p 16384
	                ulimit -n 65536
        	else
                	ulimit -u 16384 -n 65536
	        fi
	fi

Create Oracle base directory

	# mkdir /mnt/data/apps/oracle
	# chown -R oracle:oinstall /mnt/data/apps/oracle
	# chmod -R 775 /mnt/data/apps/oracle

Create required directories

	# mkdir /mnt/data/apps/oradata
	# chown oracle:oinstall /mnt/data/apps/oradata
	# chmod 775 /mnt/data/apps/oradata

Configuring oracle user environment
- set user oracle home to "/mnt/data/apps/oracle", in "/etc/passwd"
- login as oracle
  # su - oracle
- edit "~/.bash_profile", add
  umask 022
- run ".bash_profile"
  $ . ~/.bash_profile
- set display
  $ DISPLAY=local_host:0.0 $ export DISPLAY
- set oracle base and and SID
  $ ORACLE_BASE=/mnt/data/apps/oracle $ ORACLE_SID=orcl $ export ORACLE_BASE ORACLE_SID
Edit "database/install/oraparam.ini", add "SuSE-10" to [Certified Versions]
Change directory to database, run
```
	$ ./runInstaller
```
Follow the installation instruction

Configuring new installation

Run,

$ . /usr/local/bin/oraenv

Start SQLPLUS

$ sqlplus "/ AS SYSDBA"

Run this script

SQL> @?/rdbms/admin/utlrp.sql

Run this script to create client static library

# $ORACLE_HOME/bin/genclntst

Configuring GCC as Primary Compiler

Edit $ORACLE_HOME/plsql/spnc_commands, look for line like this,

/opt/intel/compiler70/ia32/bin/icc -Qlocation,as,/usr/bin/
-Qlocation,ld,/usr/bin/ %(src) -O1 -fPIC -fp -mp1 -fp_port
-I$(ORACLE_HOME)/plsql/include -I$(ORACLE_HOME)/plsql/public -Wl,-s -shared
-o
%(so)

then comment it. And look for line like this,

/usr/bin/gcc -B/usr/bin/ %(src) -c -O1 -fPIC -I$(ORACLE_HOME)/plsql/include
-I$(ORACLE_HOME)/plsql/public -o %(obj) /usr/bin/ld -s -shared %(obj) -o %(so)

then UNcomment it.