Loading...
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 Read more about Simple way how to use Database Point-in-Time Recovery[…]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
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 Read more about [Oracle 12c] BACKUP PLUGGABLE DATABASE[…]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
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: Read more about [Oracle 12c] BACKUP DATABASE ROOT[…]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
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 Read more about Oracle Database 12c : Common User x Local User[…]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
  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 Read more about Creating a PDB by Cloning a Remote PDB[…]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
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 Read more about Creating a PDB from a local PDB[…]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
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 Read more about Creating a PDB database from seed template[…]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
    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 Read more about Configuring Multiple local_listener[…]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
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 Read more about Oracle 12c: Save State in a single instance[…]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
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: Read more about “ORA-65011: Pluggable database does not exist” while cloning a NON-CDB into a PDB[…]
Read Full Article
Visit website

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview