Wednesday 26 August 2015

Oracle client Installation.

INSTALLATION OF ORACLE 11G CLIENT FOR RAC
Installing Linux Operating system
========================
1. Press Enter
2. Move to skip-enter

3. Click on Next Button
\
4. Select Language then Next button
5. Click the keyboard language--Next

6. Click on Skip entering Installation Number
7. Click on Skip Button
9. Click on Yes Button
10.  Select create custom layout from drop down list and click on next button
11. make the following directory and click on Next button
12. Click on Next button
13. Click on Next buton

14. select the time zone and click on next button
15. Enter the root password

16. Click on Next button.

17. Click on Next button

18.> Installation has been started.

19. Click on Reboot button
20. Click on  Forward.

21. Accept the license and click on Next button.

22. Disabled the firewall and click on Next button


23. Disabled the setting and click on forward button.
25.> Click on next button
26.> Set date and Time

27.> Click on No, I prefer to register at a later time
28. click on forward button
29. Click on foward button
click on continue button
30. click on finish button

31. Configure tools for copy paste  between desktop to vmware and vmware to desktop.
click on VM--> Install vmware tools-->Extract the Vmarware tool
32. Make the IP configuration.
$ neat
33. First click on Deactivate button then click on EDIT button and enter the IP address  as mentioned below.
34. click on PROBE button and then apply
35. Now activite this by click on Activate button and  click on file -->save

36.  click on DNS Tab and enter the hostname. Primary DBN and DNS search path
37. click on Hosts tab , make the following entries and then file-->save
38. Check all the connectivity  by nslookup and ping method between Client host to server hostname
40. Reboot the host.
41. Now sync the time of Client with DNS server .-- Optional if you configure DNS server
NTP settings

In  /etc/ntp.conf add the following line
vi /etc/ntp.conf
#server ....
#server ....
#server ....
   server 192.168.1.15   //DNS IP

      
vi /etc/sysconfig/ntpd
 
  Replace Options="-u........."

   with  Options="-x  -u......."


42. Run the following command to sync client host time with DNS server.
$ checkconfig ntpd on
$ service ntpd restart

Installation of Oracle client
1. Create Group and User
[root@client /]# groupadd oinstall
[root@client /]# groupadd dba
[root@client /]# useradd -g oinstall -G dba oracle
[root@client /]# 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.
2. Create Directory
[root@client /]# mkdir -p /u01/app/oracle/
[root@client /]# chown -R oracle:oinstall /u01/app/oracle
[root@client /]#
3.Install these package
[root@client ~]# yum install binutils-2.* compat-libstdc++-33* elfutils-libelf-0.* elfutils-libelf-devel-* gcc-4.* gcc-c++-4.* glibc-2.* glibc-common-2.* glibc-devel-2.* glibc-headers-2.* ksh-2* libaio-0.* libaio-devel-0.* libgcc-4.* libstdc++-4.* libstdc++-devel-4.* make-3.* sysstat-7.* unixODBC-2.* unixODBC-devel-2.*
Loaded plugins: katello, product-id, security, subscription-manager
Updating certificate-based repositories.
Unable to read consumer identity
Setting up Install Process
Package binutils-2.17.50.0.6-20.el5.i386 already installed and latest version
Package compat-libstdc++-33-3.2.3-61.i386 already installed and latest version
Package elfutils-libelf-0.137-3.el5.i386 already installed and latest version
Package glibc-2.5-81.i686 already installed and latest version
Package glibc-common-2.5-81.i386 already installed and latest version
Package ksh-20100621-5.el5.i386 already installed and latest version
Package libaio-0.3.106-5.i386 already installed and latest version
Package libgcc-4.1.2-52.el5.i386 already installed and latest version
Package libstdc++-4.1.2-52.el5.i386 already installed and latest version
Package 1:make-3.81-3.el5.i386 already installed and latest version
Resolving Dependencies
--> Running transaction check
---> Package elfutils-libelf-devel.i386 0:0.137-3.el5 set to be updated
---> Package elfutils-libelf-devel-static.i386 0:0.137-3.el5 set to be updated
---> Package gcc.i386 0:4.1.2-52.el5 set to be updated
---> Package gcc-c++.i386 0:4.1.2-52.el5 set to be updated
---> Package glibc-devel.i386 0:2.5-81 set to be updated
---> Package glibc-headers.i386 0:2.5-81 set to be updated
--> Processing Dependency: kernel-headers >= 2.2.1 for package: glibc-headers
--> Processing Dependency: kernel-headers for package: glibc-headers
---> Package libaio-devel.i386 0:0.3.106-5 set to be updated
---> Package libstdc++-devel.i386 0:4.1.2-52.el5 set to be updated
Server/filelists                                                                                                                                 | 2.4 MB     00:00     
---> Package sysstat.i386 0:7.0.2-11.el5 set to be updated
---> Package unixODBC.i386 0:2.2.11-10.el5 set to be updated
--> Processing Dependency: unixODBC-libs = 2.2.11-10.el5 for package: unixODBC
--> Processing Dependency: libodbcinst.so.1 for package: unixODBC
--> Processing Dependency: libodbc.so.1 for package: unixODBC
---> Package unixODBC-devel.i386 0:2.2.11-10.el5 set to be updated
--> Running transaction check
---> Package kernel-headers.i386 0:2.6.18-308.el5 set to be updated
---> Package unixODBC-libs.i386 0:2.2.11-10.el5 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================================================================
Package                                                Arch                           Version                                   Repository                        Size
========================================================================================================================================================================
Installing:
elfutils-libelf-devel                                  i386                           0.137-3.el5                               Server                            25 k
elfutils-libelf-devel-static                           i386                           0.137-3.el5                               Server                            66 k
gcc                                                    i386                           4.1.2-52.el5                              Server                           5.2 M
gcc-c++                                                i386                           4.1.2-52.el5                              Server                           3.4 M
glibc-devel                                            i386                           2.5-81                                    Server                           2.0 M
glibc-headers                                          i386                           2.5-81                                    Server                           606 k
libaio-devel                                           i386                           0.3.106-5                                 Server                            12 k
libstdc++-devel                                        i386                           4.1.2-52.el5                              Server                           2.8 M
sysstat                                                i386                           7.0.2-11.el5                              Server                           182 k
unixODBC                                               i386                           2.2.11-10.el5                             Server                           290 k
unixODBC-devel                                         i386                           2.2.11-10.el5                             Server                           739 k
Installing for dependencies:
kernel-headers                                         i386                           2.6.18-308.el5                            Server                           1.3 M
unixODBC-libs                                          i386                           2.2.11-10.el5                             Server                           551 k

