Thinking Out Loud

January 15, 2013

OEL 6.3 Minimal Install VirtualBox for 11.2.0.3 Database

Filed under: 11g,linux,oracle,VirtualBox — mdinh @ 4:15 am

I am a lazy DBA. The less configuration I do the less chance I have to make a mistake.

Surprisingly, oracle-rdbms-server-11gR2-preinstall does not configure pam.d/login and selinux.

Here’s how to create kernel panic with incorrect configuration.

kernelpanic

NOTE: Configuration should be SELINUX=disabled NOT SELINUXTYPE=disabled

At the same time, I need to slow down and read more carefully.

Here is the super condensed version since there are already many blogs on how to install Linux on VirtuaBox.

Customize Minimal Install

Base System
> Base
> Client Management Tools
Desktops
> Desktop
> Desktop Platform
> Graphical Administration Tools
> X Window System

NTP not configured

Reboot

Disable Firewall/Disable Software Updates

yum install oracle-rdbms-server-11gR2-preinstall

Note: I did not have to modify public-yum-ol6.repo for OEL 6.3

Read more about it here https://blogs.oracle.com/linux/entry/oracle_rdbms_server_11gr2_pre

Modify /etc/grub.conf to include: divider=10

Read more about it here http://www.virtualbox.org/manual/ch12.html#idp13392912 via @rmoff https://twitter.com/rmoff/status/287187594712862721

Modify /etc/pam.d/login to include: session required pam_limits.so

Modify /etc/selinux/config: SELINUX=disabled

Install Guest Additions.

yum clean all

Configure /etc/hosts accordingly.

Reboot

As root, Configure oracle:

passwd oracle
usermod -G dba,vboxsf oracle
mkdir -p /u01/app/oracle
mkdir -p /u01/app/oraInventory
mkdir -p /u01/app/oracle/cfgtoollogs
mkdir -p /u01/app/oracle/product/11.2.0.3/db_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01

As oracle, Modify /home/oracle/.bash_profile to include:

# User specific environment and startup programs
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi

export TEMP=/tmp
export TMPDIR=$TEMP
export BASE_PATH=$PATH
export ORACLE_TERM=xterm;
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0.3/db_1
export LD_LIBRARY_PATH=/lib:/usr/lib
export ORACLE_HOSTNAME=gg1.localdomain
export ORAENV_ASK=NO
export PS1=”
${LOGNAME}@`hostname -a`:\${ORACLE_SID}:\${PWD}
> “

Install oracle software only

About these ads

1 Comment »

  1. I feel this is among the so much significant info for me.
    And i’m happy studying your article. However wanna commentary
    on few basic things, The site style is perfect,
    the articles is actually great : D. Just right task, cheers

    Comment by Kylee Fauth — October 2, 2013 @ 4:16 pm | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Rubric Theme. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 313 other followers

%d bloggers like this: