Oracle (DBaaS) Service Introduction

Turn https://oracle-base.com/articles/vm/oracle-cloud-database-as-a-service-dbaas-create-service?utm_source= Tuicool&utm_medium=referral

Oracle Cloud:database as a service (DBaaS)-Create Service

This article provides a run through of creating a new DBaaS service on the Oracle Cloud.

• Create SSH Key
• Create Service
• Connecting to the VM using SSH
• Oracle Compute Cloud service-network (Firewall)
• Connecting to the database using Oracle Net
• Notes

Related articles.

• Database as a Service (DBaaS) on Oracle Cloud
• Oracle Cloud:database as a service (DBaaS)-Patch Service
• Oracle Databases in the Cloud
• A Cure for Virtual insanity:a vendor-neutral Introduction to virtualization without the Hype
• Oracle Database Consolidation Comparison

Create SSH Key

Before you start, you is going to need a key pair for authentication to your service.

$ ssh-keygen-b 2048-t rsa-f myoraclecloudkey$ chmod

Enter and confirm the passphrase when prompted. You'll be asked to upload the public key during the service creation.

If you had any problems, or need instructions for using PuTTYgen on Windows, check out the documentation here.

Create Service

Log into your Oracle Cloud "My Services" dashboard. Scroll the "Oracle Database Cloud Service" section and click either the title, or the "Open Service Console" link.

On the "Oracle Database Cloud Service" page, click the "Create Service" button.

The next page allows you to enter the following details about the service.

• Subscription Type: "Oracle Database Cloud Service" or "Oracle Database Cloud Service-virtual Image". Pick the first.
• SSH public Key:upload the Key created earlier.
• Software Release:11gr2, 12CR1, 12CR2
• Software Edition:standard Edition, Enterprise Edition, Enterprise Edition-high performance, Enterprise Edition-extre Me performance. Check the definitions of the options included in the Enterprise Edition variants.
• Billing frequency:hourly, Monthly

Once you is happy with your choices, click the "Next" button.

Enter the service details. The shape determines the number of virtual CPUs and memory associated with the service, so pick a shape it is relevant T O Your performance needs. Enter the database configuration details. Pick the backup configuration appropriate to your system. When your is happy with the configuration, click the "Next" button.

If you is happy with the service setting listed on the "Confirmation" screen, click the "Create" button.

The Wait while the new service is created. The progress is shown under the status.

Once complete, the status disappears.

The service hamburger allows you to navigate to a number of management tools. You'll need to amend the firewall rules to access these.

Click on the service name to drill down into the service. The Detail page gives basic information about the service, including the public IP address and the database connection str Ing.

The hamburger gives you basic management operations (Start, Stop, Restart, scale Up/down) for the service.

If There is any patches available for your database, they'll be displayed in the ' Administration ' section.

Connecting to the VM using SSH

Most of the probably is connecting to the "Oracle" operating system user. Specifying your private key and connect to the ' Oracle ' user on the ' public IP address ' from your service det Ail page.

$ ssh-i./myoraclecloudkey [email protected][[email protected] ~]$

Once connected, you can do all the usual stuff.

[[email protected] ~]$ sqlplus/as sysdbasql*plus:release 12.2.0.1.0 Production on Tue Nov 8 09:44:42 2016Copyright (c) 1982, Oracle.  All rights reserved. Connected to:oracle Database 12c Enterprise Edition Release 12.2.0.1.0-64bit productionsql> ALTER SESSION SET contain ER = PDB1; Session altered. sql> CREATE USER test identified by test; User created. Sql> GRANT CREATE SESSION to test; Grant succeeded. Sql>

If you need to perform any tasks as root, you must connect to the "OPC" user and run them using "sudo".

$ ssh-i./myoraclecloudkey [email protected]-bash-4.1$ sudo vi/etc/hosts

Oracle Compute Cloud service-network (Firewall)

The DBaaS services is run under the Oracle Compute Cloud (IaaS). This has it's own firewall configuration, allowing you to the limit access to your services. By default, all endpoints except SSH is disabled. There is a number of predefined "Security Rules" to open up the assorted endpoints, but they typically open the endpoints To public, which is rather risky. Instead, should define custom rules, opening access to ports from specific machines.

