ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []

Solution of the Error
Step 1: Check permission on /etc/hosts

$ ls -l /etc/hosts
-rw-r--r--  1 root root 153 Nov 24  2007 /etc/hosts

Note that you need read permission of all users.

Step 2: Check the contents of /etc/hosts
Open the contents of /etc/hosts and check the contents inside it.
$ less /etc/hosts
Note that the contents of this files follow following format.

IP Address      fully qualified hostname    simple or short hostname     Alias

A simple example,

$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
192.168.1.4               dhcppc2 localhost.localdomain localhost

Step 3: Check the hostname and make sure you can ping your hostname.
$ hostname
dhcppc2

$ ping database
PING dhcppc2 (192.168.1.4) 56(84) bytes of data.
64 bytes from dhcppc2 (192.168.1.4): icmp_seq=0 ttl=64 time=0.038 ms
64 bytes from dhcppc2 (192.168.1.4): icmp_seq=1 ttl=64 time=0.000 ms
64 bytes from dhcppc2 (192.168.1.4): icmp_seq=2 ttl=64 time=0.038 ms
64 bytes from dhcppc2 (192.168.1.4): icmp_seq=3 ttl=64 time=0.000 ms
64 bytes from dhcppc2 (192.168.1.4): icmp_seq=4 ttl=64 time=0.041 ms


If you get the following message,
$ ping database
ping: unknown host database

then possibly you will hit above bug.
And you need to modify /etc/hosts files. In the alias section you can give the name of your machine name. If your machine name is "dhcppc2" you can give /etc/hosts entry as,

192.168.1.4               dhcppc2 localhost.localdomain localhost

And then ping database again. Make sure you are able to ping your host.

Step 4: Diagnosis DNS problem if you have DNS setup
If you have DNS setup, ping is not a tool to diagnose DNS problem. A better tool to use is nslookup, dnsquery, or dig.

$nslookup www.google.com
The forward and reverse lookup should succeed.

Step 5: Check nsswitch.conf

$ cat /etc/nsswitch.conf
hosts:      files dns

Make sure host lookup is also done through the /etc/hosts file and not just dns. The keyword files should come before dns.

Step 6: Check resolv.conf

$ cat /etc/resolv.conf

; generated by /sbin/dhclient-script
nameserver 125.22.47.125
nameserver 202.56.250.5

Make sure nameserver with DNS name is added there.

libXp.so.6: cannot open shared object file: No such file or directory

Error while Installing Oracle 10g on RHEL(2.618-8.EL5)linux


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.

Error
Preparing to launch Oracle Universal Installer from
/tmp/OraInstall2011-08-09_10-42-02PM. Please wait ...[oracle@localhost
database]$ Exception in thread "main" java.lang.UnsatisfiedLinkError:
/tmp/OraInstall2011-08-09_10-42-02PM/jre/1.4.2/lib/i386/libawt.so:
libXp.so.6: cannot open shared object file: No such file or directory
       at java.lang.ClassLoader$NativeLibrary.load(Native Method)
       at java.lang.ClassLoader.loadLibrary0(Unknown Source)
       at java.lang.ClassLoader.loadLibrary(Unknown Source)
       at java.lang.Runtime.loadLibrary0(Unknown Source)
       at java.lang.System.loadLibrary(Unknown Source)
       at sun.security.action.LoadLibraryAction.run(Unknown Source)
       at java.security.AccessController.doPrivileged(Native Method)
       at sun.awt.NativeLibLoader.loadLibraries(Unknown Source)
       at sun.awt.DebugHelper.(Unknown Source)
       at java.awt.Component.(Unknown Source)




Solution:-
Install libXp-1.0.0-8.i386.rpm package

