Before You Begin
Purpose
This tutorial shows you how to deploy a single-node Oracle Database and create a general-purpose database on Oracle Compute Cloud Service instances.
The topology of the installation can vary, depending on how many virtual machines (VMs) you provision as part of the installation.
Time to Complete
60 minutes for deployment without Chef
60 minutes for deployment using Chef
Background
Oracle Database is the first database designed for enterprise grid computing, the most flexible and cost-effective way to manage information and applications. Enterprise grid computing creates large pools of industry-standard, modular storage and servers. With this architecture, you can rapidly provision each new system from the pool of components. There’s no need to preallocate resources to accommodate peak workload, because you can easily add or reallocate capacity from the resource pools as needed.
Oracle Compute Cloud Service enables you to rapidly provision VMs on Oracle Cloud with the necessary storage and networking resources, manage and scale the virtual machine topology easily, and migrate your applications to Oracle Cloud.
Chef is a configuration management tool written in Ruby and Erlang. This tutorial uses Chef Server version 12 without any premium features like Chef Manage or Chef Reporting.
This tutorial describes the following deployment scenarios:
- Deploying Oracle Database 10.2.0.5 on a single Compute Service instance either by using custom scripts or by using Chef
- Deploying Oracle Database 11.2.0.4 or 12.1.0.2 on a single Compute Service instance by using Chef
What Do You Need?
General Requirements
- Subscription to Oracle Compute Cloud Service. See Getting Started with Oracle Cloud.
- Secure Shell (SSH) key with a bit size of 2048 or higher. See "Generating an SSH Key Pair" in the tutorial Creating Oracle Compute Cloud Service Instances Using an Orchestration.
Requirements for Deploying Oracle Database Without Chef
- Oracle Compute Cloud Service instances. See the tutorial Creating a Single Instance Using the Oracle Compute Cloud Service Web Console.
- Operating systems on your Oracle Compute Cloud Service instances:
- Oracle Database 10.2.0.5: Oracle Linux 5.11
- Oracle Database 11.2.0.4 and later: Oracle Linux 5.11 or Oracle Linux 6.6
- Storage volumes attached to the created instance:
- 30 GB storage volume mounted on the /u01 directory for the Oracle Home
- 10 GB storage volume mounted on /u02 for the data files
- 20 GB storage volume mounted on /u03 for the Flash Recovery Area
- 10 GB storage volume mounted on /u04 for the Redo Logs
- Scripts, cookbooks, and recipes to install the Chef server and Oracle databases. You can access the scripts, cookbooks, and recipes either from a GitHub repository or from Oracle Technology Network (OTN).
Requirements for Deploying Oracle Database with Chef
- A minimum of two Oracle Compute Cloud Service instances, one to deploy the Chef server and another to bootstrap the Chef client. See the tutorial Creating Oracle Compute Cloud Service Instances Using an Orchestration.
- Operating systems on your Oracle Compute Cloud Service instances:
- Chef server: Oracle Linux 6.6
- Chef client, Oracle Database 10.2.0.5: Oracle Linux 5.11
- Chef client, Oracle Database 11.2.0.4 and later: Oracle Linux 5.11 or Oracle Linux 6.6
- Storage volumes attached to the created instance:
- 30 GB storage volume mounted on the /u01 directory for the Oracle Home
- 10 GB storage volume mounted on /u02 for the data files
- 20 GB storage volume mounted on /u03 for the Flash Recovery Area
- 10 GB storage volume mounted on /u04 for the Redo Logs
- Scripts, cookbooks, and recipes to install the Chef server and Oracle databases. You can access the scripts, cookbooks, and recipes either from a GitHub repository or from Oracle Technology Network (OTN).
Deploying a Standalone Oracle Database 10.2.0.5
You can deploy a standalone Oracle Database 10.2.0.5 server on Oracle Compute Cloud Service instances by downloading and installing the installer binaries.
Performing Preinstallation Tasks
- Download the Oracle Database 10.2.0.5 installer.
- Download the latest OPatch patching tool.
- Download the recommended patch from My Oracle Support.
- Connect to the Oracle Compute Cloud Service environment by using an SSH.
- Install the Oracle RDBMS prerequisites.
- Transfer the downloaded installer and patches to the Oracle Compute Cloud Service instance.
- Mount the attached storage volumes.
Downloading the Oracle Database 10.2.0.5 Installer
The software is available as a media or FTP request for those customers who own a valid Oracle Database product license for any edition.
- Request access to these releases. See Oracle Support Document 1071023.1 (Requesting Physical Shipment or Download URL for Software Media) on My Oracle Support.
- On your local machine, create the
db
directory:mkdir /scratch/db
- Download the installer to
/scratch/db
. - Ensure that the following files are downloaded:
/scratch/db/B24792-01_1of5.zip
/scratch/db/V21262-01.zip
Downloading the OPatch Tool
- Open a web browser and go to:
- Select Oracle 10.2.0.0.0 from the Select a Release list.
- Select Linux x86-64 from the Platform or Language list.
- Ensure that the path to the downloaded file is
/scratch/db/p6880880_102000_Linux-x86-64.zip,
and then click Download.
Downloading the Recommended Patch
The patch is available as a compressed file for those customers who have valid My Oracle Support credentials.
- In your web browser, go to the home page of the 16619894 patch, and provide your My Oracle Support credentials.
- Select Linux x86-64 from the Platform list.
- Ensure that the path to the downloaded patch is
/scratch/db/p16619894_10205_Linux-x86-64.zip,
and click the Download.
Connecting to the Oracle Compute Cloud Service Environment Using SSH
You access the instance from your local machine by using the ssh
command in a UNIX command shell or from Windows by using Putty
.
- Sign in to the My Services application at http://cloud.oracle.com/sign_in. On the My Services Dashboard, click Consoles and select Oracle Compute Cloud Service. On the Oracle Compute Cloud Service Console, click the name of the instance and note down the IP address that appears in the instance details page.
- In a command shell, run the
ssh
utility:$> ssh -i path_to_SSH_private_key opc@IP_address_of_instance
In the preceding command:
path_to_SSH_private_key
is the path to the SSH private key file that matches the public key used when your instance was created.IP_address_of_instance
is the public IP address of the instance inn.n.n.n
format.opc
is the user account.Note: This step works only in Oracle-provided instances. You may have a different user provisioned in your custom instances.
For example:
$> ssh -i keys/id_rsa opc@192.0.2.100
- If this is the first time that you're connecting to the instance, confirm the RSA key fingerprint of the instance. In response to the prompts in the
ssh
utility, enteryes
, and then enter the passphrase for the SSH key (if you created a passphrase).
Installing the Oracle RDBMS Prerequisites
- By using your SSH key, log on to the Oracle Compute Cloud Service instance. See "Connecting to the Oracle Compute Cloud Service Instance Using SSH" in Performing Preinstallation Tasks in this tutorial.
- Install the prerequisites by using
yum
:sudo yum install -y oracle-validated
View Expected Outputsudo yum install -y oracle-rdbms-server-10gR2-preinstall Loaded plugins: refresh-packagekit, security Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package oracle-rdbms-server-11gR2-preinstall.x86_64 0:1.0-11.el6 will be installed --> Finished Dependency Resolution Dependencies Resolved ========================================================================================================================================================================================== Package Arch Version Repository Size ========================================================================================================================================================================================== Installing: oracle-rdbms-server-11gR2-preinstall x86_64 1.0-11.el6 public_ol6_latest 18 k Transaction Summary ========================================================================================================================================================================================== Install 1 Package(s) Total download size: 18 k Installed size: 44 k Downloading Packages: oracle-rdbms-server-11gR2-preinstall-1.0-11.el6.x86_64.rpm | 18 kB 00:00 Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Installing : oracle-rdbms-server-11gR2-preinstall-1.0-11.el6.x86_64 1/1 Verifying : oracle-rdbms-server-11gR2-preinstall-1.0-11.el6.x86_64 1/1 Installed: oracle-rdbms-server-11gR2-preinstall.x86_64 0:1.0-11.el6 Complete!
Transferring the Downloaded Installer and Patches to the Oracle Compute Cloud Service VM
- Create a directory to save the binaries, and then change the owner of the directory to the
oracle
user:sudo su - mkdir /scratch mkdir /scratch/db chmod -R 777 /scratch/db sudo chown -R oracle:oinstall /scratch/
- On your local machine, copy the downloaded binaries to the Oracle Compute Cloud Service instance:
scp -i path_to_SSH_private_key /scratch/db/B24792-01_1of5.zip opc@IP_address_of_VM:/scratch/db scp -i path_to_SSH_private_key /scratch/db/V21262-01.zip opc@IP_address_of_VM:/scratch/db scp -i path_to_SSH_private_key /scratch/db/p6880880_102000_Linux-x86-64.zip opc@IP_address_of_VM:/scratch/db scp -i path_to_SSH_private_key /scratch/db/p16619894_10205_Linux-x86-64.zip opc@IP_address_of_VM:/scratch/db
In the preceding command:
path_to_SSH_private_key
is the path to the SSH private key file that matches the public key used when your instance was created.opc
is the user account.
Mounting the Attached Additional Storage Volumes
- On the Oracle Compute Cloud Service instance, create the mount directories:
mkdir /u01 mkdir /u02 mkdir /u03 mkdir /u04
- List the partition tables of the attached storage volumes:
sudo su - fdisk -l
The four storage volumes aren’t partitioned.
View Expected OutputDisk /dev/xvda: 21.6 GB, 21689581568 bytes 255 heads, 63 sectors/track, 2636 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/xvda1 * 1 64 514048+ 83 Linux /dev/xvda2 65 586 4192965 82 Linux swap / Solaris /dev/xvda3 587 2636 16466625 83 Linux Disk /dev/xvdb: 10.7 GB, 10737418240 bytes 255 heads, 63 sectors/track, 1305 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Disk /dev/xvdb doesn't contain a valid partition table Disk /dev/xvdc: 21.4 GB, 21474836480 bytes 255 heads, 63 sectors/track, 2610 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Disk /dev/xvdc doesn't contain a valid partition table Disk /dev/xvdd: 32.2 GB, 32212254720 bytes 255 heads, 63 sectors/track, 3916 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Disk /dev/xvdd doesn't contain a valid partition table Disk /dev/xvde: 10.7 GB, 10737418240 bytes 255 heads, 63 sectors/track, 1305 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Disk /dev/xvde doesn't contain a valid partition table
In the previous output:
/dev/xvda
volume is for the operating system./dev/xvdb
volume is for the data files./dev/xvdc
volume is for the Flash Recovery Area./dev/xvdd
volume is for the Oracle Home./dev/xvde
volume is for the Redo Logs.
- Partition the
/dev/xvdb
storage volume:fdisk /dev/xvdb
- At the prompt, enter
o
,n
,p
,1
, press Enter twice, and then enterw
in sequence. - Repeat Steps 3 and 4 for the
xvdc
,xvdd
, andxvde
volumes. - View the partitioned volumes:
fdisk -l
View Expected OutputDisk /dev/xvda: 21.6 GB, 21689581568 bytes 255 heads, 63 sectors/track, 2636 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/xvda1 * 1 64 514048+ 83 Linux /dev/xvda2 65 586 4192965 82 Linux swap / Solaris /dev/xvda3 587 2636 16466625 83 Linux Disk /dev/xvdb: 10.7 GB, 10737418240 bytes 255 heads, 63 sectors/track, 1305 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/xvdb1 1 1305 10482381 83 Linux Disk /dev/xvdc: 21.4 GB, 21474836480 bytes 255 heads, 63 sectors/track, 2610 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/xvdc1 1 2610 20964793+ 83 Linux Disk /dev/xvdd: 32.2 GB, 32212254720 bytes 255 heads, 63 sectors/track, 3916 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/xvdd1 1 3916 31455238+ 83 Linux Disk /dev/xvde: 10.7 GB, 10737418240 bytes 255 heads, 63 sectors/track, 1305 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/xvde1 1 1305 10482381 83 Linux
- Create file system for each volume:
mkfs.ext4 -L DB_DATA /dev/xvdb1 mkfs.ext4 -L DB_FRA /dev/xvdc1 mkfs.ext4 -L DB_BITS /dev/xvdd1 mkfs.ext4 -L DB_REDO /dev/xvde1
- Add the mount point entries to
/etc/fstab
to make mounts persistent between reboots:echo "LABEL=DB_BITS /u01 ext4 defaults 0 0" >> /etc/fstab echo "LABEL=DB_DATA /u02 ext4 defaults 0 0" >> /etc/fstab echo "LABEL=DB_FRA /u03 ext4 defaults 0 0" >> /etc/fstab echo "LABEL=DB_REDO /u04 ext4 defaults 0 0" >> /etc/fstab
- Mount the file systems:
mount -a
- Verify the mounted file systems:
df -h
View Expected OutputFilesystem Size Used Avail Use% Mounted on /dev/xvda3 16G 4.5G 10G 31% / /dev/xvda1 487M 47M 415M 11% /boot tmpfs 59G 0 59G 0% /dev/shm /dev/xvdd1 30G 172M 28G 1% /u01 /dev/xvdb1 9.9G 151M 9.2G 2% /u02 /dev/xvdc1 20G 172M 19G 1% /u03 /dev/xvde1 9.9G 151M 9.2G 2% /u04
Installing Oracle Database 10.2.0.5 and Creating a Sample Database
- Log on to the Oracle Compute Cloud Service instance by using your SSH key. See "Connecting to the Oracle Compute Cloud Service Instance Using SSH" in Performing Preinstallation Tasks in this tutorial.
- Extract the binaries for the Oracle Home and all other relevant patches:
sudo su - oracle cd /scratch/db unzip -d /scratch/db/ora10201 /scratch/db/B24792-01_1of5.zip unzip -d /scratch/db /scratch/db/V21262-01.zip unzip -d /scratch/db/ora10205 /scratch/db/p8202632_10205_Linux-x86-64.zip unzip -d /scratch/db /scratch/db/p16619894_10205_Linux-x86-64.zip exit
- Install the Oracle Home binaries:
sudo mkdir -p /u01/app sudo chown oracle:oinstall /u01/app sudo su - sudo echo "inventory_loc=/u01/app/oraInventory" >> /etc/oraInst.loc sudo echo "inst_group=oinstall" >> /etc/oraInst.loc sudo chown oracle:oinstall /etc/oraInst.loc sudo chmod 664 /etc/oraInst.loc sudo su - oracle cd /scratch/db/ora10201/database ./runInstaller -ignoreSysPrereqs -silent FROM_LOCATION="/scratch/db/ora10201/database/stage/products.xml" ORACLE_HOME="/u01/app/oracle/product/10.2.0/dbhome_1" ORACLE_HOME_NAME="OraDb10g_home1" TOPLEVEL_COMPONENT='{"oracle.server","10.2.0.1.0"}' INSTALL_TYPE="EE" n_configurationOption=3 exit sudo /u01/app/oracle/product/10.2.0/dbhome_1/root.sh
- The
root.sh
script prompts you to specify the full path of the localbin
directory. For the purpose of this tutorial, press Enter. - Patch the Oracle Home to the 10.2.0.5 version:
sudo su - oracle cd /scratch/db/ora10205/Disk1 ./runInstaller -ignoreSysPrereqs -silent FROM_LOCATION="/scratch/db/ora10205/Disk1/stage/products.xml" ORACLE_HOME="/u01/app/oracle/product/10.2.0/dbhome_1" ORACLE_HOME_NAME="OraDb10g_home1" TOPLEVEL_COMPONENT='{"oracle.patchset.db","10.2.0.5.0"}' DECLINE_SECURITY_UPDATES=TRUE exit sudo /u01/app/oracle/product/10.2.0/dbhome_1/root.sh
- Install the latest OPatch tool, and apply the corresponding Patch Set Update file. At the
opatch
command prompt to enter your My Oracle Support credentials, press Enter, and then entery
at theIs the local system ready for patching?
command prompt.sudo su - oracle export ORACLE_HOME=/u01/app/oracle/product/10.2.0/dbhome_1 cd $ORACLE_HOME unzip -o /scratch/db/p6880880_102000_Linux-x86-64.zip cd /scratch/db/16619894 $ORACLE_HOME/OPatch/opatch apply
exit - Create a sample database as the
opc
user:sudo mkdir -p /u02/app/oracle/oradata sudo mkdir -p /u03/app/oracle/fast_recovery_area sudo chown oracle:oinstall /u02/app/oracle/oradata sudo chown oracle:oinstall /u03/app/oracle/fast_recovery_area sudo su - oracle export ORACLE_HOME=/u01/app/oracle/product/10.2.0/dbhome_1 export ORACLE_BASE=/u01/app/oracle $ORACLE_HOME/bin/dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname orcl -sid orcl -responseFile NO_VALUE -characterSet AL32UTF8 -memoryPercentage 50 -emConfiguration NONE -datafileDestination /u02/app/oracle/oradata -recoveryAreaDestination /u03/app/oracle/fast_recovery_area exit
- Create a default listener that will listen on the internal IP address at port
1521:
sudo su - oracle export ORACLE_HOME=/u01/app/oracle/product/10.2.0/dbhome_1 export ORACLE_BASE=/u01/app/oracle $ORACLE_HOME/bin/lsnrctl start exit
Validating the Database Server Installation
Log on to the database and validate the database instance:
sudo su - oracle
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/dbhome_1
export ORACLE_BASE=/u01/app/oracle
export ORACLE_SID=orcl
$ORACLE_HOME/bin/sqlplus / as sysdba
select * from v$instance;
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT
----------------- --------- ------------ --- ---------- ------- ---------------
LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO
---------- --- ----------------- ------------------ --------- ---
1 orcl
b1e4b7
10.2.0.5.0 24-JUN-15 OPEN NO 1 STOPPED
ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO
Deploying a Standalone Oracle Database 10.2.0.5 by Using Chef
You can deploy a single-node Oracle Database 10.2.0.5 server on Oracle Compute Cloud Service instances by using Chef.
Performing Preinstallation Tasks
- Download the Oracle Database 10.2.0.5 installer.
- Download the latest OPatch patching tool.
- Download the recommended patch from My Oracle Support.
- Connect to the Oracle Compute Cloud Service environments by using an SSH.
- Set up the Chef server.
- Transfer the downloaded installer and patches to the Oracle Compute Cloud Service instance.
- Mount the attached storage volumes.
Downloading the Oracle Database 10.2.0.5 Installer
The software is available as a media or FTP request for those customers who own a valid Oracle Database product license for any edition.
- Request access to these releases. See Oracle Support Document 1071023.1 (Requesting Physical Shipment or Download URL for Software Media) on My Oracle Support.
- On your local UNIX-based or Linux machine, create the
db
directory:mkdir /scratch/db
- Download the installer to
/scratch/db
. - Ensure that the following files are downloaded:
/scratch/db/B24792-01_1of5.zip
/scratch/db/V21262-01.zip
Downloading the OPatch Tool
- Open a web browser and go to:
- Select Oracle 10.2.0.0.0 from the Select a Release list.
- Select Linux x86-64 from the Platform or Language list.
- Ensure that the path to the downloaded file is
/scratch/db/p6880880_102000_Linux-x86-64.zip,
and then click Download.
Downloading the Recommended Patch
The patch is available as a compressed file for those customers who have valid My Oracle Support credentials.
- In your web browser, go to the home page of the 16619894 patch, and provide your My Oracle Support credentials.
- Select Linux x86-64 from the Platform list.
- Ensure that the path to the downloaded patch is
/scratch/db/p16619894_10205_Linux-x86-64.zip,
and click the Download.
Connecting to the Oracle Compute Cloud Service Environment Using SSH
You access the instance from your local machine by using the ssh
command in a UNIX command shell or from Windows by using Putty
.
- Sign in to the My Services application at http://cloud.oracle.com/sign_in. On the My Services Dashboard, click Consoles and select Oracle Compute Cloud Service. On the Oracle Compute Cloud Service Console, click the name of the instance and note down the IP address that appears in the instance details page.
- In a command shell, run the
ssh
utility:$> ssh -i path_to_SSH_private_key opc@IP_address_of_instance
In the preceding command:
path_to_SSH_private_key
is the path to the SSH private key file that matches the public key used when your instance was created.IP_address_of_instance
is the public IP address of the instance inn.n.n.n
format.opc
is the user account.Note: This step works only in Oracle-provided instances. You may have a different user provisioned in your custom instances.
For example:
$> ssh -i keys/id_rsa opc@192.0.2.100
- If this is the first time that you're connecting to the instance, confirm the RSA key fingerprint of the instance. In response to the prompts in the
ssh
utility, enteryes
, and then enter the passphrase for the SSH key (if you created a passphrase).
Setting Up the Chef Server
If you’re using Chef to deploy Oracle Database 10.2.0.5, then set up the Chef server and clone the GitHub repository. See the tutorial Deploying Chef Server on Oracle Compute Cloud Service Instances.
Transferring the Downloaded Installer and Patches to the Chef Server Instance
On your local machine, copy the downloaded binaries to the Oracle Compute Cloud Service instance that’s running the Chef server:scp -i path_to_SSH_private_key /scratch/db/B24792-01_1of5.zip opc@IP_address_of_Chef_Server_VM:/var/www/files scp -i path_to_SSH_private_key /scratch/db/V21262-01.zip opc@IP_address_of_Chef_Server_VM:/var/www/files scp -i path_to_SSH_private_key /scratch/db/p6880880_102000_Linux-x86-64.zip opc@IP_address_of_Chef_Server_VM:/var/www/files
scp -i path_to_SSH_private_key/scratch/db/p16619894_10205_Linux-x86-64.zip
opc@IP_address_of_Chef_Server_VM:/var/www/files
In the preceding command:
path_to_SSH_private_key
is the path to the SSH private key file that matches the public key used when your instance was created.IP_address_of_Chef_Server_VM
is the public IP address of the Chef server instance.opc
is the user account.
Mounting the Attached Additional Storage Volumes
- Using SSH, log on to the Oracle Compute Cloud Service instance that you designated as the Chef client, and create the mount directories:
sudo mkdir /u01 sudo mkdir /u02 sudo mkdir /u03 sudo mkdir /u04
- List the partition tables of the attached storage volumes:
sudo su - fdisk -l
The four storage volumes aren’t partitioned.
View Expected OutputDisk /dev/xvda: 21.6 GB, 21689581568 bytes 255 heads, 63 sectors/track, 2636 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/xvda1 * 1 64 514048+ 83 Linux /dev/xvda2 65 586 4192965 82 Linux swap / Solaris /dev/xvda3 587 2636 16466625 83 Linux Disk /dev/xvdb: 10.7 GB, 10737418240 bytes 255 heads, 63 sectors/track, 1305 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Disk /dev/xvdb doesn't contain a valid partition table Disk /dev/xvdc: 21.4 GB, 21474836480 bytes 255 heads, 63 sectors/track, 2610 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Disk /dev/xvdc doesn't contain a valid partition table Disk /dev/xvdd: 32.2 GB, 32212254720 bytes 255 heads, 63 sectors/track, 3916 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Disk /dev/xvdd doesn't contain a valid partition table Disk /dev/xvde: 10.7 GB, 10737418240 bytes 255 heads, 63 sectors/track, 1305 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Disk /dev/xvde doesn't contain a valid partition table
In the previous output:
/dev/xvda
volume is for the operating system./dev/xvdb
volume is for the data files./dev/xvdc
volume is for the Flash Recovery Area./dev/xvdd
volume is for the Oracle Home./dev/xvde
volume is for the Redo Logs.
- Partition the
/dev/xvdb
storage volume:fdisk /dev/xvdb
- At the prompt, enter
o
,n
,p
,1
, press Enter twice, and then enterw
in sequence. - Repeat Steps 3 and 4 for the
xvdc
,xvdd
, andxvde
volumes. - View the partitioned volumes:
fdisk -l
View Expected OutputDisk /dev/xvda: 21.6 GB, 21689581568 bytes 255 heads, 63 sectors/track, 2636 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/xvda1 * 1 64 514048+ 83 Linux /dev/xvda2 65 586 4192965 82 Linux swap / Solaris /dev/xvda3 587 2636 16466625 83 Linux Disk /dev/xvdb: 10.7 GB, 10737418240 bytes 255 heads, 63 sectors/track, 1305 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/xvdb1 1 1305 10482381 83 Linux Disk /dev/xvdc: 21.4 GB, 21474836480 bytes 255 heads, 63 sectors/track, 2610 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/xvdc1 1 2610 20964793+ 83 Linux Disk /dev/xvdd: 32.2 GB, 32212254720 bytes 255 heads, 63 sectors/track, 3916 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/xvdd1 1 3916 31455238+ 83 Linux Disk /dev/xvde: 10.7 GB, 10737418240 bytes 255 heads, 63 sectors/track, 1305 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/xvde1 1 1305 10482381 83 Linux
- Create file system for each volume:
mkfs.ext4 -L DB_DATA /dev/xvdb1 mkfs.ext4 -L DB_FRA /dev/xvdc1 mkfs.ext4 -L DB_BITS /dev/xvdd1 mkfs.ext4 -L DB_REDO /dev/xvde1
- Add the mount point entries to
/etc/fstab
to make mounts persistent between reboots:echo "LABEL=DB_BITS /u01 ext4 defaults 0 0" >> /etc/fstab echo "LABEL=DB_DATA /u02 ext4 defaults 0 0" >> /etc/fstab echo "LABEL=DB_FRA /u03 ext4 defaults 0 0" >> /etc/fstab echo "LABEL=DB_REDO /u04 ext4 defaults 0 0" >> /etc/fstab
- Mount the file systems:
mount -a
- Verify the mounted file systems:
df -h
View Expected OutputFilesystem Size Used Avail Use% Mounted on /dev/xvda3 16G 4.5G 10G 31% / /dev/xvda1 487M 47M 415M 11% /boot tmpfs 59G 0 59G 0% /dev/shm /dev/xvdd1 30G 172M 28G 1% /u01 /dev/xvdb1 9.9G 151M 9.2G 2% /u02 /dev/xvdc1 20G 172M 19G 1% /u03 /dev/xvde1 9.9G 151M 9.2G 2% /u04
Deploying Oracle Database 10.2.0.5
- Ensure that the Oracle Compute Cloud Service instances are created. See the tutorial Creating Oracle Compute Cloud Service Instances Using an Orchestration.
- Use SSH to connect to the Chef server instance. See "Connecting to the Oracle Compute Cloud Service Instance Using SSH" in Performing Preinstallation Steps in this tutorial.
- Prepare the environment. See the following sections in the tutorial Deploying Chef Server on Oracle Compute Cloud Service Instances:
- "Installing the git Client" (Install it on your Oracle Compute Cloud Service instance where the Chef server should run.)
- "Configuring a Passwordless SSH Connection”
- "Setting Up the Chef Server" (step 2, clone the GitHub repository)
Alternatively, you can download the scripts that are required to set up the Chef server from the following link:
http://www.oracle.com/technetwork/topics/cloud/whatsnew/compute-cloud-service-2760092.html
- "Setting Up the Chef Server" (step 5, install the Chef server)
- Check out the Oracle Database recipe from the GitHub repository:
cd ~/compute-cloud-service-demos/ git checkout chef-oracle-database
The command checks out all cookbooks, roles and environments required to deploy Oracle Database 10.2.0.5.
Alternatively, you can download the scripts that are required to set up the Oracle Database 10.2.0.5 from the following link:
http://www.oracle.com/technetwork/topics/cloud/whatsnew/compute-cloud-service-2760092.html
Unpack the scripts to the
compute-cloud-service-demos
folder:tar -xvzf chef-oracle-database-compute-cloud-service-demos.tgz -C <path to the compute-cloud-service-demos folder>
- Open the
src/chef-repo/cookbooks/oracle-database/attributes/default.rb
file in an editor. - For the
csi
andemail
attributes, enter your valid Customer Support Identifier (CSI) and email address:default['oracle']['csi'] = '<Customer CSI>' default['oracle']['email'] = '<Customer Email>'
You can modify the other attributes based on your requirements.
- 9. Verify that the following attribute values match the installer and patch file names, and then save and close the file:
default['oracle']['db_installer_zip'] = 'B24792-01_1of5.zip' default['oracle']['patch_installer_zip'] = 'V21262-01.zip' default['oracle']['patch_installer_inner_zip'] = 'p8202632_10205_Linux-x86-64.zip' default['oracle']['opatch_installer_zip'] = 'p6880880_102000_Linux-x86-64.zip' default['oracle']['psu_installer_zip'] = 'p16619894_10205_Linux-x86-64.zip'
- Upload the checked-out cookbooks, roles, and environments to the Chef server:
mkdir ../chef-repo/ cp -rp src/chef-repo/* ../chef-repo/ knife cookbook upload -a knife upload /roles knife upload /environments
- Verify that you updated the permissions on your Chef client instance and that you bootstrapped the instance. See "Bootstrapping the Chef Clients" and "Updating Node Permissions" in the tutorial Deploying Chef Server on Oracle Compute Cloud Service Instances.
- Add
run-list
items to the client. (Run-list is an ordered list of roles or recipes or both that is run in the exact defined order.)knife node run_list add target.instance.dns.name 'role[oracle_database_10205]'
In the previous example,
target.instance.dns.name
is the domain name system (DNS) name of the Oracle Compute Cloud Service instance (running the Chef client, and that you've bootstrapped) where Oracle Database 10.2.0.5 will be deployed.View Expected Outputknife node run_list add <the DNS name of your Compute Service instance where the Chef client will run> 'role[oracle_database_10205]' <the DNS name of your Compute Service instance where the Chef client will run>: run_list: role[oracle_database_10205]
- Deploy Oracle Database 10.2.0.5 on the bootstrapped client instance:
knife ssh -x opc 'role:oracle_database_10205' 'sudo chef-client'
After the Oracle Database 10.2.0.5 deployment is completed, the following message is displayed:
Chef Client finished, <x/y> resources updated in <n> seconds
Validating the Database Server Installation
Log on to the database and validate the database instance:
sudo su - oracle
. oraenv
ORACLE_SID = [oracle] ? orcl
The Oracle base has been set to /u01/app/oracle
$> sqlplus / as sysdba
SQL> select * from v$instance;
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT
----------------- --------- ------------ --- ---------- ------- ---------------
LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO
---------- --- ----------------- ------------------ --------- ---
1 orcl
b1e4b7
10.2.0.5.0 24-JUN-15 OPEN NO 1 STOPPED
ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO
Deploying a Standalone Oracle Database 11.2.0.4 by Using Chef
You can deploy a single-node Oracle Database 11.2.0.4 server on Oracle Compute Cloud Service instances by using Chef.
Performing Preinstallation Tasks
- Download the Oracle Database 11.2.0.4 installer and the patch files from My Oracle Support.
- Download the latest OPatch patching tool from My Oracle Support.
- Connect to the Oracle Compute Cloud Service environments by using an SSH.
- Set up the Chef server.
- Transfer the downloaded installer and patches to the Oracle Compute Cloud Service instance.
- Mount the attached storage volumes.
Downloading the Oracle Database 11.2.0.4 Installer and Patch Files
- On your local UNIX-based or Linux machine, create the
db
directory:mkdir /scratch/db
- Open a web browser and download the following files from My Oracle Support to
/scratch/db
by providing your My Oracle Support credentials.
Downloading the OPatch Tool
- Open a web browser and go to:
- Select Oracle 11.2.0.0.0 from the Select a Release list.
- Select Linux x86-64 from the Platform or Language list.
- Ensure that the path to the downloaded file is
/scratch/db/p6880880_112000_Linux-x86-64.zip,
and then click Download.
Connecting to the Oracle Compute Cloud Service Environment Using SSH
You access the instance from your local machine by using the ssh
command in a UNIX command shell or from Windows by using Putty
.
- Sign in to the My Services application at http://cloud.oracle.com/sign_in. On the My Services Dashboard, click Consoles and select Oracle Compute Cloud Service. On the Oracle Compute Cloud Service Console, click the name of the instance and note down the IP address that appears in the instance details page.
- In a command shell, run the
ssh
utility:$> ssh -i path_to_SSH_private_key opc@IP_address_of_instance
In the preceding command:
path_to_SSH_private_key
is the path to the SSH private key file that matches the public key used when your instance was created.IP_address_of_instance
is the public IP address of the instance inn.n.n.n
format.opc
is the user account.Note: This step works only in Oracle-provided instances. You may have a different user provisioned in your custom instances.
For example:
$> ssh -i keys/id_rsa opc@192.0.2.100
- If this is the first time that you're connecting to the instance, confirm the RSA key fingerprint of the instance. In response to the prompts in the
ssh
utility, enteryes
, and then enter the passphrase for the SSH key (if you created a passphrase).
Setting Up the Chef Server
If you’re using Chef to deploy Oracle Database 11.2.0.4, then set up the Chef server and clone the GitHub repository. See the tutorial Deploying Chef Server on Oracle Compute Cloud Service Instances.
Transferring the Downloaded Installer and Patches to the Chef Server Instance
On your local machine, copy the downloaded binaries to the Oracle Compute Cloud Service instance that’s running the Chef server:
scp -i path_to_SSH_private_key /scratch/db/p13390677_112040_Linux-x86-64_1of7.zip opc@IP_address_of_Chef_Server_instance:/var/www/files scp -i path_to_SSH_private_key /scratch/db/p13390677_112040_Linux-x86-64_2of7.zip opc@IP_address_of_Chef_Server_instance:/var/www/files scp -i path_to_SSH_private_key /scratch/db/p20299013_112040_Linux-x86-64.zip opc@IP_address_of_Chef_Server_instance:/var/www/files
scp -i path_to_SSH_private_key/scratch/db/p20406239_112040_Linux-x86-64.zip
opc@IP_address_of_Chef_Server_instance:/var/www/files scp -i path_to_SSH_private_key
/scratch/db/p6880880_112000_Linux-x86-64.zip
opc@IP_address_of_Chef_Server_instance:/var/www/files
In the preceding command:
path_to_SSH_private_key
is the path to the SSH private key file that matches the public key used when your instance was created.IP_address_of_Chef_Server_VM
is the public IP address of the Chef server instance.opc
is the user account.
Mounting the Attached Additional Storage Volumes
- Using SSH, log on to the Oracle Compute Cloud Service instance that you designated as the Chef client, and create the mount directories:
sudo mkdir /u01 sudo mkdir /u02 sudo mkdir /u03 sudo mkdir /u04
- List the partition tables of the attached storage volumes:
sudo su - fdisk -l
The four storage volumes aren’t partitioned.
View Expected OutputDisk /dev/xvda: 21.6 GB, 21689581568 bytes 255 heads, 63 sectors/track, 2636 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/xvda1 * 1 64 514048+ 83 Linux /dev/xvda2 65 586 4192965 82 Linux swap / Solaris /dev/xvda3 587 2636 16466625 83 Linux Disk /dev/xvdb: 10.7 GB, 10737418240 bytes 255 heads, 63 sectors/track, 1305 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Disk /dev/xvdb doesn't contain a valid partition table Disk /dev/xvdc: 21.4 GB, 21474836480 bytes 255 heads, 63 sectors/track, 2610 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Disk /dev/xvdc doesn't contain a valid partition table Disk /dev/xvdd: 32.2 GB, 32212254720 bytes 255 heads, 63 sectors/track, 3916 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Disk /dev/xvdd doesn't contain a valid partition table Disk /dev/xvde: 10.7 GB, 10737418240 bytes 255 heads, 63 sectors/track, 1305 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Disk /dev/xvde doesn't contain a valid partition table
In the previous output:
/dev/xvda
volume is for the operating system./dev/xvdb
volume is for the data files./dev/xvdc
volume is for the Flash Recovery Area./dev/xvdd
volume is for the Oracle Home./dev/xvde
volume is for the Redo Logs.
- Partition the
/dev/xvdb
storage volume:fdisk /dev/xvdb
- At the prompt, enter
o
,n
,p
,1
, press Enter twice, and then enterw
in sequence. - Repeat Steps 3 and 4 for the
xvdc
,xvdd
, andxvde
volumes. - View the partitioned volumes:
fdisk -l
View Expected OutputDisk /dev/xvda: 21.6 GB, 21689581568 bytes 255 heads, 63 sectors/track, 2636 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/xvda1 * 1 64 514048+ 83 Linux /dev/xvda2 65 586 4192965 82 Linux swap / Solaris /dev/xvda3 587 2636 16466625 83 Linux Disk /dev/xvdb: 10.7 GB, 10737418240 bytes 255 heads, 63 sectors/track, 1305 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/xvdb1 1 1305 10482381 83 Linux Disk /dev/xvdc: 21.4 GB, 21474836480 bytes 255 heads, 63 sectors/track, 2610 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/xvdc1 1 2610 20964793+ 83 Linux Disk /dev/xvdd: 32.2 GB, 32212254720 bytes 255 heads, 63 sectors/track, 3916 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/xvdd1 1 3916 31455238+ 83 Linux Disk /dev/xvde: 10.7 GB, 10737418240 bytes 255 heads, 63 sectors/track, 1305 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/xvde1 1 1305 10482381 83 Linux
- Create file system for each volume:
mkfs.ext4 -L DB_DATA /dev/xvdb1 mkfs.ext4 -L DB_FRA /dev/xvdc1 mkfs.ext4 -L DB_BITS /dev/xvdd1 mkfs.ext4 -L DB_REDO /dev/xvde1
- Add the mount point entries to
/etc/fstab
to make mounts persistent between reboots:echo "LABEL=DB_BITS /u01 ext4 defaults 0 0" >> /etc/fstab echo "LABEL=DB_DATA /u02 ext4 defaults 0 0" >> /etc/fstab echo "LABEL=DB_FRA /u03 ext4 defaults 0 0" >> /etc/fstab echo "LABEL=DB_REDO /u04 ext4 defaults 0 0" >> /etc/fstab
- Mount the file systems:
mount -a
- Verify the mounted file systems:
df -h
View Expected OutputFilesystem Size Used Avail Use% Mounted on /dev/xvda3 16G 4.5G 10G 31% / /dev/xvda1 487M 47M 415M 11% /boot tmpfs 59G 0 59G 0% /dev/shm /dev/xvdd1 30G 172M 28G 1% /u01 /dev/xvdb1 9.9G 151M 9.2G 2% /u02 /dev/xvdc1 20G 172M 19G 1% /u03 /dev/xvde1 9.9G 151M 9.2G 2% /u04
Deploying Oracle Database 11.2.0.4
- Ensure that the Oracle Compute Cloud Service instances are created. See the tutorial Creating Oracle Compute Cloud Service Instances Using an Orchestration.
- Use SSH to connect to the Chef server instance. See "Connecting to the Oracle Compute Cloud Service Instance Using SSH" in Performing Preinstallation Steps in this tutorial.
- Prepare the environment. See the following sections in the tutorial Deploying Chef Server on Oracle Compute Cloud Service Instances:
- "Installing the git Client" (Install it on your Oracle Compute Cloud Service instance where the Chef server should run.)
- "Configuring a Passwordless SSH Connection”
- "Setting Up the Chef Server" (step 2, clone the GitHub repository)
Alternatively, you can download the scripts that are required to set up the Chef server from the following link:
http://www.oracle.com/technetwork/topics/cloud/whatsnew/compute-cloud-service-2760092.html
- "Setting Up the Chef Server" (step 5, install the Chef server)
- Check out the Oracle Database recipe from the GitHub repository:
cd ~/compute-cloud-service-demos/ git checkout chef-oracle-database
The command checks out all cookbooks, roles and environments required to deploy Oracle Database 11.2.0.4.
Alternatively, you can download the scripts that are required to set up the Oracle Database 11.2.0.4 from the following link:
http://www.oracle.com/technetwork/topics/cloud/whatsnew/compute-cloud-service-2760092.html
Unpack the scripts to thecompute-cloud-service-demos
folder:tar -xvzf chef-oracle-database-compute-cloud-service-demos.tgz -C <path to the compute-cloud-service-demos folder>
- Open the
src/chef-repo/cookbooks/oracle-database/attributes/default.rb
file in an editor. - For the
csi
andemail
attributes, enter your valid Customer Support Identifier (CSI) and email address:default['oracle']['csi'] = '<Customer CSI>' default['oracle']['email'] = '<Customer Email>'
You can modify the other attributes based on your requirements.
- Verify that the attribute values match the installer and patch file names, and then save and close the file.
- Upload the checked-out cookbooks, roles, and environments to the Chef server:
mkdir ../chef-repo/ cp -rp src/chef-repo/* ../chef-repo/ knife cookbook upload -a knife upload /roles knife upload /environments
- Verify that you updated the permissions on your Chef client instance and that you bootstrapped the instance. See "Bootstrapping the Chef Clients" and "Updating Node Permissions" in the tutorial Deploying Chef Server on Oracle Compute Cloud Service Instances.
- Add
run-list
items to the client. (Run-list is an ordered list of roles or recipes or both that is run in the exact defined order.)knife node run_list add target.instance.dns.name 'role[oracle_database_11204]'
In the previous example,
target.instance.dns.name
is the domain name system (DNS) name of the Oracle Compute Cloud Service instance (running the Chef client, and that you've bootstrapped) where Oracle Database 11.2.0.4 will be deployed.View Expected Outputknife node run_list add <the DNS name of your Compute Service instance where the Chef client will run> 'role[oracle_database_10205]' <the DNS name of your Compute Service instance where the Chef client will run>: run_list: role[oracle_database_11204]
- Deploy Oracle Database 11.2.0.4 on the bootstrapped client instance:
knife ssh -x opc 'role:oracle_database_11204' 'sudo chef-client'
After the Oracle Database 11.2.0.4 deployment is completed, the following message is displayed:
Chef Client finished, <x/y> resources updated in <n> seconds
Validating the Database Server Installation
Log on to the database and validate the database instance:
sudo su - oracle
. oraenv
ORACLE_SID = [oracle] ? orcl
The Oracle base has been set to /u01/app/oracle
$> sqlplus / as sysdba
SQL> select * from v$instance;
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT
----------------- --------- ------------ --- ---------- ------- ---------------
LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO
---------- --- ----------------- ------------------ --------- ---
1 orcl
b1e4b7
11.2.0.4.0 24-JUN-15 OPEN NO 1 STOPPED
ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO
Deploying a Standalone Oracle Database 12.1.0.2 by Using Chef
You can deploy a single-node Oracle Database 12.1.0.2 server on Oracle Compute Cloud Service instances by using Chef.
Performing Preinstallation Tasks
- Download the Oracle Database 12.1.0.2 installer and the patch files from My Oracle Support.
- Download the latest OPatch patching tool from My Oracle Support.
- Connect to the Oracle Compute Cloud Service environments by using an SSH.
- Set up the Chef server.
- Transfer the downloaded installer and patches to the Oracle Compute Cloud Service instance.
- Mount the attached storage volumes.
Downloading the Oracle Database 12.1.0.2 Installer and Patch Files
- On your local UNIX-based or Linux machine, create the
db
directory:mkdir /scratch/db
- Open a web browser and download the following files from My Oracle Support to
/scratch/db
by providing your My Oracle Support credentials.
Downloading the OPatch Tool
- Open a web browser and go to:
- Select Oracle 12.1.0.1.0 from the Select a Release list.
- Select Linux x86-64 from the Platform or Language list.
- Ensure that the path to the downloaded file is
/scratch/db/p6880880_121010_Linux-x86-64.zip,
and then click Download.
Connecting to the Oracle Compute Cloud Service Environment Using SSH
You access the instance from your local machine by using the ssh
command in a UNIX command shell or from Windows by using Putty
.
- Sign in to the My Services application at http://cloud.oracle.com/sign_in. On the My Services Dashboard, click Consoles and select Oracle Compute Cloud Service. On the Oracle Compute Cloud Service Console, click the name of the instance and note down the IP address that appears in the instance details page.
- In a command shell, run the
ssh
utility:$> ssh -i path_to_SSH_private_key opc@IP_address_of_instance
In the preceding command:
path_to_SSH_private_key
is the path to the SSH private key file that matches the public key used when your instance was created.IP_address_of_instance
is the public IP address of the instance inn.n.n.n
format.opc
is the user account.Note: This step works only in Oracle-provided instances. You may have a different user provisioned in your custom instances.
For example:
$> ssh -i keys/id_rsa opc@192.0.2.100
- If this is the first time that you're connecting to the instance, confirm the RSA key fingerprint of the instance. In response to the prompts in the
ssh
utility, enteryes
, and then enter the passphrase for the SSH key (if you created a passphrase).
Setting Up the Chef Server
If you’re using Chef to deploy Oracle Database 12.1.0.2, then set up the Chef server and clone the GitHub repository. See the tutorial Deploying Chef Server on Oracle Compute Cloud Service Instances.
Transferring the Downloaded Installer and Patches to the Chef Server Instance
On your local machine, copy the downloaded binaries to the Oracle Compute Cloud Service instance that’s running the Chef server:
scp -i path_to_SSH_private_key /scratch/db/p17694377_121020_Linux-x86-64_1of8.zip opc@IP_address_of_Chef_Server_instance:/var/www/files scp -i path_to_SSH_private_key /scratch/db/p17694377_121020_Linux-x86-64_2of8.zip opc@IP_address_of_Chef_Server_instance:/var/www/files scp -i path_to_SSH_private_key /scratch/db/p17694377_121020_Linux-x86-64_3of8.zip opc@IP_address_of_Chef_Server_instance:/var/www/files
scp -i path_to_SSH_private_key/scratch/db/p20834538_121020_Linux-x86-64.zip
opc@IP_address_of_Chef_Server_instance:/var/www/files scp -i path_to_SSH_private_key
/scratch/db/p6880880_121010_Linux-x86-64.zip
opc@IP_address_of_Chef_Server_instance:/var/www/files
In the preceding command:
path_to_SSH_private_key
is the path to the SSH private key file that matches the public key used when your instance was created.IP_address_of_Chef_Server_VM
is the public IP address of the Chef server instance.opc
is the user account.
Mounting the Attached Additional Storage Volumes
- Using SSH, log on to the Oracle Compute Cloud Service instance that you designated as the Chef client, and create the mount directories:
sudo mkdir /u01 sudo mkdir /u02 sudo mkdir /u03 sudo mkdir /u04
- List the partition tables of the attached storage volumes:
sudo su - fdisk -l
The four storage volumes aren’t partitioned.
View Expected OutputDisk /dev/xvda: 21.6 GB, 21689581568 bytes 255 heads, 63 sectors/track, 2636 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/xvda1 * 1 64 514048+ 83 Linux /dev/xvda2 65 586 4192965 82 Linux swap / Solaris /dev/xvda3 587 2636 16466625 83 Linux Disk /dev/xvdb: 10.7 GB, 10737418240 bytes 255 heads, 63 sectors/track, 1305 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Disk /dev/xvdb doesn't contain a valid partition table Disk /dev/xvdc: 21.4 GB, 21474836480 bytes 255 heads, 63 sectors/track, 2610 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Disk /dev/xvdc doesn't contain a valid partition table Disk /dev/xvdd: 32.2 GB, 32212254720 bytes 255 heads, 63 sectors/track, 3916 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Disk /dev/xvdd doesn't contain a valid partition table Disk /dev/xvde: 10.7 GB, 10737418240 bytes 255 heads, 63 sectors/track, 1305 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Disk /dev/xvde doesn't contain a valid partition table
In the previous output:
/dev/xvda
volume is for the operating system./dev/xvdb
volume is for the data files./dev/xvdc
volume is for the Flash Recovery Area./dev/xvdd
volume is for the Oracle Home./dev/xvde
volume is for the Redo Logs.
- Partition the
/dev/xvdb
storage volume:fdisk /dev/xvdb
- At the prompt, enter
o
,n
,p
,1
, press Enter twice, and then enterw
in sequence. - Repeat Steps 3 and 4 for the
xvdc
,xvdd
, andxvde
volumes. - View the partitioned volumes:
fdisk -l
View Expected OutputDisk /dev/xvda: 21.6 GB, 21689581568 bytes 255 heads, 63 sectors/track, 2636 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/xvda1 * 1 64 514048+ 83 Linux /dev/xvda2 65 586 4192965 82 Linux swap / Solaris /dev/xvda3 587 2636 16466625 83 Linux Disk /dev/xvdb: 10.7 GB, 10737418240 bytes 255 heads, 63 sectors/track, 1305 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/xvdb1 1 1305 10482381 83 Linux Disk /dev/xvdc: 21.4 GB, 21474836480 bytes 255 heads, 63 sectors/track, 2610 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/xvdc1 1 2610 20964793+ 83 Linux Disk /dev/xvdd: 32.2 GB, 32212254720 bytes 255 heads, 63 sectors/track, 3916 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/xvdd1 1 3916 31455238+ 83 Linux Disk /dev/xvde: 10.7 GB, 10737418240 bytes 255 heads, 63 sectors/track, 1305 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/xvde1 1 1305 10482381 83 Linux
- Create file system for each volume:
mkfs.ext4 -L DB_DATA /dev/xvdb1 mkfs.ext4 -L DB_FRA /dev/xvdc1 mkfs.ext4 -L DB_BITS /dev/xvdd1 mkfs.ext4 -L DB_REDO /dev/xvde1
- Add the mount point entries to
/etc/fstab
to make mounts persistent between reboots:echo "LABEL=DB_BITS /u01 ext4 defaults 0 0" >> /etc/fstab echo "LABEL=DB_DATA /u02 ext4 defaults 0 0" >> /etc/fstab echo "LABEL=DB_FRA /u03 ext4 defaults 0 0" >> /etc/fstab echo "LABEL=DB_REDO /u04 ext4 defaults 0 0" >> /etc/fstab
- Mount the file systems:
mount -a
- Verify the mounted file systems:
df -h
View Expected OutputFilesystem Size Used Avail Use% Mounted on /dev/xvda3 16G 4.5G 10G 31% / /dev/xvda1 487M 47M 415M 11% /boot tmpfs 59G 0 59G 0% /dev/shm /dev/xvdd1 30G 172M 28G 1% /u01 /dev/xvdb1 9.9G 151M 9.2G 2% /u02 /dev/xvdc1 20G 172M 19G 1% /u03 /dev/xvde1 9.9G 151M 9.2G 2% /u04
Deploying Oracle Database 12.1.0.2
- Ensure that the Oracle Compute Cloud Service instances are created. See the tutorial Creating Oracle Compute Cloud Service Instances Using an Orchestration.
- Use SSH to connect to the Chef server instance. See "Connecting to the Oracle Compute Cloud Service Instance Using SSH" in Performing Preinstallation Steps in this tutorial.
- Prepare the environment. See the following sections in the tutorial Deploying Chef Server on Oracle Compute Cloud Service Instances:
- "Installing the git Client" (Install it on your Oracle Compute Cloud Service instance where the Chef server should run.)
- "Configuring a Passwordless SSH Connection”
- "Setting Up the Chef Server" (step 2, clone the GitHub repository)
Alternatively, you can download the scripts that are required to set up the Chef server from the following link:
http://www.oracle.com/technetwork/topics/cloud/whatsnew/compute-cloud-service-2760092.html
- "Setting Up the Chef Server" (step 5, install the Chef server)
- Check out the Oracle Database recipe from the GitHub repository:
cd ~/compute-cloud-service-demos/ git checkout chef-oracle-database
The command checks out all cookbooks, roles and environments required to deploy Oracle Database 12.1.0.2.
Alternatively, you can download the scripts that are required to set up the Oracle Database 12.1.0.2 from the following link:
http://www.oracle.com/technetwork/topics/cloud/whatsnew/compute-cloud-service-2760092.html
Unpack the scripts to thecompute-cloud-service-demos
folder:tar -xvzf chef-oracle-database-compute-cloud-service-demos.tgz -C <path to the compute-cloud-service-demos folder>
- Open the
src/chef-repo/cookbooks/oracle-database/attributes/default.rb
file in an editor. - For the
csi
andemail
attributes, enter your valid Customer Support Identifier (CSI) and email address:default['oracle']['csi'] = '<Customer CSI>' default['oracle']['email'] = '<Customer Email>'
You can modify the other attributes based on your requirements.
- Verify that the attribute values match the installer and patch file names, and then save and close the file.
- Upload the checked-out cookbooks, roles, and environments to the Chef server:
mkdir ../chef-repo/ cp -rp src/chef-repo/* ../chef-repo/ knife cookbook upload -a knife upload /roles knife upload /environments
- Verify that you updated the permissions on your Chef client instance and that you bootstrapped the instance. See "Bootstrapping the Chef Clients" and "Updating Node Permissions" in the tutorial Deploying Chef Server on Oracle Compute Cloud Service Instances.
- Add
run-list
items to the client. (Run-list is an ordered list of roles or recipes or both that is run in the exact defined order.)knife node run_list add target.instance.dns.name 'role[oracle_database_12102]'
In the previous example,
target.instance.dns.name
is the domain name system (DNS) name of the Oracle Compute Cloud Service instance (running the Chef client, and that you've bootstrapped) where Oracle Database 12.1.0.2 will be deployed.View Expected Outputknife node run_list add <the DNS name of your Compute Service instance where the Chef client will run> 'role[oracle_database_10205]' <the DNS name of your Compute Service instance where the Chef client will run>: run_list: role[oracle_database_12102]
- Deploy Oracle Database 12.1.0.2 on the bootstrapped client instance:
knife ssh -x opc 'role:oracle_database_12102' 'sudo chef-client'
After the Oracle Database 12.1.0.2 deployment is completed, the following message is displayed:
Chef Client finished, <x/y> resources updated in <n> seconds
Validating Database Server Installation
Log on to the database and validate the database instance:
sudo su - oracle
. oraenv
ORACLE_SID = [oracle] ? orcl
The Oracle base has been set to /u01/app/oracle
$> sqlplus / as sysdba
SQL> select * from v$instance;
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT
----------------- --------- ------------ --- ---------- ------- ---------------
LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO
---------- --- ----------------- ------------------ --------- ---
1 orcl
b1e4b7
12.1.0.2.0 24-JUN-15 OPEN NO 1 STOPPED
ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO
Want to Learn More?
Credits
- Lead Curriculum Developer: Anirban Ghosh
- Other Contributors: Roland Koenn, Edward Huang, Irina Mok