Uh-oh, it looks like your Internet Explorer is out of date.

For a better shopping experience, please upgrade now.

Oracle8 to 8i Upgrade Exam Cram

Oracle8 to 8i Upgrade Exam Cram

3.0 1
by Robert G. Freeman, Charles Pack
Covers the published objectives for the Oracle 8i: New Features for Administrators exam. Contains key terms and acronyms an Oracle 8i Certified DBA is expected to know to pass the exam.


Covers the published objectives for the Oracle 8i: New Features for Administrators exam. Contains key terms and acronyms an Oracle 8i Certified DBA is expected to know to pass the exam.

Product Details

Coriolis Group
Publication date:
Exam Cram 2 Series
Product dimensions:
5.99(w) x 8.98(h) x 1.00(d)

Related Subjects

Read an Excerpt

Chapter 2: Installing, Configuring, and Migrating to Oracle8i

Terms you'll need to understand:
  • Universal Installer
  • Silent-mode installation
  • Database Configuration Assistant
  • Oracle Software Packager
  • Migration
  • Upgrade
  • Data Migration Assistant
Techniques you'll need to master:
  • Using the features of the Universal Installer
  • Performing a silent-mode installation
  • Describing how the installer uses Oracle Optimal Flexible Architecture (OFA)
  • Knowing and understanding the features of the Database Configuration Assistant
  • Migrating and upgrading databases to Oracle8i
This chapter deals with the many changes that have been made to the Oracle8i installation process and with what you'll be expected to know about it in the Oracle8i Oracle Certified Professional (OCP) Upgrade exam. Oracle has introduced a whole new installer for 8i-we will discuss this installer, including its new features, in this chapter. We will also review the new features of the Database Configuration Assistant and the Oracle Software Packager as we cover these areas. Finally, the methods of migrating or upgrading previous Oracle database versions to Oracle8i will also be discussed, as will configuration issues related to migrating or upgrading to Oracle8i.

The Oracle Universal Installer

In previous versions of Oracle, a character-based installer was available on Unix platforms (among others), and a graphical-based installer was available for Windows platforms. For Oracle8i, Oracle decided to standardize on one single software installer package called the Oracle Universal Installer.

Based on Java, the Oracle Universal Installer provides a common graphical front end for Oracle8i Relational Database Management System (RDBMS) software installations, as well as installations of products packaged by the Oracle Software Packager. (For details, see "Oracle Software Packager" later in this chapter.) As a result of the introduction of the Universal Installer, the character-based installation program that you might be more familiar with is no longer available. Because the method of running the Universal Installer is different for each platform, refer to the Oracle8i Installation Manual for more information regarding your specific platform type.

The features of the Oracle Universal Installer include the following:

  • The Universal Installer provides a common interface for all Oracle RDBMS installations.
  • Automatic dependency resolution is supported.
  • Support for multiple ORACLE_HOME locations is provided.
  • Silent-mode installs are supported (see details later in this chapter).
  • Through the Oracle Software Packager, customized installation routines of additional, third-party products are supported as well. (For more details, see the section on the Oracle Software Packager later in this chapter.)
Note: Support for multiple CDs and compression is expected in a later release.

Be certain to concentrate heavily on the common elements of the Universal Installer. Although it's important to know about platform-specific issues, you don't need to worry about them for the exam.

Because the Universal Installer is Java based, you have to run the server installation from a Java-based client. An alternative to the client-based graphical installation program is the use of the silent-mode installation. The silent-mode installation uses a response file that contains all the information the installer needs to provide an automated installation on the Oracle RDBMS software without any user interaction. In this section, we'll look at Universal Installer first. Following that, we'll look at the silent-mode method of installing the RDBMS software, and finally, we'll do example installs using both methods.

Installing the Oracle RDBMS Software with the Universal Installer

As noted before, the Universal Installer is a Java-based product and therefore requires the use of the Java Runtime Environment (JRE). Several tools are available that can provide the JRE if you are doing, for example, a Unix installation on an NT client. The screen captures you'll see in this chapter were generated on a Windows NT PC using ReflectionX. The Oracle RDBMS installation was done on a Sun Solaris machine.

