Oracle Database 20c is now Generally Available on the cloud two days ago, 14-Feb-2020. Oracle 20c is next major database release. It includes many new fetaures espcially in the following areas: BlockchainMachine LearningSecurityJSONIn-Memory For a quick introduction to this new release:https://blogs.oracle.com/database/ga-of-oracle-database-20c-preview-release Also, for complete list of the new features, please refer to the:https://docs.oracle.com/en/database/oracle/oracle-database/20/newft/new-features.html Oracle Database … Continue reading Oracle Database 20c is now Generally Available
This is a quick post about a question that I got about the objectNumber in the "list flashcachecontent" output, is it the same as object_id in the dba_objects in the database? Answer: No, objectNumber is not the same as object_id in dba_objects, actually it maps to the "data_object_id" not the "object_id" Example: Also, the tablespaceNumber … Continue reading Exadata – Flashcache Contents/objectNumber
This Exadata Database Machine: 12c Administration Workshop training introduces you to Oracle Exadata Database Machine, covering the features and capabilities of the Exadata Database Machine X6 product family. In this course, you will be introduced to Oracle Database Exadata Cloud Service. Explore the various Exadata Database Machine features and configurations, with emphasis on the unique … Continue reading Exadata Database Machine: 12c Administration Workshop
When time came to troubleshooting , we started to search and review the log files. At stress time, one may waste time searching about the location of these log files. So, it may be a good practice to document the location of your environment log files, so as to reach them quickly when you need … Continue reading Oracle Exadata Log Files
I had a question from one of my customers about the available fast cloning options for Oracle databases. This customer has a supercluster on the production site and another supercluster on the DR site. The client requirement is to be able to prepare a new Test/Dev database in minutes , not hours for their large … Continue reading Oracle Database Fast Cloning Options for Databases on Supercluster
Objective: This report will show the detailed steps that we followed to migrate a real client production database from its current production server to the Exadata machine. Environment: SourceTargetServer Nameprod-n-214exa-db-101Database NamePRODPRODOracle version220.127.116.1118.104.22.168O.SLinux OEL 6.5Exadata OEL 6.8Character setWE8ISO8859P1WE8ISO8859P1Clustered:Single InstanceSingle Instance Migration High Level Plan: Migration Preparation.Backup the production database.Duplicate the production database to Exadata.Post Migration stepsValidate … Continue reading Oracle Database Migration to Exadata – Case Study
What? Does tnsnames.ora file need a Distribution Management System? In our case, the answer is yes. It is a headache to implement our client requirements without some sort of automation. What is tnsnames.ora file? tnsnames.ora is a text file that resides on the ORACLE_HOME/network/admin and contains some simple information about our databases connection information, it … Continue reading Oracle tnsnames.ora Distribution Management System!