04-04-2018 01:16 PM
Our master server is linux (v 8), however this issue is occurring with an Online oracle backup of a Windows server. The Policy shows as Oracle. Up until a couple days ago, it has never had any problems. The Backup schedule is failing with: "6) the backup failed to back up the requested files" The on_database_ schedule is failing with: "Apr 3, 2018 2:44:12 AM - Info bpbrm (pid=21239) INF - Client read timeout = 18000
Apr 3, 2018 7:44:12 AM - Error bpbrm (pid=21239) listen for client timeout during accept from data listen socket after 60 seconds
Apr 3, 2018 7:44:40 AM - Info dbclient (pid=0) done. status: 54: timed out connecting to client"
An Oracle DBA checked it from her side and this is the error she sees:
"RMAN-03002: failure of backup plus archivelog command at 04/04/2018 03:08:29
ORA-19506: failed to create sequential file, name="_20180404_25316.p1_s26287.r", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
VxBSACreateObject: Failed with error:
Server Status: Communication with the server has not been initiated or the server status has not been retrieved from the serve
RMAN>"
Any ideas? As state above, this backup has been "good" for years.
Solved! Go to Solution.
04-05-2018 12:20 AM - edited 04-05-2018 12:22 AM
Looks like oracle host did not respond to a network connection in time
listen for client timeout during accept from data listen socket after 60 seconds
its like a phone call where no one is answering. Verify connectivity with bptestbpcd as Marainne pointed out and re-try the operation.
04-05-2018 12:04 AM
'Something' has changed causing connectivity to fail.
Any chance that the master is no longer listed as 1st Server entry in the Registry?
Important to test connectivity from master and media server as well as connectivity initiated by the client to the master server.
Ensure log folders exist before running tests:
Master: bprd (NBU must be restarted after folder is created)
Media: bpbrm (This is for backup-related troubleshooting)
Client: bpcd and dbclient (for connectivity and backup troubleshooting)
Connectivity tests:
On master and media server:
bptestbpcd -client <client-name> -debug -verbose
On client:
bpclntcmd -pn
04-05-2018 12:20 AM - edited 04-05-2018 12:22 AM
Looks like oracle host did not respond to a network connection in time
listen for client timeout during accept from data listen socket after 60 seconds
its like a phone call where no one is answering. Verify connectivity with bptestbpcd as Marainne pointed out and re-try the operation.