Tuesday, September 7, 2010

Installing oracle 10.0.2 on Red Hat Linux

Hi,
I tried to install Oracle 10.2 on Red Hat ES 4.0 and found the below article as very useful and easy one.
Before installation
• Have static ip to installation machine.
• Copy the installer to folder where user ‘oracle’ has execute permissions.
During Oracle installation
• RUN scripts as root user (Oracle will give you the hint, don’t ignore it)
• Unlock the account which you need.
Regards
Balaji

Source Post is from: http://www.oracle-base.com/articles/10g/OracleDB10gR2InstallationOnRedHatAS4.php

Oracle Database 10g Release 2 (10.2.0.1) Installation On Red Hat Enterprise Linux 4 (RHEL4)
In this article I'll describe the installation of Oracle Database 10g Release 2 (10.2.0.1) on Red Hat Enterprise Linux 4 (RHEL4). The article is based on a server installation with a minimum of 2G swap, secure Linux disabled and the following package groups installed:
• X Window System
• GNOME Desktop Environment
• Editors
• Graphical Internet
• Text-based Internet
• Server Configuration Tools
• Development Tools
• Administration Tools
• System Tools
Alternative installations may require more packages to be loaded, in addition to the ones listed below.
• Download Software
• Unpack Files
• Hosts File
• Set Kernel Parameters
• Setup
• Installation
• Post Installation
Download Software
Download the following software:
• Oracle Database 10g Release 2 (10.2.0.1) Software
Unpack Files
Unzip the files:
unzip 10201_database_linux32.zip
You should now have a single directory containing installation files. Depending on the age of the download this may either be named "db/Disk1" or "database".

Hosts File
The /etc/hosts file must contain a fully qualified name for the server:

Set Kernel Parameters
Add the following lines to the /etc/sysctl.conf file:
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
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.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144
Run the following command to change the current kernel parameters:
/sbin/sysctl -p
Add the following lines to the /etc/security/limits.conf file:
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536
Add the following line to the /etc/pam.d/login file, if it does not already exist:
session required pam_limits.so
Note by Kent Anderson: In the event that pam_limits.so cannot set privileged limit settings see Bug 115442.

Disable secure linux by editing the /etc/selinux/config file, making sure the SELINUX flag is set as follows:
SELINUX=disabled
Alternatively, this alteration can be done using the GUI tool (Applications > System Settings > Security Level). Click on the SELinux tab and disable the feature.

Setup
Install the following packages:
# From RedHat AS4 Disk 2
cd /media/cdrom/RedHat/RPMS
rpm -Uvh setarch-1*
rpm -Uvh compat-libstdc++-33-3*
rpm -Uvh make-3*
rpm -Uvh glibc-2*

# From RedHat AS4 Disk 3
cd /media/cdrom/RedHat/RPMS
rpm -Uvh openmotif-2*
rpm -Uvh compat-db-4*
rpm -Uvh libaio-0*
rpm -Uvh gcc-3*

# From RedHat AS4 Disk 4
cd /media/cdrom/RedHat/RPMS
rpm -Uvh compat-gcc-32-3*
rpm -Uvh compat-gcc-32-c++-3*
Create the new groups and users:
groupadd oinstall
groupadd dba
groupadd oper

useradd -g oinstall -G dba oracle
passwd oracle
Create the directories in which the Oracle software will be installed:
mkdir -p /u01/app/oracle/product/10.2.0/db_1
chown -R oracle.oinstall /u01
Login as root and issue the following command:
xhost +
Login as the oracle user and add the following lines at the end of the .bash_profile file:
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID=TSH1; 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
#LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME_KERNEL

if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
Installation
Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable:
DISPLAY=:0.0; export DISPLAY
Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory:
./runInstaller

Sunday, September 5, 2010

Copying videos to Sony WalkMan NWZ-E344

Hi recently I bought a sony walk man and struggled to copy videos to it. I found the following steps to copy the songs.
• Convert your DVD files to Windows Media file
o You can use Win Avi http://www.winavi.com/ very good tool.
o Go to advanced options and use the following settings
o Resolution: 310x230
o Bit rate 768 Kbps
o Frame rate 30
• Copy the generated windows media file to sony walkman using content transfer utitly from Sony.
o Download the utility from http://www.sony.co.in/support/download/363271/product/nwz-w252/sectionfirst?subpage=detail
Hope this Help!
Balaji

Followers