donderdag 22 maart 2012

Create the database using DBCA

Set the ORACLE_HOME, ORACLE_BASE and PATH environment variables:

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_home1
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_BASE=/u01/app/oracle


Create the directories for the datafiles:
[root@ORAVM1 ~]# mkdir -p /u02/oradata/ocmdb1
[root@ORAVM1 ~]# mkdir -p /u03/oradata/ocmdb1
[root@ORAVM1 ~]# chown -R oracle:oinstall /u02/oradata/ocmdb1
[root@ORAVM1 ~]# chown -R oracle:oinstall /u03/oradata/ocmdb1
[root@ORAVM1 ~]# chmod -R 775 /u02/oradata/ocmdb1
[root@ORAVM1 ~]# chmod -R 775 /u03/oradata/ocmdb1

Launch dbca:
[oracle@ORAVM1 ~]$ dbca

Click Next in the first screen:

image

image

image

image

image

Either configure the listener first using netca, or untick “Configure Enterprise Manager”, and configure it after the installation.

Run netca in a different terminal window:
[oracle@ORAVM1 ~]$ netca
 image

image

image
image

image


image

Click Finish to exit netca.

Continue with the dbca session:
image

image

Choose File System or ASM:

image

image 

image

image

image

image
image

Choose Unicode as character set:

image

image

Make sure that the control files are spread over 3 separate disk groups:

image

 

image

The redo logs should be mirrored, and the members of each redo group placed in 2 different disk groups:

image

 

image

image 

image

Geen opmerkingen:

Een reactie posten