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…
Category: Oracle Cloud
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…
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-28040: NO MATCHING AUTHENTICATION PROTOCOL EXCEPTION AFTER UPGRADE FROM 11G TO 12C
After upgraded an Oracle database from 11.2.0.4 to 12.2.0.1 I receive the error “ORA-28040: No matching authentication protocol exception” during one of our applications tried to connect to this database. This is due to the fact that in version 11G the parameter SQLNET.ALLOWED_LOGON_VERSION_SERVER had the default value 8 while in version 12c it is 11. Knowing this, after changing the value of the parameter in the sqlnet.ora file the problem has been solved. Portuguse / Português Depois de atualizar um banco de dados Oracle 11.2.0.4 para 12.2.0.1 eu recebir o…
(RUs) Patch Set Update and Critical Patch Update July 2017 to 12.2
Unlike April’s PSU where Oracle reported that there was no PSU for version 12.2 through the note on Metalink (MOS) (Doc ID 2228898.1): “Patch Availability for Oracle Database 12.2.0.1 There are no Quarterly Security Patches for 12.2.0.1 for the April 2017 cycle as there are in the Database CPU security vulnerabilities, nor any recommended non-security bug fixes applicable at this time. The July 2017 CPU cycle will be the first Quarterly Security Patch cycle for 12.2.0.1 ” For July, the then-mentioned RU is available for download in the note…
UPGRADE 11G TO 12C: Additional space required is more than max allowed space for these datafiles
Estava atualizando um banco de dados 11g Enterprise Edition Release 11.2.0.2.0 para um 12.1.0.2, quando tive o seguinte erro durante a atualização: Isto acontece porque o valor máximo do datafile está sendo mostrado com um valor menor do que o necessário e a solução para este erro é aumentar o limite de maxsize ( MAXBYTES ) para um valor maior que o tamanho do dafile. Exemplo: E depois reprocessar o DBUA: brunors*The views expressed here are my own and do not represent those of my employer.* Hello, I’m Bruno —…
/lib/ld-linux.so.2: bad ELF interpreter: No such file or directory
Estava instalando um banco de dados no sistema operacional Oracle Linux 6.3 quando recebi o seguinte erro: Com o usuário root, verifiquei que a solução era instalar a lib glibc.i686 e , após isso, pude prosseguir com a instalação do banco de dados: brunors*The views expressed here are my own and do not represent those of my employer.* Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and…