Transaction Summary
========================================================================================================================================================================
Install      13 Package(s)
Upgrade       0 Package(s)

Total download size: 17 M
Is this ok [y/N]: y
Downloading Packages:
(1/13): libstdc++-devel-4.1.2-52.el5.i386.rpm                                                                                                    | 2.8 MB     00:00     
(2/13): kernel-headers-2.6.18-308.el5.i386.rpm                                                                                                   | 1.3 MB     00:00     
(3/13): sysstat-7.0.2-11.el5.i386.rpm                                                                                                            | 182 kB     00:00     
(4/13): gcc-4.1.2-52.el5.i386.rpm                                                                                                                | 5.2 MB     00:00     
(5/13): elfutils-libelf-devel-static-0.137-3.el5.i386.rpm                                                                                        |  66 kB     00:00     
(6/13): unixODBC-libs-2.2.11-10.el5.i386.rpm                                                                                                     | 551 kB     00:00     
(7/13): unixODBC-devel-2.2.11-10.el5.i386.rpm                                                                                                    | 739 kB     00:00     
(8/13): elfutils-libelf-devel-0.137-3.el5.i386.rpm                                                                                               |  25 kB     00:00     
(9/13): gcc-c++-4.1.2-52.el5.i386.rpm                                                                                                            | 3.4 MB     00:00     
(10/13): glibc-devel-2.5-81.i386.rpm                                                                                                             | 2.0 MB     00:00     
(11/13): glibc-headers-2.5-81.i386.rpm                                                                                                           | 606 kB     00:00     
(12/13): unixODBC-2.2.11-10.el5.i386.rpm                                                                                                         | 290 kB     00:00     
(13/13): libaio-devel-0.3.106-5.i386.rpm                                                                                                         |  12 kB     00:00     
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                   4.0 MB/s |  17 MB     00:04     
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
 Installing     : kernel-headers                                                                                                                                  1/13
 Installing     : glibc-headers                                                                                                                                   2/13
 Installing     : glibc-devel                                                                                                                                     3/13
 Installing     : libstdc++-devel                                                                                                                                 4/13
 Installing     : unixODBC-libs                                                                                                                                   5/13
 Installing     : unixODBC                                                                                                                                        6/13
 Installing     : gcc                                                                                                                                             7/13
 Installing     : gcc-c++                                                                                                                                         8/13
 Installing     : sysstat                                                                                                                                         9/13
 Installing     : unixODBC-devel                                                                                                                                 10/13
 Installing     : libaio-devel                                                                                                                                   11/13
 Installing     : elfutils-libelf-devel                                                                                                                          12/13
 Installing     : elfutils-libelf-devel-static                                                                                                                   13/13
Server/productid                                                                                                                                 | 1.7 kB     00:00     
Installed products updated.

Installed:
 elfutils-libelf-devel.i386 0:0.137-3.el5  elfutils-libelf-devel-static.i386 0:0.137-3.el5  gcc.i386 0:4.1.2-52.el5              gcc-c++.i386 0:4.1.2-52.el5         
 glibc-devel.i386 0:2.5-81                 glibc-headers.i386 0:2.5-81                      libaio-devel.i386 0:0.3.106-5        libstdc++-devel.i386 0:4.1.2-52.el5
 sysstat.i386 0:7.0.2-11.el5               unixODBC.i386 0:2.2.11-10.el5                    unixODBC-devel.i386 0:2.2.11-10.el5

Dependency Installed:
 kernel-headers.i386 0:2.6.18-308.el5                                                unixODBC-libs.i386 0:2.2.11-10.el5                                               

Complete!

4. Copy and paste client 11gR2 software in Linux Machine and Unzip that software.
5.  start ./runinstallar
5. Click on Adminstor redio button

6.> Click on SKIP SOFTWARE UPDATE redio button
7. Select the language and click on next button

8.>  check the location and path of oracle base  and oracle home and click on next button
9. check the Inventory location

10. we can ignore the SWAP size if there is not much difference between expected value and actual value then next button
10.> click on install button
12. run root.sh script.
[root@client ~]# /u01/app/oracle/product/11.2.0/client_1/root.sh
Performing root user operation for Oracle 11g

The following environment variables are set as:
   ORACLE_OWNER= oracle
   ORACLE_HOME=  /u01/app/oracle/product/11.2.0/client_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
  Copying dbhome to /usr/local/bin ...
  Copying oraenv to /usr/local/bin ...
  Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.

13. Installation of client completed. click on close button.
14. Configure SCAN LISTENER NAME in TNSNAMES.ora file
[oracle@client admin]$ cat tnsnames.ora
orcl =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan.example.com)(PORT = 1521))
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = orcl)
   )
 )