Oracle 10g version (10.2.0.1.0) Installation Guide on RHEL-4(Kernel-2.6.69-EL

Oracle 10g version (10.2.0.1.0) Installation Guide on RHEL-4(Kernel-2.6.69-EL

 Hardware and software check:-

Note:-
This guide is assumed that all pre-requisite  of hardware and software is done.

Check the space availability and ensure that your SwapTotal should be twice or 1+1/2 of MemTotal Value.

[root@dhcppc3 ~]# cat /proc/meminfo | grep Total

1) Host Entry:-

Make an hostentry if it is not present.

2) Kernel Parameter Setting.

Cat /etc/sysctl.conf

Vi /etc/sysctl.conf

net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
kernel.shmmax = 2147483648
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.wmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_max = 262144

[root@dhcppc3 ~]# sysctl -p

[root@dhcppc3 ~]#vi /etc/security/limits.conf

  oracle soft nproc 2047

 oracle hard nproc 16384

 oracle soft nofile 1024

 oracle hard nofile 65536

[root@dhcppc3 ~]# vi /etc/pam.d/login

session required /lib/security/pam_limits.so

3) Package Installation:-

[root@dhcppc3 oracle10g_rhel4_2.6.9-67.EL]# ls -ltr

-rwxr-xr-x  1 root root 3172244 Feb  2  2007 compat-gcc-32-3.2.3-47.3.i386.rpm

-rwxr-xr-x  1 root root 3863472 Feb  2  2007 compat-gcc-32-c++-3.2.3-47.3.i386.rpm

-rwxr-xr-x  1 root root  231823 Feb  2  2007 compat-libstdc++-33-3.2.3-47.3.i386.rpm

-rwxr-xr-x  1 root root   18745 Feb  2  2007 libaio-0.3.105-2.i386.rpm

-rwxr-xr-x  1 root root  118050 Oct 15  2007 sysstat-5.0.5-16.rhel4.i386.rpm

4) User and group Addition:-

[root@dhcppc3 ~]# groupdel dba

[root@dhcppc3 ~]# groupdel oinstall

[root@dhcppc3 ~]# useradd -g oinstall -G dba oracle

[root@dhcppc3 ~]# passwd oracle

Changing password for user oracle.

New UNIX password:

BAD PASSWORD: it is based on a dictionary word

Retype new UNIX password:

passwd: all authentication tokens updated successfully.

5) Create the software Directory and Grant permission:-

6) Set the .bash_profile for Oracle User

NOTE:-

Make sure /tmp and $ORACLE_HOME  directory should contain at least 108MB,1.5GB  of spaces.

# Oracle Settings

TMP=/tmp; export TMP

TMPDIR=$TMP; export TMPDIR

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/10.1.0/db_1; export ORACLE_HOME

ORACLE_SID=orcl; 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

7) Make Oracle 10g backward compatibility by entering the relase num to redhat-3 in /etc/redhat-release

8) Make SELINUX value as disable if it is enable.

9) Make below entry to allow all connection if your client and user are in the same machine.

[root@dhcppc3 oracle]# xhost +

access control disabled, clients can connect from any host

[root@dhcppc3 oracle]#

10).Execute the Installer:-

./runInstaller

11)Oracle Installation page will be pop-up.

The rest of the steps are GUI based. Hence I have not provided.

oracle service in Windows machine

The syntax to create oracle services in windows machine.
oradim -new -sid {test9}  -intpwd {oracle}  -startmode auto

To check the services running or not.
Start->run->services.msc
The service name would be like OracleServicetest10

Issue of DISPLAY setting in Oracle Installation

Errors got:-

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-05-25_02-29-56AM. Please wait ...[oracle@localhost database]$ Exception in thread "main" java.lang.InternalError: Can't connect to X11 window server using '192.168.159.130: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)

OR

[root@localhost bin]# xhost + 192.168.159.130

xhost:  unable to open display "192.168.159.130:0.0"

Solution:-

While working on the graphical console, then you must set DISPLAY as follows:

# export DISPLAY = xx.xx.xx.xx:0.0

or just for console based where OS supported it
login as root

[root@localhost database]# xhost +
access control disabled, clients can connect from any host // This will allow any one can connect
[root@localhost database]#

