mortenbra

#install some basic utils
yum install nano -y
yum install unzip -y
yum install bc -y
yum install wget -y

mortenbra

   <-- setup SSL connector for Tomcat, and enabling only recommended protocols and ciphers  -->
   <Connector port="8443" protocol="HTTP/1.1" maxHttpHeaderSize="32767" URIEncoding="UTF-8"
              maxThreads="150" connectionTimeout="20000"
              SSLEnabled="true" scheme="https" secure="true"
              sslProtocol="TLS" sslEnabledProtocols="TLSv1,TLSv1.1,TLSv1.2"
              ciphers="TLS_RSA_WITH_AES_128_CBC_SHA,TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA,TLS_RSA_WITH_AES_128_CBC_SHA256,TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256,TLS_RSA_WITH_3DES_EDE_CBC_SHA,TLS_ECDHE_RSA_WITH_3DES_EDE_CBC_SHA"
              keystoreFile="/path/to/your_keystore.jks" keystorePass="yourpasswordhere"
              clientAuth="false" />

mortenbra

# 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

mortenbra

# 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

mortenbra

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

mortenbra

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

mortenbra

-- check/verify network ACL settings 
select host, lower_port, upper_port, acl
from dba_network_acls;
 
select *
from dba_network_acl_privileges;

mortenbra

# check what updates are available
yum check-update

# update everything
yum update -y

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

mortenbra

# install Oracle XE 11g on CentOS

# assumes the installation file has already been copied to /u01/download

# create Oracle user and groups
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba,oinstall oracle
chown -R oracle:oinstall /u01

mortenbra

# setup Oracle environment in bash profile to be able to access sqlplus from anywhere

# http://stackoverflow.com/questions/16823591/how-to-add-lines-to-end-of-file-linux
# this adds the Oracle environment variables to the "oracle" user, but you may also want to add it to root or any other users
echo '. /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh' >> /home/oracle/.bash_profile