oraculix

Windows on AWS EC2: Install software with Chocolatey package manager

Why

When you create a new EC2 instance, you usually would like to install some software on top of the OS during the creation process. But unlike Linux, Windows doesn't come a package manager like yum or apt. Chocolatey is such a package manager that can either be used for free with community-made packages or as an enterprise solution with a custom repository.

How

To install and manage software automatically on instance launch, paste the code below into the UserData field. This will install Chocolatey package manager first. Then you can install software packages from Chocolatey's community repository as shown below via choco install -y .

Find the largest LOB in an Oracle schema

This is meant for DMS migration tasks using "Limited LOB Mode", where you need to set the LobMaxSize parameter.

Run either as the schema owner or,
For multiple schemas or if you're not the schema owner:
- Adapt the line "AND OWNER = USER" to the list of schemas to be queried
Run script as admin user.

GNU Screen Cheat Sheet

Basics

Hotkey	Description
ctrl-a c	create new window
ctrl-a A	set window name
ctrl-a w	show all windows
ctrl-a \	switch to window n

	create table if not exists deps_saved_ddl
	(
	deps_id serial primary key,
	deps_view_schema name,
	deps_view_name name,
	deps_ddl_to_run text
	);

	create or replace function deps_save_and_drop_dependencies(p_view_schema name, p_view_name name) returns void as
	$$

	#!/data/data/com.termux/files/usr/bin/sh
	touch ~/obsidian-git-sync-timestamp
	while IFS= read VAULT; do
	echo _____________________________________________________________
	echo ${VAULT}
	cd ~/storage/shared/Documents/Obsidian/${VAULT}
	git config --global pack.windowMemory "100m"
	git config --global pack.packSizeLimit "100m"
	git config --global pack.threads "1"
	git pull --rebase

	-- Find first occurence of NEXTVAL case-insensitive and deliver the line of occurrence and the lines around it.
	WITH found AS (
	SELECT owner, name, type, line FROM all_source
	WHERE owner = 'GSMADMIN_INTERNAL'
	AND regexp_instr(text, 'NEXTVAL',1,1,0,'i') > 0
	)
	SELECT a.*
	FROM all_source a, found
	WHERE a.owner = found.owner
	AND a.name = found.name

	/* gen_incr_sequences.sql
	* Generates SQL script to increase Oracle sequences.
	*
	* For use in migration scenarios, e.g. with DMS or GoldenGate,
	* when access to the source database is difficult.
	* Run this
	* - either as the target schema owner
	* - or as an admin user (edit list of schema_owner first)
	* , then run the generated script "incr_sequences.sql" during cutover
	* on the target.

	---------------
	-- SQL-Monitor
	---------------
	-- Welche Reports stehen zur Verfügung?
	-- Ggf. auf INST_ID oder SQL_ID einschränken.
	select DBMS_SQLTUNE.REPORT_SQL_MONITOR_LIST(
	INST_ID => NULL
	, active_since_date => sysdate-1/48
	, report_level => 'BASIC'
	-- , SQL_ID => 'dqbzzupk4xuz5'

	-- How to format your Oracle SQL*Plus output for Markdown:

	SET COLSEP '\|'
	select * from USER_SYS_PRIVS order by PRIVILEGE;

	# /etc/udev/rules.d/50-u2f.rules
	# HyperFIDO U2F Key
	SUBSYSTEMS=="usb", ATTRS{idVendor}=="2ccf", ATTRS{idProduct}=="0880", OWNER="root", GROUP="plugdev", MODE:="0660"