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…
Month: March 2018
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 …
Configuring Multiple local_listener
The configuration of multiple listeners consists of setting up 2 or more listeners for the same database. This is a task that consists of the following steps: 1- Creation of listeners:: 1.1: Listener named X1 on port 1539; 1.1: Listener named X2 on port 1537; 1.2: Initialization of listeners: 2- Create the entries of each listener for the database in tnsnames.ora: Example: Database named cbd4; 2.1: Entries will be created in tnsnames: 2.2: Testing Inputs Inserted: 2- Define the services in the database listener_local parameter of the…