12c
Hi ALL,
I have listener.ora and tnsnames.ora below:
# listener.ora Network Configuration File: /u01/orabrdg1/BRDG1/12.1.0/network/admin/listener.ora
# Generated by Oracle configuration tools.
BRDG1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = bridge.lccgroup.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_BRDG1 =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME= /u01/orabrdg1/BRDG1/12.1.0)
(SID_NAME = BRDG1.lccgroup.com)
)
)
ADR_BASE_BRDG1 = /u01/orabrdg1/BRDG1
# tnsnames.ora
BRDG1 =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=bridge.lccgroup.com)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=BRDG1)
(INSTANCE_NAME=BRDG1)
)
)
But if I run > tnsping BRDG1, I got error below:
TNS Ping Utility for Linux: Version 12.2.0.1.0 - Production on 13-JAN-2020 09:10:32
Copyright (c) 1997, 2016, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=bridge.lccgroup.com)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=BRDG1) (INSTANCE_NAME=BRDG1)))
TNS-12538: TNS:no such protocol adapter
Please help....
Kind regards,
jc