Sometimes, it doesn’t matter how expert you are! I believe I have good knowledge on datagaurd but it took me three days to solve simple issue. Oh it doesn’t mean I am not expert, because culprit was not Oracle its Windows.
Issue was, I had configured standby database till then everything was right, problem occurs whenever I put standby database in recovery, it fetches one or two logs from productions and then listener crashes. I configured different listener even standby database as well but no Luck.
Error prompt:
Faulting application TNSLSNR.EXE, version 0.0.0.0, faulting module orantcp9.dll, version 0.0.0.0, fault address 0×00005732
After lot of goggling I got one magical command.
netsh winsock reset catalog
I surprised, this simple command solves my problem immediately. Oh god, I used this command many times in past but failed to relate it with this issue.
Most of the Internet connectivity problems are because of the corruption in Winsock settings. Windows sockets settings may get corrupted due to the installation of a networking software, Malware infestation. In this situation user can connect to the Internet, but randomly may get Page cannot be displayed .Above command resets the Winsock catalog to the default configuration. This can be useful if a malformed LSP is installed that results in loss of network connectivity.
0 comments:
Post a Comment