Key words

 

  • VMWARE workstation 9.
  • REDHAT 6.4
  • Oracle 12.1.0.1
  • ASM on shared disks.
  • 2 nodes grid infrastrucuture.

 

In my test environment, I have installed the 12.1.0.1 grid infrastructure on VMWARE 9 and REDHAT 6.4. After successful installation of grid infrastructure and database binaries when I try to create database with dbca, it shows me ORA-12547 TNS LOST CONTACT.

 

The installation is 2 node (IND120201, IND120202 ) grid infrastucture with ASM on shared disc. Used grid and oracle users for grid and database binaries respectively.

 

The main issue was that  libaio x86_64 rpms are installed , but libaio i686 rpms were missing. So install the libaio i686 rpms and  if the error still exists then uninstall and reinstall the Oracle binaries ( Grid Infrastructure or database ).


Below is the work around for the issue.

Work around :

 

I have searched forum and METALINK also, I got some below documents.

 

  1. 1. Doc ID 1069517.1it says to check the permissions on oracle binaries should be as  below. I found it ok.

 

   -rwsr-s--x 1 oracle asmadmin 184286251 Aug  9 16:25 /home/oracle/app/oracle/product/11.2/db/bin/oracle

 

  1. 2. Many docs suggested to check libaio-*. rpm.

 

I found that  libaio x86_64 rpms are installed , but libaio i686 rpms were missing. I installed them also.

 

But still getting the same error ORA-12547 TNS LOST .

 

Solution:

 

  1. 1. After the installation of libaio i686 rpms , i also   installed each package given in the document.

 

rpm -ivh --replacepkgs \

binutils-2.20.51.0.2-5.36.el6.x86_64.rpm \

compat-libcap1-1.10-1.x86_64.rpm        \

compat-libstdc++-33-3.2.3-69.el6.x86_64.rpm     \

compat-libstdc++-33-3.2.3-69.el6.i686.rpm       \

gcc-4.4.7-3.el6.x86_64.rpm      \

gcc-c++-4.4.7-3.el6.x86_64.rpm  \

glibc-2.12-1.107.el6.i686.rpm   \

glibc-2.12-1.107.el6.x86_64.rpm \

glibc-devel-2.12-1.107.el6.x86_64.rpm   \

glibc-devel-2.12-1.107.el6.i686.rpm     \

libgcc-4.4.7-3.el6.i686.rpm     \

libgcc-4.4.7-3.el6.x86_64.rpm   \

libstdc++-4.4.7-3.el6.x86_64.rpm        \

libstdc++-4.4.7-3.el6.i686.rpm  \

libstdc++-devel-4.4.7-3.el6.x86_64.rpm  \

libstdc++-devel-4.4.7-3.el6.i686.rpm    \

libaio-0.3.107-10.el6.x86_64.rpm        \

libaio-0.3.107-10.el6.i686.rpm  \

libaio-devel-0.3.107-10.el6.x86_64.rpm  \

libaio-devel-0.3.107-10.el6.i686.rpm    \

libXext-1.3.1-2.el6.x86_64.rpm  \

libXext-1.3.1-2.el6.i686.rpm    \

libXtst-1.2.1-2.el6.x86_64.rpm  \

libXtst-1.2.1-2.el6.i686.rpm    \

libX11-1.5.0-4.el6.x86_64.rpm   \

libX11-1.5.0-4.el6.i686.rpm     \

libXau-1.0.6-4.el6.x86_64.rpm   \

libXau-1.0.6-4.el6.i686.rpm     \

libxcb-1.8.1-1.el6.x86_64.rpm   \

libxcb-1.8.1-1.el6.i686.rpm     \

libXi-1.6.1-3.el6.x86_64.rpm    \

libXi-1.6.1-3.el6.i686.rpm      \

make-3.81-20.el6.x86_64.rpm     \

sysstat-9.0.4-20.el6.x86_64.rpm

 

  1. 2. After installation of the packages relink the grid binaries  with below document.

 

How To Relink The Oracle Grid Infrastructure Standalone (Restart) Installation Or Oracle Grid Infrastructure RAC/Cluster Installation (11.2 or 12c). (Doc ID 1536057.1)

 

Below is my workaround for relink binaries

 

Run below from root

 

[root@IND120101 db_1]# cd /u01/app/12.1.0/grid/crs/install

[root@IND120101 install]# perl rootcrs.pl -unlock

Using configuration parameter file: ./crsconfig_params

2014/04/20 10:18:29 CLSRSC-347: Successfully unlock /u01/app/12.1.0/grid

 

Run below from grid owner

 

[root@IND120101 install]# su - grid

[grid@IND120101 ~]$  cd /u01/app/12.1.0/grid/bin

 

[grid@IND120101 bin]$ . oraenv

ORACLE_SID = [grid] ? +ASM1

The Oracle base has been set to /u01/app/grid

[grid@IND120101 bin]$ relink all

writing relink log to: /u01/app/12.1.0/grid/install/relink.log

[grid@IND120101 bin]$ vi /u01/app/12.1.0/grid/install/relink.log

[grid@IND120101 bin]$ logout

 

Run below from root

[root@IND120101 install]# cd /u01/app/12.1.0/grid/rdbms/install

[root@IND120101 install]# ./rootadd_rdbms.sh

 

[root@IND120101 install]# cd /u01/app/12.1.0/grid/crs/install

[root@IND120101 install]# perl rootcrs.pl -patch

Using configuration parameter file: ./crsconfig_params

 

3. After relinking of grid binaries, I relinked the oracle database binaries as well.

[oracle@IND120101 ~]$  cd /u01/app/oracle/product/12.1.0/db_1/bin

[oracle@IND120101 bin]$ relink all

 

But dbca didn't work then also.

 

4. Then I uninstalled the oracle database binaries and reinstalled.

 

The dbca run well now ... Happiness after frustating 24 hrs.