In the Virtual Cloud Network tab click on the “Create Virtual Cloud Network” button: In the Virtual Cloud Networks tab click on the “Create Virtual Cloud Network” button: You will then be presented with the screen to create the Virtual Cloud Network, where it is necessary to specify all the information for the VNC configuration: In the Virtual Cloud Network tab choose the option “Create Virtual Cloud Network plus related resources” to create the VNC only with public subnets: Click the “Create Virtual Cloud Network” button and a screen with…
Category: Oracle Cloud
Oracle Database 18c: Provisioning the Oracle Autonomous Database in the Cloud
For this step you will need to create the account in the Oracle Cloud with this link, https://cloud.oracle.com/home . Before you provide the database you need to create a Compartment. If you have not yet created one click on “Identity” and later on “Compartments” under the “Governance and Administration” tab of the menu: Then click “Create Compartment” if there is none existing : The root compartment is the first compartment created. From it, it is possible to create other compartments by using them as an option in the “Parent Compartment”…
Creating a CDB database by command line
Sometimes the Oracle DBA needs to create a CDB database without DBCA. This procedure is possible. However, it is needed some additional steps to be done. For instance, to run some scripts to create components who DBCA utilitty create automatically. Therefore, in this post I am going to show how to create a CDB database by command line: Create directories for the Oracle Database. As the database will be named “db2”, some file system structures will contain this word: Create the init<SID>.ora file at $ORACLE_HOME/dbs: Start the…
Simple way how to use Database Point-in-Time Recovery
There are some situations where it is relevant for DBA to use FLASHBACK or Database Point-in-Time Recovery such as when a user modifies some data incorrectly or also when an upgrade failed and if it wishes to revert the previous situation of the database among several others possibilities. With this, in this post I will be explaining in a simple way how to use Database Point-in-Time Recovery. Therefore, I will be considering some requirements for this operation be possible: – The database must be enabled in Archivelog mode: – The…
[Oracle 12c] BACKUP PLUGGABLE DATABASE
Backing up the Oracle database is always very important. In version 12c, there is the possibility of backing up one or more PDBs. There are two methods to back up the PDB, one is connecting directly as a ROOT in RMAN and using the “BACKUP PLUGGABLE DATABASE” command or the option to connect directly to the PDB through the service and execute the “BACKUP DATABASE” command. So, in this post I will be explaining just how to backup the PDB by connecting as ROOT and using as an example a…
[Oracle 12c] BACKUP DATABASE ROOT
Backing up the Oracle database is always very important. In version 12c, there is a possibility of backing up the ROOT database that has important metadata for the CDB. So, in this post I’ll be illustrating how to backup the ROOT database: 1. Connect to the RMAN catalog: 2- Execute the command BACKUP DATABASE ROOT: Efetuar o backup do banco de dados Oracle é sempre muito importante. Na versao 12c, há a possibilidade de se efetuar o backup do banco de dados ROOT que possui possui metadados importantes para…
Oracle Database 12c : Common User x Local User
In this post I will be showing you how to create an user in the CDB, what are called “Common Users” (users using the COMMON_USER_PREFIX parameter to set the user prefix at creation time) and then afterwards an user in a PDB called TECHDATABASKET , which are the “Local Users”. 1- Creating Common User in a CDB: 2- Creating Local User in a PD Neste post estarei mostrando simplificamente como criar um usuário no CBD, o que chamados de “Common Users” (usuários que utilizam o parâmetro COMMON_USER_PREFIX para definir o…
Creating a PDB by Cloning a Remote PDB
In this post I will be showing a simple example of how to create a PDB database through another PDB remotely. CDB database: CBD4 with the PDB database named TECHDATABASKET2 CDB database: CBD3 where the TECHDATABASKET2new PDB will be created using the TECHDATABASKET2 PDB of the CDB4 database. Then here are the examples: 1-The database must be CDB and be connected in the CDB$ROOT: 2- Creating the service entry for the TECHDATABASKET2 PDB in TNSNAMES.ORA and performing some tests: – Adding the entry for the service of the PDB…
Creating a PDB from a local PDB
In this post I will be showing a simple example of how to create a PDB database through a local PDB: Then follow the examples: 1-The database must be CDB and you must be connected in the CDB$ROOT: 2-Create the PDB through the local PDB (which should be open in read-only mode: – As we will be using the PDB TECHDATABASKET in this example, the next step will be to put this PDB in READ ONLY mode: — Como estaremos utilizando o PDB TECHDATABASKET neste exemplo, o próximo passo será…
Creating a PDB database from seed template
In this post I will be showing a simple example of how to create a PDB database from the seed template. Therefore, follow the examples: 1-The database must be CDB and you have to be connected in CDB$ROOT: 2- Create the PDB from seed: 3- Open the new PDB in read/write mode: 4- Check the status of the new PDB: Neste post estarei mostrando um simples exemplo de como se criar um banco de dados PDB do template seed. Sendo assim, seguem os exemplos: 1-O banco de dados …