Oracle
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
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)
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.
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
Oracle Database 12c Release 2 (12.2) introduced the ability to perform a hot clone of a remote pluggable database (PDB) using the CREATE PLUGGABLE DATABASE command. In…
View More Multitenant : DBCA PDB Remote Clone in Oracle Database 19c
Parameter WALLET_LOCATN in file sqlnet.ora specifies the location of the obfuscated Oracle Wallet for use by Oracle PKI applications. For example, the WALLET_LOCATN parameter for storing an Oracle Wallet in the…
View More Registry Parameters for Oracle Wallet Storage in Windows
Learn how you can test connectivity to an Oracle Database server from Microsoft tools. Oracle directory objects in Active Directory are integrated with the following…
View More Testing Oracle Connectivity from Microsoft Tools
Prerequisites The prerequisites for cloning a remote PDB or non-CDB are very similar, In this context, the word “local” refers to the destination or target…
View More Hot Cloning a Remote PDB or Non-CDB
In our more and more connected world, security is a big concern. Storing password is a very important topic because if a machine is compromised,…
View More Use a wallet to encrypt Oracle client passwords
Have you ever needed to calculate a “running total” or “cumulative sum” in SQL? You can do this in SQL without any other programming language…
View More How to Generate a Running(Accumulated) Total in SQL