Table of Contents

1) Things you need before Installation
2) Installing Required RPMs
3) Create ORACLE Software owner OS User
4) Setup Kernel Parameters, File Handlers, and Limits
5) Setup Temporary Swap Space
6) Setup Oracle Environment Variables
7) Unpack Oracle Software Archives
8) Verify X-Windows
9) Starting Oracle Universal Installer
10) Oracle 10g Release 2 (10.2.0.1) Software Installation
11) Setup Other Oracle Environment Variables
12) Upgrading 10g Release 2 (10.2.0.1) to Oracle 10g R2 (10.2.0.3)
13) Upgrade/Migrate Database to 10g Release 2 (10.2.03)
14) Start and Shutdown Oracle Database/Processes

1) Things you need before Installation

1a) Red Hat Packages:

Install below or higher versions of Red Hat RPM packages;

ORBit-0.5.17-14
alsa-lib-1.0.6-5.RHEL4
audiofile-0.2.6-1.el4.1
binutils-2.15.92.0.2-21
compat-db-4.1.25-9
compat-libstdc++-33-3.2.3-47.3
control-center-2.8.0-12.rhel4.5
esound-0.2.35-2
gcc-3.4.6-3
gcc-c++-3.4.6-3
gdk-pixbuf-0.22.0-17.el4.3
glibc-2.3.4-2.25
glibc-common-2.3.4-2.25
glibc-devel-2.3.4-2.25
glibc-headers-2.3.4-2.25
glibc-kernheaders-2.4-9.1.98.EL
gnome-libs-1.4.1.2.90-44.1
gtk+-1.2.10-33
imlib-1.9.13-23
libaio-0.3.105-2
libpng10-1.0.16-1
libstdc++-3.4.6-3
libstdc++-devel-3.4.6-3
libungif-4.1.3-1.el4.2
make-3.80-6.EL4
pdksh-5.2.14-30.3
sysstat-5.0.5-11.rhel4
xorg-x11-deprecated-libs-6.8.2-1.EL.13.37.5
xscreensaver-4.18-5.rhel4.11

1b) Oracle Software:

Below files can be downloaded from http://technet.oracle.com

10201_database_linux32.zip

1c) Oracle Patches:

Below files can be downloaded from http://metalink.oracle.com 

p5337014_10203_LINUX.zip

1e) Validation and Certification:

For Validation and/or Certification, Checkout Oracle Validation Certification Matrix

2) Installing Required RPMs

2a) Query Installed Packages:

rpm -q ORBit alsa-lib audiofile binutils compat-db compat-libstdc++-33 control-center esound gcc gcc-c++ gdk-pixbuf glibc glibc-common glibc-devel glibc-headers glibc-kernheaders gnome-libs gtk+ imlib libaio libpng10 libstdc++ libstdc++-devel libungif make pdksh sysstat xorg-x11-deprecated-libs xscreensaver 

Sample output as below;

ORBit-0.5.17-14
alsa-lib-1.0.6-5.RHEL4
audiofile-0.2.6-1.el4.1
binutils-2.15.92.0.2-21
compat-db-4.1.25-9
compat-libstdc++-33-3.2.3-47.3
control-center-2.8.0-12.rhel4.5
esound-0.2.35-2
gcc-3.4.6-3
gcc-c++-3.4.6-3
gdk-pixbuf-0.22.0-17.el4.3
glibc-2.3.4-2.25
glibc-common-2.3.4-2.25
glibc-devel-2.3.4-2.25
glibc-headers-2.3.4-2.25
glibc-kernheaders-2.4-9.1.98.EL
gnome-libs-1.4.1.2.90-44.1
gtk+-1.2.10-33
imlib-1.9.13-23
libaio-0.3.105-2
libpng10-1.0.16-1
libstdc++-3.4.6-3
libstdc++-devel-3.4.6-3
libungif-4.1.3-1.el4.2
make-3.80-6.EL4
pdksh-5.2.14-30.3
sysstat-5.0.5-11.rhel4
xorg-x11-deprecated-libs-6.8.2-1.EL.13.37.5
xscreensaver-4.18-5.rhel4.11

If any of the above packages show as " not installed". Use yum or up2date to install, it will resolve dependencies automatically.

