Oracle Database Cloud Service Provisioning on the fly
!!!
Oracle Database Cloud - Database as a Service provides you
the ability to create service instances that contain Oracle databases, with
each service instance containing a single Oracle database. You have full access
to the features and operations available with Oracle Database, but with Oracle
providing the computing power, physical storage and (optionally) tooling to
simplify routine database maintenance and management operations.
When you create service instances, Database as a Service
creates compute nodes to host the database, using computing and storage
resources provided by Oracle Compute Cloud Service. Additionally, it provides
access to the compute nodes (and thus to the database) using networking
resources provided by Oracle Compute Cloud Service.
Please follow below simple steps to provision Oracle DB
instance on cloud as service –
Step1:
Login into Oracle cloud services account using the credentials
which you have received from oracle for your cloud subscription and access “Oracle
Database Cloud Service Console” as highlighted in snap
Step2:
Click on “create” button for creating new instance of DB on
cloud
Step3:
Select the Service level option “Oracle Database Cloud
Service”. This is best option as it will create DB with configuration provided
by you, also oracle cloud services will take care backup, recovery and
patching.
Also, select billing frequency as per your needs.
Step4:
Select the DB version what you are looking for. In this
example I have selected the Oracle Database 12c Release 1 (12.1.0.2) installed
on Linux 6.6
Step5:
Select the Edition which you are looking for as per you
organization need.
Step6:
Service
Configuration:
Select the name, description,
and compute shape of your service instance and provide an SSH public key to access
the instance.
DB Attributes
|
DB Attributes Description
|
Specify DB Service Name
|
Enter a name for your service instance.
|
Description,
|
Enter a description for your service instance
|
Shape
|
Select a compute shape
from the list of supported OCPU (Oracle CPU) and RAM combinations. These combinations fall into
two categories 1) General Purpose and 2) High Memory
|
Timezone
|
Provide the time zone for the service instance to use
|
SSH Public key
|
Provide the SSH public
key to be used for authentication when using an SSH client to connect to a
compute node that is associated with your service instance
|
Database
Configuration:
Select the amount of
data storage, administrator password, database name (SID), PDB name (for Oracle
Database 12c), inclusion of “Demos” PDB (for Oracle Database 12c) for the
Oracle Database to be created in your service instance.
DB Attributes
|
DB Attributes Description
|
Usable Database Storage (GB)
|
Enter the amount of
storage you want for actual database data (in GB).
|
Total Data File Storage (GB
|
The computed amount of
storage in GB that will be allocated to your instance, including space for operating
system and product binaries, supporting files, database data and
configuration files, and so on.
|
Administration Password and Confirm
Password
|
Enter and then reenter
a password for administrative access to the database and to other
components of your
service instance, specifically:
– Oracle Database SYS
and SYSTEM users
– Oracle Application
Express ADMIN user
– Oracle GlassFish
Server admin user
– Cloud database
monitor access
|
DB Name (SID)
|
Enter a name for the database instance. This name:
|
PDB Name
|
(Available only for
Oracle Database 12c)—Enter a name for the
default PDB (pluggable
database).
|
Character Set
|
Provide the database
character set for the database.
|
Backup and Recovery
Configuration:
Select how backups are to be configured
DB Attributes
|
DB Attributes Description
|
Backup Destination
|
Select how backups are to be configured 1) None 2) Both Cloud Storage
and Local Storage
|
None
|
Backups are not
configured for your service instance
|
Both Cloud Storage and Local
Storage
|
Backups are configured
to be created automatically and stored both on local storage and on an Oracle
Storage Cloud Service container.
|
Cloud Storage Container
|
Enter the name of an
existing Oracle Storage Cloud Service container in the format:
instance-id_domain/container
Where instance is the
name of the Oracle Storage Cloud Service Instance. Can be find using Rest
Endpoint URL given for your storage e.g. https://jcsdemo0117.storage.oraclecloud.com/v1/Storage-jcsdemo0117
In above “Storage” is
the instance name.
id_domain is the id of
the identity domain. In above “jcsdemo0117” is the identity domain.
Container is the name
of the container. You have to create container inside storage using curl
tool. For this example I have created a container called “fpsoadbbkp“. Please
refer Using Oracle Storage Cloud Service E37261-14 guide for how to create
container.
So, final value for
this example was – “Storage-jcsdemo0117/fpsoadbbkp”
|
Cloud Storage User Name
|
Enter the user name of
a user who has read/write access to the container specified in Cloud Storage Container.
|
Cloud Storage Password
|
Enter the password of
the user specified in Cloud Storage User Name.
|
Step7:
Verify all the configuration and input provided by you
Step8:
Request will be submitted and will take a while to provision
database. In my case it took approx. 1 hr time. There is no progress monitor
sort of thing available wherein you can see how much time left, how much time
required etc. You just need to wait and refresh the screen and verify the
status.
Step9:
Once done in progress status for that dB instance will be changed
and you would be able to see something like this-
Step 10:
Start the DB by click on DB name and select “start” from
under “Manage db node”
Step11:
Enable multiple ports to access this db. Below are various
ports been configured but disable by default. In order to access EM console and
other console you need to access all the required ports. Please go through
below link to get more details.
ora_p2_dbconsole, which controls access to port 1158,
the port used by Enterprise Manager 11g Database Control.
ora_p2_dbexpress, which controls access to port 5500,
the port used by Enterprise Manager Database Express 12c.
ora_p2_dblistener, which controls access to port 1521,
the port used by SQL*Net.
ora_p2_http, which controls access to port 80, the port used for HTTP
connections to the instance.
ora_p2_httpadmin, which controls access to port 4848,
the port used by the Oracle GlassFish Server administration console.
ora_p2_httpssl, which controls access to port 443,
the port used for HTTPS connections to the instance, including Oracle REST Data
Services, Oracle Application Express, and the Oracle Cloud on-instance database
monitor.
Go the “Oracle compute cloud service” and then “Network”,
find out your newly DB instance rules using find and enable them as per your
requirement.
Step12:
Access the DBaaS Monitor console and EM console
Use the password which you gave while provisioning db. User name
would be “dbaas_monitor”
Step13:
Access Database Express 12c Console and provide user name “SYS”
and password which you gave during database cloud service provisioning.
No comments:
Post a Comment