本帖最后由 botang 于 2014-9-23 10:45 编辑
Section2
Notes: 1. This very web page only be avaliable in your “ODD machine” and the first “RAC machine”. It should be opened by firefox web browser. 2. Accessing machines other than your “ODD machine”, your “EVEN machine” and your two “RAC machines” is strictly prohibited, hence will be considered as a serious cheating event. 3. Oracle user's password is “oracle”. Use sudo, when you want to run program with supper user's privilege. You CAN NOT login all of the operating systems with root account. 4. All of the software files locate in “/stage”. 5. All of the document files locate in “/home/oracle/doc”. 6. DO NOT remove entries of “/root/.ssh/authorized_keys” of all of the machines, but you can add entries you want. 7. DO NOT change any other settings of all of the operating systems. 8. At the end of this web page, there is a link named 'CES', which is the testing link to verify we can score your result. We recommend you to test it at the end of each section before hand in. In section2, the right result of “CES” is as follows:
Thu Jul 3 23:05:25 CST 2014 SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 3 23:05:25 2014 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options 'OK.SECTION2CANBESCORED.' -------------------------- OK.Section2 can be scored. Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options |
Topics: 1.Grid Control Installation 1.1 Create a database for your repository: Use EMREP for database name and instance name on your even machine, characterset should be identical as that of PROD.Sys account of EMREP database should be set as "oracle". 1.2 Label Security is the only option needed with the EMREP database. 1.3 Install Grid Control on your Management Server using the installation media found under /stage/. During installation, there is an "opmnctl" warnning, you should run "opmnctl startall" manually. 1.4 Deploy an Oracle Management Agent on your Database Server, and set the right "dbsnmp" credential 1.5 For EMREP database, also set the right "dbsnmp" credential. 1.6 Create a Grid Control super user called EMADMIN with password EMADMIN 2.Using Grid Control 2.1 Using Grid Control, change the PGA_AGGREGATE_TARGET on your PROD server to 500MB so that it will revert when the instance is restarted. 2.2 Using Grid Control, configure the instance to ensure that it will take up to five(5) minutes to recover your instance following an instance failure. 2.3 Configure an alert on the SYSTEM tablespace of the PROD database.The alert should register as a warning at 87% full and critical at 95% full. 2.4 Setup notifications to be sent to the email address'dba@ocm.com'. Notification messages should be sent to this address at anytime. 2.5 Using Grid Control,create a new tablespace in the PROD database called REGISTRATION 2.5.1 Create with on 90MB datafile 2.5.2 Make sure this datafile can grow to 120MB if needed 2.5.3 Configure the tablespace for optimal block space utilization 3.Implementing Schedules and Jobs 3.1 Using Grid Control,create a schedule for the PROD database. 3.2 Call this schedule DAILYREBUILD 3.3 Configure it to run at 2PM every day 3.4 Create a program for the PROD database called EMP_IND_REBUILD that rebuilds all indexes on the SYSTEM schema. 3.5 Create a window that utilites the DIALYREBUILD schedule and SYSTEM_PLAN resource manager plan. 3.6 Create a job called REBUILD_JOB that uses the DAILYREBUILD schedule and EM_IND_REBUILD program. 3.7 Create a System-plan Batch: There are two windows in it, called win1 and win2, both run daily from 8:00PM to 4:00am next day.
End State: Your database must be open for access by the proctor for validation.The proctor will connect remotely to your databases using the sysdba role.You can check this as follows: 1. Log on to the PROD database using: sys/oracle@prod as sysdba 2. Query the DUAL table. 3. Log on to the Grid Control repository database using: sys/oracle@emrep as sysdba
| 
发表于 2014-9-22 08:43:13
