Sadan's Oracle dba Blog

 https://www.perforce.com/blog/spr/oracle-native-network-encryption https://monin-it.be/how-to-activate-encryption-in-transit-in-oracle-databases-for-free/ https://questoraclecommunity.org/learn/blogs/oracle-database-network-encryption-native-vs-tls-ssl/ https://oracle-base.com/articles/misc/native-network-encryption-for-database-connections select network_service_banner from v$session_connect_info  where sid in (select distinct sid from v$mystat); Oracle Database Network Encryption

  https://infraxpertzz.com/step-by-step-oracle-grid-rac-database-upgrade-from-12-2-0-1-to-19c-in-silent-method/#google_vignette https://www.rackspace.com/blog/upgrade-oracle-grid-from-12c-to-19c https://www.luxoug.org/oracle-restart-database-upgrade-12c-to-19c-using-autoupgrade/

============================= 19C RAC INSTALATION ================================== [root@rac02 oracle]# cat /etc/selinux/config [root@rac02 oracle]# sed -i --follow-symlinks 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config [root@rac02 oracle]# cat /etc/selinux/config https://docs.google.com/document/d/15GTD9Wogr4fUg0iPnoKY2S89kbQ_h4-9HxPd2EQ1AVw/edit# Things need to select: export CV_ASSUME_DISTID=OEL7.6 https://youtu.be/-zynUdIFW6w rac01 first machine name rac02 second machine name 1 NAT. Internet purpose 2 HOSTONLY ADAPTER Public network 3.INTERNAL NETWORK Private Nerwork. 8 optios we need to select. system administrator tools devolopment tools compatability libraries remote management for linux performance Tolls KDE java platform Hardware monitoring utilitis. 6 mount points ... / 30 gb /home 5 gb swap 10 gb /boot 1 gb biosboot 1gb /u01 60 gb /u02 50 gb hostname: rac01.oracle.com rac01#] cat /etc/system-release #systemctl stop firewalld systemct...

  ===================Source Side =================== @db_status.sql select dbid from v$database; col file_name format a90 select file_name from dba_data_files order by file_name; col member for a90 select member from v$logfile; show parameter controlfile show parameter spfile; SQL> create pfile='/home/oracle/initCALCOPQ1.ora' from spfile; col "Database Size" format a20 col "Free space" format a20 select round(sum(used.bytes) / 1024 / 1024 /1024) || ' GB' "Database Size" , round(free.p / 1024 / 1024 /1024) || ' GB' "Free space" from (select bytes from v$datafile union all select bytes from v$tempfile union all select bytes from v$log) used , (select sum(bytes) as p from dba_free_space) free group by free.p / connect to catalog database. rman target / catalog rman12/sxc0v7ry@dxRCAT list backup of controlfile; list backup of database; ===================Target side ===========...

  Upgrade Oracle 11g to 21c using AutoUpgrade utility: How do I upgrade Oracle database to 21c?  install the 21c oracle binaries into the server . Oracle Virtual Bix  Oracle Linux 7 Oracle Database 19c currently running Upgrading 19c database to 21c directly Oracle Database 19c on premises is available – and one of the key features is the new Auto Upgrade utility. In the following days I will publish several blog posts explaining and showcasing the new Auto Upgrade. What is the Auto Upgrade? The Oracle Database Auto Upgrade utility is a new tiny little command line tool which allows you to upgrade your databases in an unattended way. I call it the Hands-Free Upgrade. The new Auto Upgrade utility in Oracle 19che idea of the tool is to run the prechecks against multiple databases, fix 99% of the potential issues, set a restore point in case something goes wrong – and then upgrade your databases. And of course, do the post upgrade, recompilation and time zone adjustment. The...

RAC installation on OEL 7.9  Dissable the firewall:   systemctl stop firewalld systemctl disable firewalld systemctl status firewalld cat /etc/selinux/config sed -i --follow-symlinks 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config cat /etc/selinux/config Add the below entries into the /etc/hosts file  vi /etc/hosts Public Ip 192.168.56.120  19crac01.oracle.com  19crac01 192.168.56.121  19crac02.oracle.com  19crac02 10.10.10.101   19crac0-priv.oracle.com 19crac01-priv 10.10.10.102   19crac02-priv.oracle.com 19crac02-priv 192.168.56.123  19crac01-vip.oracle.com 19crac01-vip 192.168.56.124  19crac02-vip.oracle.com 19crac02-vip Add the scan ip entries into the dns vi /etc/racdns 192.168.56.127  prod-scan.oracle.com rac-scan 192.168.56.128  prod-scan.oracle.com rac-scan 192.168.56.129  prod-scan.oracle.com rac-scan vi /etc/dnsmasq.conf addn-hosts= /etc/racdns :wq vi /etc/resolv.conf nameserver 127.0....