This assignment is using Oracle Database KBR Corporation contacts you, the DBA t
ID: 3682303 • Letter: T
Question
This assignment is using Oracle Database
KBR Corporation contacts you, the DBA to come up with a script to create database named mynewdb. Write your actions you perform for the following steps to make the database creation process transparent. As a part of this process, you will be required to provide the script to create the database. Step 1: Specify an Instance Identifier (SID) Step 2: Ensure That the Required Environment Variables Are Set Step 3: Choose a Database Administrator Authentication Method Step 4: Create the Initialization Parameter File Step 5: (Windows Only) Create an Instance Step 6: Connect to the Instance Step 7: Create a Server Parameter File Step 8: Start the Instance Step 9: Issue the CREATE DATABASE Statement Step 10: Create Additional Tablespace and Run Scripts to Build Data Dictionary Views Final Step: Provide the script. Grading Rubric Project Requirement Criteria Weight CREATE DATABASE SCRIPT This script must have everything included about all 10 steps you perform 50 Documents with Steps you perform Description of each step you perform 40 Spelling, Grammar, Professional Formatting 10 Total 100
Explanation / Answer
1.set ORACLE_SID=mynewdb
2. Automatic
3. Automatic
4.
db_name='ORCL'
memory_target=1G
processes = 150
db_block_size=8192
db_domain=''
db_recovery_file_dest='<ORACLE_BASE>/flash_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='<ORACLE_BASE>'
dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
# You may want to ensure that control files are created on separate physical
# devices
control_files = (ora_control1, ora_control2)
compatible ='12.0.0'
5.
DB_NAME = test
DB_DOMAIN = us.example.com
6.
7.
8.
CREATE SPFILE FROM PFILE='/u01/oracle/dbs/init.ora';
9.
CREATEDATABASE mynewdb;