Infrastructure at your Service

Category Archives: Cloud

Eric Simbozel

Oracle Database to SQL Server 2016 TCO Analyzer

By | Cloud, Database management | No Comments

Today, many enterprises are striving to transform their IT organization from a cost center into a strategic asset and looking for ways to get more value from their application and data platform investments. To deliver on this vision, Microsoft SQL Server 2016 – via its on-premises, cloud, or hybrid deployment options – provides customers with significantly lower total cost of ownership (TCO) compared to existing Oracle DB platform. How to know the real difference in…

 
Read More
Olivier Toussaint

DBSAT un outil pour la sécurité de vos bases de données Oracle

By | Cloud, Database Administration & Monitoring, Database management | No Comments

Qu’est-ce que DBSAT ? C’est un outil gratuit d’Oracle que vous pouvez télécharger sur My Oracle Support avec comme référence : Doc Id 2138254.1. Il a pour but d’évaluer la sécurité de vos bases de données Oracle en analysant la configuration et les stratégies de sécurité mise en place afin de découvrir les risques liés à la sécurité. Comment cela fonctionne t-il ? Dans un premier temps il sera nécessaire de collecter les informations de…

 
Read More
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