yum install packagename  or   up2date packagename  

3) Create ORACLE Software owner OS User

3a) Create USER and GROUPS:

[root@dellc600l1 ~]# groupadd dba
[root@dellc600l1 ~]# groupadd oinstall
[root@dellc600l1 ~]# useradd -c "Oracle software owner" -g oinstall -G dba oracle
[root@dellc600l1 ~]# passwd oracle
Changing password for user oracle.
New UNIX password: 
Retype new UNIX password: 
passwd: all authentication tokens updated successfully.
[root@dellc600l1 ~]# 

3b) Create Oracle Software Directory:

[root@dellc600l1 ~]# mkdir -p /u01/app/oracle
[root@dellc600l1 ~]# chown -R oracle.oinstall /u01
[root@dellc600l1 ~]# chmod -R 775 /u01

4) Setup Kernel Parameters, File Handlers, and Limits

4a) Memory Kernel Parameters:

Execute the below command to find out Memory Kernel parameter values;

[root@dellc600l1 ~]# cat /proc/sys/kernel/shmmax
33554432
[root@dellc600l1 ~]# cat /proc/sys/kernel/shmmni
4096
[root@dellc600l1 ~]# cat /proc/sys/kernel/shmall
2097152
[root@dellc600l1 ~]# ipcs -lm |grep "min seg size"
min seg size (bytes) = 1

[root@dellc600l1 ~]# cat /proc/sys/kernel/sem | awk '{print "semmsl="$1" semmns="$2" semopm="$3" semmni="$4}'
semmsl=250 semmns=32000 semopm=32 semmni=128

4b) File Handlers:

Execute the below command to find out Maximum File Handlers;

[root@dellc600l1 ~]# cat /proc/sys/fs/file-max
50975

TIP: Do not change the value of any kernel parameter on a system where it is already higher than the minimum requirement. 

Add below lines to /etc/sysctl.conf 

kernel.shmmax=2147483648
kernel.sem=250 32000 100 128
fs.file-max=65536

4c) Network Kernel Parameters

Run command below to check local port range;

[root@dellc600l1 ~]# cat /proc/sys/net/ipv4/ip_local_port_range
32768 61000

Add below lines to /etc/sysctl.conf

net.ipv4.ip_local_port_range=1024 65000
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144

To make all the changes made in 4a, 4b and 4c,  issue sysctl -p;

[root@dellc600l1 ~]# sysctl -p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
kernel.shmmax = 2147483648
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_max = 262144

4d) Shell Limits / Open File Descriptors for Oracle:

Login as root, and add below lines to  /etc/security/limits.conf 

oracle soft nofile 63536
oracle hard nofile 63536
oracle soft nproc 16384
oracle hard nproc 16384

Add soft and hard limit to ~oracle/.bash_profile  

ulimit -n 63536
ulimit -u 16384

5) Setup Temporary Swap Space

5a) Create Swap Space:

Check available memory and swap space

[root@dellc600l1 ~]# grep MemTotal /proc/meminfo
MemTotal: 515468 kB
[root@dellc600l1 ~]# cat /proc/swaps
Filename Type Size Used Priority
/dev/hda2 partition 1052248 0 -1

Here is the command to create temporary swap space.

[root@dellc600l1 ~]# dd if=/dev/zero of=tmpswap bs=1k count=900000
900000+0 records in
900000+0 records out
[root@dellc600l1 ~]# chmod 600 tmpswap
[root@dellc600l1 ~]# mkswap tmpswap
Setting up swapspace version 1, size = 921595 kB
[root@dellc600l1 ~]# swapon tmpswap

5b) Remove Swap Space:

Issue the below command to disable and remove swap space

[root@dellc600l1 ~]# swapoff tmpswap
[root@dellc600l1 ~]# rm tmpswap

6) Setup Oracle Environment Variables

Add below lines to ~oracle/.bash_profile 

export ORACLE_BASE=/u01/app/oracle
export ORACLE_SID=db10g1

TIP: Oracle Installer uses only BASE and SID variables, do not set any other variables while installing oracle.

7) Unpack Oracle Software Archives

Issue below command to unzip Oracle 10g Software Archive;

[oracle@dellc600l1 ~]$ unzip 10201_database_linux32.zip

