Monthly Archive December 2017

ByJoel Pérez ( Oracle ACE Director )

Oracle Cloud Onboarding Guide for IT Organizations

Oracle Cloud Onboarding Guide for IT Organizations

面向IT组织的Oracle云入职指南

 

By Joel Peréz Skant Gupta

This article is brought by en.enmotech.com

 

This is very important document that everyone must read before going to Cloud:

http://www.oracle.com/webfolder/technetwork/tutorials/cloud_onboarding/Cloud_Onboarding_Guide_for%20IT_Organizations.pdf

 

 

Enjoy the reading!

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.co

 

This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com

Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/

Subscribe to our Blog and enjoy our Weekly Cloud article..!

ByJoel Pérez ( Oracle ACE Director )

Oracle Cloud (DBaaS): Migration “On-prem” database to Cloud Using RMAN Cross-Platform Transportable PDB

By Joel Peréz Skant Gupta

 

This article is brought by en.enmotech.com

 

This method can be used only if the on-premises platform is little endian, and the database character sets of your on-premises database and Oracle Database Cloud Service database are compatible.

 

To migrate an Oracle Database 12c PDB to a PDB in an Oracle Database 12c database on an Oracle Database Cloud Service deployment using the RMAN cross-platform transportable PDB method, you perform these tasks:

 

1.- On the on-premises database host, invoke SQL*Plus and close the on-premises PDB.

2.- On the on-premises database host, execute the ALTER PLUGGABLE DATABASE UNPLUG command to generate an XML file containing the list of datafiles that will be plugged in on the cloud database.

3.- On the on-premises database host, invoke RMAN and connect to the root. Execute the BACKUP FOR TRANSPORT PLUGGABLE DATABASE command.

4.- Creating the Database Cloud Service database

5.- Use a secure copy utility to transfer the XML file and the backup set to the Database Cloud Service compute node.

6.- On the Database Cloud Service compute node, invoke RMAN and connect to the root. Execute the RESTORE ALL FOREIGN DATAFILES command.

7.- the Database Cloud Service compute node, invoke SQL*Plus and connect to the root. Execute the CREATE PLUGGABLE DATABASE command.

8.- the Database Cloud Service compute node, execute the ALTER PLUGGABLE DATABASE OPEN command.

 

On-premises database to Cloud Using RMAN Cross-Platform Transportable PDB: Example

This example is to migrate an On-premises database to Cloud Using RMAN Cross-Platform Transportable PDB

In this example, the on-premises database is on a Linux host.

 

1.- On the on-premises database host, invoke SQL*Plus and close the on-premises PDB.

 

a) On the on-premises database host, invoke SQL*Plus and log in to the on-premises database as the SYS user.

[oracle@cloud ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sun Jun 4 11:47:11 2017

Copyright (c) 1982, 2014, Oracle. All rights reserved.

 

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

 

SQL>

 

b) Close the on-premises PREM_PDB PDB.

SQL> ALTER PLUGGABLE DATABASE pdb_prem CLOSE;

Pluggable database altered.

SQL>

 

2. On the on-premises database host, execute the ALTER PLUGGABLE DATABASE UNPLUG command to generate an XML file containing the list of datafiles that will be plugged in on the cloud database.

 

a) Create a directory for creating the xml and backup file.

[oracle@cloud ~]$ mkdir –p /u01/app/dpump/

[oracle@cloud ~]$

 

b) Unplug the PDB. The following command generates the XML file.

SQL> ALTER PLUGGABLE DATABASE pdb_prem UNPLUG INTO ‘/u01/app/dpump/PDB_PREM.xml’;

Pluggable database altered.

 

SQL>

 

3.- On the on-premises database host, invoke RMAN and connect to the root. Execute the BACKUP FOR TRANSPORT PLUGGABLE DATABASE command.

 

a) On the on-premises database host, invoke RMAN and log in to the on-premises database as the SYS user.

[oracle@cloud admin]$ rman target /

 

Recovery Manager: Release 12.1.0.2.0 – Production on Thu Jun 8 22:33:05 2017

 

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

 

connected to target database: CDBPREM (DBID=1893698667)

 

RMAN>

 

b) Take the backup

RMAN> BACKUP FOR TRANSPORT AS COMPRESSED BACKUPSET PLUGGABLE DATABASE ‘PDB_PREM’ FORMAT ‘/u01/app/dpump/PDB_PREM.dfb’;

Starting backup at 08-JUN-17

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=82 device type=DISK

channel ORA_DISK_1: starting compressed full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00011 name=/u01/app/oracle/oradata/CDBPREM/PDB_PREM/example01.dbf

input datafile file number=00009 name=/u01/app/oracle/oradata/CDBPREM/PDB_PREM/sysaux01.dbf

input datafile file number=00008 name=/u01/app/oracle/oradata/CDBPREM/PDB_PREM/system01.dbf

input datafile file number=00010 name=/u01/app/oracle/oradata/CDBPREM/PDB_PREM/SAMPLE_SCHEMA_users01.dbf

input datafile file number=00012 name=/u01/app/oracle/oradata/CDBPREM/fsindex01.dbf

input datafile file number=00013 name=/u01/app/oracle/oradata/CDBPREM/fsdata01.dbf

channel ORA_DISK_1: starting piece 1 at 08-JUN-17

channel ORA_DISK_1: finished piece 1 at 08-JUN-17

piece handle=/u01/app/dpump/PDB_PREM.dfb tag=TAG20170608T223310 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:01:35

Finished backup at 08-JUN-17

 

RMAN>

 

4.- Creating the new Cloud Database Service

a) Login to your Oracle cloud services account, go to the “Oracle Database Cloud Service” page and create a new service.

  • For Service Name, select Cloud-Mig12c.
  • From the Service Level list, select Oracle Database Cloud Service.
  • From the Metering Frequency list, select whatever frequency is appropriate for your environment.
  • From the Software Release list, select Oracle Database 12c Release1.
  • From the Software Edition list, select Enterprise Edition.
  • From the Database Type list, select Single Instance.

 

Then click Next to continue.

Figure1. Creating a new service (Cloud-Mig12c)

 

b) In the Service Details screen, do the following:

  • For DB Name (SID), enter PRODDB.
  • Set an administrative password of your choice and confirm the password (this will be your sys password).
  • For Usable Database Storage (GB), enter 25.
  • From the Compute Shape list, select OC3 -1 OCPU, 7.5GB RAM (this is the bare minimum required).
  • For SSH Public Key, enter rsa-key-20170111.pub.

 

Then click Next to continue.

Figure 2. Specifying the service details

 

c) Finally, review the configuration and click Create to create your cloud database.

Figure 3. Creating the cloud database instance

 

After a few minutes, the cloud database instance has been created successfully.

Figure 4. The cloud database has been created

 

d) Click the service name (Cloud-Mig12c) to open the main page of the database.

Figure 5. Main page of the cloud database

 

e) Before trying to connect to the primary database instance on the cloud machine, you have to enable the dblistener access rule. Do the following:

a. Open the database service and select Access Rules from the menu.

Figure 6. Selecting the Access Rules item

 

b. For the ora_p2_dblistener rule, select Enable from the Actions menu.

Figure 7. Enabling the ora_p2_dblistener rule

 

Connect the Cloud Database

1. Open the instance of the PuTTY executable and connect to the machine using SSH public key.

Figure 8. Connecting to machine using PuTTY

 

5.- Use a secure copy utility to transfer the XML file and the backup set to the Database Cloud Service compute node.

 

a) On the Database Cloud Service compute node, create a directory for the backup set and dump file.

[oracle@Cloud-Mig12c ~]$ mkdir –p /u01/app/on_premise/

[oracle@Cloud-Mig12c ~]$

 

b) Before using the scp command to copy files, make sure the SSH private key that provides access to the Database Cloud Service compute node is available on your on-premises host.

 

c) On the on-premises database host, use the SCP utility to transfer the backup set and the dump file to the Database Cloud Service compute node.

[oracle@cloud ~]$ scp -i rsa-key-20170111.ssh /u01/app/dpump/PDB_PREM.xml oracle@129.144.149.23:/u01/app/on_premise

Enter passphrase for key ‘rsa-key-20170111.ssh’:

PDB_PREM.xml 100% 7681 7.5KB/s 00:00

[oracle@cloud ~]$ scp -i rsa-key-20170111.ssh /u01/app/dpump/PDB_PREM.dfb oracle@129.144.149.23:/u01/app/on_premise

Enter passphrase for key ‘rsa-key-20170111.ssh’:

PDB_PREM.dfb 100% 190MB 55.8KB/s 58:06

[oracle@cloud ~]$

 

6.- On the Database Cloud Service compute node, invoke RMAN and connect to the root. Execute the RESTORE ALL FOREIGN DATAFILES command.

 

a) Invoke RMAN and log in to the PDB as a user that has been granted the SYSDBA or SYSBACKUP privilege.

[oracle@Cloud-Mig12c ~]$ rman target /

 

Recovery Manager: Release 12.1.0.2.0 – Production on Thu Jun 8 18:08:20 2017

 

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

 

connected to target database: PRODDB (DBID=685826250)

 

RMAN>

 

b) Execute the RESTORE command.

RMAN> RESTORE ALL FOREIGN DATAFILES TO NEW FROM BACKUPSET ‘/u01/app/on_premise/PDB_PREM.dfb’;

Starting restore at 08-JUN-17

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=36 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring all foreign files in backup piece

channel ORA_DISK_1: reading from backup piece /u01/app/on_premise/PDB_PREM.dfb

channel ORA_DISK_1: restoring foreign file 11 to /u02/app/oracle/oradata/PRODDB/datafile/o1_mf_example_dmm4nwql_.dbf

channel ORA_DISK_1: restoring foreign file 9 to /u02/app/oracle/oradata/PRODDB/datafile/o1_mf_sysaux_dmm4nwt1_.dbf

channel ORA_DISK_1: restoring foreign file 8 to /u02/app/oracle/oradata/PRODDB/datafile/o1_mf_system_dmm4nwx9_.dbf

channel ORA_DISK_1: restoring foreign file 10 to /u02/app/oracle/oradata/PRODDB/datafile/o1_mf_users_dmm4nx06_.dbf

channel ORA_DISK_1: restoring foreign file 12 to /u02/app/oracle/oradata/PRODDB/datafile/o1_mf_fsindex_dmm4nx1z_.dbf

channel ORA_DISK_1: restoring foreign file 13 to /u02/app/oracle/oradata/PRODDB/datafile/o1_mf_fsdata_dmm4nx3c_.dbf

channel ORA_DISK_1: foreign piece handle=/u01/app/on_premise/PDB_PREM.dfb

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:01:46

Finished restore at 08-JUN-17

 

c) Exit from RMAN.

 

7.- the Database Cloud Service compute node, invoke SQL*Plus and connect to the root. Execute the CREATE PLUGGABLE DATABASE command.

 

a) On the on-premises database host, invoke SQL*Plus and log in to the on-premises database as the SYS user.

[oracle@cloud ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sun Jun 4 11:47:11 2017

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

 

SQL>

 

b) Execute the CREATE PLUGGABLE DATABASE command.

SQL> CREATE PLUGGABLE DATABASE PDB_PREM as clone USING ‘/u01/app/on_premise/PDB_PREM.xml’

source_file_name_convert = (

‘/u01/app/oracle/oradata/CDBPREM/PDB_PREM/system01.dbf’,’/u02/app/oracle/oradata/PRODDB/datafile/o1_mf_system_dmm4nwx9_.dbf’,

‘/u01/app/oracle/oradata/CDBPREM/PDB_PREM/sysaux01.dbf’,’/u02/app/oracle/oradata/PRODDB/datafile/o1_mf_sysaux_dmm4nwt1_.dbf’,

‘/u01/app/oracle/oradata/CDBPREM/PDB_PREM/SAMPLE_SCHEMA_users01.dbf’,’/u02/app/oracle/oradata/PRODDB/datafile/o1_mf_users_dmm4nx06_.dbf’,

‘/u01/app/oracle/oradata/CDBPREM/PDB_PREM/example01.dbf’,’/u02/app/oracle/oradata/PRODDB/datafile/o1_mf_example_dmm4nwql_.dbf’,

‘/u01/app/oracle/oradata/CDBPREM/fsindex01.dbf’,’/u02/app/oracle/oradata/PRODDB/datafile/o1_mf_fsindex_dmm4nx1z_.dbf’,

‘/u01/app/oracle/oradata/CDBPREM/PDB_PREM/PDB_PREM_temp012017-05-21_01-01-24-PM.dbf’,’/u02/app/oracle/oradata/PRODDB/datafile/pdb4_temp01.dbf’,

‘/u01/app/oracle/oradata/CDBPREM/fsdata01.dbf’,’/u02/app/oracle/oradata/PRODDB/datafile/o1_mf_fsdata_dmm4nx3c_.dbf’)

file_name_convert=NONE NOCOPY TEMPFILE REUSE;

Pluggable database altered.

 

SQL>

 

8.- The Database Cloud Service compute node, execute the ALTER PLUGGABLE DATABASE OPEN command.

 

a) Set the PDB_PREM to READ WRITE

SQL> ALTER PLUGGABLE DATABASE pdb_prem OPEN;

Pluggable database altered.

SQL>

 

b) Exit from SQL*Plus.

 

Well.. Until here, this article. We hope it can be useful for making grow your knowledge about Oracle Database Cloud.

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.co

 

This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com

Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/

Subscribe to our Blog and enjoy our Weekly Cloud article..!

ByJoel Pérez ( Oracle ACE Director )

Oracle Cloud (DBaaS) Security: Move PDB with exporting the TDE master Key in Oracle 12.2

Oracle Cloud (DBaaS) Security: Move PDB with exporting the TDE master Key in Oracle 12.2

Oracle 12.2 中通过导出TDE主密钥实现PDB迁移
PDB迁移:Oracle 12.2 中通过导出TDE主密钥快速实现

 

By Joel Peréz Skant Gupta

 

This article is brought by en.enmotech.com

Subscribe to our Oracle Cloud Blog: blog.enmotech.com

 

Hi Readers

 

Security is one of the main issues that customers think at the time of moving or having the databases, applications and more into the Cloud. Security has many layers, areas, sections and more. When we work with databases “On-Prem”, security in many tasks and configurations is optional but when we work in Cloud, many of them are mandatory.

 

In this article our focused will be based on Oracle Advanced Security TDE and PDB working in DBCS (Database Cloud Service).

 

Oracle Advanced Security TDE provides the ability to encrypt sensitive application data on storage media completely transparent to the application itself. TDE addresses encryption requirements associated with public and private privacy

and security mandates such as PCI and California SB1386. Oracle Advanced Security TDE column encryption was introduced in Oracle Database 10g Release 2, enabling encryption of application table columns, containing credit card or social security numbers. Oracle Advanced Security TDE tablespace encryption was introduced with Oracle Database 11gR1, being the main focus of our article.

Oracle Multitenant Architecture is one of the key points for having a great scalability for moving and upgrades databases into the Cloud. Moving, creating PDB databases in “On-prem” does not have too much complexity if we are not working with security features but if we are.. we have to take into account additional things.

When you create your CDB database using DBCS is mandatory to have at least a PDB in the minimal configuration, that PDB has already a TDE Master Key created to fulfil conditions related to secure our data but when we create a new PDB into that CDB the TDE Master Key is not created by default, however we can create it without no problem. Later when you will create the first user-defined tablespace is when you will receive an error if the TDE Master Key is not already created for that new PDB.

 

The first time We were creating a new PDB and a new tablespace within it We got this problem, this article shows how to solve it and the procedure to administer TDE Master Keys working with PDB.

 

This article shows how to move the PDB in different DBCS Multitenant environment wit exporting TDE master key.

Steps:

1. Create the Database Cloud Service database.

2. Create New PDB in Multitenant environment.

3. Create new master key and create demo table

4. Unplug the PDB whilst exporting the TDE master key

5. Move the data unplugged PDB to different DBCS

6. Plug-in the unplugged PDB and show TDE master key

 

Create the new Cloud Database Service

a) Login to your Oracle cloud services account, go to the “Oracle Database Cloud Service” page and create a new service.

 

  • For Service Name, select PDB-Security.
  • From the Service Level list, select Oracle Database Cloud Service.
  • From the Metering Frequency list, select whatever frequency is appropriate for your environment.
  • From the Software Release list, select Oracle Database 12c Release2.
  • From the Software Edition list, select Enterprise Edition.
  • From the Database Type list, select Single Instance.

 

Then click Next to continue.

 

 

 

 

 

 

 

 

 

 

 

Figure1. Creating a new service (PDB-Security)

 

b) In the Service Details screen, do the following:

  • For DB Name (SID), enter ORCL.
  • For PDB Name, enter PDB1.
  • Set an administrative password of your choice and confirm the password (this will be your sys password and master key password).
  • For Usable Database Storage (GB), enter 25.
  • From the Compute Shape list, select OC3 -1 OCPU, 7.5GB RAM (this is the bare minimum required).
  • For SSH Public Key, enter rsa-key-20170111.pub.

 

Then click Next to continue.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Figure 2. Specifying the service details

 

c) Finally, review the configuration and click Create to create your cloud database.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Figure 3. Creating the cloud database instance

 

c) After a few minutes, the cloud database instance has been created successfully.

 

 

 

 

 

 

 

 

 

 

Figure 4. The cloud database has been created

 

d) Click the service name (PDB-Security) to open the main page of the database.

 

 

 

 

 

 

 

 

 

 

 

 

Figure 5. Main page of the cloud database

 

Connect the Cloud Database

1. Open the instance of the PuTTY executable and connect to the machine using SSH public key.

Figure 6. Connecting to machine using PuTTY

 

 

Create New PDB in Multitenant environment

 

a. On the cloud database host, invoke SQL*Plus and log in to the cloud database as the SYS user.

