第10次和第11次：Section0, 2014-08-25和2014-08-27

botang

第10次：Section0, 2014-08-25



Section0



Notes:

1. This very web page only be avaliable in your “ODD machine” and the first “RAC machine”. It should be opened by firefox web browser.

2. Accessing machines other than your “ODD machine”, your “EVEN machine” and your two “RAC machines” is strictly prohibited, hence will be considered as a serious cheating event.

3. Oracle user's password is “oracle”. Use sudo, when you want to run program with supper user's privilege. You CAN NOT login all of the operating systems with root account.  

4. All of the software files locate in “/stage”.

5. All of the document files locate in “/home/oracle/doc”.

6. DO NOT remove entries of “/root/.ssh/authorized_keys” of all of the machines, but you can add entries you want.

7. DO NOT change any other settings of all of the operating systems.

8. Section0 will not be scored.



Topics:

1. Create a database, the sid name of the database is “PROD”.

2. At the time you create it, all of the database files should reside on “/u01/app/oracle/oradata/PROD”.

2.1 You should have at lease 3 controlfiles reside in '/u01/app/oracle/oradata/PROD/Disk1', '/u01/app/oracle/oradata/PROD/Disk2' and '/u01/app/oracle/oradata/PROD/Disk3' respectively.

        2.2 System tablespace should reside on '/u01/app/oracle/oradata/PROD/Disk1'.

2.3 Sysaux tablespace should reside on '/u01/app/oracle/oradata/PROD/Disk2'.

2.4 Undo tablespace should reside on '/u01/app/oracle/oradata/PROD/Disk3'.

2.5 Temporary tablespace should reside on '/u01/app/oracle/oradata/PROD/Disk5'.

        2.6 With at lease 3 redo logfile groups reside on '/u01/app/oracle/oradata/PROD/Disk1',

'/u01/app/oracle/oradata/PROD/Disk2' and '/u01/app/oracle/oradata/PROD/Disk3' respectively.

3. Run the minimum required scripts to complete the basic configuration of PROD database.

4. All datafiles and tempfiles can autoextend automatically.

crazy_gh

没有附件？