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


root@anaruatdb1:/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 ANARTEST -o immediate




root@anaruatdb1:~# su - oracle




Oracle Corporation      SunOS 5.11      11.3    September 2015




You have mail.




bash-4.1$ . .profile_ANARTEST




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_ANARTEST




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 - ANARTEST




Password:




Oracle Corporation      SunOS 5.11      11.3    September 2015




.profile




#################################################################~




### ANARTEST LOGIN ###################################################~




#################################################################~




root@anaruatdb1:/export/home2/ANARTEST >




root@anaruatdb1:/export/home2/ANARTEST >




root@anaruatdb1:/export/home2/ANARTEST > 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@anaruatdb2:~# /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@anaruatdb2:~# cd /u02/app/11.2.0/grid/cr




crf/ crs/




root@anaruatdb2:~# cd /u02/app/11.2.0/grid/crs/install/




root@anaruatdb2:/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 'anaruatdb2'




CRS-2673: Attempting to stop 'ora.mdnsd' on 'anaruatdb2'




CRS-2673: Attempting to stop 'ora.crf' on 'anaruatdb2'




CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'anaruatdb2'




CRS-2677: Stop of 'ora.mdnsd' on 'anaruatdb2' succeeded




CRS-2677: Stop of 'ora.crf' on 'anaruatdb2' succeeded




CRS-2673: Attempting to stop 'ora.gipcd' on 'anaruatdb2'




CRS-2677: Stop of 'ora.drivers.acfs' on 'anaruatdb2' succeeded




CRS-2677: Stop of 'ora.gipcd' on 'anaruatdb2' succeeded




CRS-2673: Attempting to stop 'ora.gpnpd' on 'anaruatdb2'




CRS-2677: Stop of 'ora.gpnpd' on 'anaruatdb2' succeeded




CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'anaruatdb2' has completed




CRS-4133: Oracle High Availability Services has been stopped.




Successfully unlock /u02/app/11.2.0/grid




root@anaruatdb2:/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@anaruatdb2:/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@anaruatdb2:/u02/app/11.2.0/grid/crs/install# cd ../../rdbms/install/




root@anaruatdb2:/u02/app/11.2.0/grid/rdbms/install# ./rootadd_rdbms.sh




root@anaruatdb2:/u02/app/11.2.0/grid/rdbms/install# cd -




/u02/app/11.2.0/grid/crs/install




root@anaruatdb2:/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@anaruatdb2:/u02/app/11.2.0/grid/crs/install#













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













We can check again:













root@anaruatdb1:/export/home2/ANARTEST >




root@anaruatdb1:/export/home2/ANARTEST >




root@anaruatdb1:/export/home2/ANARTEST > 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
Advertisements

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: