Database

About Creating an Oracle Database

Published by : Obay Salah , November 19, 2024

 We usually create the database during the installation of Oracle Database Software, however you can create the database after installing Oracle... Continue Reading

Database

Create Database Using DBCA

Published by : Obay Salah , November 19, 2024

 It is a tool issued by Oracle for several purposes:1- Creating a database.2- Re-initializing the database.3- Deleting the database.4- Creating d... Continue Reading

SQL

Table in Oracle Dtabase

Published by : Obay Salah , November 19, 2024

Database tables are structures used to store data in the form of fields (columns) and records (rows).Fields (Columns): Define the type of data to be s... Continue Reading

Data Guard

Fast-Start Failover

Published by : Obay Salah , November 19, 2024

Fast-Start Failover is a feature that enables automatic and seamless failover to the standby database in the event of a failure in the primary databas... Continue Reading

Data Guard

Data Guard Failover Operation

Published by : Obay Salah , November 19, 2024

To bring one of the standby databases as the new primary database and perform a failover, especially in the case of a catastrophic failure in the prim... Continue Reading

Database

Create Database Manually on Windows

Published by : Obay Salah , November 18, 2024

 Before starting, it should be noted that we will be using the Windows operating system.1- Determine the name of the ORACLE_SID (Instance): There... Continue Reading

Database

Creating and Configuring Database

Published by : Obay Salah , November 18, 2024

 Database Planning:One of the most important tasks of a database administrator is database planning. It is impossible to imagine a successful dat... Continue Reading

Database

Installing Oracle Database 10g in Windows

Published by : Obay Salah , November 18, 2024

 Oracle installation requirements:Installing Oracle is one of the most important tasks of the database administrator. The database administrator... Continue Reading

Database

Oracle Database Architecture

Published by : Obay Salah , November 18, 2024

 It is the second part of the Oracle database components:Oracle Database Server = Oracle Instance + Oracle DatabaseThis section contains a set of... Continue Reading

Database

Oracle Instance Architecture

Published by : Obay Salah , November 18, 2024

 Without this part, we cannot access the database. It is a part of memory and a group of processors through which we can deal with and access the... Continue Reading