Oracle Database 2 Day DBA 11g Release- P13

Oracle Database 2 Day DBA 11g Release- P13:Oracle Database 2 Day DBA is a database administration quick start guide that teachesyou how to perform day-to-day database administrative tasks. The goal of this guideis to help you understand the concepts behind Oracle Database. It teaches you how toperform all common administrative tasks needed to keep the database operational,including how to perform basic troubleshooting and performance monitoringactivities.
Nội dung trích xuất từ tài liệu:
Oracle Database 2 Day DBA 11g Release- P13 Patching the Oracle Software8. Enter the credentials for the operating system user that will perform the patching operation. If you have already configured Preferred Credentials, you can choose the Use Preferred option. For the Schedule Type option, use the default value of One Time (Immediately). Optionally, you can choose to schedule the patching for a later time using the One Time (Later) option. Click Next to continue. The Review page appears.9. Review the information on this page. If any of the information is incorrect, you can click Back to return to a previous page and make corrections. When finished, click Finish to submit the job that patches the database. The Deployment Procedure Manager page appears.10. (Optional) To view the progress of the recently submitted patching operation, click Patch Oracle Standalone Database. The Procedure Completion Status page appears. Managing Oracle Database Software 12-7Viewing Critical Patch Advisories As part of the patching procedure, the database instance and Database Control are shut down and then restarted. After they have restarted, you must log in again and navigate to the Procedure Completion Status page to check the status. 11. After you have reviewed the status of each step, you can click Refresh to update the display if the procedure has not yet completed. When you have finished viewing the results, click Done. 12. Click the Database tab.Viewing Critical Patch Advisories The Patch Advisor in Enterprise Manager describes critical software patches for your installed Oracle products. To help ensure a secure and reliable configuration, all relevant and current critical patches should be applied. The Patch Advisor provides support for Remedies. When you select an advisory, you can view the calculated remedies from the context of that Advisory, as well as the affected Oracle homes. The Patch Advisor also displays a list of available patches and patch sets for your installation, along with the name of the feature that is impacted. You can choose to display only patches for features that are used by your database, or all available patches. To view the critical patch advisories and other recommended patches: 1. Using Database Control, on the Database Home page, in the Policy Violations section, view the count for Critical Security Patches. If any critical patches have not been applied to the Oracle home for the database, this section displays the number of critical patch advisories that are relevant to the12-8 Oracle Database 2 Day DBA Upgrading a Database Oracle home for the database. Also, a warning icon appears corresponding to the Oracle Home link on the Database Home page is the Oracle home is missing critical patches. 2. To view a list of available critical patch advisories, click the nonzero number next to the heading Critical Security Patches. Alternatively, from the Database Home page, select the Software and Support subtab, then, under the heading Database Software Patching, click Patch Advisor. The Patch Advisor page appears, listing the available critical security patches and patch recommendations by feature. 3. (Optional) In the Critical Security Patches table, click a value in the Advisory column to view further details for that critical security patch. 4. (Optional) To view all available patches, in the Patch Recommendations by Feature table, in the View list, select the value All, then click Go.Upgrading a Database Use Database Upgrade Assistant (DBUA) to upgrade an existing database to the current release of Oracle Database. This section contains these topics: ■ Overview of Database Upgrade Assistant ■ Database Versions Supported by DBUA ■ Starting DBUA ■ Upgrading a Database Using DBUAOverview of Database Upgrade Assistant Database Upgrade Assista ...