8) Verify X-Windows

Make sure the clock (xclock) appears before you  kick off oracle installer ; Open a terminal and issue the below command

[oracle@dellc600l1 ~]$ xclock

If you don’t see a graphical clock on the console then, Issue the below command in terminal

[oracle@dellc600l1 ~]$ echo "DISPLAY=localhost:0.0;export DISPLAY"
[oracle@dellc600l1 ~]$ source .bash_profile
[oracle@dellc600l1 ~]$ xclock

If you don't see a graphical clock after setting the DISPLAY environment variable, please consult Red Hat User Manuals to configure XWindows

9) Starting Oracle Universal Installer

Run below command to start the oracle installer, only when you succeeded step 8.  

[oracle@dellc600l1 ~]$ cd database/
[oracle@dellc600l1 database]$ ./runInstaller

10) Oracle 10g Release 2 (10.2.0.1) Software Installation

Checking operating system requirements ...
Expected result: One of redhat-3,redhat-4,SuSE-9,asianux-1,asianux-2
Actual Result: redhat-4
Check complete. The overall result of this check is: Passed
=======================================================================

Checking operating system package requirements ...
Checking for make-3.79; found make-1:3.80-6.EL4. Passed
Checking for binutils-2.14; found binutils-2.15.92.0.2-21. Passed
Checking for gcc-3.2; found gcc-3.4.6-3. Passed
Checking for libaio-0.3.96; found libaio-0.3.105-2. Passed
Check complete. The overall result of this check is: Passed
=======================================================================

Checking kernel parameters
Checking for semmsl=250; found semmsl=250. Passed
Checking for semmns=32000; found semmns=32000. Passed
Checking for semopm=100; found semopm=100. Passed
Checking for semmni=128; found semmni=128. Passed
Checking for shmmax=536870912; found shmmax=2147483648. Passed
Checking for shmmni=4096; found shmmni=4096. Passed
Checking for shmall=2097152; found shmall=2097152. Passed
Checking for file-max=65536; found file-max=65536. Passed
Checking for VERSION=2.6.9; found VERSION=2.6.9-42.0.8.EL. Passed
Checking for ip_local_port_range=1024 - 65000; found ip_local_port_range=1024 - 65000. Passed
Checking for rmem_default=262144; found rmem_default=262144. Passed
Checking for rmem_max=262144; found rmem_max=262144. Passed
Checking for wmem_default=262144; found wmem_default=262144. Passed
Checking for wmem_max=262144; found wmem_max=262144. Passed
Check complete. The overall result of this check is: Passed
=======================================================================

Checking Recommended glibc version
Expected result: ATLEAST=2.3.2-95.27 
Actual Result: 2.3.4-2.25
Check complete. The overall result of this check is: Passed
=======================================================================

Checking physical memory requirements ...
Expected result: 922MB
Actual Result: 500MB
Check complete. The overall result of this check is: Failed <<<<
Problem: The system does not have sufficient physical memory to perform the install.
Recommendation: Increase the amount of physical memory available to your system before continuing with the installation.
=======================================================================

Checking available swap space requirements ...
Expected result: 1000MB
Actual Result: 1027MB
Check complete. The overall result of this check is: Passed
=======================================================================

Checking Network Configuration requirements ...
Check complete. The overall result of this check is: Failed <<<<
Problem: The install has detected that the primary IP address of the system is DHCP-assigned.
Recommendation: Oracle supports installations on systems with DHCP-assigned public IP addresses. However, the primary network interface on the system should be configured with a static IP address in order for the Oracle Software to function properly. See the Installation Guide for more details on installing the software on systems configured with DHCP.
=======================================================================

Validating ORACLE_BASE location (if set) ...
Check complete. The overall result of this check is: Passed
=======================================================================

Checking Oracle Home path for spaces...
Check complete. The overall result of this check is: Passed
=======================================================================

Checking for proper system clean-up....
Check complete. The overall result of this check is: Passed
=======================================================================

Checking for Oracle Home incompatibilities ....
Actual Result: NEW_HOME
Check complete. The overall result of this check is: Passed
=======================================================================

