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