Search This Blog

Thursday, February 8, 2007

Install Oracle 10gr2 on Linux Version 4

Logging In to the System as root
For X windows system.
For LOCAL Machine
# xterm



For Remote Machine
# xhost fully_qualified_remote_host_name

Hardware Requirements
1.At least 1024 MB of physical RAM
2.swap space
Up to 1024 MB-----------> 2 times the size of RAM
Between 1025 MB-----------> and 2048 MB 1.5 times the size of RAM
Between 2049 MB and 8192 MB-----------> Equal to the size of RAM
More than 8192 MB-----------> 0.75 times the size of RAM

Add SWAP SPACE is NECCESSARY.#we have two option 1.swap partition 2.swap file
#On my example i am choose second option for increase swap space.

ADD SWAP FILE
1.Determine the size of the new swap file and multiple by 1024 to determine the block size. For example, the block size of a 64 MB swap file is 65536.
count being equal to the desired block size:

linux@oracle]# dd if=/dev/zero of=/swapfile bs=1024 count=65536
linux@oracle]# mkswap /swapfile #setup swap file.
linux@oracle]# swapon /swapfile #enable swap file.
edit /etc/fstab to include:
/swapfile swap swap defaults 0 0 #enable for boot time.
linux@oracle]# cat /proc/swaps or free # check swap size is add or not.

3.TEMP space
400 MB of disk space in the /tmp directory
4.DISK space
3.5 GB + 1.2 GB optional

Check above requirements.
1.RAM size.
# grep MemTotal /proc/meminfo

2.SWAP size
# grep SwapTotal /proc/meminfo

3.TEMP size
# df -k /tmp

4.DISK size
# df -k

5.System Architecture
# grep "model name" /proc/cpuinfo

Software Requirements
OPERATING SYSTEM
Red Hat Enterprise Linux AS/ES 3.0 (Update 4 or later)
Red Hat Linux 4.0
Which Version is install.
linux@oracle]# cat /etc/issue


KERNEL VERSION
Red Hat Enterprise Linux 3.0 and Asianux 1.0:
2.4.21-27.EL
Note: This is the default kernel version.

Red Hat Enterprise Linux 4.0 and Asianux 2.0:
2.6.9-5.EL

Kernel is install.
linux@oracle]# uname -r

[root@alwarid-taj ~]# uname -r
2.6.9-34.ELsmp


PACKAGES
Red Hat Enterprise Linux 3.0 and Asianux 1.0:
make-3.79.1
gcc-3.2.3-34
glibc-2.3.2-95.20
compat-db-4.0.14-5
compat-gcc-7.3-2.96.128
compat-gcc-c++-7.3-2.96.128
compat-libstdc++-7.3-2.96.128
compat-libstdc++-devel-7.3-2.96.128
openmotif21-2.1.30-8
setarch-1.3-1



Red Hat Enterprise Linux 4.0 and Asianux 2.0:
binutils-2.15.92.0.2-13.EL4
compat-db-4.1.25-9
compat-libstdc++-296-2.96-132.7.2
control-center-2.8.0-12
gcc-3.4.3-22.1.EL4
gcc-c++-3.4.3-22.1.EL44
glibc-2.3.4-2.9
glibc-common-2.3.4-2.9
gnome-libs-1.4.1.2.90-44.1
libstdc++-3.4.3-22.1
libstdc++-devel-3.4.3-22.1
make-3.80-5
pdksh-5.2.14-30
sysstat-5.0.5-1
xscreensaver-4.18-5.rhel4.2
setarch-1.6-1

Packages is install.
linux@oracle]# rpm -q package_name


Operating System Groups and Users

The Oracle Inventory group (oinstall)
linux@oracle]# more /etc/oraInst.loc
linux@oracle]#grep oinstall /etc/group
if group is not exists then create.
linux@oracle]# /usr/sbin/groupadd oinstall

The OSDBA group (dba)
linux@oracle]# grep dba /etc/group
if group is not exists then create.
linux@oracle]# /usr/sbin/groupadd dba

The Oracle software owner (oracle)
linux@oracle]# id oracle
if exists output like
uid=440(oracle) gid=200(oinstall) groups=201(dba),202(oper)
if oracle user not exists then create first with below command
linux@oracle]# /usr/sbin/useradd -g oinstall -G dba oracle

after add oracle user to oinstall or dba group with below command
linux@oracle]# /usr/sbin/usermod -g oinstall -G dba oracle

