19.3 to 19.23 upgrade
https://www.mirsayeedhassan.com/patching-oracle-database-19c-release-update-on-april-2024-19-23-p36233263-on-single-instance-database/
Monthly Archives: April, 2025
change timezone
timedatectl set-timezone US/Central timedatectlLocal time: Mon 2025-04-21 12:51:47 CDTUniversal time: Mon 2025-04-21 17:51:47 UTCRTC time:…
set command in vi
set -o vi To switch into vi command mode, press <Esc>. You can use the vi…
How to update remote listener port
alter system set remote_listener=’scanname:1591′ scope=spfile sid=’*’;alter system register srvctl modify scan_listener -p 1591,1521srvctl config scan_listenersrvctl…
Oracle datagaurd – applied
https://oracle-artifacts.blogspot.com/2012/04/oracle-data-guard-issues-applied-column.html SQL> SELECT THREAD#, LOW_SEQUENCE#, HIGH_SEQUENCE# FROM V$ARCHIVE_GAP; THREAD# LOW_SEQUENCE HIGH_SEQUENCE# ———————————————-…