[oracle@PDB-Security ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Aug 11 18:53:09 2017

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production

With the Partitioning, Oracle Label Security, OLAP, Advanced Analytics

and Real Application Testing options

SQL>

 

b. Create the new NEWPDB PDB in the DBaaS CDB

SQL> create pluggable database newpdb admin user admin identified by “Welcome_1”;

 

Pluggable database created.

 

c. Open the new PDB in the DBaaS CDB and check the status of PDB

SQL> alter pluggable database newpdb open read write;

 

Pluggable database altered.

 

SQL> show pdbs;

 

CON_ID CON_NAME OPEN MODERESTRICTED

———- —————————— ———- ———-

2 PDB$SEED READ ONLYNO

3 PDB1 READ WRITE NO

4 NEWPDB READ WRITE NO

 

Create a new master key and dummy table

 

a. Open the wallet for new PDB

SQL>alter session set container=newpdb;

 

Session altered.

 

SQL>administer key management set keystore open force keystore identified by “MyKey#123”;

 

keystore altered.

 

b. Create the new master key of new PDB

SQL> administer key management set key force keystore identified by “MyKey#123” with backup;

 

keystore altered.

 

c. Check the new master created for New PDB.

SQL> select pdb.name, e.key_id, to_char(e.creation_time,’DD-MON-YY HH24:MI:SS’) created from v$encryption_keys e, v$pdbs pdb where pdb.con_id=e.con_id order by pdb.name desc, created;

 

NAME KEY_ID CREATED

——————– —————————————————————————— —————————

PDB1 Abw1aBB/Pk8Cvwxg6bwJKcgAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 10-AUG-17 14:17:54

NEWPDB AXkR6FF3pU+xv5FJLzWyerMAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 11-AUG-17 19:08:18

 

d. Now create the tablespace in newpdb

SQL>create tablespace test;

 

Tablespace created.

 

e. Now create the new user

SQL>create user demo identified by demo account unlock;

 

User created.

 

SQL>grant connect, resource, unlimited tablespace to demo;

 

Grant succeeded.

 

SQL>alter user demo default tablespace test;

 

User altered.

 

f. Connect with new user and create dummy table and load some data into it.

SQL>connect demo/demo@localhost/newpdb.gbvodafone.oraclecloud.internal

Connected.

 

SQL>show user

USER is “DEMO”

SQL>create table test as select table_name from all_tables;

 

Table created.

 

SQL>select count(*) from test;

 

COUNT(*)

———-

110

 

Unplug the PDB while exporting the TDE master key

 

a. On the cloud database host, invoke SQL*Plus and log in to the cloud database as the SYS user.

[oracle@PDB-Security ~]$ sqlplus / as sysdba

 

SQL*Plus: Release 12.2.0.1.0 Production on Fri Aug 11 19:36:34 2017

 

Copyright (c) 1982, 2016, Oracle. All rights reserved.

 

 

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production

 

SQL>alter session set container=cdb$root;

 

Session altered.

 

b. Close the NEWPDB PDB.

SQL>alter pluggable database newpdb close immediate;

 

Pluggable database altered.

 

c. Unplug the PDB. The following command generates the XML file with TDE master key.

SQL>alter pluggable database newpdb unplug into ‘/tmp/newpdb.xml’ encrypt using “MasterKey”;

 

Pluggable database altered.

 

Move the data unplugged PDB to different DBCS

 

a. On the another Database Cloud Service compute node ,create a directory for XML and database files. We can not repeat the steps for creating new Database Cloud Instance.

[oracle@PDB-Security ~]$echo “mkdir -p /u02/app/oracle/oradata/ORCL/NEWPDB” | ssh -i /home/oracle/key.ssh oracle@141.144.32.70

Enter passphrase for key ‘/home/oracle/key.ssh’:

 

b. Tar the datafile for PDB and use the SCP utility to transfer the XML and datafiles to another instance.

[oracle@PDB-Security ~]$ cd /u02/app/oracle/oradata/ORCL/NEWPDB/datafile

 

[oracle@PDB-Security ~]$ tar -cvzf /tmp/newpdb.tar.gz *

 

[oracle@PDB-Security ~]$ scp -i /home/oracle/key.ssh /tmp/newpdb* oracle@141.144.32.70:/u02/app/oracle/oradata/ORCL/NEWPDB

 

Enter passphrase for key ‘/home/oracle/key.ssh’:

newpdb.tar.gz 100% 244MB 243.7MB/s 00:01

newpdb.xml 100% 13KB 13.2KB/s 00:00

 

c. Untar the file on destination server

[oracle@PDB-Security ~]$ echo “cd /u02/app/oracle/oradata/ORCL/NEWPDB ; tar xvzf newpdb.tar.gz” | ssh -i /home/oracle/key.ssh oracle@141.144.32.70

Enter passphrase for key ‘/home/oracle/key.ssh’:

o1_mf_sysaux_drvzxbhr_.dbf

o1_mf_system_drvzxbhh_.dbf

o1_mf_temp_drvzxbhw_.dbf

o1_mf_test_drw05q9c_.dbf

o1_mf_undotbs1_drvzxbht_.dbf

 

Plug-in the unplugged PDB and show TDE master key

 

a. On the destination cloud database host, invoke SQL*Plus and log in to the cloud database as the SYS user.

[oracle@PDB-Migration~]$ sqlplus / as sysdba

 

SQL*Plus: Release 12.1.0.2.0 Production on Fri Aug 11 18:53:09 2017

 

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production

With the Partitioning, Oracle Label Security, OLAP, Advanced Analytics

and Real Application Testing options

 

SQL>

 

b. Create the PDB in the DBaaS CDB with XML and master key.

SQL>create pluggable database newpdb

using ‘/u02/app/oracle/oradata/ORCL/NEWPDB/newpdb.xml’

decrypt using “MasterKey”

keystore identified by “MyKey#123”

source_file_directory=’/u02/app/oracle/oradata/ORCL/NEWPDB’;

 

Pluggable database created.

 

c. Open the PDB in Read Write Mode.

SQL>alter pluggable database newpdb open;

 

Pluggable database altered.

 

d. Connect with demo user and check data in the dummy table

SQL>connect demo/demo@localhost/newpdb.gbvodafone.oraclecloud.internal

Connected.

 

SQL>select count(*) from test;

 

COUNT(*)

———-

110

 

e. Check the master TDE for migrated PDB

SQL>select pdb.name, e.key_id, to_char(e.creation_time,’DD-MON-YY HH24:MI:SS’) created

from v$encryption_keys e, v$pdbs pdb

where pdb.con_id=e.con_id

order by pdb.name desc, created;

 

NAME KEY_ID CREATED

——————– —————————————————————————— —————————

PDB1 Abw1aBB/Pk8Cvwxg6bwJKcgAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 10-AUG-17 14:17:54

NEWPDB AXkR6FF3pU+xv5FJLzWyerMAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 11-AUG-17 19:08:18

 

Conclusion

So now you know that it is very easy to move the PDB in different DBCS Multitenant environment wit exporting TDE master key.

We hope this article is useful and we invite you to continue reading our next publications focused on Oracle Cloud.

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.com

 

This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com

Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/

Subscribe to our Blog and enjoy our Weekly Cloud article..!

ByJoel Pérez ( Oracle ACE Director )

Oracle 18c: Data Warehousing New Features.. What’s NEWS..

Oracle 18c: Data Warehousing New Features.. What’s NEWS..

Oracle 18c: Oracle Data Warehousing新功能一览

 

By Joel Peréz Skant Gupta

This article is brought by en.enmotech.com

 

Data Warehousing will be the focus of the first Autonomous Database Service in Oracle 18c, so, this implies.. many new features will exist for this area.

Many people.. including me.. we are so eager to see how the autonomous conception will work on Data Warehouses since it was announced that a new Autonomous Database for Datawarehouse will be just a thing of load tables.. running queries and that’s it.. that’s what Oracle Corp. said and really we are so eager to see how close could be what we imagine in comparison to reality.

 

Meanwhile, let’s see some technical Oracle 18c New Features for Data Warehousing and you will start to realize how all this will be working..

 

Key 18c Features to Enhance Data Warehouses

 

DATABASE INFRASTRUCTURE

  • Autonomous health framework
  • Standby support for nologging ops

DATA MANAGEMENT

  • Online partition merge
  • Partitioning scheme online conversion of a table
  • Private temporary tables

DATA PROCESSING

  • SQL language
    • Enhanced approximate query processing
    • Enhanced analytic views, incl. MDX interface
  • In-Memory
    • In-memory external tables
    • In-memory for NVRAM
    • Automatic in-memory management
  • Optimizer and SQL processing
    • Inline external tables
    • Polymorphic table functions
    • Better fine-grained cursor Invalidation – Enhanced SQL Plan Management
  • And much more …

In-Memory Key Features

  • Automatic In-Memory Management
  • In-Memory For External Tables
    • Support for all storage tiers
  • In-Memory for Extreme Capacity NVRAM Memory
    • Dramatic increase of in-memory capacity
  • Warehouse-specific performance improvements:
    • In-Memory Dynamic Scans
    • In-Memory Optimized Arithmetic

In-Memory For External Tables

Fast Analytics on External Data

  • External Tables allow transparent access to data outside the DB

 

  • In-Memory For External Tables builds in-memory column cache of data outside the DB for ultra-fast analytics on external data
  • All In-Memory Optimizations apply
    • Vector processing, JSON expressions extend transparently to external data
  • Up to 100X faster

Approximate Query Processing

Delivers significantly faster analysis for interactive and highly iterative data exploration

 

 

  • Approximations for expensive aggregate calculations:
  1. APPROX_COUNT_DISTINCT
  2. APPROX_PERCENTILE
  3. APPROX_MEDIAN
    • 6-13X faster, accuracy typically within < 1%
  • Use with ZERO code changes
    • approx_for_aggregation = TRUE
  • Accuracy and error rate provided

 

Top-N approximate aggregation

  • Approximate results for common top n queries
    • Approximately how many page views did the top five blog posts get last week?
    • What were the top 50 customers in each region and their approximate spending?
  • Order of magnitudes faster processing with high accuracy (error rate < 0.5%)
  • New approximate functions APPROX_COUNT(), APPROX_SUM(), APPROX_RANK()

 

Top 5 blogs with approximate hits

Top 50 customers per region with approximate spending

Oracle Advanced Analytics in 18.1

  • New Scalable Machine Learning Algorithms (SQL API)
    • Random Forests for Classification
    • Neural Networks for both classification and regression
    • Explicit Semantic Analysis ML algorithm extended to support classification
    • Time Series via Exponential Smoothing
    • CUR decomposition-based algorithm for attribute and row importance

  • Ability to export ML models to C and Java for applications deployment

Analytic Views

  • Moves business logic (Aggregations, Hierarchies, Calculations) back into database
  • Simple SQL for complex analytic queries
    • no joins or GROUP-BY clauses necessary
  • Works on top of pre-existing tables or views
    • no persistent storage
  • Built-in data visualization via APEX

 

Analytic Views enhancements in 18.1

  • More calculations within Analytic Views:
    • Ranking and statistical functions
      • RANK_*, PERCENTILE_*, STATS_*, COVAR_*
  • Hierarchical expressions
    • HIER_DEPTH, HIER_LEVEL, HIER_MEMBER_NAME, etc
  • Broader schema support for Analytic Views:
    • Snowflake schemas; flat/denormalized fact tables (in addition to star schemas)
  • More powerful SQL over Analytic Views:
    • Dynamic definition of calculations within SQL queries

 

MDX Query Language with 18.1 Analytic Views

  • Support for MDX (Multi-Dimensional Expression) query language
    • Initially certified for use by Microsoft Excel Pivot Tables
      • Support/certification for other applications to follow
  • Includes a multi-dimensional query cache
    • Similar to the SQL Result Cache

 

 

 

 

 

 

 

 

Polymorphic Tables: Self-Describing, Fully Dynamic SQL

  • Part of ANSI 2016
  • Encapsulate sophisticated algorithms
    • Hides implementation of algorithms
    • Leverage powerful, dynamic capabilities of SQL
    • Pass in any table-columns for processing
    • Returns SQL rowset (table, JSON, XML doc etc)
      • E.g. return credit score and associated risk level

 

Inline external tables

  • External table definition provided at runtime
    • Similar to inline view
  • No need to pre-create external tables that are used one time only
    • Increased developer productivity

 

and more..

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.co

 

This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com

Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/

Subscribe to our Blog and enjoy our Weekly Cloud article..!

ByJoel Pérez ( Oracle ACE Director )

Oracle 18c: RAC New Features.. What’s NEWS..

Oracle 18c: RAC New Features.. What’s NEWS..

Oracle 18c: RAC新功能一览

By Joel Peréz Skant Gupta

This article is brought by en.enmotech.com

 

Oracle Real Application Cluster is an Oracle solution that seems will improve in a endless way. Every Oracle Release we have new features that perhaps we never expected to have. Oracle 18c is not the exception, we have amazing new features.

 

Oracle EVP of Server Technologies Andy Mendelsohn said:

“We’re not going to do that with our SLAs,” he said. “We’re going to implement online patching using RAC rolling upgrades and use best practices on top of one of the most powerful and reliable platforms for running Oracle Database—Oracle Exadata.”

 

Oracle Autonomous Database Cloud will offer instant elasticity for databases. For Instance, now a customer can go from 8 cores of database computing to 16 cores to scale-up for end-of-quarter processing, then back down to the less expensive 8 cores. “We can do it instantly because our RAC technology lets you scale across clusters of servers very quickly, so we won’t have to move data around,” he said. “In order to grow its databases, Amazon has to move data to a new, bigger system and this can take hours or days”, he said. “That’s not truly elastic.” Mendelsohn envisioned a scenario using Oracle where, “you could even shut down all your compute CPUs over the weekend so you’re not paying for them, then start them up again on Monday morning,” he said. “That’s elastic.”

 

“Ask why customers run big transaction or operational systems on Oracle and their top reasons will probably be high availability, reliability, and scalability,” Mendelsohn said. These customers have grown to rely on technologies like Oracle Real Application Clusters (RAC), Oracle Active Data Guard, and Oracle’s Exadata database machine, which, he said, are unique to Oracle, “and are highly fault tolerant and scalable and that allow systems to run at 99.995 percent availability,” he said.

 

According to the last paragraphs, you could easily realise that Oracle RAC will be one of the key components related to the functioning of Autonomous Databases.

 

So.. Let’s see some technical points..

 

Oracle Real Application Cluster is one of the key components of Autonomous Databases for several reasons:

  • Rolling Patch
  • Rolling Upgrade
  • Domain Services Cluster Management Service (DSC) working with Machine learning ( This started in 12.2. , however in Oracle18c we will experiment a more advance functioning )
  • and more..

 

The DSC Management Service

 

 

 

 

 

 

 

 

 

Applied Machine Learning for Database Diagnostics

  • Efficient diagnosis using Machine Learning
  • Automatically performs corrective actions to prevent possible issues
  • Provides simple alerts & recommendations for issues that require manual intervention

 

 

 

 

 

 

 

 

 

 

 

 

 

Zero Impact Patching

Never take down a database instance to patch Grid Infrastructure

  • Zero Impact Patching enables patching of the Oracle Grid Infrastructure without interrupting database operations.
  • Patches are applied out-of-place and in a rolling fashion with one node being patched at a time while the database instance(s) on that node remain up and running.
  • Zero Impact Patching supports Oracle Real Application Clusters (RAC) databases on clusters with two or more nodes.

Convert a Standalone Cluster to Member Cluster

Member Clusters = Standalone Cluster + Benefits

• A Member Cluster is a Standalone Cluster utilizing shared services on the Domain Services Cluster

• It automatically benefits from the management, TFA & RHP service.

– ASM services are opRonal – and can be utilizing as needed

 

Convert a Standalone Cluster to Member Cluster

 

  • Easy conversion from Standalone to Member Clusters
  • Member Cluster GI version can be higher or equal to the GI version on the Domain Services Cluster

Hang Manager

Resolving cross-layer hangs in the Cluster Domain

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Hang Manager “manages” database process(es) that are not progressing

– Manage = detection and resolution

– Considers cross-layer hangs

• I.E: Hangs caused by a blocked ASM resource.

 

  • In addition, deadlocks are now resolved by Hang Manager
  • User defined control via PL/SQL
  • Early Warning exposed via (V$ view)

Resolving cross-layer hangs in the Cluster Domain

Up to now Oracle 18c is not still released so that we do not still too much information, however this article will be updated according to.

 

This is the end of this article, we hope it can be useful.. Stay tune for more Oracle Database Cloud articles.

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.co

ByJoel Pérez ( Oracle ACE Director )

Oracle 18c: RMAN New Features.. What’s NEWS..

Oracle 18c: RMAN New Features.. What’s NEWS..

Oracle 18c: RMAN新功能一览

 

By Joel Peréz Skant Gupta

This article is brought by en.enmotech.com

 

 

Oracle Recovery Manager, better known as “RMAN”. RMAN is one of those kind of tool that is present in almost the daily activities for regular DBAs.

With RMAN we can perform a lot of different kind of activities for different kind of objectives.

It’s impossible a DBA can not know tools such as: RMAN.. SQL*Plus.. expdp.. impdp.. etc.. those are part of the Oracle Software’s main core.

 

RMAN Beyond the Backup Utility, we can use it for:

  • Cloning and Platform Migration
  • Data Guard Operations
  • Backup to Disk
  • Backup to Cloud Storage
  • Oracle Secure Backup or 3rd party backup applications
  • Oracle Zero Data Loss Recovery Appliance
  • and more..

So.. based on that.. no need to introduce the concept of what is RMAN..

 

Oracle Recovery Manager has a long history, let’s highlight briefly some about it:

 

Oracle 8, Oracle 8i, Oracle 9i ( 1997-2002 )

  • Parallel Backups
  • DUPLICATE
  • Block Media Recovery
  • Automatic Control File & SPFILE Backup
  • CONFIGURE Persistent Settings
  • BACKUP BACKUPSET
  • And more …

Oracle 10g, Oracle 11g ( 2003 – 2012 )

  • Fast Recovery Area
  • Fast Incremental Backups
  • Incrementally Updated Backups
  • SWITCH TO COPY
  • Offload Backups to Standby Database
  • And more …

Oracle 12c ( Today )

  • Table Level Recovery
  • Cross-Platform Backup & Recovery enhancements
  • Fast Active DUPLICATE
  • Fast Standby Database Synchronization
  • Multitenant Database Backup & Recovery
  • And more ..

Oracle Database 18c: Key RMAN Benefits/Enhancements

  • Multitenant DB Enhancements
  • Duplication Enhancements
  • Enhancements for DATA GUARD
  • Cloud Archive Support

So.. Let’s star to see some technical new features of Oracle Recovery Manager in Oracle 18c..

 

18c: Multitenant DB Enhancement

Backup history preservation

  • Restore a PDB from a backup taken as non-multitenant, or when the PDB was plugged into a different CDB
  • Export PDB metadata to RMAN catalog of destination CDB
    • XML generated at UNPLUG operation
    • Use DBMS_PDB.EXPORTRMANBACKUP() procedure for non-CDB

RESTORE PLUGGABLE DATABASE <PDBNAME> FROM PREPLUGIN BACKUP;

RECOVER PLUGGABLE DATABASE <PDBNAME> FROM PREPLUGIN BACKUP;

ALTER PLUGGABLE DATABASE <PDBNAME> OPEN;

 

 

18c: Duplication Enhancements

Active Cross-CDB PDB Duplication

  • Active duplication of a PDB into a different CDB is now possible
  • Start RMAN and connect to the root of the source database as TARGET and to the auxiliary instance
  • Duplicate the database using the DUPLICATE PLUGGABLE… FROM ACTIVE DATABASE command

DUPLICATE PLUGGABLE DATABASE <PDBNAME> to <CDBNAME> FROM ACTIVE DATABASE;

 

18c: RMAN and Data Guard Enhancements

Active Data Guard Sync

 

  • new RECOVER STANDBY DATABASE FROM SERVICE
  • One command to refresh the standby database
  • Refreshes controlfile, datafile, restores newly added datafiles
  • Start RMAN and connect as target to the physical standby database.
  • Roll forward the physical standby database using the RECOVER STANDBY DATABASE command with the FROM SERVICE clause

RECOVER STANDBY DATABASE FROM SERVICE primary_db;

 

Stay tune for more Oracle Database Cloud articles.

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.co

 

This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com

Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/

Subscribe to our Blog and enjoy our Weekly Cloud article..!

ByJoel Pérez ( Oracle ACE Director )

Oracle 18c: New Features for Oracle Data Guard.. What’s NEWS..

Oracle 18c: New Features for Oracle Data Guard.. What’s NEWS..

Oracle 18c: Oracle Data Guard新功能一览

 

By Joel Peréz Skant Gupta

This article is brought by en.enmotech.com

 

 

 

 

 

 

 

 

Now, Let’s start to read..

 

Oracle Data Guard is an Oracle solution that seems will improve in a endless way. Every Oracle Release we have new features that perhaps we never expected to have.

Oracle 18c is not the exception, we have amazing new features, So.. Let’s see..

 

New Broker VALIDATE commands

Personally, at the time to check or correct Oracle Data Guard configurations, one of the most common problems is the network configuration. Sometimes we are building RAC-RAC configurations with many servers.. many IPs.. etc.. and it’s natural we can miss a name.. and IP.. etc.. at the end we can have some problems when this configuration is working and we have to start the tedious job to check every single detail.. ( Network Configuration.. Parameters.. etc.. ) to find where it’s the problem.. With these 3 following commands we will be able to save a lot of time when we face that kind of difficulties..

 

VALIDATE DATABASE SPFILE

  • Validate parameters settings between the Primary and a Standby database.

VALIDATE NETWORK CONFIGURATION

  • Validate the network setup between all databases in the configuration

VALIDATE STATIC CONNECT IDENTIFIER

  • Verifies the static connect identifier setup in Single Instance databases the do not have Oracle Restart.

 

Multi-Instance Redo Apply

– Multi-Instance Redo Apply allows all standby nodes to participate in recovery

– In-memory DB (IMC) on Active Data Guard allows:

  • Creation of IMC tables and columns for analytics on Active Data Guard
  • Population with different data than production database
  • Offloading even more to your standby!

– IMC now works with Multi-Instance Redo Apply!

– Multi-Instance Redo apply also works with BCT

* Available only on Exadata and Oracle Cloud Offerings

 

18c: RMAN and Data Guard Enhancements

Active Data Guard Sync

 

  • New RECOVER STANDBY DATABASE FROM SERVICE
  • One command to refresh the standby database
  • Refreshes controlfile, datafile, restores newly added datafiles
  • Start RMAN and connect as target to the physical standby database.
  • Roll forward the physical standby database using the RECOVER STANDBY DATABASE command with the FROM SERVICE clause

RECOVER STANDBY DATABASE FROM SERVICE primary_db;

 

Creating GTTs on Active Data Guard

– Creating GTTs today will fail when executed on Active Data Guard

– In Oracle Database 18c CREATE GLOBAL TEMPORARY TABLE on an Active Data Guard standby will:

  • Create the GTT on the Primary
  • Wait for the GTT to be replicated and applied to the Active Data Guard standby
  • Return control to the user

Transient tables useful for reporting applications

 

Global temporary tables

Persistent, shared (global) table definition

Temporary, private (session-based) data content

  • Data physically exists for a transaction or session
  • Session-private statistics

Private temporary tables (18c)Temporary, private (session-based) table definition

  • Private table name and shape

Temporary, private (session-based) data content

  • Session or transaction duration

Executing DML on Active Data Guard

– DML Re-direction automatically performed from Active Data Guard standby to the Primary without compromising ACID

  • Standby ADG session waits for updates to show up on ADG via redo apply
  • DML data re-directed by an ADG session is only visible to that session before commit
  • DML data re-directed is visible to all sessions after ADG session commits
  • Enabled by setting parameter _enable_proxy_adg_redirect=TRUE and appropriate connectivity parameters
  • Respects ACID properties of a database for ADG session
  • Targeted for “Read Mostly Occasional Updates” applications

Keep Buffer Cache at Role Change

How often we did not dream for having a switchover without losing some transactions because of that..

Well, part of that dream “come true”..

– The database buffer cache state will be maintained on an ADG standby during a role change

 

– Automatic, nothing to set up.

  • Services need to be configured correctly

Control login attempts

– The ADG_ACCOUNT_INFO_TRACKING parameter extends the control of user account security information and reaction.

  • ‘LOCAL’ (default value) continues to enforce the existing behavior
    • Maintains local copy of users account information in the Standby’s in-memory view.
      • Login failures are only tracked locally on a per database basis and login denied when the failure maximum is reached.

– ‘GLOBAL’ triggers the new secure behavior

    • Maintains a single global copy of users account info across all Data Guard databases
      • Login failures across all databases in the Data Guard configuration count towards the maximum count and logins anywhere will be denied when the count is reached.

Data Guard and No Force Logging

How often you have been in the situation to repair/reinstate an Standby Database because a load was done in “No Logging mode”.

It was really a hard situation for many companies to know that some specific loads could be done very efficient and fast in “No Logging mode” but sometimes there was not another option if we wanted to preserve the health state of our standby databases. Now, we have a new feature to make more versatile some specific loads in “No Logging mode”

 

  • Extended to provide better support in an Active Data Guard environment without significantly increasing the amount of redo generated.
  • Two new modes are added as alternatives to the existing nologging mode
    • Standby Nologging for Load Performance
      • Ensures that standbys will receive the nonlogged data changes with the minimum impact to the speed of loading at the primary
        • The standby can transiently have nonlogged blocks. These nonlogged blocks will be automatically resolved by managed standby recovery.
    • Standby Nologging for Data availability
      • Ensures all standbys have the data when the primary load commits but at the cost of throttling the speed of loading data at the primary
      • The standbys will never have any nonlogged blocks.

In Oracle Release 12.1 & 12.2 there a lot of new features that perhaps you have not experimented up to now. Here we have a list of all them so that you can differentiate to what release belongs the new features you will use.

 

RMAN

Oracle 18c: RMAN New Features.. What’s NEWS..

 

Review – Data Guard 12.1 New Features Summary

Data Guard

  • SYSDG Role for Data Guard specific operations
  • Multitenant Database Standbys
  • Default Real Time Apply
  • Transparent Online Data file movement
  • Single SQL*Plus Switchover command
  • No Primary instance shutdown for switchover
  • FastSync (SYNC NOAFFIRM)
  • Enhanced Extended Datatype Support for upgrades
  • Logical Standby support for additional data types
    • XMLType data for all storage models, Oracle Spatial, Oracle Multimedia, Oracle Text, Objects and Collections (including VARRAYs and nested collections), Database File System (DBFS), XDB, Oracle SecureFiles (deduplication), and User-defined types.
  • DBMS_SCHEDULER support for Rolling Upgrades
  • Broker VALIDATE DATABASE capability
  • Enhanced Broker configuring with RedoRoutes
  • Broker Resumable switchover
  • New Broker Observer properties and capabilities
  • Broker support of Cascading Redo destinations

Active Data Guard

  • Real Time Cascading Redo destinations
  • WAN Distance Zero Data Loss with Far Sync
  • Global Temporary Table DML on a standby
  • Sequences (global and session) on a standby
  • DBMS_ROLLING automated rolling upgrades
  • Support for Oracle Application Continuity
  • Support for Oracle Global Data Services

Review – Data Guard 12.2 New Features Summary

Data Guard

  • Use DBCA and EMCLI to create Standbys
  • Use RMAN and Enterprise Manager to create Far Sync Instances in addition to Standbys
  • Rest Interface to the Data Guard Broker
  • Chef tools to create and manage Data Guard standbys
  • Scripting with the Broker DGMGRL command line interface
  • Easily creating Subset Standby databases in Multitenant
  • Migrate and Failover PDBs with the Broker
  • Automatic Password File management
  • Easy repair of No Logging operations
  • Data File Block Comparison between Primary and Standby
  • Multiple FSFO Targets and Observers
  • FSFO in Maximum Protection mode
  • Zero Data Loss Failovers in any mode with Storage Failures
  • Enhanced control of Alternate destinations
  • Convert to TDE easily with little or no downtime

Active Data Guard

  • Using all your Standby Instances to apply redo
  • Data Guard Broker Support and involvement in DBMS_ROLLING controlled rolling upgrades
  • Use the In Memory Column Store on your Standby
  • Use AWR and SQL Tuning Advisor to diagnose and tune Redo Apply and Query issues on your Active Data Guard Standby
  • Move users transparently during role change with Session Draining on the Primary and Preserving existing connections at the Active Data Guard Standby
  • More protection with Auto Block repair enhancements

this is the end of this article, we hope it can be useful.. Stay tune for more Oracle Database Cloud articles.

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.co

 

This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com

Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/

Subscribe to our Blog and enjoy our Weekly Cloud article..!

ByJoel Pérez ( Oracle ACE Director )

Oracle 18c: Oracle 18c.. New Features.. What’s NEWS..

Oracle 18c: Oracle 18c.. New Features.. What’s NEWS..

Oracle 18c 新功能一览

 

By Joel Peréz Skant Gupta

 

This article is brought by en.enmotech.com

 

Well.. Oracle 18c.. one release more.. ? Uhmm perhaps not.. Oracle 18c has a that kind of air of.. “Starting now.. it’s when Oracle Cloud Database will mark a real strong beginning..”

 

I have been playing with Oracle Databases in Cloud from some years ago when all this was barely starting.. when it was more the concept of “Cloud Computing” as a whole.. I’m talking about when the Cloud Computing model was originally designed to be implanted “On-prem”, basically with an arrange of some servers.. software.. resources ( CPU.. Memory.. etc ) and all that could be managed by Enterprise Manager to built your own Cloud infrastructure but “On-prem”, that was around year 2013.. the service of Public Cloud was not still available in that time.. In that time we started to know concepts of “Pay-as-you-go..”.. “Chargeback..” and things like that.. the real concept of that first commercial proposal was really a model of “Cloud Computing”

 

In that time the concept of Oracle Database Cloud was extreme far from what it’s nowadays.. of course.. the product.. the concept was getting mature.. getting shape..

A couple of years later the first Public Cloud services appeared in the market.. year 2015.. Uhmm.. this was really a more close image of what we were having in mind about Oracle Database Cloud.. of course.. it was product that was changing all time.. and getting mature.. at the beginning even you could not choose the database character set.. the wizard interface had more steps.. and so on.. it was like a child opening his/her eyes to the world.. and we could enjoy how all that was growing..

 

Little by little more Oracle Database Cloud Services were starting to be available as per we have now:

  • Oracle Database Cloud Service
  • Oracle Bare Metal Cloud Database Service
  • Oracle Database Exadata Cloud Service
  • Oracle Database Exadata Cloud Machine
  • Oracle Database Express Cloud Service

 

All these lastly mentioned does not include the future new Oracle Database Cloud Services that will be available starting with Oracle 18c.

 

So.. continuing with the subject.. Oracle Database Cloud services were still changing/evolving.. even its web interface, pricing model, etc until the last months.. so.. it can be said the product was still modeling itself.. but internally we can consider it already a strong product.

 

So, according to my point of view, all that was a process to see how the product had interaction with real people.. with real customers.. with real companies.. All that was the preparation way to present finally the king product.. “Autonomous Database Suit of Services on Oracle18c..”, which is a great mix of all learned with Oracle Cloud Database Services and all years making better and better the auto-performance tuning techniques.. ( AWR, ADDM, Advisors.. etc )

 

So, I consider Oracle 18c and all its new feature a real “before and after” related to Cloud Databases..

 

Oracle 18c as every release.. has many new features.. that can be suitable for some kind of companies and others not too much.. as always.. perhaps a small company for sure will not be interested in autonomous database running in a powerful Exadata and so on.. Perhaps new “Startup” companies could be very interested in the regular “Oracle Database Cloud Service” to have a cheap and fast IT infrastructure.. not thinking as before how costly could be to establish an own data center.. etc..

 

So, the point it’s.. Oracle 18c as every release has new features for everyone..

 

The objective of this article is to name/to introduce them briefly before we can get the real production release starting December 2018.

 

Then, Let’s talk briefly technically of What’s news in Oracle Database 18c..

 

The figure you will see now is the Lifetime Support Commitments and Plans for current and future Oracle Releases.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

*Oracle Database 19c is expected to the long term support release.

Always check MOS Note 742060.1 for the latest schedule.

 

As you can see between all that information, we will have extended support of 12.2 until 2025 and Oracle 18c will start on December2017. There are a lot of people in fear for the future for DBAs related to Autonomous Database & Oracle 18c, if you want to read my point of view about that subject go here:

#10 Oracle 18c: “Oracle 18c and its impact on DBAs”

 

Now, Let’s highlight briefly some of what we have today and what we will have in Oracle Database 18c

 

Performance

Today:

  • In-Memory Column Store
  • Software in Silicon
  • Engineered Systems

Oracle Database 18c:

Low Latency Memory Transactions

  • 2x throughput for streaming ingest
  • 4x throughput for low latency key lookups

Non Volatile Memory Support

  • Multi Tiered Database Cache

In-Memory Column Store Improvements

  • Performance improvements
  • Automatic Population

 

Memory Optimized Access for OLTP Workloads

Example: Read Joel’s Balance

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Ultra-Fast key-based lookup:

  • Uses new lock-free In-memory hash index
  • Just declare table MEMOPTIMIZE FOR READ

New low latency client protocol with direct access to data engine

Performance benefits:

  • Up to 4x throughput increase for Primary Key based lookups
  • 50% lower response times

 

Memory Optimized Access for IoT Workloads

Example: Write Temperature Reading


 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

New streaming ingest:

  • Declare table MEMOPTIMIZE FOR WRITE
  • Clients performs low-latency write into in-memory buffer
  • Buffered writes drained in background
  • Very high throughput inserts since server issues deferred writes in large batches

Performance:

2x faster throughput than conventional

  • 21M inserts per second on 2-socket server

 

Multitenant

Today:

Container managed database virtualization

Manage Many as one

  • Patching, Backup, Security, Online Cloning, Online Relocation

Software as Service

  • Shared metadata, Data location transparency

Oracle Database 18c:

  • Per-PDB Switchover
  • Transportable Backups
  • Snapshot Carousel
  • Faster Upgrades

Example of

  • Per-PDB Switchover

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

RMAN

Oracle 18c: RMAN New Features.. What’s NEWS..

http://blog.enmotech.com/2017/12/17/16-oracle-18c-rman-new-features-whats-news/

 

Oracle Data Guard

Oracle 18c: New Features for Oracle Data Guard.. What’s NEWS..

RAC

Oracle 18c: RAC New Features.. What’s NEWS..

Availability

Today:

Comprehensive HA and disaster recovery functionality

  • Real Application Clusters, Active Data Guard, Recovery Appliance

Oracle Golden Gate for heterogeneous replication

Scale out and fault isolation with Oracle Database Sharding

 

Oracle Database 18c:

Zero Impact Grid Infrastructure Patching

Sharded RAC

  • Logically partition data across instances in RAC
  • Sharded access for shard-aware applications and transparency for non-sharded applications

Sharding improvements

  • User Defined Sharding
  • Improved Cross Shard Query support

 

Sharded RAC

Higher performance for shard-aware RAC applications

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Affinitizes shards to RAC instances

  • Requests that specify sharding key will be routed to the RAC instance that logically holds the shard
  • Affinity gives better cache utilization and reduced block pings across instances

Requests that don’t specify sharding key still work transparently

Gives Sharded Database performance with minimal application changes

  • Just add sharding key to the most performance intensive operations

 

Security

Today:

Security In-Depth

  • Access Controls, Encryption, Redaction, Masking, Auditing, SQL Firewalls

Key Vault

Audit Vault Database Firewall

Security Assessment Tool

 

Oracle Database 18c:

Integration with Active Directory

  • Authorization to database through Active Directory user/group mappings to database schema users and roles

Per PDB Key storage

Password-less schema creation

  • No default passwords

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Data Warehousing and Big Data

Today:

The most advanced analytics engine available today

  • Partitioning, Compression, SQL, Analytical Views, Analytical SQL, Data Mining

Easily analyze data held in Hadoop with Big Data SQL

Big Data Appliance

 

Oracle Database 18c:

In-Memory for external tables

Automatic propagation of nologged data to standby

More Machine Learning algorithms

Polymorphic Table Functions

Alter Table Merge Partition Online

Approximate Query Improvements

 

Development

Today:

Application Express 5.1

SQL Developer & SQLCl

Comprehensive Language support

  • PL/SQL, SQL , Python, Node.js, PHP, Java, C, .NET, REST

JSON

  • SODA API, SODA REST API
  • SQL Support

 

Oracle Database 18c:

Improved JSON Support

Property Graph Improvements

  • Support for PGQL

Rolling patches for OJVM

Private Temporary Tables

 

Private Temporary Tables

Transient tables useful for reporting applications

 

Global temporary tables

Persistent, shared (global) table definition

Temporary, private (session-based) data content

  • Data physically exists for a transaction or session
  • Session-private statistics

 

Private temporary tables (18c)

Temporary, private (session-based) table definition

  • Private table name and shape

Temporary, private (session-based) data content

  • Session or transaction duration

 

Database Instance Management REST API

  • A REST API to provide instance management and monitoring
  • Same consistent API for Cloud and On Premises
  • Simple API for all database lifecycle operations
  • Supports Oracle Databases integration with orchestration frameworks
  • Expected CY2018

 

List the pdbs in the exadata database container: https://myserver.mydomain.com/ords/databases/exadata/pdbs

 

Official Docker Support

Oracle Database is fully supported on Docker for

  • Oracle Linux 7
  • Red Hat Enterprise Linux 7

** Oracle RAC is not supported on Docker “CURRENTLY” but in Oracle 18c Oracle RAC support is coming

MOS Note: Oracle Support for Database Running on Docker (Doc ID 2216342.1)

Oracle 12.2.0.1 & 12.1.0.2 images are available on Oracle Container Registry

Docker build files also available at

 

New Installation Approaches

  • Oracle Gold Image as a Service
  • On demand image creation including application of RUs, RURs and one off patches
  • Request images as a

Zip file, TAR File, Docker Image, Virtual Box, VM (Ravello, BMC, Vbox)

  • Web Interface or REST API
  • Coming soon…

Oracle Installation via RPM

  • Oracle EE, SE2, and Grid Infrastructure

 

Oracle Database 18c XE

  • Free use for development and production
  • Expected CY 2018
  • Nearly all functionality is included
  • Limited to 12GB of user storage
  • Limited to 2GB of SGA

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

Follow us in Enmotech LinkedIn Page: https://www.linkedin.com/company/1856106/

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.co

 

This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com

Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/

Subscribe to our Blog and enjoy our Weekly Cloud article..!

ByJoel Pérez ( Oracle ACE Director )

#1 Oracle Cloud (DBaaS): Oracle Data Guard in Database Cloud Service ( DBCS )

By Joel Peréz   & Skant Gupta

This article is brought by en.enmotech.com

 

Full Index of Oracle Cloud Articles:

Sir.CloudDBaaSjoelperez

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

Hi Readers, in this article you will go through the steps to create a disaster recovery configuration with Oracle Data Guard using the public Cloud Service “Oracle Database Cloud Service”. Across a simple wizard you will see how easy is to create a configuration with Data Guard in Cloud-Cloud Deployment. So.. Let’s start..

 

When creating an Oracle Database Cloud Service database deployment at the Oracle Database Cloud Service level, you can create an Oracle Data Guard configuration.

 

Since we will talk about Oracle Data Guard, let’s remember the concept:

 

Oracle Data Guard enables production Oracle databases to survive disasters and data corruptions by providing a comprehensive set of services that create, maintain, manage, and monitor a standby database. Oracle Data Guard maintains the standby database as a copy of the production database. If the production database becomes unavailable because of a planned or an unplanned outage, you can switch the standby database to the production role, minimizing the downtime associated with the outage.

 

To create an Oracle Data Guard configuration in Database Cloud Service, make the following choices in the Create Service wizard:

 

  • For Service Level, choose Oracle Database Cloud Service.
  • For Software Edition, choose Enterprise Edition, Enterprise Edition – High Performance, or Enterprise Edition – Extreme Performance.
  • For Database Type, choose Single Instance with Data Guard Standby.
  • For Standby Database Configuration (on the Service Details page), choose where you want the standby database placed in relation to the primary database:
    • o High Availability—The standby database is placed in a different availability domain from the primary database, thus providing isolation at the infrastructure level.
    • o Disaster Recovery—The standby database is placed in a different data center from the primary database, thus providing isolation at the infrastructure level and geographical separation to support availability despite catastrophic events.

When you make these choices, Database Cloud Service creates an Oracle Data Guard configuration with a primary database and a single standby database, hosting the databases on two independent compute nodes. It creates these compute nodes using computing, storage and networking resources provided by Oracle Compute Cloud service.

 

Create the Oracle Data Guard in Cloud Database Service

 

a) Login to your Oracle cloud services account, go to the “Oracle Database Cloud Service” page and create a new service.

  • For Service Name, select DATAGUARD.
  • From the Service Level list, select Oracle Database Cloud Service.
  • From the Metering Frequency list, select whatever frequency is appropriate for your environment.
  • From the Software Release list, select Oracle Database 11g Release2.
  • From the Software Edition list, select Enterprise Edition.
  • From the Database Type list, select Single Instance with Data Guard Standby.

