Infrastructure at your Service

Category Archives: Cloud

Franck Pachot

Google Cloud Platform instances and Oracle Database

By | Cloud, Database Administration & Monitoring | No Comments

When it comes to choose a cloud instance to run Oracle Database, you want to be able to run your workload on the minimum CPU cores. This is why in a previous post I measured how many logical reads per seconds can be achieved with a SLOB workload, on AWS which is often the first considered, and will probably do it on Azure in the future. I did the same on the Oracle Cloud which…

 
Read More
Franck Pachot

Oracle 12cR2, RAC, Cloud, ACFS, PDB thin clones and asmadmin

By | Cloud, Database Administration & Monitoring | No Comments

In the Oracle Public Cloud, fast provisioning gets all its meaning when creating a RAC database service: in one hour you can get an operational highly available multitenant database. You can even create it in Data Guard for Disaster Recovery. Now, Oracle is pushing ACFS to store the datafiles rather than direct ASM. Especially in multitenant because a great feature is thin cloning: CREATE PLUGGABLE DATABASE AS SNAPSHOT COPY. However, I encountered an error when…

 
Read More
Franck Pachot

Oracle Public Cloud 12cR2: TDE is not an option

By | Cloud, Database Administration & Monitoring | No Comments

In Oracle Public Cloud, Transparent Data Encryption is not an option. You can use it because it is included in all database services for all editions. You have to use it because the database won’t allow you to create, or import, non encrypted tablespaces. This is controlled by a new parameter, encrypt_new_tablespaces, which defaults to CLOUD_ONLY;  

 
Read More
Franck Pachot

Exadata Express Cloud Service: MAX_PDB_STORAGE

By | Cloud, Database Administration & Monitoring | No Comments

The separation of roles between system DBA and application DBA is the way to go for agile development and the PDBaaS managed service is an excellent way to play with this concept: You are PDB administrator but not the CDB administrator. Here is an example about tablespace creation/deletion, and the kind of problems that may arise with this architecture.  

 
Read More
Mouhamadou Diaw

Amazon Web Services: Upgrade to Dbvisit Standby 8

By | Cloud | No Comments

In a previous blog we installed Dbvisit Standby 7 on two AWS linux instances. In this article we are just upgrading to Dbvisit Standby 8. The first thing is to stop on both nodes dbvnet and dbvserver on both servers [oracle@primaserver dbvnet]$ ps -ef|grep dbv|grep -v grep oracle 2062 1 0 04:53 ? 00:00:02 /u01/app/dbvisit/dbvserver/dbvserverd oracle 2064 2062 0 04:53 ? 00:00:00 /u01/app/dbvisit/dbvserver/dbvserverd oracle 2131 1 0 04:54 ? 00:00:00 /u01/app/dbvisit/dbvnet/dbvnetd oracle 2132 2131 0…

 
Read More
Mouhamadou Diaw

Installing Dbvisit Standby 7 between two AWS Linux Instances

By | Cloud | No Comments

Dbvisit is compatible with Amazon Cloud. In this article we are going to talk about installation of Oracle SE2 and Dbvisit Standby 7 between 2 AWS linux instances. We suppose that ssh equivalence is configured for user oracle used for dbvisit installation. First we have to install oracle software on both servers: primaserver and standserver. To Install oracle-rdbms-server-12cR1-preinstall.x86_64 package yum can be used to configure the repository [root@primaserver yum.repos.d]# wget http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol7 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle –2016-11-14 03:52:34–…

 
Read More
Mouhamadou Diaw

Managing My Amazon Web Services Redhat Instance

By | Cloud | No Comments

In a precedent Blog I talked about how to create an AWS linux instance. Some questions can be: How to create a new user and to connect with, how to transfert files from my workstation, how to connect to my oracle instance from my workstation and so on. In this blog I am going to deal with some basic but useful  administration tasks. Changing my hostname One thing we will probably do is to change…

 
Read More