Oracle Database 10.2 Installation on Oracle Enterprise Linux 5

Here are my experience for installing Oracle Database 10.2 on Oracle Enterprise Linux:

Extract the installer:
tar -zxvf database.tgz

Make sure your domain are set correctly in host file, /etc/hosts.
For example:
127.0.0.1 localhost.localdomain localhost
192.168.41.82 dbcamps.balicamp.com dbcamps

Edit file sysctl.conf on /etc, insert these line:
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 6500
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144

Run this file to activate the changes on kernel:
/sbin/sysctl -p

Edit /etc/security/limit.conf to insert these line:
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536

Then edit /etc/pam.d/login to insert these line:
session required /lib/security/pam_limits.so

Install these packages in order:
kernel-headers-2.6.18-92.el5.i386.rpm
glibc-headers-2.5-24.i386.rpm
glibc-devel-2.5-24.i386.rpm
libgomp-4.1.2-42.el5.i386.rpm
gcc-4.1.2-42.el5.i386.rpm
compat-libf2c-34-3.4.6-4.i386.rpm
compat-gcc-34-3.4.6-4.i386.rpm
compat-gcc-34-c++-3.4.6-4.i386.rpm
compat-db-4.2.52-5.1.i386.rpm
libXp-1.0.0-8.1.el5.i386.rpm
openmotif-2.3.0-0.5.el5.i386.rpm
Note:You must install those package sequentialy...

Prepare the user and installation folder:
groupadd oinstall
groupadd dba
groupadd oper

useradd -g oinstall -G dba oracle
password

This is just for example, you can make your own directory in your root directory:
mkdir -p /u10/app/oracle/product/10.2.0/db_1
chown -R oracle.oinstall /u10

Then edit /etc/redhat-release, change to this (backup first - remember to restore it later):
redhat-4

Edit this file /home/oracle/.bash_profile, then insert these folowing lines:
#Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_BASE=/u10/app/oracle/; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID=ORABALI; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH;export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;
export CLASSPATH

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

And run those script ass root:
xhost+

Login to oracle account and run these lines:
DISPLAY=:0.0;
export DISPLAY

Entry to the directory that had been extracted, then type:
./runInstaller

After you finished the installation, start the service on your console by typing:
emctl start dbconsole
but before that, you must login with user "oracle".

Then use your browser and type:

http://localhost:1158


That's it.....

Close port 445 to Stop Worm Activities

Even after you disable local file and print sharing, Windows XP still leaves port 445 open and listening for incoming connections. If you are using Internet, this can pose a security risk. To close this port you need to make a change. Here are the some isntruction to close port 445 in Windows XP:

1. Click "Start"
2. Click "Run"
3. type "regedit"
4. Navigate to HKLM\System\CurrentControlSet\Services\NetBT\Parameters
5. Find the value "TransportBindName" and right click it to open a menu of options.
6. Click "Modify"
7. Where it says "Value data:" delete whatever is in the box to clear the box.
8. Click "OK"
9. Close, and Restart your PC.

Installing Oracle Enterprise Linux 5 on VMware Server 2

Here are my experiment with installing Oracle Linux Server (Enterprise Edition) on VMware server 2 (free edition).

1. Choose "Create Virtual Machine" on Summary tag.
2. Enter Name of Virtual Machine you want to create, if you have more than one datastore, choose one. click Next.


3. On the radio button choose "Linux Operating" with version "Other 2.6.x Linux (32-bit)"


4. Set virtual Memory and Processors, this setting is depending on the configuration of your PC. if it is finished, click Next.


5. Specify the hard disk space do you want to create.


6. Add the Network Adapter.


7. Use the network bridge.


8. On CD/DVD Drive, specify the source file. If you have the ISO file, choose "Use an ISO", if the source from physical CD/DVD Drive, choose "use a Physical Drive".


9. If you need floopy drive, you can add it. But i dont choose to install it.


10. But in this step i choose to add a USB device. Click next.


11. Finish


12. Turn on the machine.

13. Click at the "Console" tag, then click console to open the console in a new window.

Now you have the host for install the Oracle Linux Enterprise. Then you just follow the installation instruction.

Installing VMware Server 2 in openSUSE 11.0

These are short tutorial for installing VMware Server 2 in openSUSE 11.0:

1. First, check the availability of the prerequisites:
   rpm -qa | egrep "kernel-source|gcc-|make"
   Make sure kernel-source, make, gcc, gcc-c++ already installed, if it's not use YaST to install it.
2. Run this command as root:
   # cd /usr/src/linux
   # make mrproper; make cloneconfig; make modules_prepare
3. Download the VMWare .rpm installer and installed using YaST (just double-click the file). Or in the terminal type, #rpm -ivh .
4. Run configuration script as root:
   # /usr/bin/vmware-config.pL

• accept the licence agreement. (Press enter and the space bar to scroll through and enter q at the end to quit)
• configuration starts and in most cases you can accept the defaults.
• choose "Bridged" for the networking option.
• choose your username when asked: "Please specify the user whom you wish to be the VMware Server administrator".
• if asked "Do you want this program to try to build the vmmon module for your system?", then answer "yes".
• if told that there's a difference between various "gcc" modules and then asked if you want to proceed anyway, then answer "yes".
• finally, enter the software key. (A8H80-PAF8N-0CM9M-4RJ09)

5. Open YaST- System - System Services (Runlevel). Enable vmware in the the "Service" list, leaving the other vmware services alone. In "Expert" mode, vmware is set to runlevels 2, 3 and 5 and the other vmware-related services aren't set for any runlevels. Stop the 4 vmware services (that you see in Yast's System Services [Runlevel]) from running concurrently at boot time. They are supposed to run consecutively. Edit the file /etc/sysconfig/boot and find the line RUN_PARALLEL="yes". Change yes to no. That will cause the startup scripts to run consecutively.

6. Start it manually :
# sudo /etc/init.d/vmware start

7. Open the browser:
http://localhost:<8222>
8222 is default port for VMware server.


That's it..