mortenbra

## oracle_upload_software.sh
# copy files from client to server
# assumes you have downloaded everything into an "install" folder
# adjust SSH port number, file paths, server/host name and version numbers as appropriate
cd /users/yourname/install/oracle
scp -P 22 oracle-xe-11.2.0-1.0.x86_64.rpm.zip root@server-name-or-ip:/u01/download/
scp -P 22 apex_5.0.1_en.zip root@server-name-or-ip:/u01/download/
scp -P 22 jdk-7u79-linux-x64.rpm root@server-name-or-ip:/u01/download/
scp -P 22 ords.2.0.10.289.08.09.zip root@server-name-or-ip:/u01/download/

## centos_firewall.sh
#!/bin/bash

# see http://oracle-base.com/articles/linux/linux-firewall.php

# Set the default policies to allow everything while we set up new rules
# Prevents cutting yourself off when running from remote SSH
iptables -P INPUT ACCEPT
iptables -P FORWARD ACCEPT
iptables -P OUTPUT ACCEPT

## centos_update.sh
# check what updates are available
yum check-update

# update everything
yum update -y

# update everything except the kernel
#yum update -y --exclude=kernel*

## ora_network_acl_verify.sql
-- check/verify network ACL settings
select host, lower_port, upper_port, acl
from dba_network_acls;

select *
from dba_network_acl_privileges;

## apex_workspace_verify.sql
-- check setup of Apex workspaces
select *
from apex_workspaces;

select *
from apex_workspace_schemas;

## apex_install_runtime.sql
-- install Apex (runtime only)
@apxrtins.sql SYSAUX SYSAUX TEMP /i/

## xe_post_install_cleanup.sql
-- do some cleanup after Oracle XE installation
-- run as SYS

-- disable XDB server
-- assumes we will use ORDS or other web listener instead
exec dbms_xdb.sethttpport(0);
exec dbms_xdb.setftpport(0);

-- anonymous user is not needed when we don't use XDB
alter user anonymous account lock;

## xe_post_install_verify.sh
# initial test of Oracle XE database after install

# become the "oracle" user
su - oracle

# connect to database
sqlplus /nolog
connect sys as sysdba

-- basic query to see stuff working

## centos_swapfile.sh
# Oracle XE requires a swap file of at least twice the size of physical memory
# see https://www.digitalocean.com/community/tutorials/how-to-add-swap-on-centos-6

# check current swap file
swapon -s
# check available space
df

# setup 2GB swap file
dd if=/dev/zero of=/swapfile bs=1024 count=2048k

## centos_ntp.sh
# setup Network Time Protocol (NTP)
# see http://www.uptimemadeeasy.com/networking/setup-ntp-on-centos-linux/

# check current date/time
date

# setup time zone
mv /etc/localtime /etc/localtime.bkp
cp /usr/share/zoneinfo/Europe/Oslo /etc/localtime
	# copy files from client to server
	# assumes you have downloaded everything into an "install" folder
	# adjust SSH port number, file paths, server/host name and version numbers as appropriate
	cd /users/yourname/install/oracle
	scp -P 22 oracle-xe-11.2.0-1.0.x86_64.rpm.zip root@server-name-or-ip:/u01/download/
	scp -P 22 apex_5.0.1_en.zip root@server-name-or-ip:/u01/download/
	scp -P 22 jdk-7u79-linux-x64.rpm root@server-name-or-ip:/u01/download/
	scp -P 22 ords.2.0.10.289.08.09.zip root@server-name-or-ip:/u01/download/
	#!/bin/bash

	# see http://oracle-base.com/articles/linux/linux-firewall.php

	# Set the default policies to allow everything while we set up new rules
	# Prevents cutting yourself off when running from remote SSH
	iptables -P INPUT ACCEPT
	iptables -P FORWARD ACCEPT
	iptables -P OUTPUT ACCEPT
	# check what updates are available
	yum check-update

	# update everything
	yum update -y

	# update everything except the kernel
	#yum update -y --exclude=kernel*
	-- check/verify network ACL settings
	select host, lower_port, upper_port, acl
	from dba_network_acls;

	select *
	from dba_network_acl_privileges;
	-- check setup of Apex workspaces
	select *
	from apex_workspaces;

	select *
	from apex_workspace_schemas;
	-- install Apex (runtime only)
	@apxrtins.sql SYSAUX SYSAUX TEMP /i/
	-- do some cleanup after Oracle XE installation
	-- run as SYS

	-- disable XDB server
	-- assumes we will use ORDS or other web listener instead
	exec dbms_xdb.sethttpport(0);
	exec dbms_xdb.setftpport(0);

	-- anonymous user is not needed when we don't use XDB
	alter user anonymous account lock;
	# initial test of Oracle XE database after install

	# become the "oracle" user
	su - oracle

	# connect to database
	sqlplus /nolog
	connect sys as sysdba

	-- basic query to see stuff working
	# Oracle XE requires a swap file of at least twice the size of physical memory
	# see https://www.digitalocean.com/community/tutorials/how-to-add-swap-on-centos-6

	# check current swap file
	swapon -s
	# check available space
	df

	# setup 2GB swap file
	dd if=/dev/zero of=/swapfile bs=1024 count=2048k
	# setup Network Time Protocol (NTP)
	# see http://www.uptimemadeeasy.com/networking/setup-ntp-on-centos-linux/

	# check current date/time
	date

	# setup time zone
	mv /etc/localtime /etc/localtime.bkp
	cp /usr/share/zoneinfo/Europe/Oslo /etc/localtime