Free Essay

Provisioning Database Through Oem

In: Computers and Technology

Submitted By sallianz11
Words 4373
Pages 18
|[pic] |IT Infrastructure |Document Number |EDCS-xxxxxxx |
| | |Based on Template |No EDCS, Rev 0.x |
| | |Created By |Manickaraja Kumarappan |

IT Infrastructure Standards

Provisioning through Oracle Enterprise Manager

For document reviewers and modification history, see Table of Contents, Document History.

Any change to this document need to be reviewed and approved by Standard team or SME of this Domain. For document modification refer Revision History in next page.

Table of Contents

1. Purpose and Scope 3

2. Pre-Install requirements 3

3. EM Deployment Entities that are available today 4

3.1. List of Deployment Procedures 4 3.2. List of Software Library Components 5 3.3. List of Database Templates 5

4. Steps to Provision Oracle Components 6

4.1. Provisioning a RAC Database. 6 4.2. Provisioning a Standalone Database. 17 4.3. Monitoring a submitted procedure. 28

5. Executing root.sh script post install 32

5.1. For CRS install 32 5.2. For RDBMS Install 33

6. Manual Tasks 33

7. Glossary 34

8. Appendix 34

9. References 34

10. Documentation History 35

a. Revision History 35 b. Contributors 35 c. Reviewers 35

Purpose and Scope

This document provides complete steps for provisioning an Oracle CRS, RDBMS home and create a vanilla database through Oracle Enterprise Manager (OEM) Cloud control 12c.

Pre-Install requirements

a) Enterprise Manager Agent should be installed and configured across all hosts where provisioning is being attempted. b) All the mounts for installing oracle component should be in place as per Cisco standards. c) User should have access with “DBA” rights to OEM 12c. d) SSH should be set across all the DB nodes in case of RAC. e) CRS Oracle Home and RDBMS Oracle Home should be empty. Everything including lost+found should be removed prior to attempt provisioning through EM. f) Make sure central inventory is in place (check /oracle/product/oraInventory and /etc/oraInst.loc). INVENTORY_LOC inside this file should point to /oracle/product/oraInventory. g) You are suppose to have oraredo_mirr mount irrespective of whether the DB provisioned being MVDC or not (only in case of NAS storage). In case the same is missing, then as a work around please create a link and point it to /oracle/oraaredo. Example ln -s /oracle/oraredo /oracle/oraredo_mirr h) If you are attempting to run a provisioning procedure for the very first time, you should create a named credential in OEM. If you have already done that you can simply re-use the same and can skip this step. In order to create a named credential login into OEM Navigate to setup (on the right hand side) -> security -> named credential - > create [pic] Fill in the following stuffs. Credential Name: Meaningful name (could be same as your username) Credential Description: optional Authenticating Target Type: Host Credential Type: Host Credentials Scope: Global UserName: Your CEC user id Password: Your CEC password Confirm Password: Your CEC password Run Privilege: Sudo Run as: Oracle [pic] i) Click Test and Save. j) Choose any host (may be the host on which you are going to attempt provisioning) and make sure test succeeds. k) At any point of time if you want to see the status of submitted procedure, you can do so by navigating to Enterprise - > provisioning and patching - > procedure activity

EM Deployment Entities that are available today

1 List of Deployment Procedures

Below table will summarize when to use what procedure when a deployment is attempted through Enterprise Manager.

|S.No |Requirement |Procedure Name |Items to be checked while submitting procedure |
|1. |Install CRS, Clone Oracle Home and |Cisco Provision Oracle RAC Database |Deploy Grid Infrastructure |
| |Create Database | |Deploy Database Software |
| | | |Configure Grid Infrastructure |
| | | |Create a New Database |
|2. |Install CRS, Clone Oracle Home |Cisco Provision Oracle RAC Database |Deploy Grid Infrastructure |
| | | |Deploy Database Software |
| | | |Configure Grid Infrastructure |
|3. |Install CRS |Cisco Provision Oracle RAC Database |Deploy Grid Infrastructure |
| | | |Configure Grid Infrastructure |
|4. |Clone Oracle Home on a RAC Cluster |Cisco Provision Oracle RAC Database |Deploy Database Software |
| |and create Database | |Create a New Database |
|5. |Clone Oracle Home |Cisco Provision Oracle RAC Database |Deploy Database Software |
|6. |Clone Oracle Home and Create Database|Cisco Provision Oracle Database |Deploy Database Software |
| |for Non-RAC | |Create a New Database |
|7. |Clone Non-RAC oracle Home |Cisco Provision Oracle Database |Deploy database Software |
|8. |Create RAC/NON-RAC database |Cisco Create Oracle Database |N/A |

All these procedures can be accessed by navigating into OEM -> Enterprise -> Provisioning and Patching -> Database Provisioning

[pic]

2 List of Software Library Components

➢ CISCO_11203_CRS_PSU_CURRENT – 11.2.0.3 CRS with current PSU ➢ CISCO_10205_CRS_PSU_CURRENT – 10.2.0.5 CRS with current CPU ➢ CISCO_11203_DB_PSU_CURRENT – 11.2.0.3 RDBMS with current PSU ➢ CISCO_11203_DB_PSU_PREV – 11.2.0.3 RDBMS with current-1 PSU ➢ CISCO_10205_DB_PSU_CURRENT – 10.2.0.5 RDBMS with current PSU ➢ CISCO_10205_DB_PSU_PREV – 10.2.0.5 RDBMS with current -1 PSU