Fixes for prerequisite checks:
Physical memory requirements: Though the minimum requirement it 1 GB, you can still install with 512 MB physical memory.
Network Configuration requirements:  I added "192.168.1.100  dellc600l1" to /etc/hosts file to avoid the port 1521 error while creating database.

Oracle creates a General Purpose Startup Database, screenshots below;

Before you click "OK",   Login as root and execute above mentioned scripts, steps below;

[root@dellc600l1 ~]# . /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory to 770.
Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete

[root@dellc600l1 ~]# . /u01/app/oracle/product/10.2.0/db10g1/root.sh
Running Oracle10 root.sh script...

The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/10.2.0/db10g1

Enter the full pathname of the local bin directory: [/usr/local/bin]: /usr/local/bin
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...


Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
[root@dellc600l1 ~]# 

11) Setup Other Oracle Environment Variables

After installing Oracle 10g Release 2 (10.2.0.1) Software, add below lines to ~oracle/.bash_profile

export ORACLE_HOME=$ORACLE_BASE/oracle/product/10.2.0/db10g1
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

12) Upgrading 10g Release 2 (10.2.0.1) to Oracle 10g R2 (10.2.0.3)

Copy p5337014_10203_LINUX.zip to /tmp directory and use below command to extract the archive;

[oracle@dellc600l1 tmp]$ p5337014_10203_LINUX.zip 

TIPS: Shutdown all Oracle Database, Listener, iSQLPlus and Database Console before you Patch Oracle Software; Check out Start and Shutdown Oracle Database/Processes

Now execute below command to Launch Oracle Universal installer that came with 10.2.0.3.

[oracle@dellc600l1 tmp]$ cd Disk1
[oracle@dellc600l1 Disk1]$ ./runInstaller

Before you click "OK",   Login as root and execute above mentioned scripts, steps below;

[root@dellc600l1 ~]# . /u01/app/oracle/product/10.2.0/db10g1/root.sh
Running Oracle10 root.sh script...

The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/10.2.0/db10g1

Enter the full pathname of the local bin directory: [/usr/local/bin]: /usr/local/bin
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n) 
[n]: y
Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) 
[n]: y
Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) 
[n]: y
Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.

13) Upgrade/Migrate Database to 10g Release 2 (10.2.03)

TIPS: Shutdown all Oracle Database, Listener, iSQLPlus and Database Console before you Patch Oracle Software; Check out Start and Shutdown Oracle Database/Processes

Login as oracle user

Migrate Instance:

