Databases Reference
In-Depth Information
Database credentials
This option allows you to define the password for SYS and SYSTEM users, and if you
have chosen to configure DB Control Console, then you can specify the password
for SYSMAN and DBSNMP. You can choose to define the same password for all
users or a different password for each one of them. It is advisable to take note of the
password set at this stage; it may be required in the future if you want to reconfigure
the Enterprise Manager DB Console. SYSMAN and DBSNMP users are particularly
important to properly set up the Enterprise Manager repository, these users will be
further explained in the EMCA chapter.
Storage options
When creating a database you can choose which storage method to use. They can be
File System,
ASM
, or Raw Devices. ASM is a storage method that requires an ASM
instance to already exist. ASM has been available since 10.1.0 and it is a simplified
database storage method that optimizes I/O performance and simplifies datafile
management. A database can use any storage option or it can combine the three of
them. This screen only defines the initial storage method used by the database and
the DBA can later change or combine it.
The File System is the most commonly used storage option, it requires a regular file
system, and it utilizes the OS buffer cache and block mode devices. The Raw devices
option doesn't use OS resources to access the database files, it lets Oracle directly
manage the access to the unformatted device. ASM is the Oracle storage option that
has been increasingly gaining popularity among DBA's, as it is simple and combines
the best characteristics of raw devices and file system options.
Database file locations
The location of database files can be taken from the template (
F
), or you can choose
to define a common file location for all your files (
G
); a third option is that you can
choose the
Oracle-Managed Files
(
OMF
) (
H
), this configures the
db_create_file_
dest
instance parameter, allowing Oracle to set the file names. The file location
variables used during this procedure can be seen by clicking on the
File Location
button (
I
).
Search WWH ::
Custom Search