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…
Backup Script
cat > /home/oracle/scripts/rman.sh !/bin/sh DATE=date +%m%d%y%H%M$ORACLE_HOME/bin/rman target / log=/home/oracle/scripts/log/backup_PROD_$DATE.log @/home/oracle/scripts/db.rman cat > /home/oracle/scripts/db.rmanrun {allocate channel…
Convert archivelog in RAC environment
https://oracledbwr.com/enabling-archive-log-mode-in-oracle-19c-rac-database/
Restore using timestamp
Find the sequence from v$archived_log and get the timestamp and then restore using RMAN col…