[Laskey99] Section 5.5. Oracle Network Manager

来源:百度文库 编辑:神马文学网 时间:2024/05/17 06:56:20

5.5. Oracle Network Manager

The Oracle Network Manager is apoorly named tool; it does not perform network management at all.Rather, it is a tool provided by Oracle to configure the variouscomponents of Oracle's networking software.

Oracle networks can be very complex, often with servers running onvarious operating systems, and with multiple network topologiesrunning different protocols and frequently utilizing WAN technologiesto implement geographically dispersed networks. In such complexnetworks, change is often the norm, and since detailed informationabout the composition of most components of the network must be madeavailable to Oracle products in various parameter files, it would bedifficult indeed to keep all network parameter files up to date.

Network Manager was developed and bundled with Oracle7 to help handlethis network complexity and to simplify the DBA's job ofconfiguring and maintaining an Oracle network. Network Manager is aGUI tool that you can use to create, change, and distribute therequired Oracle parameter files.

It is important to know that Network Manager was originally developedto run under Windows 3.1, and while it runs on Windows 95, Windows98, and Windows NT clients, it is not installed with the normalOracle installer on those platforms. Rather, you must navigate to the\WINDOWS\INSTALL directory on the Oracle clientinstallation CD-ROM, then run ORAINST to installNetwork Manager. The resulting executable will be found in the\ORAWIN \BIN directory on the client, ratherthan in the expected \ORAWIN95 directory.

Although Network Manager can be used to configure a network runningOracle8 and Net8, Oracle is now shipping a new configuration productcalled the Net8 Assistant that replaces Network Manager for Oracle8installations.

Network Manager is a GUI tool that runs only on the Windows 95/98 and Windows NT platforms. The files that are created are used on other host machines, but must be created in the Windows environment.


5.5.1. Network Manager Data Storage

A major advantage of Network Manager isthat data about the network is entered only once, then stored in arepository that may be either a flat file (operating- system-level)structure or an Oracle database. When a change is required, only theaffected component is changed, and all parameter files can be quicklyand easily regenerated and distributed as required.

If the Network Manager data is being stored in the database, severalscripts must be run by the SYSTEM account to create the requireddatabase objects. These scripts, which are normally found in the\ORAWIN \DBS directory on a Windows clientmachine, are shown in Table 5.1.

Table 5.1. Network Manager Scripts Required to Run
Script Name Function rosbild.sql Builds the Resource Object Store database objects rosgrnt.sql Grants access to the Resource Object Store objects rosrvke.sql Revokes access to the Resource Object Store objects rosdrop.sql Drops Resource Object Store objects from the database nmcbild.sql Builds database objects required by Network Manager nmcgrnt.sql Grants access to Network Manager database objects nmcrvke.sql Revokes access to Network Manager database objects nmcdrop.sql Drops Network Manager objects from the database

5.5.2. Using Network Manager

Before beginning to define an Oracle network using Network Manager,you'll need to collect the answers to some basic questions,including the following:

  • What protocols will be supported?

  • Will the MultiProtocol Interchange be used?

  • How will you name your Oracle services?

  • Will you use Oracle Names?

  • What are the physical or logical addresses of the servers in your Oracle network?

  • What are the SIDs (instance names) of the databases on each server?

Once this information is available, you can begin defining yournetwork. Network Manager easily walks you through the configurationprocess. After starting Network Manager, choose the "new"option from the "File" menu, and answer "yes"to the prompt that asks "Would you like to walk throughconfiguration of a network definition?" From this point on, youcan simply answer questions on the screen and provide the necessaryinformation to complete your configuration.

5.5.3. Files Created by Network Manager

When the network is specified toNetwork Manager (or a change is made to an existing networkdefinition), a set of SQL*Net configuration files is created on theWindows workstation. Individual directories are created for eachclient and server node defined in the network. In each of thesedirectories, you'll find the files shown in Table 5.2.

Table 5.2. Files Generated by Network Manager
File Distributed to Description tnsnames.ora Client (and server when using database links or distributed processing) Contains all service names for all databases and interchanges on the network. sqlnet.ora Client Contains parameters to control SQL*Net diagnostics (logging and tracing). tnsnav.ora Client Contains a list of local communities in the client profile or node. This file also contains information to identify the location of interchanges for connections across communities. listener.ora Server Contains information unique to each server specifying how SQL*Net should configure and operate the TNS (Transparent Network Substrate) listener on the server. intchg.ora (Oracle7) MultiProtocol Interchange Contains parameters to control the operation of a particular MultiProtocol Interchange. tnsnet.ora MultiProtocol Interchange Contains information to describe the relationships of all the communities and interchanges in the network. cman.ora (Oracle8) Connection Manager Contains parameters to control the operation of the Oracle Connection Manager. names.ora Names Server Contains parameters to control the operation of a single Oracle Names server.

Once these files are created, the DBA must copy the files, using atechnique such as FTP or Windows copy, to the appropriate node(identified by the directory name).

  • Create Bookmark (Key: b)Create Bookmark
  • Create Note or Tag (Key: t)Create Note or Tag
  • Download (Key: d)Download
  • Email This Page (Key: e)Email This Page
  • PrintPrint
  • Html View (Key: h)Html View
  • Zoom Out (Key: -)Zoom Out
  • Zoom In (Key: +)Zoom In
  • Toggle to Full Screen (Key: f)
  • Previous (Key: p)Previous
  • Next (Key: n)Next

Related Content

Oracle Networking Fundamentals
From: Oracle in a Nutshell

Configuring Oracle Net
From: Oracle Essentials, 4th Edition

Configuration Files
From: Oracle in a Nutshell

Oracle Database Objects
From: Oracle Security

Oracle
From: Introduction to the New Mainframe: Security

Oracle and Security
From: Oracle Security

SNMP Support
From: Oracle Distributed Systems

The Oracle Security Model
From: Oracle Security

Using the Oracle Net Manager
From: Oracle Database 11g DBA Handbook: Administer a Scalable, Secure Oracle Enterprise Database

Making the Connection
From: Oracle in a Nutshell