Oracle Database 10g Release 2 (10.2.0.1) on SLES9 install guide - OTN Installfest
-------------------------------------------------------------------------
International PHP Conference - Frankfurt, November 2005

*** This guide for test purposes only - not production ***

1. Physical Requirements : 
	** Need at least 512MB RAM / 2.5GB disk space **
+ Automaticaly or Manually partition your hard drive
	/tmp = 512MB 
	/boot = 128MB 
	swap = 1024MB 
	/ = fill to maximum allowable size

2. Out of the box SLES9 Software Installation :
Boot from CDROM - F3 function : SLES9 CD1 disk
New Installation
Accept all defaults - Copies contents from Disk 1&2 then reboots
+ Set Root Password
Use detected network configuration
+ skip Internet test
Use detected service configuration
+ Change authentication method to
	Local (/etc/passwd)
+ Set up local user  eg. todd/welcome ;-)
Use detected hardware configuration

3. Installing required Software Packages :
+ login as root user
+ System > YAST > Software > Install and Remove Software
to install gcc, orarun, openmotif, mozilla:

Search gcc
	/cpp		The GCC Preprocessor
	/gcc		The GNU C Compiler and Support Files
	/gcc-c++	The GNU C++ Compiler
	/libgcc		C Compiler runtime library
Check Dependencies 	
        x Autocheck
	/glibc -devel
        /libstdc++ -devel

Use the same technique to install
	/openmotif      -- needed for installing 10g DB
	/mozilla        -- web browser to use with EM to manage DB

4. Set Kernel parameters and environment:
+ System > YAST > Software > Install and Remove Software

Search orarun
	/orarun		Environment for running Oracle products
Check Dependencies	
        x Autocheck
        /libaio -devel dev files for async I/O

5. Configure the 'oracle' account used for installing oracle :
+ System > YAST > Security and Users > Edit and create users
shows local user 'todd'
+ use 'set filter' to display the System Users
+ highlight and edit the 'oracle' user created by the orarun package
	- change password
	- select detail and add oracle user to dba group
	- enable login shell by changing /bin/false to /bin/bash

+ In a root shell update Oracle's home directory and SID by editing:
	# vi /etc/profile.d/oracle.sh
	ORACLE_SID=orcl  **orarun sets the SID to mydb by default
	ORACLE_HOME=$ORACLE_BASE/product/10gR2

+ Set the oracle shell parameters by running
	# /usr/sbin/rcoracle start

6. Run the oracle installer as the user oracle :
+ login as the oracle user  **default home set by orarun is /opt/oracle
+ Insert Oracle 10g R2 (10.2.0.1) Core CD.zip
    - Extract the .zip file 
My Computer > DVD > runInstaller
	- follow the installer instructions 
	- use password mgmt to unlock DBuser scott & set password 'tiger'

7. Post Install Configuration :
+ Do the following steps as root
	# vi /etc/oratab  
		change :N to :Y 
    # cp /etc/oratab /var/opt/oracle/oratab
  -- these steps enables the oracle user to use the commands 
	dbshut, dbstart and lsnrctl start from the command line.

8. Manage your oracle database :
+ open http://linux.site:1158/em in a browser  to access the
	web based Oracle Enterprise Manger console
 -- login as sys connect as sysdba with the pasword you set.

9. Shut down the database before powering down :
	a. via enterprise manager gui  or
	b. [/opt/oracle]$ dbshut    **as user oracle

10. Start up your database after powering down :
	[/opt/oracle]$ dbstart         **as user oracle 
	[/opt/oracle]$ lsnrctl start 	** starts the database listner