Then click Next to continue.

 

 

 

 

 

 

 

 

 

 

Figure1. Creating a new service (DATAGUARD)

 

b) In the Service Details screen, do the following:

  • For DB Name (SID), enter ORCL.
  • Set an administrative password of your choice and confirm the password (this will be your sys password).
  • For Usable Database Storage (GB), enter 25.
  • From the Compute Shape list, select OC3 -1 OCPU, 7.5GB RAM (this is the bare minimum required).
  • For SSH Public Key, enter rsa-key-20170111.pub.
  • From the Standby Database Configuration, select Disaster Recovery.

Then click Next to continue.

 

 

 

 

 

 

 

 

 

 

 

 

 

Figure 2. Specifying the service details

 

c) Finally, review the configuration and click Create to create your cloud database.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Figure 3. Creating the cloud database instance

 

c) After a few minutes, the data guard in cloud database instance has been created successfully.

 

 

 

 

 

 

 

 

 

Figure 4. The cloud database has been created

 

d) Click the service name (DATAGUARD) to open the main page of the database.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Figure 5. Main page of the dataguard on cloud database

 

Connect the Cloud Database

 

1. Open the two instances of the PuTTY executable and connect to the machine using SSH public key.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Figure 6. Connecting to machines using PuTTY

 

Check the Status of Oracle Data Guard on Cloud

 

  1. On the Database Cloud Service compute node, invoke SQL*Plus and log in to the database as the SYS user on both machines.

