Sunday, September 30, 2018

RMAN Recovery Catalog Issues after 12.2 Upgrade

Well, after the upgrade of the DB to 12.2 the next step is to upgrade the RMAN Recovery Catalog to the same version in order to be able to run backups using it. The process is pretty straight forward.
.    Connect to RMAN using target and catalog
.    Execute upgrade catalog

RMAN> upgrade catalog;

This finishes correctly. But then we try to resync the catalog we got below error:

RMAN> resync catalog;

starting full resync of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of resync command on default channel at 06/07/2018 22:15:36
ORA-01403: no data found

This is due to a bug 27013146. The solution is to apply this patch to the newly upgraded Oracle Home and re-run the upgrade catalog again.

More information can be found in MOS Note 2341947.1.

Everything is cool now, right? Well, now the old database backups are failing with below error:

RMAN-03008: error while performing automatic resync of recovery catalog

For that, the solution is outlined in MOS Doc Id 2291791.1.

Happy 12.2 upgrades!


Friday, August 31, 2018

Exadata/Exacloud CellServer health using AWR report

Exadata’s unique sauce relies on the fact that the DB instance can offload work to the CellServers to speed up I/O bound queries. But how do you monitor the health of the CellServers?

A quick and dirty way, especially if you don’t have access to the CellServers is to use AWR in a database that’s currently using those CellServers. Let’s get an AWR report and search for the SMART IO section. It should look like this.

What you want to see here is that % Total MB Requested is evenly distributed across all Cells. The same applies for Storage Index and Flash Cache metrics.

Now this is the interesting part. If you happen to see the Offload % Efficiency dropping for one of the cells, that means that the Cell is sending the complete blocks back to the DB and then the % Passthru metric is going to increase.

You don’t really want the % Passthru to increase as this will have a direct performance is the DBs being served by this Cell.

What are the reasons of this Passthru increasing?

There are 3 reasons for Passthru.

The first one is due to an issue with the Cell itself. The second one is due to issues with DST patches and the third one is related to user queries crashing the Cell.

You should look at the below MOS note in order to gather all the required information and open an SR immediately after you see this behavior.

SRDC - Exadata: Smart Scan Not Working Issues (Doc ID 2310422.1)


Thursday, August 9, 2018

Exalogic Agents being automatically deleted from OEM 13c

Oracle Enterprise Manager (OEM) 13c is capable of monitoring virtual guest hosts running on Exalogic (virtual configuration). OEM will connect (read-only) to the Oracle VM Manager and get the configuration and status of the VM’s running there. Then you can deploy an agent to those VM hosts and you have a complete monitoring solution for Exalogic.

The problem comes when for whatever reason you have to drop those VM’s from Exalogic but you want to keep the OEM configuration in place. For example, you want to drop the VM from Exalogic and then restore it from backup.

In this case you want to keep your monitoring configuration (metrics, credentials, etc.), but you realize that the agent was removed (along with all targets) as soon as you drop the VM from Exalogic.

This setup is being driven by metric like configuration. This synchronization is happening every minute by default.  This is covered on below Oracle’s document:

The solution was to set this synchronization schedule from every 1 minute to every 1 day.


Thursday, May 31, 2018

Manage Your Oracle Cloud Database - SQL Developer

In my previous post (How To Connect To The Oracle Cloud Instance) we reviewed the steps to connect using SQL Developer. Now we will see what DBA tasks we can perform using SQL Developer.

First click on the View menu, then click on the DBA sub menu. This is going to open the DBA pane in the lower left corner.

Click on Connections and add the connection we already setup to the Oracle Cloud Instance. 

Here you can expand the tree to verify what is available from SQL Developer.

Let's click on Tuning and then Real Time SQL Monitoring. The right pane is going to display the SQL Monitoring output. I'm really familiar to this feature in OEM 13c and honestly, looks very similar in SQL Developer.

Now let's click on Instance Viewer under Database Status menu.
This is going to show you the overall container status and statistics on where our PDB is running on.

