Infrastructure at your Service

Cloud Archives - Page 3 of 6 - Blog dbi services

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
Franck Pachot

Running SLOB on Exadata Express Cloud Service

By | Database Administration & Monitoring | One Comment

The Exadata Express Cloud Service is a managed PDBaaS: Oracle is the system admin and the CDB database administrator, you are the PDB administrator. You connect with a local user, PDB_ADMIN, which is no SYSDBA privilege but has a PDB_DBA which has nearly all DBA rights, but with some features disabled by lockdown profile. I have no worry about the performance on this service: it is an Exadata X5 half rack bare metal (my guess),…

 
Read More
Franck Pachot

Oracle Core factor and Oracle or non-Oracle Cloud

By | Database Administration & Monitoring | 5 Comments

Oracle Database licensing can be based on two metrics: Processor or Named User Plus (NUP). NUP also necessitate to count the processors because there is a minimum number of NUP per processor. Then it is very important to know how to count processors. The time where a machine had 1 socket with 1 processor with 1 chip with 1 core running 1 thread is really old past. Today, we have physical machines with multi-core processors,…

 
Read More
Franck Pachot

Exadata Express Cloud Service: PDB_ADMIN privileges

By | Database Administration & Monitoring | No Comments

I usually explain that the main point about Multitenant Architecture is the separation of roles between a system DBA who manages the container, and is responsible for its availability, and application DBA who owns all the application objects, and is responsible for data integrity and performance. The Exadata Express Cloud Service is the implementation of that: a CDB managed by Oracle and a PDB that you administrate. But the fact that the system is shared,…

 
Read More
Franck Pachot

Encryption in Oracle Public Cloud

By | Database Administration & Monitoring | 4 Comments

Oracle Transparent Data Encryption is available without option on the Oracle Public Cloud: Standard Edition as well as Enterprise Edition (EE, EE-HP EE-EP, ECS). More than that, the DBaaS enforces TDE for any user tablespace even when not specifying in the CREATE TABLESPACE. It you are not familiar with TDE key management (wallets) then you have probably encountered ORA-28374: typed master key not found in wallet. Rather than another tutorial on TDE I’ll try to…

 
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
Nathan Courtine

Manage Azure in PowerShell (RM)

By | Database Administration & Monitoring, Hardware & Storage, Operation systems | No Comments

Azure offers two deployment models for cloud components: Resource Manager (RM) and Classic deployment model. Newer and more easier to manage, Microsoft recommends to use the Resource Manager. Even if these two models can exist at the same time in Azure, they are different and managed differently: in PowerShell cmdlets are specific to RM. In order to be able to communicate with Azure from On-Premises in PowerShell, you need to download and install the Azure…

 
Read More
Soufiane Benmalek

How to install Mirantis OpenStack 9.0 using VirtualBox – part 3

By | Cloud | No Comments

In the two first blogs, I installed the Fuel environment and deployed OpenStack in the Fuel slave nodes and all of that from the Fuel Master node. In this blog, I will show you  all the steps to follow in order to create an instance in OpenStack. All is going to be done via the Command Line Interface and not via Horizon – the OpenStack Dashboard (I will explain this in an other blog) ….

 
Read More
Soufiane Benmalek

How to install Mirantis OpenStack 9.0 using VirtualBox – part 2

By | Cloud | No Comments

The  last blog ended up with a successful installation of the Fuel Master. In this blog, I will deploy Openstack on the three Fuel slave nodes. The first node will be the controller node and all these components run on it: a MySQL database RabbitMQ : which is the message broker that OpenStack uses for inter-communication (asynchronous) between the OpenStack components Keystone Glance OpenStack API’s Neutron agents There are several other components but not used…

 
Read More