3 List of Database Templates

➢ CISCO_11203_NONERP_NONRAC_NAS_DB_TEMPLATE ➢ CISCO_11203_NONERP_RAC_NAS_DB_TEMPLATE ➢ CISCO_11203_NONERP_RAC_ASM_DB_TEMPLATE

Steps to Provision Oracle Components

1 Provisioning a RAC Database.

• Navigate to OEM - > Enterprise -> Provisioning and Patching - > Database Provisioning. • Choose Cisco Provision Oracle RAC Database and click Launch [pic] • Review the check boxes under “Select tasks to Perform” and select as per the requirement (all 4 needs to be checked in if your intention is to provision CRS, Oracle Home and create Database) • If you are provisioning CRS, then you need to click [pic] under Select destination hosts and add the host which are part of the cluster • While adding hosts, please make sure they are added in ascending order. For example if a 4 node RAC is being provisioned on svr1,svr2,svr3,svr4 then while adding them please make sure first svr1 is selected, followed by svr2, then svr3 and then svr4. If this order it not maintained then we might have problem while creating DB on this cluster (DB instance order might be improper). • If you are provisioning Oracle Home (on a host where CRS already exists), then you to click [pic] and add the cluster name where you want to provision Oracle Home. Cluster should be discovered in OEM prior to this and if not it is not possible to provision Oracle Home. • If you don’t know the cluster name, then query by host name and look for a target of type “cluster”. There will be only one target of type “cluster” for a set of cluster nodes. • The configuration details will be asked based on check boxes that were checked earlier. o Setup Hosts (Required under all scenarios) ▪ Click Setup Hosts hyperlink ▪ Choose a Named credential for both Normal & Privileged user (refer pre-requisite section if you don’t have one) ▪ [pic] ▪ Click Next ▪ Enter “dba” as OS Group Name for all the components (OINSTALL, OSDBA, OSOPER, OSASM, ASMDBA, ASMOPER). You may see all or few based on components ▪ [pic]Click Next ▪ Make sure you have a green check mark next to Setup Hosts hyperlink. ▪ [pic] o Deploy Software (Required under all scenarios) ▪ Click Deploy Software hyperlink ▪ You will be required to select two components (if you are deploying both CRS and RDBMS Oracle home) or just one (based upon which one you selected) ▪ Click the magnifying glass ([pic]) Icon next to each component and select one which fits your requirement. You may refer above section in this document to know about various components that are in use. ▪ [pic] ▪ Enter the Oracle Base for Grid Infrastructure (Usually /oracle/admin/GRID) – Applicable only if CRS is being installed ▪ Enter Grid Infrastructure home (Usually /oracle/product/grid_home) – Applicable only if CRS is being installed ▪ Don’t check “Shared Grid Infrastructure home” ▪ Enter Oracle Base for Database (usually /oracle/product/). Cisco standard is to have /oracle/admin/ as Oracle Base. However due to existing issue with EM, we need to provide an Oracle Base which is a subset of Oracle Home. However we are changing this as per Cisco standard at later stage and hence we don’t have to worry. – Applicable only if RDBMS code tree is installed. ▪ Enter Database Oracle Home – Usually /oracle/product// -- Applicable only if CRS is being installed. ▪ Don’t check “Shared Database Oracle Home ▪ [pic] ▪ Enter working directory as “/oracle/export/tmp” ▪ Leave Install parameters as blank ▪ [pic] ▪ Click Next ▪ Make sure you have a green check mark next to Deploy Software o Configure Grid Infrastructure (Required only if you provisioning CRS) ▪ Click Configure Grid Infrastructure hyperlink ▪ Select the storage type for both GI and Database as appropriate (Either ASM or File system in case of NAS). By default ASM is selected ▪ [pic] ▪ Enter Cluster Name (Standard is to provide Cluster name based on Scan Name). For example if SCAN name is SCAN-D2C001 then enter Cluster name as CRS-D2C001 ▪ Enter Scan Name: Query /etc/hosts and enter the scan name accordingly ▪ Enter Scan Port: 1541 is our standard for Scan Port. ▪ [pic] ▪ Under GNS settings, enter the virtual host name (if it is not pre-filled) for all the RAC nodes. If it is pre-filled just verify the entries and make sure they are correct. ▪ [pic] ▪ Under GI Network, Verify the IP of eth1, eth0 and make sure eth0 points to Public interface and eth1 points to Private Interface. Minimum one public and one private interface are required. You can issue netstat –anr command on host to fetch the public and private IP’s. ▪ [pic] ▪ Under File System Storage Leave the Redundancy as External for both OCR and Voting disk ▪ Enter the full path where you want to store OCR & Voting disk. ▪ Example: • OCR_LOCATIONS= /oracle/GRID_D2C001/fs01/OCR1,/oracle/GRID_D2C001/fs02/OCR_MIRROR2 • VOTING_DISKS= /oracle/GRID_D2C001/fs01/VOTE1, /oracle/GRID_D2C001/fs02/VOTE_MIRROR2, /oracle/GRID_D2C001/fs03/VOTE_MIRROR3 ▪ [pic] ▪ Click Next ▪ Make sure their exist a Green check mark next to “Configure Grid Infrastructure” o Create Databases (Required only if you are creating a DB) ▪ Click “Create databases” hyperlink ▪ Choose “Select Template From Software Library” Radio button ▪ Click the Magnifying glass next to Template (where it says No template selected) ▪ Select the template as appropriate (you may refer the table above on this document for list of templates that are in use) ▪ Enter “Temporary Storage Location on Managed Host(s) as /oracle/export/tmp ▪ [pic] ▪ Click Next ▪ Leave the Configuration type as “Administrator Managed” and make sure all nodes are displayed on the screen ▪ [pic] ▪ Under Identification enter Global Database Name as DBNAME.CISCO.COM: Example: D2C001A.CISCO.COM ▪ SID Prefix as just DB Name: Example: D2C001A ▪ [pic] ▪ Under Database Credentials Choose “Use the same administrative password for all accounts” and provide password as “oracle123”. The password provided here is just temporary since we will be changing the same at later stage. ▪ [pic] ▪ Click Next ▪ Under Storage Type, choose as appropriate where the Database files will be stored. ▪ [pic] ▪ Under Database Files Location, make sure “Use Database File Locations from Template” is selected. ▪ [pic] ▪ Under Recovery Files Location, if you are going to use Fast Recovery area then select “Use Fast Recovery Area” check box ▪ Under Recovery Area Location specify the location where you want your recovery files to be created. Our standard is to provide /oracle/oradata_flashback//fs01. Example: /oracle/oradata_flashback/D2C001A/fs01 ▪ Specify Fast Recovery Area Size (MB) based on the mount point space available. ▪ [pic] ▪ If you want the database being provisioned to be in archivelog mode, then select “Enable Archiving” check box. ▪ [pic] ▪ Click “Specify Archive Log Locations” button to specify the location where archive log needs to be placed. ▪ You can enter as many location as required. ▪ Our Standard is to enter one location and it needs to be entered as /oracle/archive//fs01/.arch. Example /oracle/archive/D2C001A/fs01/D2C001A.arch ▪ [pic] ▪ Click OK ▪ Click Next ▪ Review the memory parameters and change as per requirement ▪ [pic] ▪ Review Database sizing and change as per requirement. ▪ [pic] ▪ Leave the HOST CPU count to 0 ▪ [pic] ▪ Choose Character set as per requirement ▪ [pic] ▪ Leave the Database Connection Mode to “Dedicated Server Mode” ▪ [pic] ▪ Click Next ▪ Under Database Features leave the default components selected AS-IS unless otherwise you have a business requirement to deselect any. ▪ [pic] ▪ Under Custom Scripts, no need to specify any script. Just leave it blank ▪ [pic] ▪ Click Next ▪ Just review all the items here. If you want to make any change click “Back” button to go back and make changes. ▪ If everything is fine then click Next. ▪ Make sure you have a Green Check Mark next to Create databases. o Compliance Standards (Required only if you creating a DB) ▪ Click Compliance Standards hyperlink ▪ Leave the compliance standard set to “None” which is default ▪ [pic] ▪ Click Next ▪ Make sure you have a green check mark next to Compliance Standard hyperlink. ▪ At this point you should have Green check marks against all the items listed in the screen, if you cannot proceed further ▪ [pic] ▪ Click Next ▪ On the field “Enter EMAIL for notification” enter your Cisco email address. This is where notification will be sent on issues if any post deployment process. ▪ On the field “Enter Lister Port” enter the desired port number where you want to configure the Listener for the database being deployed. This port number should be free and should be available across all RAC Nodes. ▪ [pic] ▪ Click Next ▪ Leave everything to default on this screen. ▪ You may save this if you want to re-use the value entered at later point of time. • If you want to submit a saved procedure, all you have to do is, goto Enterprise -> Provisioning and Patching -> Database Provisioning, Under “Provision Oracle RAC Database” you should be able to see the one which you saved. Just select it and move forward with submission ▪ Click Next ▪ Review all the details entered and then click Submit. ▪ It will ask you to reconfirm, just click Yes to reconfirm and procedure will be submitted for execution ▪ [pic]

