Contents → Title and Copyright Information Send Us Your Comments Preface Audience Documentation Accessibility Structure Related Documentation Conventions 1 Introduction About this Book What this Book is Not How to Use this Book with Related Material The Oracle Database Common Oracle DBA Tasks Tools for Administering the Database 2 Installing Oracle and Building the Database Overview of Installation Checking
day (IN) → Day value.
day (OUT) → Day value returned.
day (IN) → First day of week named by this is returned.
day (IN) → Day value to be set.
Managing Standalone Subprograms → Procedures and functions do not have to belong to a package. Program units that are created outside of a package are called standalone subprograms. You can use Enterprise Manager to create, modify, compile, and delete standalone subprograms just like packaged subprograms except that they do not have a parent package (and, consequently, no navigation path in Enterprise Manager from or to the package
Overview of Oracle Backup and Recovery → The focus in Oracle backup and recovery is generally on the physical backup of database files, which permit the full reconstruction of your database. The files protected by the backup and recovery facilities built into Enterprise Manager include datafiles, control files, server parameter files (SPFILEs), and archived redo log files. With these your database can be reconstructed. The backup mechanisms
Setting Preferred Credentials → You can have Enterprise Manager automatically fill in host and database login credentials for you, such as when you schedule jobs and tasks to perform administrative operations like backup and recovery. For security, Oracle stores preferred credentials in encrypted mode. To set preferred credentials for the database, do the following: From the home page, click Preferences at the top of the page. The
Installation Choices → The Oracle Universal Installer guides you through an interview phase that asks you to specify your choices for installation and database creation. The exact sequence of steps depends on your operating system. The installation choices you can make are divided into basic and advanced. During a Windows basic installation, you need only make basic choices. For all other cases, including Windows advanced
Loading Data Into Tables → You can use Enterprise Manager to load data into tables in batch. Batch loading is useful when you have a lot of data. You can load data from operating system files or from other databases. You can also export data into files. For loading data with Enterprise Manager, one method is to use control (.ctl) and data (.dat) files. These files are formatted as standard S QL*Loader files. The following example
Upgrading the Database Using the Database Upgrade Assistant → by Example (OBE) has a series on the Oracle 2 Day DBA book. This OBE steps you through the tasks in
Navigational Features → Navigational features of Oracle Enterprise Manager include the following: Property pages on each home page help you organize management tasks into distinct categories; for example, click Maintenance to perform tasks associated with backing up and maintaining your data. Figure 3-1 Database Home Page Navigational Property Pages Description of the illustration hp-propertypages.gif Drill down links that
6 Managing Database Storage Structures → This chapter discusses using Enterprise Manager to explore and manage the storage structures of your database. This chapter contains the following topics: Exploring the Storage Structure of Your Database Common DBA Tasks for Managing Database Storage Managing Undo for Your Database Making Changes to the Database Storage Structure Storage: Oracle by Example Series
Control File → A control file tracks the physical components of the database and other control information. It is essential to the functioning of the database. Because of this, Oracle recommends that the control file be multiplexed. In other words, it should have multiple identical copies. For databases created using DBCA, three copies of the control file are automatically created. If any control file fails, then
Managing Tables → Tables are the basic unit of data storage in an Oracle database. They hold all user-accessible data. Each table has columns and rows. In an employee table, for example, there can be (vertical) columns called employee and employee number. Each (horizontal) row in the table would contain a value for employee and employee number.
Starting DBCA → During installation, you can create and configure a new database. If you have already done so, you do not need to read this section and can skip to the next chapter. However, if you choose to install software only and later create a database, or if you want to create additional databases using the release software that you just installed, you can do so by using the Database Configuration Assistant
Starting i SQL*Plus → i SQL*Plus is the Web version of SQL*Plus. Before you can connect to it with a URL, you must start the i SQL*Plus application server. To do so, enter the following at the command line: isqlplusctl start After the server is started, you can connect to i SQL*Plus with a URL such as http://machine_name:5560/isqlplus Alternatively, you can connect to i SQL*Plus using Enterprise Manger. To do so from the
Starting and Shutting Down the Listener → The Oracle listener is set up to start automatically whenever your server machine is restarted. However, when your system encounters unforeseen circumstances, or when you have manually stopped the listener, you can restart it at the command line. To do so, use the following: lsnrctl start You can use Enterprise Manager to stop the listener. To do so, navigate to the Listener: listener_name page by
Viewing Tables → To view a table, click Tables on the Administration page of Enterprise Manager. The Tables property page appears as in Figure 8-3. Figure 8-3 Tables Property Page Description of the illustration tables.gif Initially, you see the tables for the schema that you are logged into. To see tables in other schemas, click the flashlight adjacent to the Schema box to select another schema, then click Go to
10 Monitoring and Tuning the Database → Monitoring the health of a database and ensuring that it performs optimally is an important task for a database administrator. This chapter discusses the features and functionality included in Oracle Database that make it easy to proactively monitor database health, identify performance problems, and implement any corrective actions. The following topics are covered: Proactive Database Monitoring