Infrastructure at your Service

Tag

multitenant Archives - Page 5 of 13 - Blog dbi services

Oracle Team

Service “696c6f76656d756c746974656e616e74” has 1 instance(s).

By | Database management | 5 Comments

By Franck Pachot . Weird title, isn’t it? That was my reaction when I did my first ‘lsnrctl status’ in 12.2: weird service name… If you have installed 12.2 multitenant, then you have probably seen this strange service name registered in your listener. One per PDB. It is not a bug. It is an internal service used to connect to the remote PDB for features like Proxy PDB. This name is the GUID of the…

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

12cR2: lockdown profiles and ORA-01219

By | Database Administration & Monitoring | One Comment

By Franck Pachot . When you cannot open a database, you will get some users unhappy. When you cannot open multitenant database, then the number of unhappy users is multiplied by the number of PDBs. I like to encounter problems in my lab before seeing them in production. Here is a case where I’ve lost a file. I don’t care about the tablespace, but would like to put it offline and at least be able…

Read More
Oracle Team

12cR2 DBCA can create a standby database

By | Database Administration & Monitoring | One Comment

By Franck Pachot . Do you like DBCA to create a database from command line, with -silent -createDatabase? On a simple command line you can provision a database, with oratab, tnsnames.ora directory creation and any setting you want. And you can even call a custom script to customize further. But if you want to put it in Data Guard, you have to do the duplicate manually with RMAN. This evolves in 12.2 with a new…

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
Oracle Team

Running SLOB on Exadata Express Cloud Service

By | Database Administration & Monitoring | One Comment

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

Read More
Oracle Team

Exadata Express Cloud Service: PDB_ADMIN privileges

By | Database Administration & Monitoring | No Comments

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

Read More