[oracle@dellc600l1 ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.3.0 - Production on Thu Mar 1 22:27:19 2007

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

SQL> conn sys/testpasswd as sysdba 
Connected to an idle instance.
SQL> STARTUP UPGRADE
SQL> SPOOL /tmp/dellc600l1_db10g1_patch.log
SQL> @?/rdbms/admin/catupgrd.sql
SQL> SPOOL OFF

Sample Output of dellc600l1_db10g1_patch.log

To see Upgrade Start and End Times;

[rperumal@dellc600l1 ~]$ cat /tmp/dellc600l1_db10g1_patch.log |awk '/COMP_TIMESTAMP/ || /DBUA_TIMESTAMP/'
COMP_TIMESTAMP UPGRD__BGN 2007-03-01 22:31:40 2454161 81100 
COMP_TIMESTAMP PATCH_BGN 2007-03-01 22:31:55 
COMP_TIMESTAMP CATPROC 2007-03-01 23:09:01
COMP_TIMESTAMP RDBMS 2007-03-01 23:09:01
DBUA_TIMESTAMP RDBMS VALID 2007-03-01 23:09:01
COMP_TIMESTAMP JAVAVM 2007-03-01 23:18:21
DBUA_TIMESTAMP JAVAVM VALID 2007-03-01 23:18:21
COMP_TIMESTAMP XML 2007-03-01 23:20:55
DBUA_TIMESTAMP XML VALID 2007-03-01 23:20:55
COMP_TIMESTAMP CATJAVA 2007-03-01 23:23:15
DBUA_TIMESTAMP CATJAVA VALID 2007-03-01 23:23:15
COMP_TIMESTAMP CONTEXT 2007-03-01 23:24:28
DBUA_TIMESTAMP CONTEXT VALID 2007-03-01 23:24:28
COMP_TIMESTAMP XDB 2007-03-01 23:27:50
DBUA_TIMESTAMP XDB VALID 2007-03-01 23:27:50
COMP_TIMESTAMP ODM 2007-03-01 23:29:00
DBUA_TIMESTAMP ODM VALID 2007-03-01 23:29:00
COMP_TIMESTAMP APS 2007-03-01 23:30:29
DBUA_TIMESTAMP APS VALID 2007-03-01 23:30:29
COMP_TIMESTAMP AMD 2007-03-01 23:33:07
DBUA_TIMESTAMP AMD VALID 2007-03-01 23:33:07
COMP_TIMESTAMP XOQ 2007-03-01 23:35:50
DBUA_TIMESTAMP XOQ VALID 2007-03-01 23:35:50
COMP_TIMESTAMP ORDIM 2007-03-01 23:53:56
DBUA_TIMESTAMP ORDIM VALID 2007-03-01 23:53:56
COMP_TIMESTAMP SDO 2007-03-01 23:57:07
DBUA_TIMESTAMP SDO VALID 2007-03-01 23:57:07
COMP_TIMESTAMP EXF 2007-03-01 23:57:57
DBUA_TIMESTAMP EXF VALID 2007-03-01 23:57:57
COMP_TIMESTAMP EM 2007-03-02 00:02:29
DBUA_TIMESTAMP EM VALID 2007-03-02 00:02:29
COMP_TIMESTAMP RUL 2007-03-02 00:03:14
DBUA_TIMESTAMP RUL VALID 2007-03-02 00:03:14
COMP_TIMESTAMP UPGRD_END 2007-03-02 00:03:14
[rperumal@dellc600l1 ~]$ 

To see List of Upgrades Components;

[rperumal@dellc600l1 ~]$ tail -40 /tmp/dellc600l1_db10g1_patch.log 
Oracle Database 10.2 Upgrade Status Utility 03-02-2007 00:03:15
.
Component Status Version HH:MM:SS
Oracle Database Server VALID 10.2.0.3.0 00:37:20
JServer JAVA Virtual Machine VALID 10.2.0.3.0 00:09:19
Oracle XDK VALID 10.2.0.3.0 00:02:34
Oracle Database Java Packages VALID 10.2.0.3.0 00:02:19
Oracle Text VALID 10.2.0.3.0 00:01:12
Oracle XML Database VALID 10.2.0.3.0 00:03:22
Oracle Data Mining VALID 10.2.0.3.0 00:01:09
OLAP Analytic Workspace VALID 10.2.0.3.0 00:01:29
OLAP Catalog VALID 10.2.0.3.0 00:02:37
Oracle OLAP API VALID 10.2.0.3.0 00:02:43
Oracle interMedia VALID 10.2.0.3.0 00:18:06
Spatial VALID 10.2.0.3.0 00:03:10
Oracle Expression Filter VALID 10.2.0.3.0 00:00:49
Oracle Enterprise Manager VALID 10.2.0.3.0 00:04:32
Oracle Rule Manager VALID 10.2.0.3.0 00:00:44
.
Total Upgrade Time: 01:31:34
DOC>#######################################################################
DOC>#######################################################################
DOC>
DOC> The above PL/SQL lists the SERVER components in the upgraded
DOC> database, along with their current version and status.
DOC>
DOC> Please review the status and version columns and look for
DOC> any errors in the spool log file. If there are errors in the spool
DOC> file, or any components are not VALID or not the current version,
DOC> consult the Oracle Database Upgrade Guide for troubleshooting
DOC> recommendations.
DOC>
DOC> Next shutdown immediate, restart for normal operation, and then
DOC> run utlrp.sql to recompile any invalid application objects.
DOC>
DOC>#######################################################################
DOC>#######################################################################

Restart Instance:

SQL> SHUTDOWN
SQL> STARTUP

Recompile Invalid Objects:

Login as sysdba and run below script;

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

Sample output as below;

TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN 2007-03-02 00:07:52
DOC> The following PL/SQL block invokes UTL_RECOMP to recompile invalid
DOC> objects in the database. Recompilation time is proportional to the
DOC> number of invalid objects in the database, so this command may take
DOC> a long time to execute on a database with a large number of invalid
DOC> objects.
DOC>
DOC> Use the following queries to track recompilation progress:
DOC>
DOC> 1. Query returning the number of invalid objects remaining. This
DOC> number should decrease with time.
DOC> SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);
DOC>
DOC> 2. Query returning the number of objects compiled so far. This number
DOC> should increase with time.
DOC> SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
DOC>
DOC> This script automatically chooses serial or parallel recompilation
DOC> based on the number of CPUs available (parameter cpu_count) multiplied
DOC> by the number of threads per CPU (parameter parallel_threads_per_cpu).
DOC> On RAC, this number is added across all RAC nodes.
DOC>
DOC> UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel
DOC> recompilation. Jobs are created without instance affinity so that they
DOC> can migrate across RAC nodes. Use the following queries to verify
DOC> whether UTL_RECOMP jobs are being created and run correctly:
DOC>
DOC> 1. Query showing jobs created by UTL_RECOMP
DOC> SELECT job_name FROM dba_scheduler_jobs
DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>
DOC> 2. Query showing UTL_RECOMP jobs that are running
DOC> SELECT job_name FROM dba_scheduler_running_jobs
DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>#

TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END 2007-03-02 00:13:32
DOC> The following query reports the number of objects that have compiled
DOC> with errors (objects that compile with errors have status set to 3 in
DOC> obj$). If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
DOC>#

OBJECTS WITH ERRORS
-------------------
0
DOC> The following query reports the number of errors caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC>#

ERRORS DURING RECOMPILATION
---------------------------
0
SQL> 

14) Start and Shutdown Oracle Database/Processes

Issue ps -eaf to see any oracle processes running in the OS,  if you have chosen an option to install reconfigured database then below services will be running.

To start, iSQL Plus:

[oracle@dellc600l1 ~]$ isqlplusctl start
iSQL*Plus 10.2.0.3.0
Copyright (c) 2003, 2006, Oracle. All Rights Reserved.
Starting iSQL*Plus ...
iSQL*Plus started.

To Stop, iSQLPlus:

[oracle@dellc600l1 ~]$ isqlplusctl stop
iSQL*Plus 10.2.0.3.0
Copyright (c) 2003, 2006, Oracle. All Rights Reserved.
Stopping iSQL*Plus ...
iSQL*Plus stopped.

To Start, Database Control for Database Management:

[oracle@dellc600l1 ~]$ emctl start dbconsole
TZ set to US/Central
Oracle Enterprise Manager 10g Database Control Release 10.2.0.3.0 
Copyright (c) 1996, 2006 Oracle Corporation. All rights reserved.
http://dellc600l1:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ......... started. 
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/10.2.0/db10g1/dellc600l1_db10g1/sysman/log 

To Stop, Database Control for Database Management:

[oracle@dellc600l1 ~]$ emctl stop dbconsole
TZ set to US/Central
Oracle Enterprise Manager 10g Database Control Release 10.2.0.3.0 
Copyright (c) 1996, 2006 Oracle Corporation. All rights reserved.
http://dellc600l1:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Database Control ... 
... Stopped. 

To Start, Oracle Listener:

[oracle@dellc600l1 ~]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 02-MAR-2007 00:18:22

Copyright (c) 1991, 2006, Oracle. All rights reserved.

Starting /u01/app/oracle/product/10.2.0/db10g1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.3.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0/db10g1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db10g1/network/log/listener.log
...output omitted..
The command completed successfully
[oracle@dellc600l1 ~]$ 

To Stop, Oracle Listener:

[oracle@dellc600l1 ~]$ lsnrctl stop 

LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 02-MAR-2007 00:24:21

Copyright (c) 1991, 2006, Oracle. All rights reserved.

To Start, Oracle Database

[oracle@dellc600l1 ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.3.0 - Production on Fri Mar 2 00:17:13 2007

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup 
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1260696 bytes
Variable Size 134218600 bytes
Database Buffers 29360128 bytes
Redo Buffers 2932736 bytes
Database mounted.
Database opened.

To Stop, Oracle Database

[oracle@dellc600l1 ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.3.0 - Production on Fri Mar 2 00:24:41 2007

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

SQL> conn / as sysdba 
Connected.
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.