https://wiki.dewberry.co.za/ 2026-04-22T23:12:13+00:00 https://wiki.dewberry.co.za/ https://wiki.dewberry.co.za/lib/tpl/dokuwiki/images/favicon.ico text/html 2021-04-23T07:57:55+00:00 ss_wiki_admin (ss_wiki_admin@undisclosed.example.com) https://wiki.dewberry.co.za/doku.php?id=oracle_goldengate&rev=1619164675&do=diff Oracle GoldenGate Cache Memory Usage ./ggsci dblogin USERIDALIAS ggadmin SEND EXTRACT ext_mr CACHEMGR CACHESTATS SEND REPLICAT rep_file CACHEMGR CACHESTATS Statistics ./ggsci STATS REPLICAT rep_mr, TOTALSONLY *.*, REPORTRATE MIN STATS EXTRACT ext_mr, TOTALSONLY *.*, REPORTRATE MIN text/html 2021-04-23T07:54:33+00:00 ss_wiki_admin (ss_wiki_admin@undisclosed.example.com) https://wiki.dewberry.co.za/doku.php?id=oracle&rev=1619164473&do=diff Oracle Database Size /* Get total size allocated */ select sum(bytes)/1024/1024 size_in_mb from dba_data_files; /* Get total space used */ select sum(bytes)/1024/1024 size_in_mb from dba_segments; /* Break down size usage by user */ select owner, sum(bytes)/1024/1024 Size_MB from dba_segments group by owner; text/html 2021-04-23T07:48:54+00:00 ss_wiki_admin (ss_wiki_admin@undisclosed.example.com) https://wiki.dewberry.co.za/doku.php?id=solaris&rev=1619164134&do=diff Networking Retrieve the ports used by a specific process with the pfiles command. pfiles `ptree | awk '{print $1}'` | egrep '^[0-9]|port:' Example output: 24168: ssh server2 sockname: AF_INET 10.0.0.1 port: 34820 peername: AF_INET 10.0.0.4 port: 22 4376: /usr/lib/ssh/sshd sockname: AF_INET 10.0.0.1 port: 22 peername: AF_INET 10.0.0.4 port: 57907 4377: /usr/lib/ssh/sshd sockname: AF_INET 10.0.0.1 port: 22 peername: AF_INET 10.0.0.4… text/html 2021-04-23T07:46:41+00:00 ss_wiki_admin (ss_wiki_admin@undisclosed.example.com) https://wiki.dewberry.co.za/doku.php?id=rac_node_grid_system_cpu&rev=1619164001&do=diff Oracle Gateway for msql showing high %system CPU usage for the "grid" user On one of our 3-node RAC Exadata systems, after configuring monitoring using Netdata, Prometheus and Grafana, I noticed that one of the nodes had a much higher CPU %System time than the other two nodes. This %system time was attributed to the Grid user. text/html 2021-04-23T07:45:00+00:00 ss_wiki_admin (ss_wiki_admin@undisclosed.example.com) https://wiki.dewberry.co.za/doku.php?id=flexera&rev=1619163900&do=diff While working through database log files looking for issues I came across numerous instances of the following error: 2019-11-07T03:57:00.623733+02:00 Errors in file /u01/app/oracle/admin/diag/rdbms/dev/dev1/trace/dev1_ora_8142.trc (incident=1313939): ORA-00603: ORACLE server session terminated by fatal error ORA-27515: inadequate memlock limit or driver settings Incident details in: /u01/app/oracle/admin/diag/rdbms/dev/dev1/incident/incdir_1313939/dev1_ora_8142_i1313939.trc text/html 2021-01-07T08:06:13+00:00 ss_wiki_admin (ss_wiki_admin@undisclosed.example.com) https://wiki.dewberry.co.za/doku.php?id=virtualbox&rev=1610006773&do=diff Keyboard Auto-Repeat Consoles inside slow VMs often result in duplicate characters being displayed on typing. The solution is to run the following command: setterm -repeat off Place the command in your ~/.bashrc or similar to execute on login. text/html 2021-01-07T08:03:35+00:00 ss_wiki_admin (ss_wiki_admin@undisclosed.example.com) https://wiki.dewberry.co.za/doku.php?id=sidebar&rev=1610006615&do=diff Operating Systems * Solaris * Linux * AIX * HPUX Database Servers * Oracle * MySQL * Postgresql Middleware * Oracle GoldenGate Big Data * Cloudera Hadoop Virtualization * KVM * VirtualBox Backup * Netbackup * ZFS Storage * PowerPath Appliances * Exadata Hardware * Oracle ILOM * HP Storage Controller * QLogic FC Adapter * LSI Logic/Symbios MegaRAID Coding * Bash * Vim * Python Rabbit holes text/html 2021-01-02T13:04:14+00:00 ss_wiki_admin (ss_wiki_admin@undisclosed.example.com) https://wiki.dewberry.co.za/doku.php?id=exadata&rev=1609592654&do=diff cellcli Show alerthistory for cell dcli -g cell_group -l root cellcli -e list alerthistory Show disk caching for griddisk disks dcli -g cell_group -l root cellcli -e list griddisk attributes name,cachingpolicy,cachedBy Disable caching of griddisk text/html 2020-09-22T12:15:21+00:00 ss_wiki_admin (ss_wiki_admin@undisclosed.example.com) https://wiki.dewberry.co.za/doku.php?id=postgresql&rev=1600776921&do=diff Installing PostgreSQL 12 UnixODBC Driver wget https://download.postgresql.org/pub/repos/yum/reporpms/EL-6-x86_64/pgdg-redhat-repo-latest.noarch.rpm rpm -i pgdg-redhat-repo-latest.noarch.rpm yum install unixODBC yum install postgresql12-odbc text/html 2020-08-13T09:43:51+00:00 ss_wiki_admin (ss_wiki_admin@undisclosed.example.com) https://wiki.dewberry.co.za/doku.php?id=tape_drives_from_hell&rev=1597311831&do=diff On master01, media02, media03, media04 and media5 servers we have 9 shared tape drives for the SLPs. Most of the time only 3 or 4 would be working. Every day I would start in the evening with 8 or 9 working tape drives and wake up in the morning to 2 or 3 working drives. text/html 2020-08-11T08:58:32+00:00 ss_wiki_admin (ss_wiki_admin@undisclosed.example.com) https://wiki.dewberry.co.za/doku.php?id=netbackup&rev=1597136312&do=diff Custom scripts Disk performance benchmark /usr/openv/netbackup/bin/support/nbperfchk -i zero: -o ./nbperfchk.tmp -s 150g Drive down checker #!/bin/ksh #---------------------------------------------------------------------- # Check drives, bring drive up if down, email # If drives are up, do not create a report, runs from cron #---------------------------------------------------------------------- # Add interested parties below: alert_mail=mail@mydomain.co.za /usr/openv/volmgr/bin/vmoprcmd…