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…
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
If you are doing a duplicate (except an Active duplication) to create a Standby database and received the following error below: You should add the entry “(UR = A)” in tnsnames.ora for the target and source database. (Feature of Oracle 10g). As the example below in the tnsnames.ora: Se você estiver fazendo um duplicate (exceto um Active duplication) para criar um banco de dados do tipo Standby e recebeu o seguinte erro abaixo: Você deverá adicionar a entrada “(UR = A)” no tnsnames.ora para o aliás dos bancos de dados…
Inventory load failed… OPatch cannot load inventory for the given Oracle Home.
Por alguma razão quando o $ORACLE_HOME é removido do inventário, o DBA irá encontrar o erro “Inventory load failed… OPatch cannot load inventory for the given Oracle Home” quando se tentar executar o utilitário do opatch (localizado em $ORACLE_HOME/OPatch/opatch) para verificar os patches aplicados no ambiente de banco de dados Oracle. Com isso, neste post estarei exemplificando como resolver este problema. Causa raíz: Por alguma razão o $ORACLE_HOME foi removido do inventário. Solucao: Simplesmente adicione novamente o ORACLE_HOME ao inventário do banco…
AWARDS: “Top 60 Oracle Blogs post” AND ” Oracle ACE Associate “
02/06/2011, esta foi a data que iniciei minha carreira como Administrador de Banco de Dados Oracle. 18 anos. Primeiro emprego e extramamente motivado para crescer profissionalmente e ajudar minha família. Em 2012, criei um blog motivado pelas postagens dos meus estudos diários e também pela motivação de ser cada vez melhor. Agora, praticamente 6 anos depois, especificamente em 14 de Outubro, o meu blog recebeu o reconhecimento ” Top 60 Oracle Blogs post” da empresa Feedspot pelo próprio fundador da empresa, Mr. Anuj Agarwal e, no dia 30 de Outubro,…