Introduction to Oracle Database Management -3

Tools for Administering on Oracle Database

Oracle Universal Installer → The Oracle Universal Installer installs your Oracle software and options. It can automatically launch the Database Configuration Assistant to install a database.

Database Upgrade Assistant → This Database Upgrade Assistant guides you through the upgrade of your existing database to a new Oracle release.

Oracle Net Manager → Net Manager is an alternate tool for configuring and managing Oracle Database networks.

Oracle Enterprise Manager → The primary tool for managing your database is Oracle Enterprise Manager, a web-based interface. After you have installed the Oracle software, created or upgraded a database, and configured the network, you can use Oracle Enterprise Manager for managing your database. In addition, Oracle Enterprise Manager also provides an interface for performance advisors and for Oracle utilities such as SQL*Loader and Recovery Manager.

Server Control Utility → It can be used to perform some operations on servers. You can use SRVCTL commands to add, remove, start, stop, modify, enable, and disable a range of entities such as databases, instances, listeners, SCAN listeners, services, grid naming service, and Oracle ASM.

SQL*Plus → SQL*Plus is an interactive and batch query tool that is installed with every Oracle Database Server or Client installation. It has a command-line user interface, a Windows Graphical User Interface (GUI) and the iSQL*Plus web-based user interface. SQL*Plus has its own commands and environment, and it provides access to the Oracle Database.

Recovery Manager → Recovery Manager is an Oracle utility that can back up, restore, and recover database files. The product is a feature of the Oracle database server and does not require separate installation. You can invoke RMAN as a command-line executable from the operating system prompt or use some RMAN features through the Enterprise Manager GUI.

Data Pump → It is used to import and export large amounts of data from the database. In addition to basic import and export functionality, the data pump provides a PL/SQL API and support for external tables.

SQL*Loader → SQL*Loader is a data transfer tool like Data Pump but includes more policies when transferring data. SQL*Loader loads data from external files into the tables of an Oracle database. It has a powerful data parsing engine that puts very few limitations on the format of the data in the data file. Can load data over a network using SQL*Loader, load data from multiple data files during the same load session, load data into multiple tables during the same load session, specify the character set of the data, load records according to the values ​​of the records, process data before loading using SQL functions, can generate unique ordinal key values ​​in specified columns, use the operating system’s file system to access data files, load data from disk, tape, or named pipe, generate complex error reports that greatly aid in troubleshooting, optionally load complex object-relational data, LOB’ You can use secondary data files to load files and collections, or you can use traditional or direct path loading. While conventional track loading is very flexible, direct track loading provides superior loading performance.

Setting Environment Variables

ORACLE_BASE → Shows some where Oracle’s directory structures begin.

ORACLE_HOME → Shows where Oracle’s executables are located.

ORACLE_SID → Gives the short name of the system.

NLS_LANG → It sets the language and territory used by the client application and the database user session.

Initialization Parameter Files

These files are parameter files that the system reads during startup. In these parameter files, we specify with which parameters we want the system to boot.

CONTROL_FILES → To specifies one or more names of control files, separated by commas.

DB_FILES → Specifies the maximum number of database files.

PROCESSES → Specifies the maximum number of operating systems, user processes that can be connected at the same time.

DB_BLOCK_SIZE → Specifies the standard database block size used by the tablespace.

MEMORY_TARGET → With this parameter, Oracle itself adjusts the size management of areas such as SGA, shared pool, db buffer cache according to the needs.

SGA_TARGET → It can be used for automatic SGA memory sizing.

PGA_AGGREGATE_TARGET → To specify how much memory the PGA will occupy

SHARED_POOL_SIZE → To specify the space that the shared pool will occupy

UNDO_MANAGEMENT → Undo space is a space used to undo operations. This parameter is used to manage this field. Usually it is set to auto.