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
Month: October 2023
Registry Parameters for Oracle Wallet Storage in Windows
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
Testing Oracle Connectivity from Microsoft Tools
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
Hot Cloning a Remote PDB or Non-CDB
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
Environment Variables in Windows
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
Use a wallet to encrypt Oracle client passwords
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
How to Generate a Running(Accumulated) Total in SQL
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