Infrastructure at your Service

Category Archives: Cloud

Oracle Team

Google Cloud Platform instances and Oracle Database

By | Cloud, Database Administration & Monitoring | One Comment

By Franck Pachot . 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…

Read More
Oracle Team

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

By | Cloud, Database Administration & Monitoring | No Comments

By Franck Pachot . 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…

Read More
Oracle Team

Oracle Public Cloud 12cR2: TDE is not an option

By | Cloud, Database Administration & Monitoring | No Comments

By Franck Pachot . 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
Oracle Team

Exadata Express Cloud Service: MAX_PDB_STORAGE

By | Cloud, Database Administration & Monitoring | No Comments

By Franck Pachot . 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
Mouhamadou Diaw

Linux Instance in Amazon Web Services (AWS)

By | Cloud | No Comments

In this article I will talk about how to create a linux machine in the cloud amazon AWS. For testing a trial account can be created. Once registered, we can connect by using the “Sign In to the Console” button To create an instance, let’s click on EC2 under Compute And then let’s use the Launch Instance button We can see the templates  for building our machine. In our exemple we are going to use…

Read More