2 Provisioning a Standalone Database.

• Navigate to OEM - > Enterprise -> Provisioning and Patching - > Database Provisioning. • Choose Cisco Provision Oracle Database and click Launch [pic] • Review the check boxes under “Select tasks to Perform” and select as per the requirement (both “Deploy Database software” and “Create a new database” needs to be selected if intention is to clone a oracle home and create vanilla database) • [pic] • Under “Select destination hosts” click [pic] • Select the host where you want to have the DB created. • [pic] • [pic] • Click Next • The configuration details will be asked based on check boxes that were checked earlier. o Setup Hosts (Required under all scenarios) ▪ Click Setup Hosts hyperlink ▪ Choose a Named credential for both Normal & Privileged user (refer pre-requisite section if you don’t have one) ▪ [pic] ▪ Click Next ▪ Enter “dba” as OS Group Name for all the components (OINSTALL, OSDBA, OSOPER). ▪ [pic]Click Next ▪ Make sure you have a green check mark next to Setup Hosts hyperlink. ▪ [pic] o Deploy Software (Required under all scenarios) ▪ Click Deploy Software hyperlink ▪ You will be required to select a component for RDBMS Oracle home ▪ Click the magnifying glass ([pic]) Icon next to “Oracle Database” component and select one which fits your requirement. You may refer above section in this document to know about various components that are in use. ▪ [pic] ▪ Enter Oracle Base for Database (usually /oracle/product/). Cisco standard is to have /oracle/admin/ as Oracle Base. However due to existing issue with EM, we need to provide an Oracle Base which is a subset of Oracle Home. However we are changing this as per Cisco standard at later stage and hence we don’t have to worry. – Applicable only if RDBMS code tree is installed. ▪ Enter Database Oracle Home – Usually /oracle/product// -- Applicable only if CRS is being installed. ▪ [pic] ▪ Enter working directory as “/oracle/export/tmp” ▪ Leave Install parameters as blank ▪ [pic] ▪ Click Next ▪ Make sure you have a green check mark next to Deploy Software o Create Databases (Required only if you are creating a DB) ▪ Click “Create databases” hyperlink ▪ Choose “Select Template From Software Library” Radio button ▪ Click the Magnifying glass next to Template (where it says No template selected) ▪ Select the template as appropriate (you may refer the table above on this document for list of templates that are in use). Example CISCO_11203_NONERP_NONRAC_NAS_DB_TEMPLATE ▪ Enter “Temporary Storage Location on Managed Host(s) as /oracle/export/tmp ▪ [pic] ▪ Click Next ▪ Under Identification enter Global Database Name as DBNAME.CISCO.COM: Example: DBCIM.CISCO.COM ▪ SID Prefix as just DB Name: Example: DBCIM ▪ [pic] ▪ Under Database Credentials Choose “Use the same administrative password for all accounts” and provide password as “oracle123”. The password provided here is just temporary since we will be changing the same at later stage. ▪ [pic] ▪ Click Next ▪ Under Storage Type, choose as appropriate where the Database files will be stored. ▪ [pic] ▪ Under Database Files Location, make sure “Use Database File Locations from Template” is selected. ▪ [pic] ▪ Under Recovery Files Location, if you are going to use Fast Recovery area then select “Use Fast Recovery Area” check box ▪ Under Recovery Area Location specify the location where you want your recovery files to be created. Our standard is to provide /oracle/oradata_flashback//fs01. Example: /oracle/oradata_flashback/D2C001A/fs01 ▪ Specify Fast Recovery Area Size (MB) based on the mount point space available. ▪ [pic] ▪ If you want the database being provisioned to be in archivelog mode, then select “Enable Archiving” check box. ▪ [pic] ▪ Click “Specify Archive Log Locations” button to specify the location where archive log needs to be placed. ▪ You can enter as many location as required. ▪ Our Standard is to enter one location and it needs to be entered as /oracle/archive//fs01/.arch. Example /oracle/archive/D2C001A/fs01/D2C001A.arch ▪ [pic] ▪ Click OK ▪ Click Next ▪ Review the memory parameters and change as per requirement ▪ [pic] ▪ Review Database sizing and change as per requirement. ▪ [pic] ▪ Leave the HOST CPU count to 0 ▪ [pic] ▪ Choose Character set as per requirement ▪ [pic] ▪ Click Next ▪ Under Listener Configuration enter a “Listener Name”. Usually LISTENER_. Example: LISTENER_DBCIM ▪ Enter a Port where you want listener to be configured. Make sure the port entered is not in use at host level. If not you may get an error message as “Specified Port is already in use by different listener on this host” ▪ [pic] ▪ Under Database Features leave the default components selected AS-IS unless otherwise you have a business requirement to deselect any. ▪ [pic] ▪ Under Custom Scripts, no need to specify any script. Just leave it blank ▪ [pic] ▪ Click Next ▪ Just review all the items here. If you want to make any change click “Back” button to go back and make changes. ▪ If everything is fine then click Next. ▪ Make sure you have a Green Check Mark next to Create databases. o Compliance Standards (Required only if you creating a DB) ▪ Click Compliance Standards hyperlink ▪ Leave the compliance standard set to “None” which is default ▪ [pic] ▪ Click Next ▪ Make sure you have a green check mark next to Compliance Standard hyperlink. ▪ At this point you should have Green check marks against all the items listed in the screen, if you cannot proceed further ▪ [pic] ▪ Click Next ▪ On the ORACLE_BASE field enter the value for ORACLE_BASE as per Cisco Standard which is /oracle/admin/. Example /oracle/admin/DBCIM ▪ [pic] ▪ On the field “Enter EMAIL for notification” enter your Cisco email address. This is where notification will be sent on issues if any post deployment process. ▪ On the field “Enter Lister Port” enter the same listener port which you entered in previous step. ▪ [pic] ▪ Click Next ▪ Leave everything to default on this screen. ▪ You may save this if you want to re-use the value entered at later point of time. • If you want to submit a saved procedure, all you have to do is, goto Enterprise -> Provisioning and Patching -> Database Provisioning, Under “Provision Oracle RAC Database” you should be able to see the one which you saved. Just select it and move forward with submission ▪ Click Next ▪ Review all the details entered and then click Submit. ▪ It will ask you to reconfirm, just click Yes to reconfirm and procedure will be submitted for execution ▪ [pic]

