Trent King CIT 472 - HW 4 (100 points) (DB Creation)

.docx

School

University of Phoenix *

*We aren’t endorsed by this school

Course

0102

Subject

Computer Science

Date

May 4, 2024

Type

docx

Pages

3

Uploaded by ProfWillpower13160 on coursehero.com

Trent King 2/16/2024 CIT 472 - HW 4 (100 points) (DB Creation) In my CIT 472 course, I embarked on a practical journey to create an Oracle database using the Database Configuration Assistant. This lab aimed to bridge the gap between theoretical knowledge and practical application, focusing on Oracle's intricate database creation process. It was designed to enhance my skills in developing, testing, and deploying databases efficiently, an essential competency for any database administrator. 1) 10pts. What directory contains the database creation scripts? The directory containing the database creation scripts is $ORACLE_BASE/admin/cit1/scripts. (2) 10pts. List all file from this directory (and only those from this directory) in the order they are used/executed upon database creation. (The first one to list is the “parameter file”. Your textbook can help you determine which file is the parameter file and which file executes first.) The files from the $ORACLE_BASE/admin/cit1/scripts directory, listed in the order they are used for database creation, are: The parameter file, known as init.ora, is the first to be used. Following the parameter file, CreateDB.sql is executed to create the database. After the database is created, CreateDBFiles.sql is run to set up the necessary database files. postDBCreation.sql is then executed for final configuration steps post-database creation. Lastly, the script cit1.bat or cit1.sh is used to initialize the Oracle instance as a service and start it up. (3) 5pts. In the parameter file (init.ora), what is the value of the “control_files” parameter? The "control_files" parameter in the init.ora file is set to: ("$ORACLE_BASE/oradata/cit1/control01.ctl", "$ORACLE_BASE/oradata/cit1/control02.ctl", "$ORACLE_BASE/oradata/cit1/control03.ctl"). (4) 5pts. In cit1.bat, what does the “oradim.exe” do? The oradim.exe command within cit1.bat is utilized to create a new Oracle Database service for the instance, enabling it to start automatically with Windows. (5) 15 pts. In cit1.sql,
i. What two accounts does the script prompt for passwords? The script prompts for passwords for the SYS and SYSTEM accounts. ii. What does the “orapwd.exe” do? The orapwd.exe utility is used to create or modify the Oracle Database password file, allowing for authentication of privileged users when the instance starts. (6) 25pts. In CreateDB.sql, i. What is the path to the first DATAFILE created? How big is this file? (You can verify this value by finding the file on the filesystem.) The first datafile created was for the SYSTEM tablespace, located at $ORACLE_BASE/oradata/cit1/system01.dbf, with a size of 700MB. ii. What is the path to the second DATAFILE created? How big is this file? The second datafile, for the SYSAUX tablespace, was set up at $ORACLE_BASE/oradata/cit1/sysaux01.dbf, also sized at 700MB. iii. What is the path to the “tempfile” for the TEMP tablespace? How big is this file? The tempfile for the TEMP tablespace was created at $ORACLE_BASE/oradata/cit1/temp01.dbf, with a file size of 100MB. iv. What is the path to the datafile for the UNDO tablespace? How big is this file? The UNDO tablespace datafile found its place at $ORACLE_BASE/oradata/cit1/undo01.dbf, with a size allocation of 200MB. v. How many LOGFILE GROUPs are created? How many files in each group? What is the path to the directory containing those files? How big are those file? Regarding LOGFILE GROUPs, two groups were created, each containing a single file. These files were stored within $ORACLE_BASE/oradata/cit1/, each sized at 50MB, named respectively to reflect their grouping, indicating a structured and organized approach to database logging and data integrity.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
SEE MORE TEXTBOOKS