Quickly set up an Oracle environment on GCP

# Create the Oracle GCE instance
gcloud compute instances create oracle \
  --zone=us-central1-c \
  --machine-type=n1-standard-1 \
  --image-project=rhel-cloud --boot-disk-size=20GB \
  --image=rhel-7-v20190618 \
  --boot-disk-type=pd-standard \
  --boot-disk-device-name=oracle \
  --scopes=cloud-platform

# Connect to the Oracle VM
gcloud compute ssh --zone=us-central1-c oracle

# Copy the oracle binary, and use the binary that you downloaded at 
# this step, change it to your bucket, you can also upload it        
# manually using cloud shell
gsutil cp gs://oracle_xe_binaries/oracle-database-xe-18c-1.0-1.x86_64.rpm .

# Get the oracle pre install binary
curl -o oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm

# Install required binary
sudo yum -y localinstall oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm

# Install oracle
sudo rpm -ivh oracle-database-xe-18c-1.0-1.x86_64.rpm

# Create initial config
sudo /etc/init.d/oracle-xe-18c configure

# You will be prompted with the message: Specify a password to be   
# used for database accounts.

# Choose your password and save it
# Wait for the message: 
# Connect to Oracle Database using one of the connect strings

# Connect to the Oracle VM
gcloud compute ssh --zone=us-central1-c oracle

# Set up Oracle environment
export ORACLE_SID=XE 
export ORAENV_ASK=NO 
. /opt/oracle/product/18c/dbhomeXE/bin/oraenv

# You should receive the message: The Oracle base has been set to   
# /opt/oracle/product/18c/dbhomeXE

# Install git, press y when prompted
sudo yum install git

# Go to your home directory
cd ~

# Clone schema Repo
git clone https://github.com/oracle/db-sample-schemas.git

# Go to customers schema directory
cd ~/db-sample-schemas/customer_orders

# Start the Oracle sqlplus Session, change to your password
sqlplus system/YOURPASS@oracle/XEPDB1

# Run create schema and populate procedures
@co_main copw oracle/XEPDB1 users temp

# You should be presented with some query results, look for the     
# value: 433 rows selected
# Quit sqlplus
quit

# Get the zip from your bucket
gsutil cp gs://oracle_xe_binaries/instantclient-basic-linux.x64-19.5.0.0.0dbru.zip .

# Unzip it
unzip instantclient-basic-linux.x64-19.5.0.0.0dbru.zip

# Set Oracle library ENV Var on the unzip dir
export LD_LIBRARY_PATH=/oracleclient/bin/instantclient_19_5

# Get the zip from your bucket
gsutil cp gs://oracle_xe_binaries/instantclient-basic-macos.x64-19.3.0.0.0dbru.zip .

# Unzip it
unzip instantclient-basic-macos.x64-19.3.0.0.0dbru.zip

# Set Oracle library ENV Var on the unzip dir
export LD_LIBRARY_PATH=/oracleclient/bin/instantclient_19_3

# Start the Compute Engine VM
gcloud compute instances start oracle --zone=us-central1-c

# Connect to the Oracle VM
gcloud compute ssh --zone=us-central1-c oracle

# Start the oracle listener
sudo /etc/init.d/oracle-xe-18c start

# Wait for the message: Oracle Database instance XE started.