I hereby claim:
- I am darkangelstrike on github.
- I am sbeaulieu (https://keybase.io/sbeaulieu) on keybase.
- I have a public key ASClLXjNAyOA6ELphPBGx-NOE5zckjroViOLSvabRRNqnQo
To claim this, I am signing this object:
DarkAngelStrike
DarkAngelStrike
/ huge_pages_pg_calc.sh
Created
March 10, 2022 17:30
— forked from AlexBaranowski/huge_pages_pg_calc.sh
Simple script to calculate huge pages for PostgreSQL. Please note that this is baseline and require further tunning.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/usr/bin/env bash | |
| [ -z "$PGDATA" ] && echo "PGDATA is not defined!" && exit 1 | |
| [ ! -e $PGDATA/postmaster.pid ] && echo "Cannot find $PGDATA/postmaster.pid is PostgreSQL server running?" && exit 1 | |
| PG_PID=$(head -1 $PGDATA/postmaster.pid) | |
| PG_MEM_U=$(grep ^VmPeak /proc/$PG_PID/status | awk '{print $3}') | |
| HP_MEM_U=$(grep ^Hugepagesize /proc/meminfo | awk '{print $3}') | |
| [ "$PG_MEM_U" != "$HP_MEM_U" ] && echo "The units differ please calculate the Huge Pages manually" && exit 1 | |
| PG_MEM=$(grep ^VmPeak /proc/$PG_PID/status | awk '{print $2}') | |
| HP_MEM=$(grep ^Hugepagesize /proc/meminfo | awk '{print $2}') |
DarkAngelStrike
/ kziaVrfyAcctStatInRootCbk.0
Last active
May 8, 2017 03:08
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [oracle@server ~]$ sqlplus / as sysdba | |
| SQL*Plus: Release 12.2.0.1.0 Production on Thu Apr 27 13:40:56 2017 | |
| Copyright (c) 1982, 2016, Oracle. All rights reserved. | |
| Connected to: | |
| Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production |
DarkAngelStrike
/ kziaVrfyAcctStatInRootCbk.5
Created
May 8, 2017 02:50
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [oracle@server ~]$ sqlplus APEX_PUBLIC_USER/*****@127.0.0.1:1521/PDB | |
| SQL*Plus: Release 12.2.0.1.0 Production on Wed May 3 12:54:35 2017 | |
| Copyright (c) 1982, 2016, Oracle. All rights reserved. | |
| Last Successful login time: Thu Apr 27 2017 09:25:18 -04:00 | |
| Connected to: | |
| Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production |
DarkAngelStrike
/ kziaVrfyAcctStatInRootCbk.4
Created
May 8, 2017 02:50
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [oracle@server ~]$ sqlplus / as sysdba | |
| SQL*Plus: Release 12.2.0.1.0 Production on Wed May 3 12:44:46 2017 | |
| Copyright (c) 1982, 2016, Oracle. All rights reserved. | |
| Connected to: | |
| Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production |
DarkAngelStrike
/ kziaVrfyAcctStatInRootCbk.3
Last active
May 8, 2017 03:29
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SYS@CDB> alter session set container = CDB$ROOT; | |
| Session altered. | |
| SYS@CDB> show con_name | |
| CON_NAME | |
| ------------------------------ | |
| CDB$ROOT |
DarkAngelStrike
/ kziaVrfyAcctStatInRootCbk.2
Created
May 8, 2017 02:49
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2017-04-28T08:34:05.210271-04:00 | |
| Errors in file /u01/app/oracle/diag/rdbms/cdb/CDB/trace/CDB_ora_4284.trc (incident=14692) (PDBNAME=CDB$ROOT): | |
| ORA-00600: internal error code, arguments: [kziaVrfyAcctStatInRootCbk: !user], [APEX_PUBLIC_USER], [], [], [], [], [], [], [], [], [], [] | |
| Incident details in: /u01/app/oracle/diag/rdbms/cdb/CDB/incident/incdir_14692/CDB_ora_4284_i14692.trc | |
| Use ADRCI or Support Workbench to package the incident. | |
| See Note 411.1 at My Oracle Support for error and packaging details. | |
| 2017-04-28T08:34:06.400212-04:00 | |
| Dumping diagnostic data in directory=[cdmp_20170428085203], requested by (instance=1, osid=4284), summary=[incident=14692]. |
DarkAngelStrike
/ kziaVrfyAcctStatInRootCbk.1
Created
May 8, 2017 02:48
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [oracle@server ~]$ sqlplus APEX_PUBLIC_USER/*****@127.0.0.1:1521/PDB | |
| SQL*Plus: Release 12.2.0.1.0 Production on Fri Apr 28 08:34:05 2017 | |
| Copyright (c) 1982, 2016, Oracle. All rights reserved. | |
| ERROR: | |
| ORA-00600: internal error code, arguments: [kziaVrfyAcctStatInRootCbk: !user], | |
| [APEX_PUBLIC_USER], [], [], [], [], [], [], [], [], [], [] |
DarkAngelStrike
/ gist:e9db82e1c1c8d11fb228
Last active
February 4, 2016 17:44
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| root@cloudshell:~$ gcloud compute instances create rh7 --image rhel-7 --zone us-central1-a --boot-disk-size 50GB --verbosity error | |
| Created [https://www.googleapis.com/compute/v1/projects/xxxxxx/zones/us-central1-a/instances/rh7]. | |
| NAME ZONE MACHINE_TYPE PREEMPTIBLE INTERNAL_IP EXTERNAL_IP STATUS | |
| rh7 us-central1-a n1-standard-1 xx.xxx.x.x xxx.xxx.xxx.xx RUNNING | |
| root@cloudshell:~$ gcloud compute config-ssh | |
| You should now be able to use ssh/scp with your instances. | |
| For example, try running: | |
| $ ssh rh7 |
DarkAngelStrike
/ gist:74d0f1453520f7e3be34
Last active
January 20, 2016 15:37
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| root@sysdba:~$ gcloud compute firewall-rules list | |
| NAME NETWORK SRC_RANGES RULES SRC_TAGS TARGET_TAGS | |
| allow-agent default 0.0.0.0/0 tcp:3872 | |
| allow-bipub default 0.0.0.0/0 tcp:9803 | |
| allow-oms default 0.0.0.0/0 tcp:7803 | |
| allow-ons default 0.0.0.0/0 tcp:2016 | |
| allow-tns default 0.0.0.0/0 tcp:1521 | |
| default-allow-http default 0.0.0.0/0 tcp:80 http-server | |
| default-allow-https default 0.0.0.0/0 tcp:443 https-server | |
| default-allow-icmp default 0.0.0.0/0 icmp |
NewerOlder