Tuesday, 24 December 2024

Find all files containing a specific text string on Linux recursive

 grep -rnw /u01/data/domains/bi/servers/AdminServer/logs -e 'IO Error: Connection reset' | grep 'Dec 10'

grep -Ril "IO Error: Connection reset" /u01/data/domains/bi/servers/AdminServer/logs/


Monday, 16 December 2024

Run Oracle Apex or other application on privileged ports like 443 or 80 without root

Below will redirect the traffic from port 443 to port 8443

 firewall-cmd --list-all

firewall-cmd --zone=public --permanent --add-forward-port=port=443:proto=tcp:toport=8443

firewall-cmd --reload

firewall-cmd --list-all


Saturday, 14 December 2024

Rebuild Oracle Standby Database oracle 12c and later with archive GAP with single command

-- On standby

rman target /

shutdown immediate;

startup nomount;

restore standby controlfile from service PRIM;

alter database mount;

--restore datafile 4 from service PRIM; -- If new data files added to primary recently    

recover database from service PRIM noredo using compressed backupset

RECOVER MANAGED STANDBY DATABASE disconnect from session;


Number of Visitors