3 Monitoring a submitted procedure.

✓ Navigate to OEM - > Enterprise -> Provisioning and Patching - > Procedure Activity to see all the procedure executions (those which are currently running as well those which got completed in the past) ✓ If a procedure is submitted by Person “A”, then Person “B” won’t be able to see the same. If their exist a required for Person “B” to monitor/take action on the procedure submitted by person “A”, then person “A” has to grant permission on the procedure he submitted. o In order to grant a privilege, choose the procedure execution on which privilege needs to be granted (by navigating into OEM -> Enterprise -> Provisioning and Patching -> Procedure Activity) o Click “Edit Permissions” button o [pic] o Click Add o Search by CEC ID to whom access needs to be provided o Click Select o [pic] o Under “Manage Target Privilege Grants” drop down list choose the privilege as appropriate (“FULL” is recommended) o [pic] o Click OK o Their after granted person will have full privilege on the procedure. ✓ Execute Prerequisites and Fixups (second step in the procedure) will be running for considerable amount of time. This is the step which does end-to-end validation to make sure the host setup if fine and parameter provided during the interview process is valid. ✓ At any given point if someone needs to know what exactly is being done and to see the relevant log files, just click the step name (which is usually hyper link), ✓ [pic] ✓ Then keep click the host name (which is again a hyper link) on which it is running/completed. ✓ Click the status (running/failed/succeeded) which is again a hyper link ✓ [pic] ✓ Expand the execution details arrow and you will see the complete log of the execution. ✓ [pic] ✓ Incase if a step got failed you will easily come know the reason for failure by reviewing corresponding log file. ✓ [pic] ✓ Incase if a step is failed, then you have an option either to Retry or to Ignore. Please note that all steps cannot be ignored. If a step is very critical and a dependent for subsequent steps then that step cannot be ignored. Ignore button will be disabled in this case. ✓ You need to select the host where you want to retry/ignore and then click corresponding button. ✓ [pic] ✓ If the issue is identified (by going through the log file) and cause for failure is fixed then one can click “retry” so that the same failed step will be reattempted and upon success it will proceed further. ✓ It is highly recommend to always use “Retry” and Ignore should never be used unless otherwise it is essential. ✓ Also Retry will only execute the procedure from failure point, this saves time and no need to repeat the steps which already got completed.

