Oracle administrator Manual: database management tools

As an Oracle administrator, you will learn database management tools from the beginning. The following describes some basic concepts of database management tools for Oracle administrators.

1. What is Oracle Enterprise Manager.

Oracle Enterprise Manager (Oracle Enterprise Manager) is a graphical database administrator tool. It provides a centralized system management tool for database administrators (DBAs) and a tool for managing multiple network nodes and services from multiple locations. OEM is a powerful and easy-to-use Graphical Database Administrator tool.

2. Notes when using Oracle Enterprise Manager OEM.

3. How to log on to Oracle Enterprise Manager OEM independently ).

Start/Program/Oracle-Ora90/Enterprise Manager Console à start independently

4. What is iSQL * Plus?

ISQL * Plus is introduced by Oracle9i and is a Web version of SQL * Plus. The iSQL * Plus application server must be started first.

5. How to enable iSQL * Plus

Start the Internet browser and enter the address barhttp://****:0000/isqlplusHost address) --> enter the user name/password scott/tiger) --> log on

6. How to Use iSQL * Plus

Like SQL * Plus, after entering the SQL and SQL * Plus commands, click execute.

7. How to enable Oracle 10g enterprise manager.

Start the Internet browser and enter the address barhttp://****:0000/em--> Enter the user name/password sys/oracle) --> log on

8. How to use Oracle 10 Gb Enterprise Manager.

--> Manage --> Control File

After reading the above, your Oracle administrator can continue learning.

1. Quick query of Oracle Default usernames and passwords
2. Easily fix Oracle user password changes
3. Authorization and management for five Oracle users
4. Two implementation methods for Oracle user unlocking commands
5. Step 4: Change the Oracle user name