![]() This is done using sophisticated job scheduling system built into the Enterprise. Preferred Credentials-Enter prise Manager can automatically execute many routine administrative tasks, such as backups, on your behalf. ![]() See "Defining Blackout Time Periods" in this section. For more information about alerts and setting up notifications, see "Setting up Notification" in Chapter 10, "Monitoring and Tuning the Database".īlackout Administration -When you have planned downtime for database maintenance, you can indicate to Oracle that you do not want false alerts to be sent to you. However, set up is required for e-mail notification. By default, the Enterprise Manager home page lists all alerts. Alerts are notifications of when a database is in an undesirable state and needs your attention. Notification- These are settings that enable Oracle to email you alert notifications. Setting Up Enterprise Manager PreferencesĮnterprise Manager enables you to set up preferences that help you manage the database. All the users shown on this page can log in to the Database Control and perform database management tasks. The selected database user is now included in the list of management users on the Setup Administrators page. To create a new user, see "Administering Database Users"Ĭlick Create to create a new Enterprise Manager user by assigning the management privileges to an existing database user.Ĭlick the flashlight icon next to the Name field and select an existing database user from the pop-up window.Įnter the password for the selected user and click Finish.Įnterprise Manager assigns the management privileges to the selected user. If you need to create a new administrator, you must first create the user and then assign administrative privileges as described in this section. Start your Web browser and log in to the Database Control as the SYS or SYSTEM database user.Ĭlick Setup at the top of the Database Home page.Ĭlick Administrators in the left navigation bar. To grant management access to other database users, use the following procedure: These are the only accounts that are automatically granted the roles and privileges required to access all the management functionality provided the Database Control. When you log in to the Oracle Enterprise Manager using the SYS or SYSTEM user account, you are logging in as the Oracle Enterprise Manager super user. Granting Database Control Administrative Privileges This is all discussed in Chapter 10, "Monitoring and Tuning the Database". You can click the provided links to see more detail about the problem area, and even to obtain recommendations for resolving the problem. For example, the Alerts, Related Alerts, and Performance Analysis sections warn you of errors and performance problems that are impacting the operation of your database. The various sections of the Database Home page, and related links, provide a wealth of information about the database's environment and health. The functionality provided by these pages is discussed in other chapters of this book. The property pages across the top of the page enable you to access performance, administration, and maintenance pages for managing your database. Use the password you specified for the account during the database installation.Įnterprise Manager displays the Database Home page ( Figure 3-4). Log in to the database using a username that is authorized to access the Database Control. In the Confirmation screen, click YES to start the database in open mode. For the database user and password, use SYS and the password you specified during installation.Ĭlick OK to start the database. ![]() You are then prompted for the host and target database login usernames and passwords, which you must enter. If this is the case, click Startup/Shutdown. If the database is down and needs to be re-started, Enterprise Manager displays the Startup/Shutdown and Perform Recovery page. If the database is up, Enterprise Manager displays the Database Control Login page. For example, if you installed the database on a host computer named comp42, and the installer indicated that your Enterprise Manager Console HTTP port number is 5500 (also recorded in the $ORACLE_HOME/install/portlist.ini file), enter the following URL: ![]() Point your Web browser to the following URL: At other times, provided the dbconsole process is running on the server, you can navigate to your Database Control from your client browser as follows: At the end of a successful database creation, Oracle Enterprise Manager is automatically launched and the database is started.
0 Comments
Leave a Reply. |