The storage menu can help you verify the size of your tablespaces and under RMAN Backup/Recovery you can verify that there are actually backups happening every night. 


Wednesday, May 30, 2018

How To Connect To The Oracle Cloud DB Instance?

In my previous post (How To Create An Oracle Cloud Instance) I showed you create your first Oracle Cloud DB instance. Now that the instance is there the question is, how to connect to it?

Let's say you want to connect using SQL Developer to start creating objects and inserting data. First you need to enable the Client Access feature. Yes, it is disabled by default. 

Navigate to the Cloud DB instance dashboard. Click on Manage menu on the left side. 
Click on Admin Password and provide a password for the PDB_ADMIN account.

Then click on Client Access and check the enabled flag, then save.

It will show like this.

Once this is enabled you need to download the Access Credentials in order to connect to your instance.

Click on the Client Credentials button located on the right side of the Client Access one. This is going to prompt for a password (type one that you can remember) and it will download a .zip file containing these credentials and connect descriptors.

Note: You don't have to unzip this file.

Open your SQL Developer software and click on New Connection.

Type a name for your connection. In the username & password you can either type the PDB_ADMIN username and password or the credentials for the newly created schema.

In Connection Type select Cloud PDB and provide the downloaded .zip file along with the password provided (the one that you should remember).  

It should look like this.

Click Save and then Connect.

Now let's test our connection by executing a simple SQL statement.

Using the Cloud DB instance dashboard you can create different schemas as needed.
You just provide the username and password.

At the end you just need to follow the same steps as we did before, just provide the username and password of the new schema.

More information can be found at:


Tuesday, May 29, 2018

How To Create An Oracle Cloud Instance

In my previous post (Thinking on trying the Oracle Cloud? My 30 day experience) I showed you how to subscribe to the Oracle Cloud and how to get to the main dashboard. From here we are going to click on the Create Instance button.

After that you are going to be prompted on what kind if service this instance is for. You have 4 options; Messaging, Data Visualization, Exadata Express and Management Cloud.

In this example we want to create a database instance on Exadata Express. So we are going to select “Create” on the Exadata Express section.

Then you need to configure the instance details. First is the name (lowercase), then the plan and finally the Database shape. In this case I just want to create a small 20GB test instance.

On the right side you have administrator details. The default is the account we created to sign up to the Oracle Cloud.

Then click on Create.

You will get a message like the one below.

It took couple of minutes for the DB instance to be provisioned. Once ready, you’ll see the status of the instance as active in the dashboard.

Next click on the service instance URL and you will be re-directioned to the instance dashboard. In this dashboard you have 2 main options, Develop and Manage.

Develop option, gives you tools like SQLPlus, App Builder, SQL Developer and the option to enable access to client tools.

Manage option enables you to create users, change passwords, export/import and Apex administration.

This concludes the instance creation process. 


Thinking on trying the Oracle Cloud? My 30 day experience.

Although I already had some exposure to the Oracle Cloud (thanks to other Oracle ACEs that put an awesome workshop last year at Collaborate 2017) , I decided to sign up for a free 30 day ($300 dollars credit) and test the Cloud out.

The sing up process was kind of weird. You first go to and click on the “Try for Free” green button in the right upper corner and then “Create Free Account”.

Then you fill the formulary with all your personal data (account details), verification code (sent to your cell), credit card details (no charge will be made) and you need to agree the terms and conditions.

You will receive an email after you submit your formulary. That night I received an email from Oracle that asked me to provide the name of the bank of my credit card and the amount that was charged to it. Yes, they charged and then they removed the charge.

After asking them by email on how to provide this information, they responded that just by replying to that email with my information (seems pretty secure, right?). I received an email couple of hours later with my login credentials and the URL. Once you click on the hyperlink or type the URL provided, you are prompted to reset your password and then sent to the main dashboard.

In my next post, I will show you how to create your first Cloud Database instance.