iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |

 

Online Oracle Training for beginners and advanced - The most comprehensive Oracle tutorial

The authors do not guarantee or take any responsibility for the accuracy, or completeness of the information.

DBAs - Performance

 

Lesson 01 | Lesson 02 | Lesson 03 | Lesson 04 | Lesson 05 | Lesson 06 | Lesson 07 | Lesson 08 | Lesson 09 | Lesson 10 | Lesson 11 | Lesson 12 | Lesson 13 | Lesson 14 | Lesson 15 |

 

Lesson 15

"You can pretend to be serious; you can't pretend to be witty." - Sacha Guitry (1885-1957)

 

Read first then play the video:

   OEM-VIDEO -Discovering a Server Node

   

Discovering a Server Node using OEM

 

Introduction

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:

Discovering a Server Node

Identifying all of the databases

Setting Preferred Credential Users

Accessing a database

Changing a user credential

Shutting down a database

Starting-up a database

 

Hands-on
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.