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.
Tag: oracle
Multitenant : DBCA PDB Remote Clone in Oracle Database 19c
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
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
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
Oracle RAC interview Questions
What is RAC?RAC stands for Real Application cluster. It is a clustering solution from Oracle Corporation that ensures high availability of databases by providing instance…
View More Oracle RAC interview Questions
What is the difference between RPO and RTO ?
Predicting a future disaster is nearly impossible, but fortunately, preparing for one and deciding your organizationโs aftermath is getting easier. Their abbreviated names are very…
View More What is the difference between RPO and RTO ?
Oracle Database Architecture
Oracle Database employs a client-server architecture, with the database server and client connections running in separate processes. The server process manages data and resources, and…
View More Oracle Database Architecture
How to install Oracle Database 19c on CentOS 8
Environment Specification: We have provisioned a minimally installed CentOS 8 virtual machine with following specifications. CPU – 3.4 Ghz (2 cores) Memory – 8 GB Storage – 80 GB Operating…
View More How to install Oracle Database 19c on CentOS 8