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/
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# ———————————————-…
Apex
https://tm-apex.hashnode.dev/quick-and-easy-apex-and-ords-installation-for-oracle-database-23c-developer-release-on-oci#heading-prerequisites-for-installing-ords-and-apex https://mindmajix.com/how-to-install-oracle-apex https://www.youtube.com/watch?v=YpHzijX3E2A&t=133s
DR Sync query
select name,db_unique_name,open_mode,database_role from v$database; sho pdbs; SELECT al.thrd “Thread”,almax “Last Seq Received”,lhmax “Last Seq Applied”,(almax…
EBS upgrade 19c to 23i
https://promatis.com/hr/en/upgrade-e-business-suite-database-to-23ai/
Oracle ZDM Migration to Autonomous Database on Oracle Database@Azure
https://blogs.oracle.com/maa/post/oracle-zdm-to-autonomous-database-on-azure
Exadata – RMAN incremental backup
https://blog.zeddba.com/2019/05/29/rman-incremental-with-block-change-tracking-demo/ To optimize the performance of incremental backups, the database can offload block filtering to Oracle…