Knowledge transfer to Wisdom: Installation

Showing posts with label Installation. Show all posts

Saturday, August 8, 2015

Interview on 07-Aug-2015

Interview question for 4-8 years experience held on 07-Aug-2015
1.Tell me about your self
2.Day to day activity in office as oracle dba
3. What is the flow of select statement?
4.What are the steps for oracle RAC installation?
5.What is the purpose of standby redolog files? why it is used?
6.Difference between 10g and 11g?
7.One table is accidentally dropped by user. You don't have flash back feature enabled. Database is production database and in terms of TB. How to restore using RMAN?
8.What is the steps of physical standby creation?
9. What are difference between exp and expdp?
10.What is voting disk and ocr?
11. Why odd numbers of voting disks are used?
12.How to trouble shoot when one node is down in RAC? What are the possible reasons?
13. In expdp what method used to take backup byte or block?
14. What are the advantages of datapump over tradition export ?
15.Suppose a user is connected to the database. and mean the time listner get down. What would happen to that user? When the user will give a statement will that process?
16.User complained one query is not performing well ? what action will be taken?
17.one index is already present in a column. Now we create primary key on that column. will new index will be created?
18. One big transaction was going on and client machine got rebooted. At that time what would happen to that transaction. If it roll back then which process will do this?
19. How to recover undo tablespace?
20 How to recover if redolog files got deleted?
21.What are the steps to create asm instance?
22. What is SCAN listner?
23.If one archive log file has not been applied and it got deleted. How to make standby database sync with primary database?
24.Explain different background process of RAC?
25. Explain background process for ASM?

Monday, February 24, 2014

Patch set reference

Database	Patch Number	Description
11.2.0.3.2	13696216	DATABASE PATCH SET UPDATE 11.2.0.3.2 (INCLUDES CPU APR2012)
11.2.0.3.1	13343438	DATABASE PATCH SET UPDATE 11.2.0.3.1 (INCLUDES CPU JAN2012)
11.2.0.3	10404530	11.2.0.3.0 PATCH SET FOR ORACLE DATABASE SERVER

11.2.0.2.6	13696224	DATABASE PATCH SET UPDATE 11.2.0.2.6 (INCLUDES CPU APR2012)
11.2.0.2.5	13343424	DATABASE PATCH SET UPDATE 11.2.0.2.5 (INCLUDES CPU JAN2012)
11.2.0.2.4	12827726	DATABASE PSU 11.2.0.2.4 (INCLUDES CPUOCT2011)
11.2.0.2.3	12419331	DATABASE PSU 11.2.0.2.3 (INCLUDES CPUJUL2011)
11.2.0.2.2	11724916	DATABASE PSU 11.2.0.2.2 (INCLUDES CPUAPR2011)
11.2.0.2.1	10248523	DATABASE PSU 11.2.0.2.1
11.2.0.2	10098816	11.2.0.2.0 PATCH SET FOR ORACLE DATABASE SERVER

11.2.0.1.6	12419378	DATABASE PSU 11.2.0.1.6 (INCLUDES CPUJUL2011)
11.2.0.1.5	11724930	DATABASE PSU 11.2.0.1.5 (INCLUDES CPUAPR2011)
11.2.0.1.4	10248516	DATABASE PSU 11.2.0.1.4 (INCLUDES CPUJAN2011)
11.2.0.1.3	9952216	DATABASE PSU 11.2.0.1.3 (INCLUDES CPUOCT2010)
11.2.0.1.2	9654983	DATABASE PSU 11.2.0.1.2 (INCLUDES CPUJUL2010)
11.2.0.1.1	9352237	DATABASE PSU 11.2.0.1.1

