This section provides information about the content and configuration of a newly created Oracle Database Cloud - Database as a Service instance at the Oracle Database Cloud Service - Virtual Image service level.
Topics
• Virtual Machine and System Characteristics
• Oracle Compute Cloud Service Resources
Virtual Machine and System Characteristics
When an Oracle Database Cloud - Database as a Service instance is created at the Oracle Database Cloud Service - Virtual Image service level, a virtual machine is created and configured as the compute node.
Topics
• User Accounts
• Environment Variables
• Network Access
• File System Layout
• Locations of Installed Software User Accounts
The Database as a Service compute node is provisioned with the following operating system user accounts.
User Description
opc The system administrator account you use with the sudo command to perform
operations that require root-user access.
oracle The Oracle Database administrator account you use to access the system and
perform non-root database administration tasks. A home directory, /home/ oracle, is created for this user. This user cannot use the sudo command to
perform operations that require root-user access.
root The root administrator for the system. You do not have direct access to this
account. To perform operations that require root-user access, use the sudo
command as the opc user.
Environment Variables
The following environment variables are created for the opc and oracle users.
Variable Description
HOME The home directory of the user, either /home/opc or /home/oracle. HOSTNAME The host name of the compute node.
LANG The system language, en_US.UTF-8. OH Short form for ORACLE_HOME. ORACLE_HO
ME
The Oracle Database home directory:
• For Oracle Database 12c, /u01/app/oracle/product/12.1.0/ dbhome_1
• For Oracle Database 11g, /u01/app/oracle/product/11.2.0/ dbhome_1
ORACLE_SI D
The database system identifier (SID) provided when the instance was created.
Variable Description
PATH The paths to search for executables; set to include:
• /sbin • /usr/sbin • /bin • /usr/bin • $ORACLE_HOME/bin • $ORACLE_HOME/OPatch • $HOME
SHELL The default shell, /bin/bash. USER The user name, either opc or oracle.
Network Access
When a Database as a Service instance is created, compute node network access is limited to Secure Shell (SSH) connections on port 22 by default. This access restriction ensures that the instance is secure by default. To access other ports, you can create an SSH tunnel to the port or you can enable access to the port using the Oracle Compute Cloud Service console. For more information, see:
• Creating an SSH Tunnel to a Compute Node Port
• Enabling Access to a Compute Node Port File System Layout
When a service instance is created using the Oracle Database Cloud Service - Virtual Image service level, Oracle Cloud Service storage volumes are created and allocated as follows.
File System Mount Description
swap Swap space; 4 GB allocated from the boot Compute Cloud storage volume.
/ (root) Operating system files; 15.8 GB allocated from the boot Compute
Cloud storage volume.
/boot Operating system kernel; 200 MB allocated from the boot Compute
Cloud storage volume.
Locations of Installed Software
When a service instance is created using the Oracle Database Cloud Service - Virtual Image service level, a GZIP file containing the version of the Oracle Database software chosen when the instance was created is stored in /scratch/db.
Oracle Compute Cloud Service Resources
When an Oracle Database Cloud - Database as a Service instance is created at the Oracle Database Cloud Service - Virtual Image service level, several Oracle Compute Cloud Service resources are created to house and support the service instance:
• Compute Cloud Service Instance (Virtual Machine)
• Compute Cloud Service Storage Volumes
• Compute Cloud Service Security Rules
• Compute Cloud Service Security Lists
• Compute Cloud Service Security Applications
• Compute Cloud Service IP Reservations
• Compute Cloud Service SSH Keys
Compute Cloud Service Instance (Virtual Machine)
Whena Database as a Service instance is created at the Oracle Database Cloud Service - Virtual Image service level, a Compute Cloud Service instance (virtual machine) is created with a name of this form:
instance-name db 1
This Compute Cloud Service instance uses the compute shape specified when the Database as a Service instance was created.
Compute Cloud Service Storage Volumes
Whena Database as a Service instance is created at the Oracle Database Cloud Service - Virtual Image service level, the following storage volume is created.
Storage Volume Description
boot 21 GB volume allocated to the following file system mounts on the virtual machine:
• / (root)
• /boot
• swap space
Compute Cloud Service Security Rules
Whena Database as a Service instance is created at the Oracle Database Cloud Service - Virtual Image service level, the ora_p2_ssh security rule is created. This rule controls access of the public internet to the ora_db security list for the Compute Cloud Service instance (VM) on the ssh security application (port 22 TCP). This security rule is enabled so that Secure Shell (SSH) connections to the instance on port 22 are permitted.
Compute Cloud Service Security Lists
Whena Database as a Service instance is created at the Oracle Database Cloud Service - Virtual Image service level, a security list named ora_db is created and associated with the Compute Cloud Service instance (VM). This security list is configured with its inbound policy set to DENY and its outbound policy set to PERMIT.
Compute Cloud Service Security Applications
Whena Database as a Service instance is created at the Oracle Database Cloud Service - Virtual Image service level, no security applications are created.
Compute Cloud Service IP Reservations
Whena Database as a Service instance is created at the Oracle Database Cloud Service - Virtual Image service level, a permanent IP reservation named ipreservation is created and associated with the Compute Cloud Service instance (VM).
Compute Cloud Service SSH Keys
In addition to the SSH key referred to or uploaded when a Database as a Service instance is created at the Oracle Database Cloud Service - Virtual Image service level, a second key is created to permit access to the instance by Oracle Cloud tools. This key has a name of the form:
domain-name.dbaas.instance-name.db.tresources.sshkey.ora_tools