On Primary Machine

[oracle@DATAGUARD-dg01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Jun 21 18:20:30 2017

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production

With the Partitioning and Real Application Testing options

SQL>

 

On Standby Machine

[oracle@DATAGUARD-dg02 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Jun 21 18:20:30 2017

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production

With the Partitioning and Real Application Testing options

SQL>

 

2.- Check the status of database role on both machines.

 

On Primary Machine

SQL> set lines 200

SQL> select name, db_unique_name, database_role, switchover_status, open_mode from v$database;

 

NAME DB_UNIQUE_NAME DATABASE_ROLE SWITCHOVER_STATUS OPEN_MODE

——— —————————— —————- ——————– ——————–

ORCL ORCL_01 PRIMARY SESSIONS ACTIVE READ WRITE

 

SQL>

 

On Standby Machine

SQL> set lines 200

SQL> select name, db_unique_name, database_role, switchover_status, open_mode from v$database;

NAME DB_UNIQUE_NAME DATABASE_ROLE SWITCHOVER_STATUS OPEN_MODE

——— —————————— —————- ——————– ——————–

ORCL ORCL_02 PHYSICAL STANDBY NOT ALLOWED READ ONLY WITH APPLY

 

SQL>

 

Checking the Status of the Oracle Data Guard Configuration with dbaascli utility

You can use the dataguard status subcommand of the dbaascli utility to check the status of your Oracle Data Guard configuration.

Before performing certain operations, you may want to check the status of your Oracle Data Guard configuration.

To check the status of the Oracle Data Guard configuration by using the dataguard status subcommand:

 

  1. Connect to either compute node in the Data Guard configuration as the oracle user.

 

 

Using username “opc”.

Authenticating with public key “rsa-key-20170425”

Passphrase for key “rsa-key-20170425”:

[opc@DATAGUARD-dg01 ~]$ sudo su – oracle

[oracle@DATAGUARD-dg01 ~]$

 

2. Check the status of the configuration

 

 

[oracle@DATAGUARD-dg01 ~]$ dbaascli dataguard status

DBAAS CLI version 1.0.0

Executing command dataguard status

SUCCESS : Dataguard is up and running

DETAILS:

Configuration – fsc

Protection Mode: MaxPerformance

Databases:

ORCL_01 – Primary database

ORCL_02 – Physical standby database

Properties:

FastStartFailoverThreshold= ’30’

OperationTimeout= ‘120’

FastStartFailoverLagLimit = ’30’

CommunicationTimeout= ‘180’

ObserverReconnect = ‘0’

FastStartFailoverAutoReinstate= ‘TRUE’

FastStartFailoverPmyShutdown= ‘TRUE’

BystandersFollowRoleChange= ‘ALL’

ObserverOverride= ‘FALSE’

ExternalDestination1= ”

ExternalDestination2= ”

PrimaryLostWriteAction= ‘CONTINUE’

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

[oracle@DATAGUARD-dg01 ~]$

 

3. Check the status of the configuration with detail subcommand

 

 

[oracle@DATAGUARD-dg01 ~]$ dbaascli dataguard status –details yes

DBAAS CLI version 1.0.0

Executing command dataguard status –details yes

SUCCESS: Dataguard is up and running

{

“instances” : [

{

“DATABASE_TYPE” : “PRIMARY”,

“PROTECTION_MODE” : “MAXIMUM PERFORMANCE”,

“PROTECTION_LEVEL” : “MAXIMUM PERFORMANCE”,

“ADDITIONAL_MESSAGES” : “”,

“DATABASE_NAME” : “ORCL_01”,

“PENDING_APPLY_LOG_CNT” : 0,

“ACTIVE_SESSIONS” : “3”,

“HOST_NAME” : “DATAGUARD-dg01”,

“OPEN_MODE” : “READ WRITE”

},

{

“PROTECTION_LEVEL” : “MAXIMUM PERFORMANCE”,

“ADDITIONAL_MESSAGES” : “”,

“APPLY_LAG” : “00 days 00 hrs 00 min 00 sec”,

“DATABASE_NAME” : “ORCL_02”,

“APPROXIMATE_ROLE_TRANSITION_TIME” : “00 days 00 hrs 00 min 00 sec + 30 sec”,

“ACTIVE_SESSIONS” : “2”,

“HOST_NAME” : “DATAGUARD-dg02”,

“TRANSPORT_LAG” : “00 days 00 hrs 00 min 00 sec last computed 0 days 0 hrs 0 min 9 sec before”,

“PROTECTION_MODE” : “MAXIMUM PERFORMANCE”,

“DATABASE_TYPE” : “PHYSICAL STANDBY”,

“OPEN_MODE” : “MOUNTED”

}

]

}

[oracle@DATAGUARD-dg01 ~]$

 

Conclusion

 

So now you know that it is very easy to create the Oracle Data Guard in Database Cloud Service.

This article will continue with two more parts where we will see the steps necessary to perform Switchover, Failover & Reinstate Operations with Console and then performing the same with dbaascli utility.

 

If you want to be updated with remarkable articles and information about Oracle Database Cloud,

Join our network, we will be please to have you there:

Joel Pérez: https://www.linkedin.com/in/sirdbaasjoelperez/

Skant Gupta: www.linkedin.com/in/skantali/

 

We invite you to read the following part of this article:

Oracle Cloud (DBaaS): Switchover, Failover & Reinstate Operations on Oracle Data Guard using DBCS Console

https://community.oracle.com/blogs/Sir.DBaaSJoelPerez/2017/09/01/oracle-cloud-dbaas-switchover-failover-reinstate-operations-on-oracle-data-guard-using-dbcs-console

 

And as a Cloud Topic related you can read here one of our hotest articles:

#10 Oracle 18c: “Oracle 18c and its impact on DBAs”

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.com

 

This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com

Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/

Subscribe to our Blog and enjoy our Weekly Cloud article..!

ByJoel Pérez ( Oracle ACE Director )

Oracle DBaaS: The Changing Role of the DBA ( Cloud )

Hi Readers

 

The changing role of Oracle DBAs has been a very hot topic from the OOW17. Based on Larry Ellison Speech that humans will not be required for keeping running the databases, many people started to worry about it. The reality is very simple.. Autonomous Database Service will not be the regular mechanism of regular databases that could administer in “On-prem” enviroments.. etc.

 

I talk very deep about that subject in this article, check it:

Oracle 18c: “Oracle 18c and its impact on DBAs” – Enmotech Blog

 

Penny Avril, vice president of product management has answered some interesting questions related to topic of DBA Changing Role.

Questions such as:

  • Do DBAs have specific concerns with the growing acceptance of cloud in the enterprise?
  • Are their jobs becoming easier or more difficult? How so?
  • What is changing in terms of their responsibilities?
  • What does this mean about the DBA role?
  • What should DBAs do to prepare for the new cloud reality?
  • In what ways does cloud put DBAs in a better position than they were before?

Questions like these and more are answered by Penny Avril, read at the link down below and enjoy it!!

The Changing Role of the DBA: Q&A with Oracle’s Penny Avril – Database Trends and Applications

 

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Join our LinkedIn group: Oracle Cloud DBaaS

or Subscribe to our Enmotech Blog!

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.co

 

This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com

Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/

Subscribe to our Blog and enjoy our Weekly Cloud article..!

ByJoel Pérez ( Oracle ACE Director )

Oracle 18c: “Oracle 18c and its impact on DBAs”

By Joel Peréz Skant Gupta

 

“DBAs will be fired.. ? It’s the end of DBAs because of the Autonomous Databases..?

Obviously not.. believe it or not.. now the DBAs will have more important role in enterprises.

Later of completing the reading of this article you could read more about new features related to Oracle18c:

Oracle 18c: Oracle 18c.. New Features.. What’s NEWS..

http://blog.enmotech.com/2017/12/17/14-oracle-18c-oracle-18c-new-features-whats-news/

Oracle 18c: New Features for Oracle Data Guard.. What’s NEWS..

http://blog.enmotech.com/2017/12/17/15-oracle-18c-new-features-for-oracle-data-guard-whats-news/

Oracle 18c: RMAN New Features.. What’s NEWS..

http://blog.enmotech.com/2017/12/17/16-oracle-18c-rman-new-features-whats-news/

Oracle 18c: RAC New Features.. What’s NEWS..

http://blog.enmotech.com/2017/12/17/17-oracle-18c-rac-new-features-whats-news/

Oracle 18c: Data Warehousing New Features.. What’s NEWS.

http://blog.enmotech.com/2017/12/17/18-oracle-18c-data-warehousing-new-features-whats-news/

Now, Let’s continue with the article..

I have +17 years as Oracle DBA and I could tell you how this profession have been evolving, having a tendency of:

  • More elaborated and advanced features.. that’s the essence of every new release..
  • More automated tasks released by release.. the DBAs and Enterprises must realise real advantages to perform early or convenient upgrades before the “Non support of Release” force them to do it..
  • and above all.. how to become DBA each day is even more complex than before.. and who will be affected by this.. this is the main point I want to focus in this short article.

Oracle Database 18c the next generation of the industry-leading database.

Oracle introduces the world’s first autonomous database cloud. Oracle Autonomous Database Cloud eliminates complexity, human error, and manual management, helping to ensure higher reliability, security, and more operational efficiency at the lowest cost.

 

 

At the previous paragraph I have highlighted the sentences “database cloud” & “Oracle Autonomous Database Cloud“, it means.. when we are talking about Cloud Databases, Oracle Autonomous Database Cloud is just another different kind of Cloud database service, so, in this article we will call it simply as “Cloud Databases”.

 

Autonomous Databases/Cloud Databases.. is a subject that could be analyzed from different points of views. Most of articles and publications focus in how ideal would be a futuristic database etc..

 

but Let’s think for a minute about Autonomous Databases..

Who will decide under what kind of service the databases will be.. ?

Who will implant the policies for those autonomous databases ?

Who will have the knowledge to decide or estimate the cost of these services based on the regular activities of those databases ?

Who will decide the complex design of IT Infrastructure when we have more and more options.. ?

The answer is obvious.. a DBA.. not any simple DBA.. a DBA that has evolved with all this new generation of databases on Cloud.

 

Oracle Autonomous Database as I mentioned before is a kind of different type of a Cloud Database Service. So.. in order to move that database from “On-prem” or create it from zero, a DBA must be needed..

 

Oracle Autonomous Database is a kind of database with a lot of mundane tasks already automated such as:

  • Applying of Patches
  • Upgrades
  • and Tunes itself..

The more important section of this article is the following

I will use the exact smart words of my colleague Tim Hall ( Oracle ACE Director ) “18c on-prem will have very little impact on DBAs. It is the Autonomous Database suite of services that have the impact”

  • “18c on-prem will have very little impact on DBAs”, Yes.. Exactly, Oracle 18c is just another higher version, “Oracle 18c” is not a relational database manager software that will work by default in autonomus mode, in fact, Autonomous Database suite of services has been designed “Up to now” just for Cloud, not for “On-prem” databases.
  • “It is the Autonomous Database suite of services that have the impact”, Autonomous databases is a kind of suit of services that will be available for “Oracle Public Cloud”, this means that “On-Prem” databases will not work in autonomous mode “until what we know up to now..”, perhaps later that kind of service could be available for “On-prem databases”

Most of DBAs currently are in fear believing “Autonomous Databases suite of Services” will let them without job.. but the reality is not even near to that.. actually there are several kind of services to lodge a database on Cloud:

  • Oracle Database Cloud Service
  • Oracle Bare Metal Cloud Database Service
  • Oracle Database Exadata Cloud Service
  • Oracle Database Exadata Cloud Machine
  • Oracle Database Express Cloud Service

“Autonomous Databases suite of Services” will represent just other possible services you could contract

 

Now, we will see some important points about Autonomous Databases that perhaps most of people does not know..

 

Oracle self driving database ( Autonomous Database ) will be available starting Oracle18c but there is still a huge period of support for 12cR1/R2. 12cR1 until 4 years more in comparison to this date, we are talking about until 2021 more or less..

12cR2 until April 2025 in extended support. As we know.. Customers normally are not moving so fast to a next release until they need it or until the support period is near to expire. So, Oracle 18c is a release that will be used for customers that really need it or by customers they want to be extreme up to date.

 

Up to now Oracle self driving database is designed to be run on Exadata, as per we know Exadata is an Engineering system very powerful but not cheap.. so.. most of customers for sure they will not be in Exadata.. it means.. Exadata has a high cost to be the regular hardware for most of regular medium companies around the world

 

So.. DBA’s no fear.. Oracle self driving database is not Oracle18c.. Oracle self driving database will not be the regular mechanism of your regular databases..

 

Then, important items to remember later of finishing to read this article:

  • Oracle 18c is not Autonomous Database suit of Services
  • Autonomous Database Service suit of Services is not Oracle 18c
  • Autonomous Database suit of Services is a kind of services available up to now just for Oracle Public Cloud
  • Autonomous Database suit of Services will run just in Exadata ( “According to the information we have up to now, later perhaps could change..”)
  • Oracle 18c is just one release more

So.. with those lines you have got the more important section of this article.

The conclusion is that “Oracle 18c” will have little impact for regular “On-prem” databases and databases services related to “self driving”

 

Now, Let’s extend this conversation..

 

But Let’s wait a minute.. Let’s analyze every one of those.. how it can be done today with the regular “Oracle Database Cloud Service (DBCS)” and how we think Oracle will do it.. We talk about “How Oracle will do it.. because the debut of Autonomous Datawarehouse Database Cloud will be in December 2017.

 

Applying of Patches: nowadays, if you want to apply a Patch using DBCS is just to go to the console, see on the screen if there is any available patch for that database and make some clicks to apply it.. So simple..

So.. I think is not “so difficult” for Oracle Corp, replace our clicks for an automated process..

There are some patches that require the database must be stopped because they change binaries.. etc.. well.. most probable Oracle had already a mechanism in order to apply patches having the database running and they have decided to release it now.. if we imagine how work the database inside running sequentially sentences.. etc.. every sentence.. operations.. etc all this can be coordinated so that patches affect in some way “post” sentences.. etc.. in a general way what I’m trying to say is.. the fact of applying patches by itself is not the big thing taking into account the level of development of the Oracle product during years.. So.. the applying patch by itself is just a step forward related to levels of automation.

 

Upgrades: Up to now when you are working with DBCS the only way to upgrade a database already working in the cloud is creating another service which will have another compute node and we apply a regular procedure to upgrade that database. However, we have to remember that Oracle has been working very hard in establish very advance mechanism to manage PDB. Nowadays we can clone PDB in hot, we can move PDBs from one container to another container in hot.. basically is very alike to the mechanism implanted to move a datafile online.. so.. this technology is extreme mature by the Oracle Software in these times.. So.. Upgrade a database must be surely a procedure a alike to what is done with PDB, the CDB in its root definition has the binaries of the corresponding version and we move just the data. I’m “sure”.. that’s the mechanism the Oracle software will use to upgrade databases in hot. So.. if we realise all I have commented.. all this is just a technology that we are using with the current release.. difference in autonomous databases is that they are applying this procedure with complete databases under this kind of new service.

 

Note : later of writing this article my colleague Tim Hall ( Oracle ACE Director ) had helped me to clarify that element, these are the exact words of Tim

Oracle have explained how the upgrades and patches will work. These systems are based on 18c running on Exadata. Since 18c allows rolling upgrades and patches for everything, including OJVM, they are able to do online patches for these services

Thanks Tim!!

 

Tunes itself: is even more easy to explain.. when you tune queries using adaptive technics.. etc.. all this can happen with the databases running.. rebuild indexes online.. etc.. must of tune operations nowadays can be done online.. it’s not so difficult to have an AI ( Artificial Intelligence ) engine collecting data and taking some decisions based on internal tests.. statistics.. etc.. so.. this new level of automation/autonomous is just what we have but being done automatically.

 

Let’s talk with what frequency we do these tasks:

 

Applying of Patches: time to time.. It’s not so frequent.. so.. there are not too much changes to appreciate in the time we employ in this task

Upgrades: even less.. it’s very seldom when we apply upgrades to the databases.. so.. there are not too much changes to appreciate in the time we employ in this task

Tunes itself: tuning.. yes.. many companies.. consultants.. etc.. employ a lot of time in constant tuning to databases for many reasons.. it’s very common that some objects.. some queries.. some code.. etc are added, removed.. changed in the database and of course this generate variations in the performance. This point could impact relatively highly the cost of many enterprises, because tuning a database constantly imply constant high costs. Of course.. we have to see how good the engine can be doing this. We have to remember that currently we have available “Tuning advisors” and they are not perfect.. sometimes we apply some recommendations and the performance of some executions.. etc.. become worst.. so.. the factor of “Tuning itself”.. really.. thinking very honest.. we have to see how that will work. If the results are very good and convenient.. definitely this factor will reduce a lot of cost to enterprises and of course will affect in some way DBAs specialized or in charge of tuning.

 

In December 2017 will be release the autonomous database service for Data warehouse, later on 2018 for OLTP and so on..

The tuning itself for Data Warehouse databases is easier than for OLTP Database according to my point of view. The typical and common operations.. ( Load.. queries.. etc ) are more common between them than for an OLTP database.

When you analize the conditions that will have autonomous databases for DW, you start to discover how it will work internally..

 

These are just some of them..

 

Automated Database Configuration for Autonomous DB for DW

• init.ora parameters

– Parameters optimized for DW workloads

– Memory, parallelism, sessions configured based on number of CPUs – Users can modify a limited set of parameters, e.g. NLS setttings

• Tablespace management

– Pre-defined data and temporary tablespaces – Users cannot create/modify tablespaces

• Compression

– All tables compressed using Hybrid Columnar Compression – Users cannot change compression method or disable compression

• Optimizer stats gathering

– Stats gathered automatically during direct load operations – Users can gather stats manually if they want

• Optimizer hints

– Hints ignored by default – Users can enable hints explicitly

• Result cache configuration

– Result cache enabled by default for all queries

 

and more.. I’ll talk more in detail about all this in an article dedicated to Autonomous DBs for DW.

 

Let’s come back a bit to the topic we were talking about automation and how enterprises can deal with that..

So.. one important thing to think.. You guess Enterprises with extreme important databases will allow to run all these tuning.. etc.. by itself without someone that can be monitoring what the database is doing.. ?

We are going to be honest.. Enterprises with critical databases will not allow to give the 100% of confidence to an engine software to tune itself on demand without control or supervision of a human. Of course, there are some databases.. under some levels of importance.. circumstances that fit that model.. to be tuned 100% without supervision but that not the regular cases.

That self tuning will have sections.. factor.. policies.. etc.. and DBAs will choose what elements could be tune by itself.. and which of them will keep under control of DBAs. At the end.. always DBAs will be needed.. Now DBAs will have more facilities to do their jobs more easy.. but that fact of thinking to replace totally the humans is something difficult to happen in spite of the engine can take correct decisions.

 

Let’s describe a simple example.. Oracle Data Guard has the option to FAILOVER automatically under some circumstances, but for some possible humans errors could happen a database can failover when the humans did not want it.. so.. most of enterprises they fear to use FSF ( Fast Start Failover ), It’s a mechanism that works perfect technically but to give the total control to the software to apply something critical to the data is something most of enterprises are not allow to implant.

 

In a general way I think autonomous databases will reduce tons of working hours for DBAs but will not represent in a practical and real way the elimination of Human presence.

 

So, autonomous databases promises the following:

 

Less time on Administration

– Less time on infrastructure

– Less time on patching, upgrades

– Less time on ensuring availability

– Less time on tuning

 

More time on Innovation

– More time on database design

– More time on data analytics

– More time on data polices

– and very important.. More time on securing data

 

So.. with databases on Cloud, DBAs must strength their skills in Security

 

Now Let’s jump to another point of analysis..

 

Future of DBAs related to Oracle Database Cloud

 

17 years ago.. it was so simple to design a database architecture. You had to decide to lodge your database in a:

  • Server..
  • Or in a Mainframe
  • Or even in a regular desktop machine in some cases..

Now, when DBAs will decide where to lodge databases must think in many options.. such as:

  • – Servers..
  • – Virtual Machines
  • – Engineering Systems such as “Exadata”
  • – and more..

They have to decide if the architecture will be implanted:

  • – “On-Prem” as the regular option
  • – Cloud in our own data center ( Private Cloud )
  • – Hybrid Cloud
  • – Public Cloud, now the public Cloud has more options with autonomous databases in Oracle18c.. etc

and more and more..

 

Before was so simple to design a database architecture.. now not.. Now we have a lot of options.. each one with pros and cons. Basically is a sea of options..

 

So.. the question is.. Who will be in charge of designing all this.. ?

The General Managers ? obviously not.. this will be designed by Database Architects.. ( DBAs )

Now DBAs will be asked more to understand the business rather than just the mechanics of keeping the database healthy and running

 

Before the cost of Servers.. services.. etc.. was not the main thing with what DBAs had to deal.. they were focused just in keeping the database running and implanting them. Now is different.. , now creating a database in Cloud, for example.. implies a decision of what kind of service to use and in what mode.. “Metered.. Non-Metered..” etc.. those factors impact directly the economy of the enterprise and the mode of operating these databases, so.. now the DBAs are more related into the business.

 

Some years ago from the first minute Oracle Corp. announced the release of “Oracle Cloud”, another level of expertise for DBAs was born, turning this business more complex..

DBAs will not be fired.. now the roles of DBAs are even more important.. the role of DBAs is simply shifting to be more of a role of architect..

 

Who must worry because of all these changes.. ?

Those kind of operational DBAs who are or were in charge just of doing simple tasks.. such as:

– Checking Backups..

– Checking storage..

– Making some reports..

– Installing Patchs..

– Installing softwares..

– Creating constantly new environments for developers..

 

All those easy and simple tasks.. have been removing with the addition of automation in Oracle Releases..

For instance, now at the time of creating an Oracle Database Cloud Service, there are many elements created automatically including:

– The creation of compute node ( Host )

– Installation of Software

– and more..

 

Here you can see how simple can be create a disaster recovery configuration on Cloud using Data Guard:

#1 Oracle Cloud (DBaaS): Oracle Data Guard in Database Cloud Service ( DBCS )

 

So.. with just this simple example.. you can realise that at the time of working with Oracle Database Cloud Service you do not have to install softwares anymore..

If you want to create a RAC configuration in a using Oracle Database Cloud Service is just some simple clicks and you could have complex RAC-DG configurations.

 

The era of regular and boring tasks is getting away.. so.. if you are a DBA in charge of those kind of simple tasks.. yes.. worry about your future..

 

Contrary of this, if you are a DBA in charge of implanting MAA architectures.. Cloud Databases, Exadata.. etc.. happy for you.. the importance of your role now will be bigger..

 

So.. now we come back to the central point of this article..

you can imagine what will be the vision of a person that is starting as DBA with all these numerous options in the market.. A person that is barely learning SQL.. and “Create table..” etc.. when the market is talking about autonomous databases.. It’s a comparison like between a kid bike and one 1000cc Motorbike.. something like that..

 

My though about all this is:

#1.- DBAs with kind of regular maintenance tasks.. could be removing from their role or job if they do not evolve to be focused in all this new generation related to Cloud

#2.- DBAs that have got the privilege to work with Oracle Databases during the golden era of “On-prem” databases, now they are in the right time to grow in parallel with something that is defining the “before” and “after” of IT. Now the DBAs will have the opportunity to move into a more strategic role in their organisations and based on that the income “salary.. commissions.. etc” will be higher.. now you will be involved in important decisions for the company

#3.- Sorry for new DBAs entering in this database world.. the journey you have to run is even harder than before to get the top level in this area because day by day are generated more and more options

 

Conclusion

1.- If you are a DBA kind #1 according to the previous description, perhaps you have several options.. evolve to #2, or if you decide to stay in the same role, your payment could be less over time or your role could be slowly disappear.

2.- If you are a DBA kind #2, keep on the track.. and your role will be more and more important in this field, by consequence your payment will have high probabilities to be increased. One more thing.. most of DBAs will not reach to be Cloud architects because this require time of study.. researching.. testing.. etc.. so.. feel proud if you reach it and take advantage of that inside your current or future organizations

3.- If you are a DBA kind #3, do not give up.. do not see the journey too long as It really is, just keep learning and you will get the level to be a good competitor in the market.

 

Now, perhaps you have the question.. How I can start to get ready to administer databases on Cloud ?

I could tell you, go to https://www.oracle.com/cloud/index.html and start there..

The page is the starting point of that monster called “Oracle Cloud.. ( PaaS, IaaS, SaaS..) etc etc”, you could be lost easily.

 

If you are DBA and you are interested in managing databases on Cloud, my main recommendation is to follow the path to become OCP Cloud.

The OCP Cloud has the base and initial path of knowledge that every DBA must domain to work with databases on Cloud.

 

This article finish here. If you have liked, go down below and share it in your prefer social medias: LinkedIn, Facebook.. etc. Thanks!!

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.co

 

This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com

Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/

Subscribe to our Blog and enjoy our Weekly Cloud article..!

ByJoel Pérez ( Oracle ACE Director )

Oracle Cloud: Ahead of the Curve

Hi Readers

 

As the leader of one of the world’s largest cloud development organizations, Oracle President of Product Development Thomas Kurian has an enviable view of the cloud economy. And whether in private conversation or on the public stage at events (such as Oracle OpenWorld), Kurian makes a strong pitch for Oracle’s position in the marketplace.

 

Thomas was interviewed by Oracle Profit where some questions like these were asked to him:

  • Oracle is ten years into its cloud journey. What have we learned from customers about our cloud portfolio?
  • How does Oracle’s cloud portfolio support customers’ need for the flexibility to adopt new technologies as they emerge?
  • How is Oracle uniquely qualified to help companies introduce emerging technologies such as AI and machine learning into their business processes?
  • What role does AI and machine learning play in the area of security? 

If you want to know the answer and more, Go here to read:

https://blogs.oracle.com/oracle-cloud%3a-ahead-of-the-curve

 

This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com

Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/

Subscribe to our Blog and enjoy our Weekly Cloud article..!

ByJoel Pérez ( Oracle ACE Director )

Oracle Cloud (DBaaS): How to access Oracle Cloud Instance in GUI Mode

How to access Oracle Cloud Instance in GUI Mode

By Joel Peréz   & Skant Gupta

This article is brought by en.enmotech.com

 

In this article we will show you how to access oracle cloud instance in GUI mode.

 

Create the new Cloud Database Service

a) Login to your Oracle cloud services account, go to the “Oracle Database Cloud Service” page and create a new service.

  • • For Service Name, select PREMISE.
  • • From the Service Level list, select Oracle Database Cloud Service.
  • • From the Metering Frequency list, select whatever frequency is appropriate for your environment.
  • • From the Software Release list, select Oracle Database 11g Release2.
  • • From the Software Edition list, select Enterprise Edition.
  • • From the Database Type list, select Single Instance.

 

Then click Next to continue.

1.JPG

Figure1. Creating a new service (Cloud-Mig12c)

 

b) In the Service Details screen, do the following:

  • • For DB Name (SID), enter ORCL.
  • • Set an administrative password of your choice and confirm the password (this will be your sys password).
  • • For Usable Database Storage (GB), enter 25.
  • • From the Compute Shape list, select OC3 -1 OCPU, 7.5GB RAM (this is the bare minimum required).
  • • For SSH Public Key, enter rsa-key-20170111.pub.

 