• Navigate to the main "Oracle Database Cloud Service".
• Click on the hamburger next to the service of interest.
• Click the "Access Rules" option on the popup menu.
• Click the "Create Rule" button.
• Enter a "Rule Name".
• Select "As the" Source "and enter your IP address in resulting box.
• Select "DB" as the "Destination".
• Enter "1521" as the "Destination Port (s)".
• Leave "TCP" as the "Protocol".
• Click the "Create" button.

You should now is able to connect to the database from the specified IP address.

You'll need to does a similar process for the other tools you want to connect to, like APEX, DB Express etc.

Connecting to the database using Oracle Net

The "Sqlnet.ora" file on the server contains the following entries, so any connections to the server is encrypted using N ative Network encryption by default.

Sqlnet. Encryption_server = Requiredsqlnet.crypto_checksum_types_server = (SHA1) sqlnet. Crypto_checksum_server = Requiredencryption_wallet_location = (source= (method=file) (Method_data= (DIRECTORY=/u01/ App/oracle/admin/cdb1/tde_wallet)) sqlnet. Encryption_types_server = (AES256, AES192, AES128) NAMES. Directory_path = (tnsnames, ezconnect) sqlnet. Wallet_override = falsesqlnet. Expire_time = 10ssl_version = 1.0wallet_location = (source= (method=file) (Method_data= (directory=/u01/app/oracle/ Admin/cdb1/db_wallet)))

Sql*net access is disabled by default, but can enable it as described above. Once enabled, create a local "Tnsnames.ora" entry as follows. The connection details is available from your service detail screens.

Pdb1_oc=  (description=    (address= (      protocol=tcp) (      host=123.123.123.123    ) (port=1521))    (connect_data=      (service_name=pdb1.my-identity.oraclecloud.internal)    )  )

Now your can connect to the database.

C:\>sqlplus test/[email protected]_ocsql*plus:release 11.2.0.3.0 Production on Wed 14:40:23 2015Copyright (c) 1 982, Oracle.  All rights reserved. Connected to:oracle Database 12c Enterprise Edition Release 12.2.0.1.0-64bit production[email protected]>

Alternatively, connect using the Ezconnect URL.

C:\>sqlplus Test/[email protected]:1521/pdb1.my-identity.oraclecloud.internalsql*plus:release 11.2.0.3.0 Production on Wed 14:42:31 2015Copyright (c) 1982, Oracle.  All rights reserved. Connected to:oracle Database 12c Enterprise Edition Release 12.2.0.1.0-64bit productionsql>

Notes

• Assuming your public IP address were 123.123.123.123 and you ' ve opened the relevant services on the firewall, the Followin G URLs are available.

  DBaaS Monitor:https://123.123.123.123/dbaas_monitor/username:dbaas_monitorpassword: (set during installation) APEX: Https://123.123.123.123/ords/pdb1Workspace:INTERNALUsername:ADMINPassword: (set during installation) Glassfish: Https://123.123.123.123:4848/common/index.jsfUsername:adminPassword: (set during installation) DB express:https:// 123.123.123.123:5500/em

• The database created by the ' Oracle database Cloud Service ' option does not has multiplexed redo logs, so you'll need t o Sort this manually.
• The "Oracle Database Cloud service-virtual Image" option says there is a software installation present; The case. Instead, there is a tarball containing the software (/scratch/db12102_bits.tar.gz). To does the installation, you would need-to-scale the service to add storage, then do the installation manually. I See no value in this offering. I would rather provision a regular compute node and do everything manually.

For more information see:

• Using Oracle Database Cloud-database as a Service
• Database as a Service (DBaaS) on Oracle Cloud
• Oracle Cloud:database as a service (DBaaS)-Patch Service
• Oracle Databases in the Cloud
• A Cure for Virtual insanity:a vendor-neutral Introduction to virtualization without the Hype
• Oracle Database Consolidation Comparison

Oracle (DBaaS) Service Introduction