Oracle Database Tips by Donald Burleson

Oracle10g Grid Computing with RAC
Chapter 6 - Install, Configure and Database Creation

Database Creation Manually

The SYSAUX tablespace is required in all new 10g databases. Only the SYSAUX tablespace data file location is specified. Oracle specifies the remainder of the tablespace properties including:

• online
   

• permanent
   

• read write
   

• extent management local
   

• segment space management auto

If a datafile is specified for the SYSTEM tablespace, then one must be specified for the SYSAUX tablespace as well. If one is not specified, then the CREATE DATABASE command will fail. The only exception is for an Oracle Managed File system. During any update of a database to Oracle Database 10g, a SYSAUX

tablespace must be created or the upgrade will fail. The SYSAUX tablespace has the same security profile as the SYSTEM tablespace. However, loss of the SYSAUX tablespace will not result in a database crash, only the functional loss of the schemas it contains.