Then click Next to continue.

2.JPG

Figure 2. Specifying the service details

 

c) Finally, review the configuration and click Create to create your cloud database.

3.JPG

Figure 3. Creating the cloud database instance

 

c) After a few minutes, the cloud database instance has been created successfully.

4.JPG

Figure 4. The cloud database has been created

 

d) Click the service name (PREMISE) to open the main page of the database.

5.JPG

Figure 5. Main page of the cloud database

 

Connect the Cloud Database

1. Open the instance of the PuTTY executable and connect to the machine using SSH public key.

6.jpg

Figure 6. Connecting to machine using PuTTY

 

Login to Putty with OPC user

 

1. Login with OPC user and sudo to root

Using username “opc”.

Authenticating with public key “rsa-key-20170425”

Passphrase for key “rsa-key-20170425”:

[opc@PREMISE ~]$ sudo su

[root@PREMISE opc]#

 

2. Installing RPM with YUM

  • • yum groupinstall “X Windows System”
  • • yum groupinstall “X Window System” -y
  • • yum groupinstall “Desktop” -y
  • • yum groupinstall “Desktop Platform” -y
  • • yum groupinstall “General Purpose Desktop” -y
  • • yum groupinstall “Graphical Administrator Tools” -y
  • • yum groupinstall “Graphical Adminstration Tools” -y
  • • yum groupinstall “Graphical Administration Tools” -y
  • • yum install tigervnc-server
  • • yum install tigervnc-server -y
  • • yum install gnome-panel -y
  • • yum install firefox–y

 

