Hands-On 01 (Discovering a Server Node using OEM)

As a DBA, you are responsible for adding databases to the Oracle Enterprise Manager. You will be told the domain name and server and then you’ll need to discover the node to your OEM. You are also responsible for starting and shutting down a database.

Your tasks are:

1. Discovering a Server Node

2. Identifying all of the databases

3. Setting Preferred Credential Users

4. Accessing a database

5. Changing a user credential

6. Shutting down a database

7. Starting-up a database

Hands-On 01 (Discovering a Server Node using OEM)

Description:

In this exercise you will learn how to discover a server node,
identify all of the databases, set the Preferred Credential, access to 
the database, change the user credentials as SYSDBA and shutdown 
and start up the database by using the Oracle Enterprise Management
tool (OEM).

==Start.
On the Enterprise Manager Console, expand the nodes. 
Notice that there is no node.

==
In the Navigator menu, click on "Discover Nodes."

==
Click NEXT in the Discovery Wizard Window.

==
Type the node name and click NEXT to start the discovery wizard.
Notice that the Intelligent Agent must be started in the machine.

==
The node was successfully discovered.
Then click FINISH.

==
The LOCALHOST server was automatically discovered.
Click Okay.

==
Expand the LOCALHOST machine.

==
Check how many databases you have on that server.
There are two.

==
Check the Listeners item.

==
Suppress the NODE item and expand the DATABASES item.

==
Open the DBS4RMAN database and enter the username and password.

==
Save it as Preferred Credential.

==
Open the SCHOOL database and enter the username and password as 
a normal DBA.

==
Save it as Preferred Credential.

==
On the "Configuration" menu, click "Preferences."

==
Then, click on the "Preferred Credentials" tab.

== 
Click on the DBS4RMAN database and change its role to SYSDBA
so you can start and shutdown the database.

==
Click Okay.

==
Suppress the SCHOOL database and expand the INSTANCE item.

==
Click "Configuration."

==
Notice that this user, as NORMAL, is not able to startup or shutdown
the database. Disconnect the SYSTEM user.

==
Now, connect as SYSDBA.

==
Expand "Instance" and click on "Configuration."

==
Notice that the shutdown and startup options are not gray.
Select the "Shutdown" option and apply the shutdown process.

==
Use the Immediate option and click Okay.

==
Check to see if the database was shutdown successfully and then close the window.

==
Notice that Oracle is not available.

==
Disconnect the database.

==
And connect back to the database.

==
Expand "Instance" and click "Configuration."
Let's open the database.

==
We also can use other startup options.

==
Apply the startup process.

==
Use configured parameters and click Okay.

==
The startup was successful. 
Close window.

==
Click memory to see the memory configuration.

==
Click on the Recovery and UNDO tab.

Details about each configuration, were already discussed 
in the Database Fundamentals I and II tutorial.

For more information about the subject, you are encouraged
to read from a wide selection of available books.

Good Luck!