Note: Following are the names of the programs that you'll want to use to start the Universal Installer. On NT, it's simply setup.exe, located in the \install\win32 directory of the CD-ROM from which you are installing. On Unix, it's RunInstaller, which is in the root directory of the 8.1.5 CD.

The Universal Installer has a point-and-click interface and is very user friendly. Figure 2.1 provides an example of the look and feel of the Universal Installer. As you can see from the figure, the Installer is a graphical application with almost a wizard feel to it. Also, at the bottom of the figure, note that the Installer indicates where it's keeping a log of the installation processes. It's a good idea to note the location of this log file for future reference should some problem with the installed database software appear later.

The installation process itself remains generally the same as it was in previous versions of Oracle with the character-based installer. You identify the ORACLE_HOME and ORACLE_BASE locations either by setting the correct environment variables or after opening the Installer itself. The Installer then leads you through the various steps of the installation, giving you the option of loading the server software, loading the client software, or selecting the specific software you wish to load through a custom installation. When you use the Universal Installer, you might also have the option to create a starter database, depending on which installation configuration you select. If you choose this option, then the Installer will start the Oracle Database Configuration Assistant along with the NET8 Configuration Assistant after the RDBMS software has been installed.

Oracle8i requires its own ORACLE_HOME directory, and you cannot install the software over any existing version of Oracle. Thus, if you are low on available hard-drive space, you'll have to remove the previous version of the Oracle RDBMS before you can install Oracle8i. You can, of course, load Oracle8i into its own ORACLE_HOME directory, separate from any other ORACLE_HOME directory, if you have the space available. This allows you to run one database in Oracle8i and other databases on different versions of the RDBMS software at the same time.

Installing the Oracle RDBMS Software with the Silent-Mode Installer

Sometimes you might want to use the Oracle Universal Installer (to install the Oracle RDBMS database software on a group of networked servers, for example) without requiring a user response to any prompts and without needing to use the graphical capabilities of the universal installer. This is a case when you might consider using the silent-mode installation method supported by the Universal Installer. Note that on Unix, although the installation itself is silent, the installer still requires an Xwindows connection to the client, even if the Installer is running in silent mode. Of course, this isn't an issue if you're using the Installer on NT.

When doing a silent-mode installation of the Oracle RDBMS software, you use a response file (see Listing 2.1) that will be used by the Universal Installer in silent mode. The response file provides the information that the Universal Installer needs to properly install the RDBMS software. Before you do the silent-mode installation, you modify the response file so that the settings, such as ORACLE_HOME, reflect the settings you want the Installer to use.

Listing 2.1 Example of response file used to do a silent-mode installation....

Meet the Author

Robert Freeman (Enid, OK), is a certified Oracle8i DBA. He has worked with Oracle products for almost 20 years, most recently as a consultant IDS Corporation in Florida, where he is working as a database administrator. Robert was the author of the Oracle 7.3 to 8 Upgrade Exam Cram.

Charles Pack (Oklahoma City, OK) has over 15 years computer experience. He is Oracle7 and 8 certified. He is currently a database administrator with CSX in Jacksonville, Florida.

Customer Reviews

Average Review:

Post to your social network


Most Helpful Customer Reviews

See all customer reviews

Oracle8 to 8i Upgrade Exam Cram 3 out of 5 based on 0 ratings. 1 reviews.
Guest More than 1 year ago
I use this book to pass 1Z0-020 (score 40 of 54) today. This book just is OK because the exam updated after the book published. If you only use this book, 10-15 questions will not be answered clearly in the exam. Some topics such as parallel_adaptive_multi_user, composite partitioned indexes, temporary lob, and so on are not covered in the book. Some topics are not deep enough such as if a listener is not available when client try to connect server using loading balance and failover, where client look for listener. So if you use this book, you have to totally understand knowledge covered in the book and very closely pass the exam.