2. Installing RPM with YUM

[root@PREMISE opc]# yum groupinstall “X Windows System”

[root@PREMISE opc]# yum groupinstall “X Window System” -y

[root@PREMISE opc]# yum groupinstall “Desktop” -y

[root@PREMISE opc]# yum groupinstall “Desktop Platform” -y

[root@PREMISE opc]# yum groupinstall “General Purpose Desktop” -y

[root@PREMISE opc]# yum groupinstall “Graphical Administrator Tools” -y

[root@PREMISE opc]# yum groupinstall “Graphical Adminstration Tools” -y

[root@PREMISE opc]# yum groupinstall “Graphical Administration Tools” -y

[root@PREMISE opc]# yum install tigervnc-server

[root@PREMISE opc]# yum install tigervnc-server -y

[root@PREMISE opc]# yum install gnome-panel -y

[root@PREMISE opc]# yum install firefox -y

[root@PREMISE opc]#

 

3. Creating the password for VNCServer.

[root@PREMISE opc]# vncserver :1 -depth 16 -alwaysshared -geometry 1600×720 -s off

You will require a password to access your desktops.

Password:

Verify:

xauth:  file /root/.Xauthority does not exist

New ‘PREMISE:1 (root)’ desktop is PREMISE:1

Creating default startup script /root/.vnc/xstartup

