Everyday Common SQL

DB Size / Tablespace Size / Tablespace Usage -- DB Size, database size free and % used ----------------------------------------- col TABLESPACE_NAME for a30 col NoDbf for a5 select NoDbf, round(tbs.size_tbs, 0) "Size(MB)" , round(nvl(df.size_free, 0), 0) "Free Space(MB)", round((tbs.size_tbs - nvl(df.size_free, 0))/tbs.size_tbs*100, 0) "% Used" from (select sum(bytes)/1024/1024 size_tbs, count(*)||'' NoDbf from dba_data_files ) tbs, (select sum(bytes)/1024/1024 size_free from dba_free_space ) df;

Cluster DB notes

Status of ASM and DB: srvctl status asm srvctl status database -d rac Start / Stop Instance: srvctl start instance -d rac -i rac2 srvctl stop instance -d rac -i rac2 Listener: srvctl status listener srvctl status scan_listener Cluster Auto Start: crsctl stat res -t crsctl status res -f | grep AUTO_START e.g. crsctl status res ora.rac.db -f | grep AUTO_START AUTO_START=restore crsctl status res ora.asm -f | grep AUTO_START AUTO_START=always

Oracle Clusterware Logs

CRS: /u01/app/grid/diag/crs/[DB_NAME]/crs/trace/ alert.log ASM: /u01/app/grid/diag/asm/+asm/+ASM1/trace/alert_+ASM1.log Force a shutdown of Oracle Clusterware (CRS) : Using root cd /u01/app/19.0.0/grid/bin ./crsctl stop crs -f Check detail of network card e.g. [oracle@srv1 bin]$ nmcli device show enp0s10 GENERAL.DEVICE: enp0s10 GENERAL.TYPE: ethernet GENERAL.HWADDR: 08:00:27:62:8A:33 GENERAL.MTU: 1500 GENERAL.STATE: 100 (connected) GENERAL.CONNECTION: Wired connection 5 GENERAL.CON-PATH: /org/freedesktop/NetworkManager/ActiveConnection/3 WIRED-PROPERTIES.CARRIER: on IP4.ADDRESS[1]: 192.168.1.140/24 IP4.GATEWAY: 192.168.1.1 IP4.ROUTE[1]: dst = 0.0.0.0/0, nh = 192.168.1.1, mt = 102 IP4.ROUTE[2]: dst = 192.168.1.0/24, nh = 0.0.0.0, mt = 102 IP4.DNS[1]: 192.168.1.1 IP6.ADDRESS[1]: fe80::5f91:3967:1437:483f/64 IP6.GATEWAY: -- IP6.ROUTE[1]: dst = fe80::/64, nh = ::, mt = 102 IP6.ROUTE[2]: dst = ff00::/8, nh = ::, mt = 256, table=255 [oracle@srv1 bin]$

Make bootable Mac OS usb for 2011 iMac, 2012 MacAir,

 This USB fixed my issue of creating a bootable MAC OS USB

https://www.youtube.com/watch?v=64IOWM8ezyk

1. Download High Sierra 10.13 from https://support.apple.com/en-gb/HT211683 2. Go to Application Admins-MacBook-Air:~ root# /Applications/Install macOS High Sierra.app/Contents/Resources/createinstallmedia --volume /Volumes/Usb32 --applicationpath /Applications/Install macOS High Sierra.app Ready to start. To continue we need to erase the volume at /Volumes/Usb32. If you wish to continue type (Y) then press return: y Erasing Disk: 0%... 10%... 20%... 30%...100%... Copying installer files to disk... Copy complete. Making disk bootable... Copying boot files... Copy complete. Done.

PHP Tuning / PHP Config

After install, getting lot of Warning / Notice in my application e.g. Notice: Undefined index: isimg in /Library/WebServer/Documents/myproject/products/prodList.php on line 459 Fix was changed following var in php.ini From error_reporting=E_ALL & ~E_DEPRECATED & ~E_STRICT To error_reporting=E_ALL & ~E_NOTICE Don't forget to restart apache for the change to take effect. On my Mac17 files in vi /Applications/XAMPP/etc/php.ini

MySQL change sroage for all tables

MySQL move from MyISAM to InnoDB Simple dynamic SQL to change stoage type in MySQL SELECT concat('alter table ', table_name, ' engine=innodb;') SQL_strg FROM information_schema.tables WHERE table_schema = 'db_dev_db' and engine='MyISAM';

Tomcat & JDBC error connecting to 19c

ORA-28040: No matching authentication protocol

This is quite generic error.
This fixed worked for me.

1. Find the JDBC driver that is being used, jdbc.jar can reside in many location e.g.

$CATALINA_HOME/lib/

webapps/myApp/WEB-INF/lib

2. Updated the correct JDBC in your location

3. Restart tomcat