Cisco Prime Optical Database Schema, 9.3
Downloads: This chapterpdf (PDF - 112.0 KB) The complete bookPDF (PDF - 5.39 MB) | Feedback


Table Of Contents






Related Documentation

Obtaining Documentation and Submitting a Service Request



This document describes the database schema that Cisco Prime Optical uses to store information in a Structured Query Language (SQL) database such as the Oracle database. The document is designed for users who need to create their own reports without using Prime Optical.

Note The Prime Optical schema is subject to change.

Various schema objects (tables, views, and functions) form the schema for Prime Optical in the Oracle database. The following information is stored in the Oracle database:

Network element (NE) information

Gateway network element (GNE) information

Topology information

Interface tables

Performance monitoring (PM) data

SONET and SDH PM data

Active alarm information

Alarm and event logs

Log tables

Administrative job and task information

Port status

NE service-related configuration information


This document contains the following information:

Chapter 1, "Database Schema Tables"

Table descriptions.

Chapter 2, "Database Schema Views"

Descriptions of the database views created and used by Prime Optical.

Chapter 3, "Database Schema Functions"

Functions defined in Prime Optical tables.

Appendix A, "Oracle Built-In Data Types"

List of Oracle data types.

Appendix B, "Config_Table Parameters"

Configuration information.


The primary audience for this guide includes network operations personnel and system administrators. This guide assumes the reader is familiar with the following products and topics:

Basic internetworking terminology and concepts

Network topology and protocols

Microsoft Windows 7, Windows Vista, Windows 2000 Professional, Windows XP Professional, and Windows Server 2003 Terminal Server

Sun Microsystems Solaris or Linux Red Hat administration

Oracle database administration


This document uses the conventions listed in .

Table 1 Document Conventions


Commands and keywords

boldface font

Variables for which you supply values

italic font

Displayed session and system information

screen font

Information you enter

boldface screen font

Variables you enter

italic screen font

Menu items and button names

boldface font

Selecting a menu item

Option  >  Network Preferences

Note Means reader take note. Notes contain helpful suggestions or references to material not covered in the publication.

Caution Means reader be careful. In this situation, you might do something that could result in equipment damage or loss of data.

Tip Means the following information will help you solve a problem.

Related Documentation

Note You can access the most current Prime Optical documentation online at

The Prime Optical documentation set comprises the following guides:

Release Notes for Cisco Prime Optical 9.3—Describes the caveats for Prime Optical.

Cisco Prime Optical 9.3 Installation Guide—Explains how to install Prime Optical and how to upgrade from previous releases.

Cisco Prime Optical 9.3 User Guide—Describes how to use the Prime Optical software, which consists of user applications and tools for network discovery, network configuration, connection management, fault management, system administration, and security management.

Cisco Prime Optical 9.3 GateWay/CORBA User Guide and Programmer Manual—Describes the GateWay/CORBA northbound interface product that is available for Prime Optical. This document serves as a reference for developers of OSS applications that work with the GateWay/CORBA interface.

Cisco Prime Optical 9.3 Database Schema—This guide.

Cisco Prime Optical 9.3 High Availability Installation Guide—Explains how to install Prime Optical in a high availability (HA) environment.

Note To obtain the Cisco Prime Optical 9.3 High Availability Installation Guide, contact your Cisco account representative.

Cisco Prime Optical 9.3 ML Provisioning Methodology—Describes the methodology that Prime Optical uses to provision ML-series cards.

Cisco Prime Optical 9.3 Basic External Authentication—Describes how Prime Optical supports basic external authentication.

Migration Matrix for Service Pack Releases—Describes the migration matrix for service pack releases.

Obtaining Documentation and Submitting a Service Request

For information on obtaining documentation, submitting a service request, and gathering additional information, see the monthly What's New in Cisco Product Documentation, which also lists all new and revised Cisco technical documentation, at:

Subscribe to the What's New in Cisco Product Documentation as a Really Simple Syndication (RSS) feed and set content to be delivered directly to your desktop using a reader application. The RSS feeds are a free service and Cisco currently supports RSS version 2.0.