IBM logoEnterprise Cloud Management SupportContact Us
ArticlesArticles Most Popular ArticlesMost Popular Articles Most Helpful ArticlesMost Helpful Articles Submit A QuestionSubmit A Question
RSS Feeds
Skip Navigation
DrillDown Icon Table of Contents
DrillDown Icon Enterprise Cloud
DrillDown Icon Release Notes
DrillDown Icon Known Issues
DrillDown Icon Policies
DrillDown Icon Registration and Login
DrillDown Icon Infinicenter Console
DrillDown Icon Enterprise Cloud API
DrillDown Icon Best Practices
DrillDown Icon FAQs
DrillDown Icon General
DrillDown Icon Registration and Login
DrillDown Icon Environment
DrillDown Icon Networks
DrillDown Icon Virtual Machines
DrillDown Icon API
DrillDown Icon Templates
DrillDown Icon Available VM templates?
DrillDown Icon Do the Oracle templates include a working database?
DrillDown Icon How do I create a Cisco CSR software router virtual machine?
DrillDown Icon Instance-Based VMs
DrillDown Icon Cloud Services
DrillDown Icon Security and Firewalls
DrillDown Icon Bandwidth
DrillDown Icon Billing and Licensing
DrillDown Icon Troubleshooting
DrillDown Icon Enterprise Cloud Managed Edition
DrillDown Icon Sales and Support
DrillDown Icon Proprietary Statement
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
Do the Oracle templates include a working database?

Question:

Do the Oracle templates include a working database?

Answer:

No.

By default, the template does not contain a running Oracle database. The expectation is that database administrators will generally choose to create databases to their design. Therefore, once the virtual machine is created from the template and powered on, the database administrator can enter the virtual machine and create their desired Oracle database.

Note: This information contained in this article is specific to the release of the Enterprise Cloud templates with Oracle for building database virtual machine images on Red Hat Enterprise Linux® or Oracle Linux®.

Oracle is available as version 11g or version 12c.

Oracle 11g

The templates with Oracle for building Oracle 11.2.0.4 database virtual machine images with Red Hat Enterprise Linux or Oracle Linux feature a choice of Oracle Enterprise and Standard versions. Available as a standard subscription license template are the following versions of Oracle:

  • Oracle Database 11g Enterprise Edition
  • Oracle Database 11g Enterprise Edition with Oracle Active Data Guard
  • Oracle Database 11g Standard Edition
  • Oracle Database 11g Standard Edition One

While the expectation is that database administrators will create databases to their design, you can create a single-instance database using the following procedure. Parameters are in DarkBlue and parameter values are in Maroon.

Log into the virtual machine as the oracle user and execute the following:

  1. $ORACLE_HOME/bin/netca -silent -responsefile $ORACLE_HOME/assistants/netca/netca.rsp
  2. Edit the responsefile if needed; defaults in the response file work well.

  3. /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbca -silent -createDatabase -automaticMemoryManagement true -templateName /u01/app/oracle/product/11.2.0/dbhome_1/assistants/dbca/templates/General_Purpose.dbc -sysPassword welcome1 -systemPassword welcome1 -dbsnmpPassword welcome1 -gdbName orcl.opcdbaas.oraclecloud.internal -emConfiguration LOCAL -sysmanPassword welcome1 -storageType FS -datafileJarLocation /u01/app/oracle/product/11.2.0/dbhome_1/assistants/dbca/templates -sampleSchema true -datafileDestination /u02/app/oracle/oradata -recoveryAreaDestination /u03/app/oracle/fast_recovery_area
  4. This example uses a password welcome1 and a system identifier (sid) orcl; set values based on your requirements.

    Log into the virtual machine as the root user and execute the following:

  5. /u01/app/oracle/product/11.2.0/dbhome_1/root.sh
Oracle 12c

The templates with Oracle for building Oracle 12.1.0 database virtual machine images with Red Hat Enterprise Linux or Oracle Linux feature a choice of Oracle Enterprise and Standard versions. Available as a standard subscription license template are the following versions of Oracle:

  • Oracle Database 12c Enterprise Edition
  • Oracle Database 12c Enterprise Edition with Oracle Active Data Guard
  • Oracle Database 12c Standard Edition
  • Oracle Database 12c Standard Edition One
Installation Details
Oracle Version 12.1.0
Oracle_Home /u01/app/oracle/product/12.1.0/dbhome_1
Users and Groups

Local Users and Groups created for Oracle installation:

Users oracle
Groups oinstall
dba
Directory and Permissions

Directory permission's updated to ensure local system user oracle has access to its installation path:

Directory /u01
User oracle
Group oinstall
Packages and Source

Package names from which Oracle 12c installation has been carried out:

Package linuxamd64_12c_database_1of2.zip
linuxamd64_12c_database_2of2.zip
Source http://download.oracle.com/
Additional Packages

Additional packages installed:

redhat-release-6Server-1.noarch Provided by oracle[Required for RHEL Servers]
ksh From yum repositories
nfs-utils From yum repositories
libaio-devel From yum repositories
compat-libstdc++-33 From yum repositories
compat-libcap1 From yum repositories
Additional Server Parameters in sysctl.conf

sysctl.conf is a file containing system control values to be read in and set by sysctl command. Parameters updated to meet minimum required setting by Oracle:

fs.file-max 6815744
kernel.sem 250 32000 100 128
kernel.shmmin 4096
kernel.shmmax 4398046511104
net.core.rmem_default 262144
net.core.rmem_max 4194304
net.core.wmem_default 262144
net.core.wmem_max 1048576
fs.aio-max-nr 1048576
net.ipv4.ip_local_port_range 9000 65500
Additional Server Parameters in limits.conf

limits.conf applies ulimit limits, nice priority and number of simultaneous login sessions limit to user login sessions. Parameters updated to meet Oracle requirements:

domain type item value
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
Log Files

Logs located in the directory:

Oracle logs /u01/app/oraInventory
System logs /var/log/message
Creating a Single-Instance Database

While the expectation is that database administrators will create databases to their design, you can create a single-instance database using the following procedure. Parameters are in DarkBlue and parameter values are in Maroon.

Log into the virtual machine as the oracle user and execute the following:

  1. $ORACLE_HOME/bin/netca -silent -responsefile $ORACLE_HOME/assistants/netca/netca.rsp
  2. Edit the responsefile if needed; defaults in the response file work well.

  3. /u01/app/oracle/product/12.1.0/dbhome_1/bin/dbca -silent -createDatabase -automaticMemoryManagement true -templateName /u01/app/oracle/product/12.1.0/dbhome_1/assistants/dbca/templates/General_Purpose.dbc -sysPassword welcome1 -systemPassword welcome1 -dbsnmpPassword welcome1 -gdbName orcl.opcdbaas.oraclecloud.internal -emConfiguration LOCAL -storageType FS -datafileJarLocation /u01/app/oracle/product/12.1.0/dbhome_1/assistants/dbca/templates -sampleSchema true -datafileDestination /u02/app/oracle/oradata -recoveryAreaDestination /u03/app/oracle/fast_recovery_area
  4. This example uses a password welcome1 and a system identifier (sid) orcl; set values based on your requirements.

    Log into the virtual machine as the root user and execute the following:

  5. /u01/app/oracle/product/12.1.0/dbhome_1/root.sh