ASM connection fails with ORA-12547: TNS:lost contact
(Doc ID 1942740.1)
Last updated on OCTOBER 25, 2024
Applies to:
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and laterOracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
1] Trying to migrate db to ASM for a single instance.
Getting the following errors when trying to do the RMAN backup:
$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Oct 2 13:15:40 2014
connected to target database: ORCL (DBID=1348193739)
RMAN> RUN
{
ALLOCATE CHANNEL dev1 DEVICE TYPE DISK;
ALLOCATE CHANNEL dev2 DEVICE TYPE DISK;
BACKUP AS COPY
INCREMENTAL LEVEL 0
DATABASE
FORMAT '+TS_DATA_01'
TAG 'ORA_ASM_MIGRATION';
}2> 3> 4> 5> 6> 7> 8> 9> 10>
using target database control file instead of recovery catalog
allocated channel: dev1
channel dev1: SID=2507 device type=DISK
allocated channel: dev2
channel dev2: SID=3008 device type=DISK
Starting backup at 02-OCT-14
channel dev1: starting datafile copy
input datafile file number=00081 name=/u01/oradata/ORCL/orcl01.dbf
channel dev2: starting datafile copy
input datafile file number=00082 name=/u01/oradata/ORCL/orcl02.dbf
RMAN-03009: failure of backup command on dev1 channel at 10/02/2014 13:16:27
ORA-19504: failed to create file "+DATA"
ORA-12547: TNS:lost contact
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact
channel dev1 disabled, job failed on it will be run on another channel
released channel: dev1
released channel: dev2
2] RDBMS alert.log shows the following similar error
Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/u01/grid/11.2.0.4/grid/bin/oracle)(ARGV0=oracle+ASM_o000_orcl)(ENVS='ORACLE_HOME=/u01/grid/11.2.0.4/grid,ORACLE_SID=+ASM')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=orcl.oracle.com)(USER=oracle))))
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.3.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
Time: 02-OCT-2014 13:16:27
Tracing not turned on.
Tns error struct:
ns main err code: 12547
TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517
TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/u01/grid/11.2.0.4/grid/bin/oracle)(ARGV0=oracle+ASM_o000_orcl)(ENVS='ORACLE_HOME=/u01/grid/11.2.0.4/grid,ORACLE_SID=+ASM')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 9 state 0x40 (12547)
ERROR: slave communication error with ASM
Thu Oct 02 13:16:28 2014
3] v$asm_disk view from RDBMS resturns zero row.
4] oracle binary permission is correct for GRID and RDBMS HOME
-rwsr-s--x 1 grid oinstall 210020671 Oct 1 11:30 /u01/grid/11.2.0.4/grid/bin/oracle
-rwsr-s--x 1 oracle asmadmin 232437411 May 3 2012 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |