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
Preparation: Before running the installation script (sh_main.sql), please edit the following two files:sh_main.sql & sh_olp_c.sqlunder D:\app\db193\WINDOWS.X64_193000_db_home\demo\schema\sales_history and replace "__SUB__CWD__" with "D:\app\db193\WINDOWS.X64_193000_db_home\demo\schema" or the directory where you extracted the sample schema scripts. Here is a live demo about installation: https://www.youtube.com/watch?v=ZRodqYAUxtk ThanksAhmed
If you are interested in installing all oracle database sample schemas, please refer to my post:Installing Oracle Sample Schemas (19.3) If you want to install the scott demo schema, please refer to:https://ahmedfattah.com/2019/12/25/how-to-create-the-scott-oracle-database-demo-schema/ Here is a live demo about Order Entry (OE) schema installation: https://www.youtube.com/watch?v=c8dxF-1rGZo Please note that before installing the OE schema, you should first install … Continue reading Installing Oracle OE Sample Schema
To find the top 10 files and directories in the current directory, we will use the "du" command with some options, along with the "sort" command to list the sizes in descending order, along with the "head" command to get only the top 10 items. Example:(output in K Bytes) Note the following "du" command options:-c … Continue reading Find the largest Top 10 Files and Directories on Linux/Unix
Oracle Database is the world's most popular database. Available on cloud and on-premise platforms, Oracle Database 19c is the most recent long term release, with an extended support window. Oracle Database 21c is the latest innovation release, initially available on Oracle cloud through Autonomous Database Free Tier and Database Cloud Service. For Oracle Database 21c documentation:https://docs.oracle.com/en/database/oracle/oracle-database/21/index.html For Oracle Database … Continue reading Oracle Database 21c Documentation
I got a question from one of my clients that he has a query that he used to run it successfully on Oracle Database 10g,but when he run the same query on Oracle Database 126.96.36.199, the query failed and the connection dropped with the following errors: He confirmed many times that the same query with … Continue reading ORA-03113 when running a specific query
According to oracle documentation:Specify a database's database identifier (DBID) when restoring a control file or server parameter file. Restrictions and Usage Notes for the SET DBID Command You should only run the SET DBID command in the following specialized circumstances: You are not connected to a recovery catalog and want to restore the control file … Continue reading When to use SET DBID in RMAN?