Oracle Database Administration: The Essential Refe

Network Manager Data Storage

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

If the Network Manager data is being stored in the database, several scripts must be run by the SYSTEM account to create the required database objects. These scripts, which are normally found in the \ORAWIN \DBS directory on a Windows client machine, 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