Ensure that the software keystore of the PDB that you plan to clone is open.You can query the STATUS column of the V$ENCRYPTION_WALLET view to…
View More Cloning a PDB with Encrypted Data in a CDB
Month: October 2023
Setup Unified auditing in Oracle 19c
The following auditing modes are available for Oracle Database 12c, 18c, 19c: Unified Auditing—Recommended. See the following Oracle technical article for detailed instructions on how…
View More Setup Unified auditing in Oracle 19c
Creating a Pluggable Database Release 19
Techniques for Creating a PDB Technique Description More Information Create a PDB from scratch Create a PDB in a CDB using the files of the…
View More Creating a Pluggable Database Release 19
Setup TDE Encryption In Oracle 19c Database
Transparent Data Encryption (TDE) enables you to encrypt sensitive data that you store in tables and tablespaces. After the data is encrypted, this data is…
View More Setup TDE Encryption In Oracle 19c Database
Unplug and Plugin Pluggable database (PDB)
Oracle has introduced new Multitenant Option from Oracle 12cR1 and this option allows a single container database (CDB) to host multiple pluggable databases. One of the most powerful feature…
View More Unplug and Plugin Pluggable database (PDB)
Datapump export/import from Source PDB to Target PDB and with network_link
Source : target: Alternatively direct import with network_link without exporting in source add pdb record in tnsnames.ora add pdb service in listener.ora of source node101…
View More Datapump export/import from Source PDB to Target PDB and with network_link
Drop Pluggable Database (SQLPLUS command line or DBCA)
SQLPLUS show pdbs; alter pluggable database orclpdb close instances=all; drop pluggable database orclpdb including datafiles; DBCA
View More Drop Pluggable Database (SQLPLUS command line or DBCA)
How To Setup Listener For PDBS In Multitenant Database.
If you wish to setup listener for a particular PDB in the multitenant database, then follow as below. Create a listener and start it. LISTENER_DBATEST…
View More How To Setup Listener For PDBS In Multitenant Database.
How to open firewall port on Windows 10
Open firewall port on Windows 10 To open one or more ports (for oracle 1521-1526) ports) in the Windows firewall, use these steps: Open Windows Security.…
View More How to open firewall port on Windows 10
How to get Connected Two Virtual Machines In VirtualBox
If you ever need to run multiple OSes simultaneously, a virtual machine (VM) is one of your best options. It’s cost-effective, provides relatively good performance,…
View More How to get Connected Two Virtual Machines In VirtualBox