Oracle Net Listener Configuration On the database host, the Oracle Net listener (the listener), is a process that listens for client connection requests. It receives incoming client connection requests and manages the traffic of these requests to the database server. The default listener configu...
Overview of Database Backup and Recovery The focus in Oracle Database backup and recovery is on the physical backup of database files, which permits you to reconstruct your database. RMAN, a command-line tool, is the method preferred by ...
Overview of the Oracle Instance and Instance Management An Oracle database system consists of an Oracle database and an Oracle instance (in an Oracle Real Application Clusters environment, there can be more than one instance). A database co...
Partitioned Tables and Indexes You can partition tables and indexes. Partitioning helps to support very large tables and indexes by enabling you to divide the tables and indexes into smaller and more manageable pieces called partitions. SQL queries and DML statements do not have to be modified to...
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...