Set password
linux@oracle]# passwd oracle

Configuring Kernel Parameters
Set to values greater than or equal to the recommended value shown in below table.

kernel.shmall = 2097152 ## /sbin/sysctl -a | grep shm
kernel.shmmax = 2147483648 ## /sbin/sysctl -a | grep shm
kernel.shmmni = 4096 ## /sbin/sysctl -a | grep shm
kernel.sem = 250 32000 100 128 ## /sbin/sysctl -a | grep sem
fs.file-max = 65536 ## /sbin/sysctl -a | grep file-max
net.ipv4.ip_local_port_range = 1024 65000 ## /sbin/sysctl -a | grep ip_local_port_range
net.core.rmem_default = 1048576 ## /sbin/sysctl -a | grep rmem_default
net.core.rmem_max = 1048576 ## /sbin/sysctl -a | grep rmem_max
net.core.wmem_default = 262144 ## /sbin/sysctl -a | grep wmem_default
net.core.wmem_max = 262144 ## /sbin/sysctl -a | grep wmem_max

Note By specifying the values in the /etc/sysctl.conf file, they persist when you restart the system.

linux@oracle]# vi /etc/sysctl.conf
#press i and set above parameters as minimum requirements.
#for file close
Shift+ZZ

Example :
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144


Restart Machine.

Creating Required Directories
About Mounted File System.
linux@oracle]# df -h

Create Directory and grant required privs.
linux@oracle]# mkdir -p /mount_point/app/oracle_sw_owner
linux@oracle]# chown -R oracle:oinstall /mount_point/app/oracle_sw_owner
linux@oracle]# chmod -R 775 /mount_point/app/oracle_sw_owner

Configuring the oracle User's Environment
For Oracle Universal Installer
Default SHELL for Oracle User.
linux@oracle]# su - oracle
linux@oracle]$ echo $SHELL
linux@oracle]$ vi .bash_profile
Add umask 022 in .bash_profile.
save and close
Set the default file mode creation mask (umask) to 022 in the shell startup file.

Run Shell Startup Script
linux@oracle]$ . ./.bash_profile


[oracle@alwarid-taj ~]$ umask
0022
[oracle@alwarid-taj ~]$

Set the DISPLAY environment variable.
linux@oracle]$ DISPLAY=local_host:0.0; export DISPLAY
eg: DISPLAY=127.0.0.1:0.0; export DISPLAY------>local host.
DISPLAY=192.168.100.239; export DISPLAY---->IP address

UNSET ORACLE_HOME or TNS_ADMIN variable.
linux@oracle]$ unset ORACLE_HOME
linux@oracle]$ unset TNS_ADMIN

Verify ENVIRONMENT VARIABLE SET CORRECTLY.
linux@oracle]$ umask
linux@oracle]$ env | more
[root@alwarid-taj ~]# su - oracle
[oracle@alwarid-taj ~]$ env | more
HOSTNAME=alwarid-taj
SHELL=/bin/bash
TERM=xterm
HISTSIZE=1000
USER=oracle
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
KDEDIR=/usr
MAIL=/var/spool/mail/oracle
PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/bin
INPUTRC=/etc/inputrc
PWD=/home/oracle
LANG=en_US.UTF-8
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SHLVL=1
HOME=/home/oracle
LOGNAME=oracle
LESSOPEN=|/usr/bin/lesspipe.sh %s
DISPLAY=:0.0
G_BROKEN_FILENAMES=1
XAUTHORITY=/root/.Xauthority
_=/bin/env
[oracle@alwarid-taj ~]$



Mounting the Product Disc
linux@oracle]$ eject /mnt/dvd #eject disc from drive.
linux@oracle]$ ls /mnt/dvd #verify disc mounted automatically.
linux@oracle]$ mount -t iso9660 /dev/dvd /mnt/dvd #display contents of the disc.

Installing Oracle Database
linux@oracle]$ /mount_point/db/runInstaller

[root@alwarid-taj ~]# su - oracle
[oracle@alwarid-taj ~]$ unset TNS_ADMIN
[oracle@alwarid-taj ~]$ unset ORACLE_HOME
[oracle@alwarid-taj ~]$ export DISPLAY=127.0.0.1:0.0;
[oracle@alwarid-taj ~]$ media/cdrecorder/database/runInstaller
-bash: media/cdrecorder/database/runInstaller: No such file or directory
[oracle@alwarid-taj ~]$ cd ..
[oracle@alwarid-taj home]$ cd ..
[oracle@alwarid-taj /]$ media/cdrecorder/database/runInstaller
Starting Oracle Universal Installer...

