Thursday, June 07, 2007


Install Oracle 10.2.0.1 on Solaris 10 (64 bit) virtual machine under VMWare Server
1.0.3 on CentOS 5.0



CentOS 5.0 and VMWare Server 1.0.3 have been installed on the box been assembled
utilizing following hardware:-
CPU Core2Duo E6600 2.4GHZ, board ASUS P5B Deluxe, 2GB RAM (2xDDR2 1GB PC 5300 Kingston),2x160 GB SATA HDDs Seagate Barracuda 160 GB. Host Controllers Intel ICH8R and Jmicron JMB 363 both running in AHCI mode, what prevents from straightforward installation Solaris 10 on mentioned box.


Solaris 10 (11/06) has been installed as VMWare Server Virtual Machine configured as:-





Solaris 10 Virtual Machine start up:-






Login to Solaris:-






Virtual Network Bridge verification:-







Runtime snapshot:-






Shutdown Solaris properly :-






Now Solaris VM may be powered off:-






Test install Oracle 10g R2 on Solaris 10 VM.



Note:-
Through my experience change VMware Solaris 10 VM BIOS setting for
"Large Disk Access Mode" from "DOS" to "Others" gives I/O performance improvement
about 20-30%. Press "F2" during VMWare startup to enter BIOS setup





Create user "oracle" :-



# groupadd oinstall
# groupadd dba
# useradd -d /export/home/oracle -g oinstall -G dba -m -s /bin/bash oracle
# passwd -r files oracle
# mkdir -p /export/home/oracle/product/10.2.0/db_1
# chown -R oracle:oinstall /export/home/oracle



Create project "oracle" and tune maximum shared memory size
segment available for oracle session as 4 GB utilizing "prctl" command as required
by Oracle manuals for Solaris 10, i.e. run as root:-



# projadd oracle



and add line to /etc/user_attr:-



oracle::::project=oracle



Having oracle’s session opened , run as root:-



# projmod -s -K "project.max-shm-memory=(priv,4gb,deny)" oracle



Relogin as oracle and make sure oracle's project has been updated:-



$ prctl -n project.max-shm-memory -i project oracle
 
 NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT
  project.max-shm-memory
  privileged 4.00GB - deny –
  system 16.0EB max   deny -


In general, following kernel parameters have to be
also tuned for Solaris 10 :-



project.max-sem-ids 100
project.max-sem-nsems 256
project.max-shm-ids  100



Tune ~oracle/.bash_profile as usual:- 



umask 022
TMP=/tmp
TMPDIR=$TMP
DISPLAY=:0.0
export TMP TMPDIR DISPLAY
export ORACLE_BASE=/export/home/oracle
export ORACLE_HOME=/export/home/oracle/product/10.2.0/db_1
export ORACLE_SID=orcl
export PATH=$ORACLE_HOME/bin:$PATH



and issue :-



# xhost +
# su - oracle
$ cd /install/database
$./runInstaller



Due to known bug , run Installer with option "Install Software only"
When done , run:-



$ dbca



to create database and



$ netca



to configure file $ORACLE_HOME/network/admin/listener.ora and
$ORACLE_HOME/network/admin/tnsnames.ora.


Different approach is to disable sendmail:-



# svcadm disable svc:/network/smtp:sendmail
# xhost +
# su - oracle
$ cd /install/database
$./runInstaller



Select option "Create Database". Installer won't hang now.











Oracle sample database start/stop benchmarking.


Posted by at