Password File A database can use a password file to authenticate administrative users with SYSDBA, SYSOPER, and SYSBACKUP privileges. A password file is required for remote connections to the database with any of these privileges. These privileges enable a DBA to start and shut down the database...
Performing Backup and Recovery This chapter introduces you to Oracle Database backup and recovery with Oracle Recovery Manager (RMAN). After reading this chapter, you should be familiar...
Performing Oracle Advised Recovery The Oracle advised recovery feature uses Data Recovery Advisor, which is an Oracle Database feature that automatically diagnoses data failures, determines and...
Pre Upgrade Checks DBUA does not begin the upgrade until it completes all of the following pre-upgrade steps: ■ Checks for any invalid user accounts or roles ■ Checks for any invalid data types or invalid objects ■ Checks for any desupported c...
Predefined User Accounts In addition to the user accounts that you create, the database includes several user accounts that are automatically created upon installation. All databases include the administrative accounts SYS, SYSTEM, SYSMAN, and DBSNMP. Administrative accounts are highly privilege...
Proactive Database Monitoring Oracle Database makes it easy to monitor the health and performance of your database. It monitors the vital signs (or metrics) related to database health and performance, analyzes the workload running against the database, and automatically identifies any issues tha...
Program Global Area A Program Global Area (PGA) is a memory region that contains data and control information for a server process. It is nonshared memory created by Oracle Database when...
Real Time ADDM Real-Time ADDM automatically monitors the database in real time. Real-Time ADDM proactively detects and diagnoses transient high impact problems such as these before they threaten application performance: ■ High CPU ■ I/O sp...
Related Documentation For more information, see these Oracle resources: ■ Oracle Database Administrator's Guide xiv ■ Oracle Database Concepts ■ Oracle Database Net Services Administrator's Guide ■ Oracle Database SQL Language Referen...
Removing Oracle Database Software If you want to remove an Oracle software installation, you can use the deinstallation tool to completely uninstall the software from your computer. Starting with Oracle Database 12c, the deinstallation t...