Checking installer requirements...

Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Passed


All installer requirements met.

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2007-02-12_12-21-08PM. Please wait ...[oracle@alwarid-taj /]$ Exception in thread "main" java.lang.InternalError: Can't connect to X11 window server using '127.0.0.1:0.0' as the value of the DISPLAY variable.
at sun.awt.X11GraphicsEnvironment.initDisplay(Native Method)
at sun.awt.X11GraphicsEnvironment.(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(Unknown Source)
at java.awt.Window.init(Unknown Source)
at java.awt.Window.(Unknown Source)
at java.awt.Frame.(Unknown Source)
at oracle.ewt.popup.PopupFrame.(Unknown Source)
at oracle.ewt.lwAWT.BufferedFrame.(Unknown Source)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.(OiocOneClickInstaller.java:378)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.main(OiocOneClickInstaller.java:2091)

[oracle@alwarid-taj /]$

===================================================================
[oracle@alwarid-taj /]$ xhost +
xhost: unable to open display "127.0.0.1:0.0"
===============================================
[oracle@alwarid-taj /]$ who am i
root pts/1 Feb 12 12:16 (:0.0)

[oracle@alwarid-taj /]$ echo you have to LOGOUT ROOT user and LOGON ORACLE user.through GUI not just "su" command.
you have to LOGOUT ROOT user and LOGON ORACLE user.through GUI not just su command.
=================================================================================
[oracle@alwarid-taj ~]$ who am i
oracle pts/1 Feb 12 12:30 (:0.0)

[oracle@alwarid-taj ~]$ export DISPLAY=127.0.0.1:0.0;
[oracle@alwarid-taj ~]$ cd ..
[oracle@alwarid-taj home]$ cd //
[oracle@alwarid-taj //]$ cd ..
[oracle@alwarid-taj //]$ media/cdrecorder/database/runInstaller
Starting Oracle Universal Installer...

Checking installer requirements...

Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Passed


All installer requirements met.

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2007-02-12_12-37-20PM. Please wait ...[oracle@alwarid-taj //]$ Exception in thread "main" java.lang.InternalError: Can't connect to X11 window server using '127.0.0.1:0.0' as the value of the DISPLAY variable.
at sun.awt.X11GraphicsEnvironment.initDisplay(Native Method)
at sun.awt.X11GraphicsEnvironment.(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(Unknown Source)
at java.awt.Window.init(Unknown Source)
at java.awt.Window.(Unknown Source)
at java.awt.Frame.(Unknown Source)
at oracle.ewt.popup.PopupFrame.(Unknown Source)
at oracle.ewt.lwAWT.BufferedFrame.(Unknown Source)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.(OiocOneClickInstaller.java:378)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.main(OiocOneClickInstaller.java:2091)

[oracle@alwarid-taj //]$

We have to first configur xhost + command in oracle user evniourments.
[oracle@alwarid-taj //]$ export DISPLAY=127.0.0.1:0.0;
[oracle@alwarid-taj //]$ xhost +
xhost: unable to open display "127.0.0.1:0.0"

Know set DISPLAY like DISPLAY=:0.0;
[oracle@alwarid-taj //]$ export DISPLAY=:0.0;
[oracle@alwarid-taj //]$ xhost +
access control disabled, clients can connect from any host
[oracle@alwarid-taj //]$ media/cdrecorder/database/runInstaller
Starting Oracle Universal Installer...

Checking installer requirements...

Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Passed


All installer requirements met.

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2007-02-12_12-41-21PM. Please wait ...[oracle@alwarid-taj //]$

On Installation first windows you have to give "sys , system, sysman or dbsnmp" users password.
must sure UNIX DBA GROUP >>>> oinstall <<<<
>>>next
On second windows must sure inventory directory select like.
/home/oracle/oraInventory
or on specify oracle group select >>>oinstall<<<<
>>>next
On Product specific prerequistic checks
=======================================================================

Checking operating system package requirements ...
Checking for make-3.79; found make-1:3.80-5. Passed
Checking for binutils-2.14; found binutils-2.15.92.0.2-18. Passed
Checking for gcc-3.2; found Not found. Failed <<<<
Checking for libaio-0.3.96; found libaio-0.3.105-2. Passed
Check complete. The overall result of this check is: Failed <<<<
Problem: Some packages required for the Oracle Database 10g to function properly are missing (see above).
Recommendation: Install the required packages before continuing with the installation.
=======================================================================

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.4.21; found VERSION=2.6.9-34.ELsmp. 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=1048576. Passed
Checking for rmem_max=262144; found rmem_max=1048576. 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.19
Check complete. The overall result of this check is: Passed
=======================================================================

Checking physical memory requirements ...
Expected result: 922MB
Actual Result: 992MB
Check complete. The overall result of this check is: Passed
=======================================================================

Checking available swap space requirements ...
Expected result: 1488MB
Actual Result: 0MB
Check complete. The overall result of this check is: Failed <<<<
Problem: The system does not have the required swap space.
Recommendation: Make more swap space available to perform the install.
=======================================================================

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
=======================================================================

[oracle@alwarid-taj ~]$ rpm -q gcc-3.2
package gcc-3.2 is not installed
[oracle@alwarid-taj ~]$ echo Go Application ---- System Settings --- Add/Remove Applications
Go Application ---- System Settings --- Add/Remove Applications
On Add/Remove Application Windows Choose "Development" Tag and do check mark on "Development Tools" ---> Click on UPDATE button bottom on current page.
You have to give Installation CD's 3.for install requried packages.

[oracle@alwarid-taj /]$ rpm -q gcc
gcc-3.4.5-2


Checking Network Configuration requirements ...
Go Application ----> System Settings ----> NETWORK
On Network Windows CLICK ON edit tag.
set STATICALLY set IP ADDRESS
ADDRESS 192.168.100.252
SUBNET MASK 255.255.255.0
or
edit HOSTS tags on Main windows and give your HOSTNAME.

>>>ACTIVATE<<<< click on main page.
or
edit "/etc/hosts" FILE LIKE

[root@alwarid-taj ~]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
192.168.100.252 alwarid-taj
127.0.0.1 localhost.localdomain localhost

[root@alwarid-taj ~]# hostname
alwarid-taj
[root@alwarid-taj ~]# ping 192.168.100.252
PING 192.168.100.252 (192.168.100.252) 56(84) bytes of data.
64 bytes from 192.168.100.252: icmp_seq=0 ttl=64 time=0.085 ms
64 bytes from 192.168.100.252: icmp_seq=1 ttl=64 time=0.054 ms
64 bytes from 192.168.100.252: icmp_seq=2 ttl=64 time=0.053 ms

--- 192.168.100.252 ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2001ms
rtt min/avg/max/mdev = 0.053/0.064/0.085/0.014 ms, pipe 2
[root@alwarid-taj ~]#

Add swap space.
Assume "/dev/hda5" in the swap parition we want to add.
Must sure
1.hard drive cann't be in use.
2.swap space cann't be enabled.

suggestion.
1.unmount parition
2.disable swap parition.

[root@alwarid-taj dev]# parted /dev/hda5
GNU Parted 1.6.19
Copyright (C) 1998 - 2004 Free Software Foundation, Inc.
This program is free software, covered by the GNU General Public License.

This program is distributed in the hope that it will be useful, but WITHOUT ANY
WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A
PARTICULAR PURPOSE. See the GNU General Public License for more details.

Using /dev/hda5
(parted) print
Disk geometry for /dev/hda5: 0.000-19100.689 megabytes
Disk label type: loop
Minor Start End Filesystem Flags
1 0.000 19100.689 ext3
here you have to create swap parition if free space available.

[root@alwarid-taj ~]# grep SwapTotal /proc/meminfo
SwapTotal: 2152668 kB















If we are not run ABOVE scripts then you received below error.










During Installation you have to run two scirpt as ROOT USERS.
open new terminal ( right click on disktop and new terminal)










Recommended Postinstallation Tasks

Creating a Backup of the root.sh Script



When upgrade or configure new database. run UTLRP.SQL script.








Setting the NLS_LANG Environment Variable


Ususal We are getting during EXPORT operation EXP-00091 error.
because of LINUX use US7ASCII or Oracle Database running WE8ISO8859P1.

For that we should set NLS_LANG in user default profile.




[oracle@localhost ~]$ . ./.bash_profile



Generating the Client Static Library

2 comments:

Anonymous said...

can u give your mail id or phone number. I hve some problem in db creation.

Mohammed Taj said...

Hi,
star_taj@yahoo.com


regards
Taj