Installing SH Sample Schema

Posted on by Ahmed Abdel Fattah

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

Installing Oracle OE Sample Schema

Posted on by Ahmed Abdel Fattah

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

Find the largest Top 10 Files and Directories on Linux/Unix

Posted on by Ahmed Abdel Fattah

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 21c Documentation

Posted on by Ahmed Abdel Fattah

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

ORA-03113 when running a specific query

Posted on by Ahmed Abdel Fattah

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 12.1.0.1, 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

When to use SET DBID in RMAN?

Posted on by Ahmed Abdel Fattah

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?