DBA_I

Preparing the operating system for installation. Software packages that are required while installing Linux (first check to see whether the server’s BIOS has the latest firmware).

In addition to a database instance, other structures are also created.

I am glad to introduce Tibero is a relational database management system.

User Management, creating users…

Including shutdown, Oracle database has 4 states

With an instance of Oracle currently running on the server, we can manually create a database.

The Control File can be considered to be the most important file in a database, it is the identity of the database.

Consistency is a key requirement and factor of a database. “Shadow Copy” and “Write-Ahead Logging” (WAL) methods are used in order to ensure consistency, WAL being more popular.

Data, in Oracle, is logically stored in tablespaces and physically stored in datafiles. The illustration below shows the file and logical structures according to the operating system.

The Listener service runs on the server and listens for requests from clients. By default it operates on TCP Port 1521 but can be reconfigured.