mortenbra

## vscode_run_sqlplus.bat
rem Setup sqlplus environment for Unicode
rem Run this before running scripts that contain multibyte characters
rem See http://www.sqlsnippets.com/en/topic-13434.html for details
set NLS_LANG=.AL32UTF8
chcp 65001

rem show raw error messages from sqlplus
rem echo exit | echo show errors | sqlplus %1 %2

rem get errors that can be parsed with problemMatcher

## letsencrypt.sh
#!/bin/bash

# shell script hardening
set -euf -o pipefail

#
# Lets Encrypt Certificate Generator
#    https://calomel.org/lets_encrypt_client.html
#    lets_encrypt.sh v0.07
#

## scp_copy_folder.sh
# copy entire folder to remote host
scp -P 22 -r my_local_folder username@hostname:/var/www/html/c/my_remote_folder

## centos_node_install.sh
# install node.js on CentOS
# see https://www.digitalocean.com/community/tutorials/how-to-install-node-js-on-a-centos-7-server

# install EPEL (Extra Packages for Enterprise Linux) repository
yum install epel-release -y

# install node
yum install nodejs -y

# install node package manager (NPM)

## ords_jdbc_config.xml
<entry key="jdbc.InitialLimit">10</entry>
<entry key="jdbc.MinLimit">10</entry>
<entry key="jdbc.MaxLimit">60</entry>

## centos_tmpfs.sh
# adjust tmpfs on CentOS as appropriate for Oracle XE
# see https://oracle-base.com/articles/11g/automatic-memory-management-11gr1

# check the available space
df -k

# adjust available space
umount tmpfs
mount -t tmpfs shmfs -o size=1024M /dev/shm

## centos_yum_cron.sh
# see http://linuxaria.com/pills/enabling-automatic-updates-in-centos-6-and-red-hat-6

# install yum-cron
yum install yum-cron -y

# if desired, set up admin email for notifications
# look for the MAILTO option
nano /etc/sysconfig/yum-cron

# enable automatic updates

## apache_ssl_install.sh
# install mod_ssl and set up self-signed certificate on Apache on CentOS

# install mod_ssl
yum install mod_ssl -y

# directory to store keys and certificates
mkdir /etc/httpd/ssl

# create server key and self-signed certificate
# you will be prompted for certificate information

## apache_copy_homepage.sh
# copy files from client to server
# adjust SSH port number, file paths, server/host name as appropriate
cd /users/yourname/projectname/website
scp -P 22 index.html root@server-name-or-ip:/var/www/html/

## oracle_network_acl_config.sql
-- to be run as user SYS

-- to avoid ORA-30992 and ORA-01858 due to invalid date format when calling create_acl
alter session set nls_language = AMERICAN;
alter session set nls_territory = AMERICA;

BEGIN
  DBMS_NETWORK_ACL_ADMIN.create_acl (
    acl          => 'apex.xml',
    description  => 'Access Control List for APEX',
	rem Setup sqlplus environment for Unicode
	rem Run this before running scripts that contain multibyte characters
	rem See http://www.sqlsnippets.com/en/topic-13434.html for details
	set NLS_LANG=.AL32UTF8
	chcp 65001

	rem show raw error messages from sqlplus
	rem echo exit \| echo show errors \| sqlplus %1 %2

	rem get errors that can be parsed with problemMatcher
	#!/bin/bash

	# shell script hardening
	set -euf -o pipefail

	#
	# Lets Encrypt Certificate Generator
	# https://calomel.org/lets_encrypt_client.html
	# lets_encrypt.sh v0.07
	#
	# copy entire folder to remote host
	scp -P 22 -r my_local_folder username@hostname:/var/www/html/c/my_remote_folder
	# install node.js on CentOS
	# see https://www.digitalocean.com/community/tutorials/how-to-install-node-js-on-a-centos-7-server

	# install EPEL (Extra Packages for Enterprise Linux) repository
	yum install epel-release -y

	# install node
	yum install nodejs -y

	# install node package manager (NPM)
	<entry key="jdbc.InitialLimit">10</entry>
	<entry key="jdbc.MinLimit">10</entry>
	<entry key="jdbc.MaxLimit">60</entry>
	# adjust tmpfs on CentOS as appropriate for Oracle XE
	# see https://oracle-base.com/articles/11g/automatic-memory-management-11gr1

	# check the available space
	df -k

	# adjust available space
	umount tmpfs
	mount -t tmpfs shmfs -o size=1024M /dev/shm
	# see http://linuxaria.com/pills/enabling-automatic-updates-in-centos-6-and-red-hat-6

	# install yum-cron
	yum install yum-cron -y

	# if desired, set up admin email for notifications
	# look for the MAILTO option
	nano /etc/sysconfig/yum-cron

	# enable automatic updates
	# install mod_ssl and set up self-signed certificate on Apache on CentOS

	# install mod_ssl
	yum install mod_ssl -y

	# directory to store keys and certificates
	mkdir /etc/httpd/ssl

	# create server key and self-signed certificate
	# you will be prompted for certificate information
	# copy files from client to server
	# adjust SSH port number, file paths, server/host name as appropriate
	cd /users/yourname/projectname/website
	scp -P 22 index.html root@server-name-or-ip:/var/www/html/
	-- to be run as user SYS

	-- to avoid ORA-30992 and ORA-01858 due to invalid date format when calling create_acl
	alter session set nls_language = AMERICAN;
	alter session set nls_territory = AMERICA;

	BEGIN
	DBMS_NETWORK_ACL_ADMIN.create_acl (
	acl => 'apex.xml',
	description => 'Access Control List for APEX',