1.0.0.0
diagnostic_dest=/u01/app/oracle
memory_target=422576128
###########################################
# Processes and Sessions
###########################################
processes=150
Appendix: Installation and Configuration 651
###########################################
# Security and Auditing
###########################################
audit_file_dest=/u01/app/oracle/admin/dw/adump
audit_trail=db
remote_login_passwordfile=EXCLUSIVE
5. Connect to the instance using SQL*Plus, as show here:
sqlplus /nolog
connect SYS/password as sysdba
Note that while the instance itself exists, there is not much that we can do with it because
we have not started the database yet.
6. Create a server parameter file (SPFILE). If the initialization file is in the default location,
this command will create the SPFILE:
create spfile from pfile;
7. Start the instance using the following command:
startup nomount
Note that because we do not have a database created yet, this is the only option we can
use with the startup command.
8. Issue the create database statement. Here is an example:
CREATE DATABASE dw
USER SYS IDENTIFIED BY clarkson404
USER SYSTEM IDENTIFIED BY kelly68
LOGFILE GROUP 1 ('/u02/oracle11g/oradata/dw/redo01.log') SIZE 100M,
GROUP 2 ('/u04/oracle11g/oradata/dw/redo02.log') SIZE 100M,
GROUP 3 ('/u06/oracle11g/oradata/dw/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/u01/oracle11g/oradata/dw/system01.
Pages:
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955