Tuesday, 16 February 2021

.bat file delete files from windows older than 7 days

 REM Remove files backup older than 7 days

forfiles /p "F:\backup\dumps" /s /m *.* /c "cmd /c Del @path" /d -7


Monday, 8 February 2021

Oracle Data Guard 19c TNS-12564: TNS:connection refused

 I faced this error during the switchover in 19c version:

Make sure:

1- Have the correct services statically registered.

2- Configure the local_listener as below in both primary and standby servers:

alter system set local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=primary)(PORT=1521)))' scope=both;

alter system set local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=standby)(PORT=1521)))' scope=both;

  

Number of Visitors