Executing root.sh script post install

1 For CRS install

❖ While installing CRS, execution procedure will fail while running root.sh. This is expected since our ID’s doesn’t have sudo access to root for running root.sh ❖ [pic] ❖ Once the step is failed, login into DB node, manually invoke root.sh o sudo /oracle/product/grid_home/root.sh ❖ Review the log file and incase of no errors run rootcrs.pl o sudo /oracle/product/grid_home/crs/install/rootcrs.pl ❖ once rootcrs.pl execution got completed, check the component status on CRS and make sure everything is in “UP” status. ❖ Please make sure root.sh & rootcrs.pl is executed in the order in which RAC instances would be created. For example if it is a 4 node RAC DB on hosts svr1,svr2,svr3 and svr4, then please execute root scripts first on svr1, once it got completed executed it on svr2, then svr3 and at last on svr4. ❖ Follow the same on all the remaining RAC Nodes. ❖ Once it is done, go back to EM, select the failed step and click retry. ❖ [pic] ❖ This time it will succeed and will move forward. ❖ Their after procedure should not fail and should complete all the way till end.

2 For RDBMS Install

Incase of RDBMS oracle home clone, root.sh script has been disabled since it is not mandatory to execute it before subsequent steps completes. However one has to run this script post deployment process to make sure process is complete.

You can login into DB node and run sudo $ORACLE_HOME/root.sh. This needs to be done across all RAC nodes.

Manual Tasks

This section lists all the tasks that are manual as of now.

1. Execution of root.sh script 2. Pinning CRS nodes in case of RAC 3. Any links those are missing which are communicated through e-mail at end of the process. 4. [pic] 5. Reviewing and scheduling the cron jobs for monitoring (Production Focus, log file manager, archive utl etc.) 6. Registering listener in LDAP 7. Making entry in DBTS 8. Scheduling backup and coordinating tasks with DIG team. 9. EMAN entry

Glossary

Appendix

1 Cisco specific customizations

Given below are Cisco specific customizations that are done as part of DB provisioning.

1) Create dedicated listeners with same port across all RAC nodes 2) Make oratab entries as per Cisco standards 3) Deploy standard scripts as per Cisco standards 4) Create CCPADMIN schema 5) Perform SOX/RDAC related setups 6) Pin Standard objects into shared pool 7) Increase AWR retention period as per Cisco standards 8) Install OS Watcher 9) Configure Splunk if applicable 10) Create EMAN Monitor User 11) Register DB in OCM 12) Configure Local and Remote listener parameters as per Cisco Standards 13) Create various softlinks as per Cisco standard 14) Disable standard gather stats job 15) Enable force logging 16) Move .patch_storage to /oracle/dump 17) Create password file 18) Register DB in RMAN catalog 19) Create password file with sys/rman schema passwords 20) Turn off auto extend across all DB files

References

Provisioning & Patching Oracle Database using Enterprise Manager 12c
Oracle Enterprise Manager 12c Documentation

OEM Wiki Page

Documentation History

1 Revision History

|Version |Revised On |Revised |Revised For |Reviewed |Reviewed |
| | |By | |By |On |
| | | | | | |

2 Contributors

|Name |Email Id |Role |
|Manickaraja Kumarappan |mkumarap@cisco.com |EM System admin |
|Pascal Laporte |plaporte@cisco.com |EM System admin |
|Venkata Kiran Gunturi |vgunturi@cisco.com |EM System admin |
|Surekha Jampala |surjampa@cisco.com |EM System admin |

