Installing Oracle OE Sample Schema

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

Oracle Database 21c Documentation

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

When to use SET DBID in RMAN?

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?

Oracle RMAN Multi-Section Feature

RMAN can optionally break up large files into sections and back up and restore these sections independently. This feature is built into RMAN. You can use it by creating multisection backups, which break up the files generated for the backup set into separate files. This can be done for backup sets and image copies. Each … Continue reading Oracle RMAN Multi-Section Feature

Change “Value” Column Width for “show parameter” in sqlplus

If you tried to increase the width of the "VALUE" column, nothing changed: I found that the NAME & Value columns have special names (for type column , it is normal): column NAME_COL_PLUS_SHOW_PARAM format A20column VALUE_COL_PLUS_SHOW_PARAM format A80 Now, it is fine.

What is the difference between Oracle Client 19c and Oracle Client Home 19c?

When I tried to download and install Oracle client 19c, it was my surprise that there are two different versions. See the following information from the oracle site: So, what is the difference between these two versions?. After some research I found that: LINUX.X64_193000_client.zip is the normal (before 19c) installer-based client software, where you can choose … Continue reading What is the difference between Oracle Client 19c and Oracle Client Home 19c?

TNS-04012: Unable to start Oracle Connection Manager instance.

Background: One advantage of the "Connection Manager" is that it can act as if a proxy server between the database client and the database server, especially when there is a firewall between the client and the server.I installed Oracle Client 19c (only the "Connection Manager" and the "Oracle Net Listener" components): https://www.youtube.com/watch?v=R-tSVkRckfs Then I configured … Continue reading TNS-04012: Unable to start Oracle Connection Manager instance.

Oracle Backup & Recovery Hands-on Practice – Oracle Database 18c VM

Do you want to practice recovering from the following common failures (with a guided step-by-step procedure)?: Recovering from a critical file loss (SYSTEM , UNDO)Recovering from a non-critical file lossRecovering from the loss of the control fileRecovering from the loss of all control filesRecovering from the loss of an inactive redo log fileRecovering from the … Continue reading Oracle Backup & Recovery Hands-on Practice – Oracle Database 18c VM