Oracle 21c RAC Linux 8 Install Tips
Tim had prepared the detail install tips regarding oracle 21c RAC.
Very convenient and efficient!
I changed VM memory size 800MB/5GB/5GB and change the DB’s size to 800MB for my mac’s limited memeory.
Oracle nslookup Linux 8 Install Tips
Oracle 19c mac os Client install Tips
Oracle 19c TDE Tips
TDE(Transparent Data Encryption) as the name suggest transparently encrypts data at rest in Oracle Databases. It stops unauthorized attempts from the operating system to access database data stored in files, without impacting how applications access the data using SQL. So we dont have any impact to Business. If the malicious user tries to open file using a HEX editor (like UltraEdit),then only non-printable characters will be present. TDE can encrypt entire application tablespaces or specific sensitive columns.
Oracle 19c ORA-65179 Tips
Since the default behavior of dropping a PDB is to keep data files on the server if you don’t indicate any further.
You should unplug the PDB first before actually dropping it or drop including datafiles.
Oracle 21c Linux 8 Install Tips
Oracle database 21c release - only linux at 8/13/2021
The latest Innovation release of the world’s most popular database, Oracle Database 21c, is now generally available “cloud first” in the Oracle Cloud Database Service Virtual Machine (for RAC and single instance) and Bare Metal Service (single instance). It’s also available in the Autonomous Database Free Tier Service in Ashburn (IAD), Phoenix (PHX), Frankfurt (FRA) and London (LHR) regions. General availability of Oracle Database 21c for on-prem platforms (including Exadata, Linux and Windows) will follow along in 2021.
Introducing Oracle Database 21c
Oracle 19c 21c parameter different Tips
parameters
Oracle 19c scheduler task Tips
Oracle crsctl commands Tips
List hint in 19c from V$SQL_HINT.
Oracle 19c Hint list Tips
List hint in 19c from V$SQL_HINT.
Oracle 19c Exadata Statistic Tip
List some tips of statistical information collection in the Exadata.
Oracle 19c use_concat Hint Tips