3 Reviewers

|Name |Email Id |Role |
|Pascal Laporte |Plaporte |EM System admin |
| | | |
| | | |
| | | |

End of Document…...

Similar Documents

Premium Essay

Database

...DSS 630 Database Management Systems Theory and Practice COURSE EXPECTATION FORM Course Description: The implementation of technology such as bar codes and scanners enable organizations to accumulate large volumes of data. Further, as the technology to collect data gets cheaper and more simplified, business organizations gather and process a huge amount of data and information. Thus, data management has become a key function for many organizations. Managers need high-quality information to manage change in a turbulent, global environment. Business organizations use information systems to store and retrieve data, the raw material in knowledge-based economies. This repository of data is organizational memory. Databases are an important component of the organizational memory. Thus, information systems professionals should develop a comprehensive understanding of data management principles to fully utilize the organizational role of information technology. This course provides core skills of data management for the relational database management systems. This course will review the theoretical concepts and applications of a modern relational database management system. In addition to a basic theoretical presentation of the database design concepts, students will be required to design and develop a database application using a modern fourth generation language system. This course teaches students data modeling and......

Words: 1374 - Pages: 6

Premium Essay

Database

...get rid of traditional databases Redundancy in defining and storing data Wasted storage space Redundant efforts to maintain common data up-to-date Miniworld - some aspect of the real world Redundancy - *Repetitive storage* of data leading to possible multiple versions and/or ill utilisation of data storage capacity Inconsistency - Failure to adhere to standardised storage of data; usage of varying formats, non-confirmation to standardised/defined methods to store similar/related data. *Design of a new application for an existing database *Design of a brand new database * requirements specification and analysis Transformed to.... * conceptual design(ENTITY-RELATIONSHIP MODEL) that can be represented and manipulated using some computerized tools. Transformed to.... * logical design(RELATIONAL DATA MODEL) that can be expressed in a data model implemented in a commercial DBMS. (In this book we will emphasize a data model known as the Relational Data Model. Transformed to.... * physical design - further specifications are provided for storing and accessing the database Characteristics of the Database Approach 1. Self-describing nature of a database system 2. Insulation between programs and data, and data abstraction 3. Support of multiple views of the data 4. sharing of data and multiuser transaction processing 1. Self-Describing Nature of a Database System @The fact that modern database systems contain......

Words: 438 - Pages: 2

Free Essay

Database

...TRAINER DATABASE PLAN When creating a database first it best that we understand why we need the database in the first place. The reason being, I am working as a corporate trainer for a large organization. In the organization there are several other trainers, with each trainer there are many training topics. Our company has grown quickly and scheduling has become difficult. The current method for our scheduling involves writing trainer names and courses on a dry-erase board. This has led to many issues with our trainers changing the assignments in their favor and accidental erasure of some course assignments. So in order to resolve the many issues that we are having, I have decided to build a database for the training schedule process. In my previous organization, we created a database for organizing our documents and the process each packet goes through day-by-day. To do this we used, Microsoft Access which gave each user privileges by the administrator. To design a database in Access or with any software, it is required that those involved understand why that database is need, those functions that will be required by the company and the knowledge of the database features in accordance to the needs of the company or organization . To begin, as a designer we know that it is best to, create a plan that will be used as a reference when the database is being implemented and also to be used as a operative specification for the database as well after it has been implemented....

Words: 661 - Pages: 3

Premium Essay

Database

...Client/Server is a system. It is not just hardware or software. It is not necessarily a program that comes in a box to be installed onto your computer’s hard drive. Client/Server is a conglomeration of computer equipment, infrastructure, and software programs working together to accomplish computing tasks which enable their users to be more efficient and productive. Client/Server applications can be distinguished by the nature of the service or type of solutions they provide. Client/Server Computing is new technology that yields solutions to many data management problems faced by modern organizations. Client/Server Computing: An Introduction, features objective evaluations and details of Client/Server development tools, used operating system, database management system and its mechanism in respect of Client/Server computing and network components used in order to build effective Client/Server applications. vi Preface Last but not the least, this work is primarily a joint work with a number of fellow teacher who have worked with us. My parents, wife Meera, and our children, Akanksha and Harsh. I am particularly grateful to Dr. A. P. Singh, Principal, Udai Pratap Inter College, Varanasi; Dr. D. S. Yadav, Sr. Lecturer, Department of Computer Science and Engineering, IET, Lucknow; Dr. A. K. Naiyak, Director IIBM, Patna, former President of IT and Computer Science Section of Indian Science Congress Association; Prof. A. K. Agrawal, Professor and Ex-Head of Department,......

Words: 79055 - Pages: 317

Premium Essay

It205 Smart Scenario - Clarifying Business Strategy Through Database Analysis

...inefficient or non-existent. ☑ Poor use of available information technology resources. ☑ Insufficient use of database technology or tools. ☐ Poor communication. How could a proper database system and subsequent tools serve to improve the issues this department is having? (short answer) Have no database to keep track of clients. Only way of customer feedback is through cards and they do not reply. Database could do all that for them. They schedule staff by previous seasons. Database could give accurate occupancy. Database could advertise and rent rooms. Front Desk What are the current problems that the Front Desk is having? (multiple choice, multi-select) ☑ System is disconnected from other departments. ☑ Too much manual intervention in the business process. ☑ Required information is not always available. ☑ Information retention is inefficient or non-existent. ☑ Poor use of available information technology resources. ☑ Insufficient use of database technology or tools. ☐ Poor communication. How could a proper database system and subsequent tools serve to improve the issues this department is having? (short answer) Recepts should be logged into computer at once for all departments to view. Reports are printed montyhly and passed around. Information should be in database to be viewed all the time. Information should be monitored by a database for accurancy. Accounting What are the current problems that Accounting is having? (multiple......

Words: 619 - Pages: 3

Premium Essay

Database

...Introduction $  $  • Purpose of Database Systems • Data Definition Language • Data Manipulation Language • Transaction Management & ' & • Storage Management • Database Administrator • Database Users • Overall System Structure 1.1 Silberschatz, Korth and Sudarshan c 1997 Database Systems Concepts Database Management System (DBMS) • Collection of interrelated data • Set of programs to access the data • DBMS contains information about a particular enterprise • DBMS provides an environment that it both convenient and efficient to use Database Systems Concepts 1.2 Silberschatz, Korth and Sudarshan c 1997 ' & ' & Purpose of Database Systems $  $  Database management systems were developed to handle the following difficulties of typical file-processing systems supported by conventional operating systems. • Data redundancy and inconsistency • Difficulty in accessing data • Data isolation – multiple files and formats • Integrity problems • Atomicity of updates • Concurrent access by multiple users • Security problems Database Systems Concepts 1.3 Silberschatz, Korth and Sudarshan c 1997 View of Data An architecture for a database system view level view 1 view 2 … view n logical level physical level Database Systems Concepts 1.4 Silberschatz, Korth and Sudarshan c 1997 ' & ' & Levels of Abstraction $  $  • Physical level: describes how a record (e.g., customer) is stored. • Logical level: describes data stored in database, and the relationships among......

Words: 1023 - Pages: 5

Premium Essay

Database

...needed to build a database for the scheduling process. * Describe the advantages and disadvantages of moving the schedule to a database. * Create a graphical representation of your proposed database environment. * Explain how referential integrity can prevent mistakes in a database. Do the advantages outweigh the difficulty of setting it up? * Impress your boss by creating a database in Microsoft Access that will match trainers with courses and meet the following requirements: * Two (2) tables, one (1) containing trainer information and the other containing course information. Create data for five (5) instructors and five (5) courses. The trainer data should include: employee ID number, last name, first name, department, and email address. The course data should include: course number, course name, trainer employee ID number, and training location. * A relationship should exist between the tables. * Use referential integrity to make sure that each course has a valid trainer assigned to it. Week 7 Assignment 4 * Discuss the requirements needed to build a database for the scheduling process. The first step in creating a database is creating a plan that serves both as a guide to be used when implementing the database and as a functional specification after it has been implemented. The complexity and detail of a design is dictated by the complexity and size of the database application as well as the user population. A database can be......

Words: 681 - Pages: 3

Premium Essay

Database

...the purpose and features of the system, the interfaces of the system, what the system will do, the constraints under which it must operate and how the system will react to external stimuli. 1.2. Scope of Project Nowadays sending SMS to the friends or other people is very common thing. Some people are addicted to chat with their friend through SMS via mobiles. This window application will provide a facility to send SMS to their friend and other people from their computers via internet. So in this case they don’t need to have their own mobile to send SMS. It would help someone when he needs to send SMS and he don’t have SMS package or balance in his mobile account. The app will also be connected with the database and the sent messages will be stored in the database and user can also see the previous messages sent by him 1.3. Glossary |Term |Definition | |User |The person who will use this application to send SMS to his friends etc. | |Database |Collection of all the information monitored by this system. | |Software Requirements Specification |A document that completely describes all of the functions of a proposed system and the | | |constraints under which it must......

Words: 2905 - Pages: 12

Free Essay

Database

...of computers in information handling, there appeared a number of databases containing bibliographic details of documents, often married with abstracts, keywords, and so on, and consequently the concept of information retrieval came to mean the retrieval of bibliographic information from stored document databases. Information retrieval is concerned with all the activities related to the organization of, processing of, and access to, information of all forms and formats. An information retrieval system allows people to communicate with an information system or service in order to find information – text, graphic images, sound recordings or video that meet their specific needs. Thus the objective of an information retrieval system is to enable users to find relevant information from an organized collection of documents. In fact, most information retrieval systems are, truly speaking, document retrieval systems, since they are designed to retrieve information about the existence (or non-existence) of documents relevant to a user query. Lancaster3 comments that an information retrieval system does not inform (change the knowledge of) the user on the subject of their enquiry; it merely informs them of the existence (or non-existence) and whereabouts of documents relating to their request. However, this notion of information retrieval has changed since the availability of full text documents in bibliographic databases. Modern information retrieval systems can either retrieve......

Words: 5238 - Pages: 21

Premium Essay

Database

...commerce. This is because goods and services that are sold in stores, through mail order, or via the telephone are today also bought and sold through various forms of e-commerce. Management companies directing and controlling a group of one or more people or entities for the purpose of coordinating and harmonizing that group towards accomplishing a goal. Management often encompasses the deployment and manipulation of human resources , financial resources, technological resources, and natural resources. Management can also refer to person or people who perform the act of management . Management operates through various functions, often classified as planning, organizing, leading, motivating and controlling. E-Management also can call as electronic management. E-Management is computerized all the management. E-Management is included a lot of things. E-leave management system also can as an e-management system. E-Management is about how to manage a resources by using web-based database system. With database system, the business will be more efficiently and systematic. The business does not have to use the manual technique that needs files and cupboards to store the forms. The forms are store in one place and references and easier to make. This system is a part of the e-services. This Database System is very import in the business world to provide a better service in a systematic way. Companies use databases because they can store a large number of records, ease of use when......

Words: 4264 - Pages: 18

Free Essay

Database

...transformation processes. In actual sense, relational database offers a solution to this menace. Data organization, keeping, storage, and retrieval among other essentials can easily be realized by adopting relational data management model. In this kind of model, tables are made use of in such a way that data items are formally described and organized according to their level of relations. The data item contained in a given table represents a relation. I am convinced beyond reasonable doubt that through the use of relational database model, an organization can be able to effectively manage their wide range of information encountered on a daily basis. Relational database model offers a more efficient means of managing data. Some of the huge benefits are discussed as follows. A relational database is a collection of relations or tables. The rows of a table in a relational database are known as tuples and each column of a table is called an attribute. By definition, a relation becomes a set of tuples having the same attributes. Operations, which can be performed on the relations are select, project and join. The join operation combines relations, the select queries are used for data retrieval and the project operation identifies attributes. The information oif the organization can be captured, manipulated, managed, and shared, and the value the database brings to the organization is immense. The advantages of a relational database are that they contribute to sound logical......

Words: 554 - Pages: 3

Premium Essay

Databases

...4600-01 INTRO TO DATABASES CLOUD DATABASES SUBMITTED BY: ALICIA RUCKER INSTRUCTOR: DR. LUIS VIDAL SPRING 2016 Abstract A cloud database is a database that typically runs on a cloud computing platform. Users can run databases on the cloud independently, using a virtual machine image, or they can purchase access to a database service, maintained by a cloud database provider. There is a proposed 5 layer cloud architecture. The External Layer, which is the first, is closest to the user. The second layer is the Conceptual Middleware Layer. The third layer is the Conceptual Layer. In this layer programming techniques, transaction management, query processing and optimization are considered. The fourth layer is the Physical Middleware Layer, where interoperability between various platforms is considered. Last, there is the Physical Layer which is concerned with how data is stored and accessibility. A cloud database management system is a distributed database that delivers computing as a service instead of a product. It is the sharing of resources, software, and information between multiply devices over a network which is mostly the internet. An example of this is Software as a Service or SaaS. SaaS is an application that is delivered through the browser to customers. A database management system is a software package with computer programs that control the creation, maintenance, and use of a database. It allows organizations to conveniently develop databases for......

Words: 851 - Pages: 4

Premium Essay

Database

...Case Study: Database Development ALEXANDRA DESINORD PROFESSOR OSAMA MORAD CIS 515- STRAT PLAN FOR DBASE SYSTEMS Week 7 Assignment February 29, 2016 The more companies base their large elements of their business strategy around data, the need for IT team and executives with deep understanding of data and analytics is growing rapidly. Data changes all of the time. That is why it is essential that companies should try to stay up to par with the ever changing technology so that they can ensure that the system can withstand anything that comes about. Down below I will discuss briefly the various aspects of the SLDC and the tasks that can be completed to help solve certain common problems that exist from within. Customer data management is not high on many organizations' lists of priorities until it has to be. The term used in systems engineering, information systems and software engineering to describe a process for planning, creating, testing, and deploying an information system is called Systems development life cycle (SDLC). This term is also referred to as the application development life-cycle, which is a term used in systems engineering, information systems and software engineering to describe a process for planning, creating, testing, and deploying an information system. The task of optimizing the software development process has faced many obstacles. The main obstacle is a lack of accurate and complete data on the development process. The use of the......

Words: 2352 - Pages: 10

Premium Essay

Clarifying Business Strategy Through Database Analysis

...|Title |IT205 Smart Scenario - Clarifying Business Strategy Through Database Analysis | |Event Coordinator | |What are the current problems that the Event Coordinator is having? (multiple choice, multi-select) | | | |☐  System is disconnected from other departments. | |☑  Too much manual intervention in the business process. | |☐  Required information is not always available. | |☐  Information retention is inefficient or non-existent. | |☐  Poor use of available information technology resources. | |☑  Insufficient use of database technology or tools. | |☐  Poor communication. ...

Words: 861 - Pages: 4

Premium Essay

Databases

...Examples of database and table creation The following examples use the create keyword to create the sample staff database and define the tables. These example OQL statements illustrate the use of the column constraints and the default keyword. Example 1 create database staff; // creates the staff database The following insert defines the managers table. create table staff.managers ( EmployeeID int NOT NULL PRIMARY KEY, Name text NOT NULL, Department text default "Sales", Gender text, Age int, unique ( EmployeeID ) // indicates that the data in the // EmployeeID column must be unique. ); For the managers table: • The EmployeeID and Name columns cannot be NULL. • The EmployeeID column is the primary key and must be unique. • If no value is inserted into the Department column for a given record it takes the value "Sales". Example 2 The following insert creates the staff.employees table. create table staff.employees ( EmployeeID int NOT NULL PRIMARY KEY, Name text NOT NULL, Skills list type text, Gender text, Age int // There is no comma here because this ...

Words: 978 - Pages: 4