11.1.0.7.11	13621679	DATABASE PATCH SET UPDATE 11.1.0.7.11 (INCLUDES CPU APR2012)
11.1.0.7.10	13343461	DATABASE PATCH SET UPDATE 11.1.0.7.10 (INCLUDES CPU JAN2012)
11.1.0.7.9	12827740	DATABASE PSU 11.1.0.7.9 (INCLUDES CPUOCT2011)
11.1.0.7.8	12419384	DATABASE PSU 11.1.0.7.8 (INCLUDES CPUJUL2011)
11.1.0.7.7	11724936	DATABASE PSU 11.1.0.7.7 (INCLUDES CPUAPR2011)
11.1.0.7.6	10248531	DATABASE PSU 11.1.0.7.6 (INCLUDES CPUJAN2011)
11.1.0.7.5	9952228	DATABASE PSU 11.1.0.7.5 (INCLUDES CPUOCT2010)
11.1.0.7.4	9654987	DATABASE PSU 11.1.0.7.4 (INCLUDES CPUJUL2010)
11.1.0.7.3	9352179	DATABASE PSU 11.1.0.7.3 (INCLUDES CPUAPR2010)
11.1.0.7.2	9209238	DATABASE PSU 11.1.0.7.2 (INCLUDES CPUJAN2010)
11.1.0.7.1	8833297	DATABASE PSU 11.1.0.7.1 (INCLUDES CPUOCT2009)
11.1.0.7	6890831	11.1.0.7.0 PATCH SET FOR ORACLE DATABASE SERVER

10.2.0.5.7	13632743 [*]	DATABASE PATCH SET UPDATE 10.2.0.5.7 (INCLUDES CPU APR2012)
10.2.0.5.6	13343471 [*]	DATABASE PATCH SET UPDATE 10.2.0.5.6 (INCLUDES CPU JAN2012)
10.2.0.5.5	12827745	DATABASE PSU 10.2.0.5.5 (INCLUDES CPUOCT2011)
10.2.0.5.4	12419392	DATABASE PSU 10.2.0.5.4 (INCLUDES CPUJUL2011)
10.2.0.5.3	11724962	DATABASE PSU 10.2.0.5.3 (INCLUDES CPUAPR2011)
10.2.0.5.2	10248542	DATABASE PSU 10.2.0.5.2 (INCLUDES CPUJAN2011)
10.2.0.5.1	9952230	DATABASE PSU 10.2.0.5.1 (INCLUDES CPUOCT2010)
10.2.0.5	8202632	10.2.0.5.0 PATCH SET FOR ORACLE DATABASE SERVER

10.2.0.4.11	12879929 [*]	DATABASE PATCH SET UPDATE 10.2.0.4.11 (PRE-REQ 10.2.0.4.4\|INCLUDES CPUJAN2012)
10.2.0.4.10	12827778	DATABASE PSU 10.2.0.4.10 (REQUIRES PRE-REQUISITE 10.2.0.4.4\|INCLUDES CPUOCT2011)
10.2.0.4.9	12419397	DATABASE PSU 10.2.0.4.9 (REQUIRES PRE-REQUISITE 10.2.0.4.4\|INCLUDES CPUJUL2011)
10.2.0.4.8	11724977	DATABASE PSU 10.2.0.4.8 (REQUIRES PRE-REQUISITE 10.2.0.4.4\|INCLUDES CPUAPR2011)
10.2.0.4.7	10248636	DATABASE PSU 10.2.0.4.7 (REQUIRES PRE-REQUISITE 10.2.0.4.4\|INCLUDES CPUJAN2011)
10.2.0.4.6	9952234	DATABASE PSU 10.2.0.4.6 (REQUIRES PRE-REQUISITE 10.2.0.4.4\|INCLUDES CPUOCT2010)
10.2.0.4.5	9654991	DATABASE PSU 10.2.0.4.5 (REQUIRES PRE-REQUISITE 10.2.0.4.4\|INCLUDES CPUJUL2010) [overlay PSU]
10.2.0.4.4	9352164	DATABASE PSU 10.2.0.4.4 (INCLUDES CPUAPR2010)
10.2.0.4.3	9119284	DATABASE PSU 10.2.0.4.3 (INCLUDES CPUJAN2010)
10.2.0.4.2	8833280	DATABASE PSU 10.2.0.4.2 (INCLUDES CPUOCT2009)
10.2.0.4.1	8576156	DATABASE PSU 10.2.0.4.1 (INCLUDES CPUJUL2009)
10.2.0.4	6810189	10.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER
10.2.0.3	5337014	10.2.0.3 PATCH SET FOR ORACLE DATABASE SERVER
10.2.0.2	4547817	10.2.0.2 PATCH SET FOR ORACLE DATABASE SERVER

Tuesday, September 13, 2011

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.

Tuesday, August 9, 2011

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

Tuesday, July 26, 2011

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

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.

Knowledge transfer to Wisdom

Labels