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.
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
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
1. What are Environment Variables? Environment variables are global system variables accessible by all the processes/users running under the Operating System (OS), such as Windows, macOS and Linux. Environment…
View More Environment Variables in Windows