Chapter 2 getting start with the Oracle server (Oracle entry)

5th lecture 04

What tools are available as DBAs:

1. Oracle universal Installer (used for database installation)

2. Database Configuration Assistant

3. Database Upgrade Assistant

4. Oracle Net Manager

5. Oracle Enterprise Manager)

6. SQL * Plus (most commonly used)

7. Recovery Manager

8. Oracle Secure Backup

9. Data Pump

10. SQL * Loader

 

Oracle universal Installer (Oui ):

1. Unified cross-platform for installing, upgrading, or deleting Oracle and creating databases

2. Based on Java Engine

3. In interactive installation mode, run the command./runinstaller directly. A graphical interface is required.

4. For unattended installation, You need to respond to the file by running the following command:

./Runinstaller-responsefile custom file name-silent

 

Oracle Database Configuration Assistant (dbca ):

1. Used to create a database

2. Run the command:./dbca

After the database is created, two users are created by default: System and SYS.

The sys user is the owner of the data dictionary. The initial password is change_on_install.

The number of system users is smaller than sys, and the number of users is smaller than 1 million,

Add an internal table (Additional inter tables) and the owner using the Oracle tool view (views used by Oracle tools). The initial password is Manager.

After creating a database, you must change the passwords of these two users. Generally, system users are used for normal operations.

 

SQL * Plus

Use commands

Sqlplus/nolog

Connect/As sysdba

 

Oracle Enterprise Manager (OEM, Web interface after 11 GB ):