Now login as oracle user

# export DISPLAY = :0.0

Installation steps of Oracle on Unix,Linux and Solaris

General instruction of Installation and configuration of oracle software in Unix, Linux and Solaris

1)download and unzip the software

2)hostname configuration
vi /etc/hosts



3)Kernel setup

  3.1 set the kernel parameter
     # vi /etc/sysctl.conf
     -- enter the shmmin,shmmax,shmmni,semmns,semmsl,semops
     -- Make the parameter permanent
     # /sbin/sysctl -p

  3.2 set the secuirty lmits of the file
     # vi /etc/security/limits.conf
hard noproc
soft noproc
hard nofile
soft nofile
   3.3 set the login parameters if it is not present
      # vi /etc/pam.d/login
      session required pam_limits.so
   3.4 Sometime selinux disable required
vi /etc/seslinux/config
        SELINUX=disabled

4)Configuration setup
   4.1 install the required packages
       rpm -uvh  
some common package name like openmotife,gcc,compat,setsearch
   4.2 create user and group. Generally the username is oracle and group are dba and oinstall which are primary and secondary group.
        #groupadd dba
#groupadd oinstall
#useradd -g oinstall -G dba oracle
#passwd oracle

   4.3 Create the directory and assign the user  to the directory of software installation
#mkdir -p /u01/app/oracle/product/10.1.0/db_1
#chown -R oracle.dba /u01/oracle

   4.4 In some release of linux you have to set redhat release number for compatibilty
       #vi /etc/redhat-release
redhat-3

   4.5 Make xhost entry
#xhost +


   4.4 set the .bash_profile. set the different variables which are required for oracle installation.
        #vi .bash_profile
ORACLE_SID, ORACLE_TERM,ORACLE_BASE,ORACLE_HOME,PATH,LIBARY_PATH,CLASS_PATH
        Set the shell on which you are going to work as oracle user.

 

5) Installation steps
   5.1 set the display parameter
       DISPLAY=:0.0; export DISPLAY

   5.2 Login as oracle user and envoke the Oracle universal installer
$.runInstaller
6) post installation steps
   6.1 give the directory where the software needs to be install
   6.2 Login as root and run the root.sh so that all the required permission will be transfer to oracle user for the drive.

Next are generic steps which will be by just click of button and depends upon your requirement.
     

http://st-curriculum.oracle.com/obe/db/10g/r2/2day_dba/install/install.htm

 

Linux Kernel Parameters for oracle

SHMMAX = The maximum size(in bytes) of a single shared memory   segment.

SHMMIN = The minimum size(in bytes) of a single shared memory  segment.

SHMMNI = The number of shared memory identifiers.

SHMSEG = The maximum number of shared memory segments that can  be attached by a process.

SEMMNS = The number of semaphores in the system.

SEMMNI = The number of semaphore set identifiers in the system;  determines the number of semaphore sets that can be  created at any one time.

SEMMSL = The maximum number of semaphores that can be in one   semaphore set. It should be same size as maximum number   of Oracle processes
Please refer to below sites for more information.
http://www.idevelopment.info/data/Oracle/DBA_tips/Linux/LINUX_8.shtml
http://www.orafaq.com/node/8
http://dataexpedition.com/~sbnoble/Tips/memory.html

Mounting Pendrive

How to mount a pendrive or CD-ROM in Linux?

Step:-1
First check what are the file system in the Linux by below command.Always last file system would be mount.You have to make sure which drive needs to be mount.
root@localhost# fdisk -l

step2:-
create a directory in the linux to which you will mount it.
root@localhost# mkdir /mnt/pendrive

Step3:-
root@localhost#mount -t vfat {/dev/sdc1} /mnt/pendrive

You will find a icon will come to your desktop.The CD rom would be same as pendrive.

RAC installation

http://blogs.oracle.com/AlejandroVargas/gems/StepbyStepRAConLinux3.pdf