Starting applications specified in /root/.vnc/xstartup

Log file is /root/.vnc/PREMISE:1.log

[root@PREMISE opc]#

 

Creating Tunnels with PuTTY

1. Open the PuTTY executable and click on Tunnels.

For Source port,enter6905.

For Destination,enter141.144.32.52:5901.

 

Then Click on Add.

7.JPG

Figure 7. Connecting to PuTTY

 

2. Click on Open

8.JPG

Figure 8. Add tunnels

 

Connecting with VncServer

Create New Connection in VNCServer.

9.jpg

Figure 9. New connection in Vncserver

 

2. Create New Connection in VNCServer.

For VNC Serverenterlocalhost:6905.

For Encryption, select Prefer off.

10.jpg

Figure 10. entering details

 

3. Connect in VNCServer.

11.jpg

Figure 11. Connect to vnc server

 

4. Enter the Password and then click on OK.

12.jpg

Figure 12.password window

 

5. Now we are able to GUI Mode.

13.JPG

Figure 13. GUI Mode of VNC

 

Conclusion

So now you know that it is very easy to access GUI Mode in Cloud Instance.

Well.. Until here, this article. We hope it can be useful for making grow your knowledge about Oracle Database Cloud.

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events  like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.co

 

This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com

Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/

Subscribe to our Blog and enjoy our Weekly Cloud article..!