Oracle / Grid permission and group owner will not work ORA-12547: TNS:lost contact (RAC environment)


root@bakuabsutdb1:/u02/app/11.2.0/grid > su - grid
Password:
Oracle Corporation      SunOS 5.11      11.3    September 2015
-bash-4.1$ bash
bash-4.1$ . .profile_asm
bash-4.1$ srvctl stop database -d AZTEST -o immediate
root@bakuabsutdb1:~# su - oracle
Oracle Corporation      SunOS 5.11      11.3    September 2015
You have mail.
bash-4.1$ . .profile_aztest
bash-4.1$ cd $ORACLE_HOME/bin
bash-4.1$ ls -ltr oracle
-rwsr-s--x   1 oracle   asmadmin 258286384 May 30 15:59 oracle
bash-4.1$ su - grid
Password:
Oracle Corporation      SunOS 5.11      11.3    September 2015
-bash-4.1$ . .profile_asm
bash-4.1$ cd $ORACLE_HOME/bin
bash-4.1$ ls -ltrh oracle
-rwsr-s--x   1 grid     oinstall    217M May 30 15:22 oracle
bash-4.1$ . .profile_aztest
bash-4.1$ cd $ORACLE_HOME/bin
bash-4.1$ ls -ltrh oracle
-rwsr-s--x   1 oracle   asmadmin    246M May 30 15:59 oracle
bash-4.1$ chgrp dba oracle
bash-4.1$ ls -lrt oracle
-rwxr-x--x   1 oracle   dba      258286384 May 30 15:59 oracle

bash-4.1$ su - abstest
Password:
Oracle Corporation      SunOS 5.11      11.3    September 2015
.profile
#################################################################~
### ABSTEST LOGIN ###################################################~
#################################################################~
root@bakuabsutdb1:/export/home2/abstest >
root@bakuabsutdb1:/export/home2/abstest >
root@bakuabsutdb1:/export/home2/abstest > sqlplus /
SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 16 16:34:26 2016
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
ERROR:
ORA-12547: TNS:lost contact

BOOOOMMMM!!!!! WHY? DON’t worry

Solution:
root@bakuabsutdb2:~# /u02/app/11.2.0/grid/bin/crsctl stat res -t
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4000: Command Status failed, or completed with errors.
root@bakuabsutdb2:~# cd /u02/app/11.2.0/grid/cr
crf/ crs/
root@bakuabsutdb2:~# cd /u02/app/11.2.0/grid/crs/install/
root@bakuabsutdb2:/u02/app/11.2.0/grid/crs/install# perl rootcrs.pl -unlock
Using configuration parameter file: ./crsconfig_params
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'bakuabsutdb2'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'bakuabsutdb2'
CRS-2673: Attempting to stop 'ora.crf' on 'bakuabsutdb2'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'bakuabsutdb2'
CRS-2677: Stop of 'ora.mdnsd' on 'bakuabsutdb2' succeeded
CRS-2677: Stop of 'ora.crf' on 'bakuabsutdb2' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'bakuabsutdb2'
CRS-2677: Stop of 'ora.drivers.acfs' on 'bakuabsutdb2' succeeded
CRS-2677: Stop of 'ora.gipcd' on 'bakuabsutdb2' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'bakuabsutdb2'
CRS-2677: Stop of 'ora.gpnpd' on 'bakuabsutdb2' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'bakuabsutdb2' has completed
CRS-4133: Oracle High Availability Services has been stopped.
Successfully unlock /u02/app/11.2.0/grid
root@bakuabsutdb2:/u02/app/11.2.0/grid/crs/install# /u02/app/11.2.0/grid/bin/crsctl check crs
CRS-4639: Could not contact Oracle High Availability Services
root@bakuabsutdb2:/u02/app/11.2.0/grid/crs/install# /u02/app/11.2.0/grid/bin/crsctl check has
CRS-4639: Could not contact Oracle High Availability Services
root@bakuabsutdb2:/u02/app/11.2.0/grid/crs/install# cd ../../rdbms/install/
root@bakuabsutdb2:/u02/app/11.2.0/grid/rdbms/install# ./rootadd_rdbms.sh
root@bakuabsutdb2:/u02/app/11.2.0/grid/rdbms/install# cd -
/u02/app/11.2.0/grid/crs/install
root@bakuabsutdb2:/u02/app/11.2.0/grid/crs/install# perl rootcrs.pl -patch
Using configuration parameter file: ./crsconfig_params
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.
root@bakuabsutdb2:/u02/app/11.2.0/grid/crs/install#

Note:  You have to do it on all nodes ..

We can check again:

root@bakuabsutdb1:/export/home2/abstest >
root@bakuabsutdb1:/export/home2/abstest >
root@bakuabsutdb1:/export/home2/abstest > sqlplus /
SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 16 22:39:13 2016
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL> exit         




Wowww this working fine  J

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: