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

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

Database

Oracle Architectural Components

Published by : Obay Salah , November 18, 2024

The database administrator is in dire need to know the components of the database and how it works. If he is unable to understand this part, he will m... Continue Reading

Database

Creating and Maintaining a Database Password File

Published by : Obay Salah , November 18, 2024

The Password file is created during Oracle installation by default and normally, but sometimes you may need to create or delete this file.ORAPWD Synta... Continue Reading

Database

Database Administrator Authentication

Published by : Obay Salah , November 18, 2024

As a database administrator, you usually have special tasks to perform, such as closing or starting the database, and because these tasks are performe... Continue Reading

Database

About Database Administrator Security and Privileges

Published by : Obay Salah , November 17, 2024

 To perform the tasks of a database administrator (DBA), you need specific privileges and permissions, especially on the databases and perhaps on... Continue Reading