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…
Category: Oracle Database General
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…
Oracle 12c: Save State in a single instance
The SAVE STATE clause serves to maintain the state of the PDB when the CDB is restarted. For example, if when the CDB was restarted the OPEN_MODE of the PDB was in READ ONLY, then when the CDB will be available the PDB will initialize in READ ONLY state automatically. Saving the state of the PDBS PDBOL and PDBOL_2 through the command “ALTER PLUGGABLE DATABASE <PDB NAME> SAVE STATE;”: Simulating the unavailability of the CBD: Rebooting the CDB: See that the PDB states were maintained: The saved states of the…
“ORA-65011: Pluggable database does not exist” while cloning a NON-CDB into a PDB
I was cloning an Oracle NON-CDB database to a PDB when I get the following error: I checked and the connection to the DB_LINK created to access the NON-CDB was OK: This error happens because you are probably trying to clone a CDB database to a PDB and this can be queried using SQL below: When a database is created as a CDB it can not be a PDB and vice versa. So, I suggest creating a new database, really a NON-CDB, and do the operation again. Eu estava clonando…
12C : A simple approach to index monitoring
Index tracking is useful to know if the index is being used or not and then delete it. In this post I’ll be creating a table called techdatabasket_customers, an index called techdatabasket_index and later activating index monitoring through the command “ALTER INDEX <index_name> MONITORING USAGE;” to finally use the view dba_object_usage (In previous versions of 12.1, the view was called V$OBJECT_USAGE) to get the information in the USED field with the value “YES” meaning that the index is being used and “NO” meaning that the index is not being…
Creating a CDB Without Using Oracle Managed Files
The following procedure below aims to create an Oracle 12c database by command line with only the CDB by enabling the ENABLE_PLUGGABLE_DATABASE = TRUE parameter for a possible creation of PDBs in the future. Therefore, it follows the procedures: Creating database directories and granting permissions to the oracle user: Creating the database pfile with the ENABLE_PLUGGABLE_DATABASE parameter set to TRUE, this way it will be possible to create PDBs in the future: Setting the environment variable and initializing the database in NOMOUNT status: Creation of the database: …
ORA-65093: multitenant container database not set up properly
I was creating a CDB database when I got the following error: Why did I get this error? Because I forgot to add the enable_pluggable_database parameter with the value to TRUE in the parameter file. Therefore, Oracle understood that I was creating a NON-CDB database instead of a CDB. After I added the parameter in the parameter file, it was possible to continue with the creation of the CDB database. enable_pluggable_database parameter with the value to TRUE Restating the instance with the new parameter: Creating the CDB database again:…
Fixing PRVF-0002 : Could not retrieve local node name
I was installing Oracle stand alone 12c while during the installation I got the following error: This error occurs because Oracle did not find the server name during the lookup operation. So how to solve this? The answer is simple. Just add the server name in the /etc/ hosts (as the example in the picture below: 192.168.56.71 dbdg.localdomain dbdg) file with the root user and then proceed with the installation: Estava instalando o Oracle stand alone 12c quando durante a instalação obtive o seguinte erro: Este erro acontece porque…