Continuing on the GCP 101 series, I will explain how you use GCP Disk Snapshots to clone a DB in a GCP VM..
I again want to mention that first you should check with Oracle and your licensing rep on what is supported and licensed before doing any of this work.
I have 2 VMs that I built using the steps in my post 101 SERIES OF ORACLE IN ...
I want to start with the news that on Monday Mar 1st, I presented my resignation letter at Pythian, and after reading an article by Dave Rensin on his lessons learned at Google, I wanted to write my version of what I have learned at Pythian.
While I was making this decision, in one of the conversations I had with my wife, she mentioned that I’m a very ...
This past weekend I was doing a production grid infrastructure(GI) Out Of Place Patching (OOP) from 19.6 to 19.8 for a client and while doing this exercise, I hit several bugs along the way (Bugs 20785766 and 27554103).
This blog post is how I solved them and hope it saves you a lot of time if you ever face this issue.
As I have already blogged in the past on ...
The other day I was doing a database cloning in 11.2.0.4, from an active duplicate and got the following error ORA-19909: datafile 1 belongs to an orphan incarnation and ORA-01110: data file 1.
This is a blog post on how I solved these errors. It is worth mentioning that what I did here applies to 12c,18c and 19c databases as well.
I first verified that I had the password file ...
The other day I was given the task of converting a single instance Oracle Enterprise Manager Management Service (OMS) Repository from legacy non-CDB (Container DataBase) to CDB architecture, and you will see that the steps are basically the same as converting a regular database, but just putting together all the extra steps that need to be done for the OMS repository in one blog post.
The first thing that ...
A couple of weeks ago a client of mine had a situation where DataGuard (DG) switchover that should have taken 5 minutes, took over 1 hour in troubleshooting and resolution. Right after the switchover completed, their application had issues connecting to the database. What we found out was that the database parameter LOCAL_LISTENER was set incorrectly.
We went ahead and fixed this parameter and went to rebuild the DG ...
Oracle 19c DataGuard introduced a very cool feature which is the ability to flashback your standby automatically if you flashback your primary.
The first thing I do in this test scenario is create a table called rene.test.
## Primary Database SQL> create table rene.test( name varchar2(100), num number) ; Table created. SQL> Begin for x in 1..3 loop for x in 1..100000 Loop insert into ...
My last post was on how to do an Out Of Place Patching for Oracle GI. The next thing that I wanted to try was the rollback procedure for this methodology, but as I searched in MOS and the Oracle documentation, I couldn’t find how to rollback from it using gridsetup.sh.
So the first thing I did was try to follow the document 2419319.1 for OOP rollback ...
I am going through a process of patching an Oracle Grid Infrastructure from 19.6 to 19.8 (Patch 31305339) and I wanted to try out Out Of Place Patching (OOP) for it, but since I don’t have access to their GUI environment, I proceeded to use the silent option. Below is how it went
I started with verifying that the GI services are up and running using Fred ...
The other day I was doing a fresh install of Oracle 19.3, using the binaries from edelivery , and doing some testing in that version and then patch it to 19.6. The installation and the tests went fine. What I did next is proceed with the analyze of the patch 30501910 and saw that everything was ok .
Lee mas acerca de este tema
This week I had the opportunity to path EM 13c with Release 4 Update 6 (13.4.0.6) and I won’t lie, this post is more for me than anything else, so that I have in handy the steps I took to patch EM. One of the things I did prior to starting this exercise was to update the OMSpatcher, but I won’t go into details on how to to ...
So this is a post that was in draft mode for almost 1.5 years. But even though that I know most clients are no longer in 11.2.0.4 , this is valid for anyone that still are and are thinking of an upgrade from 11.2 to 12/18/19.
I had been doing several test on my Spanish RAC Attack for 12.2 and creating several RAC VMs so that I can ...
This will be a short entry, but hopefully it will help you if you face the error ORA-01722 while doing an upgrade .
Today I was doing an Oracle RDBMS upgrade from 12.2 with DST 34 to 19.7 with DST 35 and the upgrade failed with the error below.
Processing config file ...
+--------------------------------+
| Starting AutoUpgrade execution ...
I thank you for coming back to this series. I wrote a couple of weeks the first part of the series and I was going to write for part II the automation with Ansible of the first part. But since there is very little blog posts on how Ansible works with GCP Compute and since you are a beginner , I will explain better just the GCP ...
About a year ago I worked on a project with some awesome teammates (Simon Pane and Karun Dutt) to work on a POC to move their Oracle environment into Google Cloud. These are some of the things I learned and this series will guide whoever is wanting to test out Oracle in Google Cloud.
I do want to make a note before I begin. I am no licensing expert, ...