Skip to content

TIMEOUT ERROR

Cause: trying to connect to database from prod to test server and it errors because of firewall. it denies connection for 1522 port

Solution:

check with sysadmin about firewall if it is blocking port 1522 from prod to test server in my case.

 

example 1:

-bash-4.2$ rman target sys@prm auxiliary sys@prmtemp

Recovery Manager: Release 12.2.0.1.0 – Production on Fri Apr 5 10:52:20 2019

Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.

connected to target database: PRMYC (DBID=2759042066)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-12170: TNS:Connect timeout occurred

example 2:

RMAN-03009: failure of backup command on pri1 channel at 04/05/2019 10:48:51
ORA-17627: ORA-12170: TNS:Connect timeout occurred
ORA-17629: Cannot connect to the remote database server
continuing other job steps, job failed will not be re-run
released channel: pri1
released channel: pri2
released channel: stby
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/05/2019 10:48:51
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on pri2 channel at 04/05/2019 10:48:51
ORA-17627: ORA-12170: TNS:Connect timeout occurred
ORA-17629: Cannot connect to the remote database server

 

No comments yet

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 )

Facebook photo

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

Connecting to %s

%d bloggers like this: