A brief description of the organization.
Identify the major changes, including the main reason for the transformation in this section.
July 25, 2020Identify the circumstances surrounding each issue; classify the circumstances; attribute the importance of each classification; and test the accuracy
July 25, 2020A brief description of the organization.
You are the Senior Database Administrator of one of the following organizations:
Hardware StoreUpper management has decided they want to upgrade their old database software to the latest and greatest Oracle 12c Database! You are delighted, until you find out; its all on your shoulders. Your task for this course project is to develop an upgrade document that will provide the following information to your team:A brief description of the organization.
A brief description of the server environment (how many servers, disk sizes, networks, OS types)
A description of the current database software being utilized by the organization
A brief (very high-level) Entity Relationship Diagram of the database being used.
New Server requirements if any. (memory, disks, numbers of, etc.)
Describe the Oracle Software file structure you wish to use. You may use OFA, or not. But identify where all the files (dbf, ctl, ora, etc.) will go on the servers. If you dont use OFA, then support your decisions.
Define the tablespaces and provide create tablespace statements for the new system.
Ensure you provide backup and recovery schedules for the upgrade
Provide general steps to perform the upgrade. Include a high level flowchart. Do not get too detailed or you will be writing a 100 page document!
