Creating a User Account Suppose you want to create a user account for a database application developer named Nick. Because Nick is a developer, you want to grant him the database privileges and roles that he requires to build and test his applications. You also want to give Nick a 10 MB quota on...
Creating and Managing a Database with DBCA Unless you specified that only the Oracle Database software should be installed, Oracle Universal Installer automatically runs Database Configuration Assistant (DBCA) after software installation...
Creation Mode This window enables you to create a database with default configuration or to use Advanced Mode to create a database. If you choose Advanced Mode, you can customize storage locations, initialization parameters, management options, database options, and different passwords for Admi...
Cross-Checking Backups Cross-checking a backup synchronizes the physical reality of backups with their logical records in the RMAN repository. For example, if a backup on disk was deleted with an operating system command, then a cross-check detects this condition. After the cross-check, the RMAN...
Current ADDM Findings If there are Real-Time ADDM findings for the past 5 minutes, these are listed on the Current ADDM Findings tab in the Performance Hub when both of the following are true: ■ Real-Time Data - Last Hour is selected in the...
Database Backup and Recovery Concepts To back up your database means to make copies of your data files, control file, and archived redo log files (if your database runs in ARCHIVELOG mode). Restoring a database means copying the physical files ...
Database Identification In the Global Database Name field, enter the database name in the form database_ name.domain_name. In the SID field, enter the system identifier. The SID defaults to the database name and uniquely identifies the instance that runs the database. If you enable the Create a...
Database Identifiers These options include your global database name and system identifier (SID). The SID is a unique identifier that is used to distinguish this instance from other Oracle Database instances that you may create later and run concurrently on your system. The global database name ...
Database Options This window includes the Sample Schemas tab and the Database Vault & Label Security tab. On the Sample Schemas tab, you can specify for the sample schemas to be created in your database, and for custom SQL scripts to be run after database creation: ■ Sample Schemas—Select S...
Database Releases Supported by DBUA If the release number of your current Oracle Database appears in the following list, you can use DBUA to perform a direct upgrade of your database to Orac...
