Oracle8i Certified Professional Dbo Certification Exam Guide (Book/CD-ROM Package)

Oracle8i Certified Professional Dbo Certification Exam Guide (Book/CD-ROM Package)

by Jason S. Couchman
     
 

Featuring a logical methodology designed to reinforce your learning experience,this guide offers study aids to help you earn your OCP DBO credential.

Get certified with official exam prep material from Oracle Press.

The new Oracle Certified Professional (OCP) Database Operator (DOB) designation is proof of your ability to successfully perform operational and

See more details below

Overview

Featuring a logical methodology designed to reinforce your learning experience,this guide offers study aids to help you earn your OCP DBO credential.

Get certified with official exam prep material from Oracle Press.

The new Oracle Certified Professional (OCP) Database Operator (DOB) designation is proof of your ability to successfully perform operational and administrative tasks on an Oracle database. Oracle DBOs provide valuable support to Database Administrators (DBAs) in the everyday management of the database.

Certify your skills and demonstrate your expertise by earning your OCP DBO credential—with help from this Oracle-authorized exam guide. The book provides full coverage of the Oracle DBO certification exams,including complete details on Oracle8i.

Featuring a logical methodology designed to reinforce your learning experience,this guide offers the following study aids:

  • Tips,examples,and exercises to help you remember key concepts

  • Two-minute drills—quick and concise checklists that summarize a chapter's main points

  • Perfect for last-minute review

  • Chapter self-tests—chapter specific questions similar to those found on the exam with detailed answers to each question

  • Comprehensive coverage of Oracle-designated exam objectives,including Oracle database configuration,database software installation,data loading,SQL and DDL,backups,Oracle8i,and much more

  • Interactive exam on CD that enables you to hotlink directly to the relevant part of the electronic book

Make a smart career move and begin enjoying all the rewards of OCP DBO certification. This officially endorsed study guide offers acomplete preparation system geared to help you pass your exams with flying colors!

Read More

Product Details

ISBN-13:
9780072123616
Publisher:
McGraw-Hill Professional
Publication date:
02/01/2000
Series:
Oracle Press Series
Edition description:
BK&CD ROM
Pages:
543
Product dimensions:
7.63(w) x 9.44(h) x 1.85(d)

Related Subjects

Read an Excerpt

Chapter 3: Networking and Database Availability

In this chapter, you will cover the following topics related to Oracle networking and database availability:

  • Oracle networking and OEM configuration
  • Startup and shutdown of Oracle databases
Oracle databases are meant to be used. In most organizations, this fact means that the Oracle database must be available to many users across a local area network. It also means that the database must be created, the instance must be running, and that users can connect to it. This chapter will teach you how to accomplish all three with Oracle running on Windows environments. By the end of it, you will be able to identify the purpose of and configure various Oracle networking files. You will also be able to use Enterprise Manager to open and close your Oracle database, and store your initialization parameters normally found in the initsid. ora file in Instance Manager instead.

Oracle Networking and OEM Configuration

This section covers the following topics on Oracle networking and OEM configuration:

  • Purpose and structure of Net8
  • Net8 files for configuration
  • Generating Net8 files with Net8 Assistant
  • Creating the OEM repository
  • Using OEM console navigator
The discussions in this section will explain the purpose and structure of Net8. You will learn the basics of how Oracle connects clients to the database server using Net8. You will also learn how to configure it using key configuration files on both client and server. The special purpose of Net8 Assistant for automatic generation of these files will also be explained. Recall in Chapter 2 that you learned how to install OracleEnterprise Manager. Well, in reality, you were only shown half the installation. The other half is learning how to create the repository of tables in Oracle that OEM uses to operate normally. This section will explain how to create that OEM repository. Finally, you will learn more about the OEM console navigator, and what it allows you to do. The purpose of a special piece of software called the Intelligent Agent, which resides on the server side to assist in OEM console tasks, will be covered as well.

Purpose and Structure of Net8

Whatever your network, Net8 can help you connect your users to the Oracle database. There are versions of Net8 that run on TCP/IP, DECnet, IPX, and many other LAN or WAN products. Moreover, it is possible for Net8 to handle users on multiple networks attempting to connect to the same Oracle database. Networked computing has seen three distinct trends in the last 40 years of organizational use of computers:

  • Mainframe computing Paradigm that uses mainframe computers to solve business problems. Mainframes feature powerful processing capacity at high speeds but have the drawbacks of unwieldy interfaces, complex programming, and inflexibility for changing business requirements.
  • Client/server computing Paradigm that uses personal computers and servers, each running their own software, to solve business problems. Advantages include great looking user interfaces and flexibility for changing business needs, but has the drawback of slow operation and distributed data storage that require synchronization activity to guarantee data reliability.
  • Internet computing Paradigm that uses servers and personal computers, each running their own software, to solve business problems. The differentiating characteristic of PC software in this case is the use of Web browser technology as a universal client. Advantages include centralized storage of data, fast user processing times, great looking user interfaces, and simplified choice process for client software. Disadvantages include security (perceived or real) and dependence on network availabi I ity for operation.
Benefits of Net8 for Client/Server and Internet Computing

Net8 is Oracle's networking software that allows both Internet computing and client/server architecture to be used in your database applications. The key component of Net8 includes database name and location resolution, locally or with an Oracle Names server. Net8 does not, however, do any hostname resolution. The resolution of a name you have given to a server to its network IP address; Net8 counts on the underlying network to handle that. Thus, Net8's basic purpose includes communication of user requests from client to server. Note the use of communication-not transport—in that description. Net8 is not a stand-alone networking protocol. In other words, if you aren't using TCP/IP, DECnet, IPX, or some other networking protocol already, Net8 alone won't make all your computers magically start talking to one another. Net8 simply runs over the top of an existing network to make all the Oracle-related components talk to each other, using something called the Transparent Network Substrate, or TNS, to form ,,connections between clients and servers. TNS allows Net8 to communicate with...

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >