ORA-12170: TNS:Connect timeout occurred [message #681727] |
Fri, 21 August 2020 00:27 |
dirish
Messages: 232 Registered: November 2006
|
Senior Member |
|
|
Hello,
I have to duplicate a database for dataguard.
primary and dataguard VMs can tnsping both primary and standby.
Standby Server>rman TARGET sys/password@primarydb
Recovery Manager: Release 19.0.0.0.0 - Production on Fri Aug 21 09:20:52 2020
Version 19.7.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =========ERROR MESSAGE STACK FOLLOWS=========
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12170: TNS:Connect timeout occurred
|
|
|
|
Re: ORA-12170: TNS:Connect timeout occurred [message #681729 is a reply to message #681728] |
Fri, 21 August 2020 00:54 |
dirish
Messages: 232 Registered: November 2006
|
Senior Member |
|
|
my apologies
Standby Server>rman TARGET sys/password@primarydb
Recovery Manager: Release 19.0.0.0.0 - Production on Fri Aug 21 09:20:52 2020
Version 19.7.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =========
ERROR MESSAGE STACK FOLLOWS
=========
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12170: TNS:Connect timeout occurred
|
|
|
|
Re: ORA-12170: TNS:Connect timeout occurred [message #681731 is a reply to message #681729] |
Fri, 21 August 2020 00:58 |
dirish
Messages: 232 Registered: November 2006
|
Senior Member |
|
|
Standby Server>tnsping primarydb
TNS Ping Utility for Solaris: Version 19.0.0.0.0 - Production on 21-AUG-2020 09:55:55
Copyright (c) 1997, 2019, Oracle. All rights reserved.
Used parameter files:
/u01/app/ora19c/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = primarydb)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = primarydb)))
OK (0 msec)
|
|
|
Re: ORA-12170: TNS:Connect timeout occurred [message #681732 is a reply to message #681731] |
Fri, 21 August 2020 01:03 |
dirish
Messages: 232 Registered: November 2006
|
Senior Member |
|
|
Standby Server
Standby Server>more listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = primarydb)
(ORACLE_HOME = /u01/app/ora19c)
(SID_NAME = primarydb)
)
(SID_DESC =
(GLOBAL_DBNAME = standbydb)
(ORACLE_HOME = /u01/app/ora19c)
(SID_NAME = standbydb)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = standby)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
Standby Server>more tnsnames.ora
standbydb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = standby)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = standbydb)
)
)
primarydb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = primary)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = primarydb)
)
)
|
|
|
Re: ORA-12170: TNS:Connect timeout occurred [message #681733 is a reply to message #681732] |
Fri, 21 August 2020 01:05 |
dirish
Messages: 232 Registered: November 2006
|
Senior Member |
|
|
Primary RAC Server
-bash-5.0$ more tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/ora19c/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
primarydb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = primary)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = primarydb)
)
)
standbydb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = standby)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = standbydb)
)
)
|
|
|
Re: ORA-12170: TNS:Connect timeout occurred [message #681734 is a reply to message #681732] |
Fri, 21 August 2020 01:07 |
John Watson
Messages: 8960 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
According to the tnsping output, the primarydb alias goes to (HOST = primarydb). But the tnsnames.ora file says (HOST = primary).
So either you are not using the files tat you think you are using, or you are not telling the truth.
|
|
|
Re: ORA-12170: TNS:Connect timeout occurred [message #681735 is a reply to message #681734] |
Fri, 21 August 2020 15:16 |
|
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
>ORA-12170: TNS:Connect timeout occurred
The MOST common cause of login TIMEOUT is a firewall on or between client & DB Server.
listener.log file contains a record for EVERY connection request that arrives at the listener.
post the excerpt from listener.log file that contains error code 12170
|
|
|