Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
74
Table 1-53: GW_SNMP_OSS_Info_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
SNMPV3_USERNAME
VARCHAR2(64) —
Name of the user who authenticates
the SNMPv3 trap.
the SNMPv3 trap.
SNMPV3_COMMUNITY VARCHAR2(64) —
The SNMPv3 community name.
SNMPV3_AUTH_PROT
VARCHAR2(64) —
The SNMPv3 authentication
protocol.
protocol.
SNMPV3_AUTH_PWD
VARCHAR2(64) —
The SNMPv3 authentication
password.
password.
SNMPV3_PRIV_PROT
VARCHAR2(64) —
The SNMPv3 privacy protocol.
SNMPV3_PRIV_PWD
VARCHAR2(64) —
The SNMPv3 privacy password.
SNMP_VERSION
NUMBER(4)
—
The SNMP version:
0: SNMPv1
1: SNMPv2
2: SNMPv3
0: SNMPv1
1: SNMPv2
2: SNMPv3
SNMP_COMMUNITY
VARCHAR2(64) —
The SNMP community name.
SNMP_PORT
NUMBER(10)
—
The SNMP OSS destination port.
SNMPV3_EID
VARCHAR2(64) —
The SNMPv3 engine identification.
SNMPV3_IP
RAW(16)
NOT NULL
The SNMPv3 IP address.
SNMPV3_IS_IP6
NUMBER(1)
—
The SNMPv3 IPv6 flag.
1.1.56 IF_Cross_Connect
The IF_Cross_Connect table contains information about cross-connects between
interfaces on the same NE. Point-to-point (p2p) and point-to-multipoint (p2mp) are
supported.
interfaces on the same NE. Point-to-point (p2p) and point-to-multipoint (p2mp) are
supported.
Primary key: None
Tablespace: ONS155XX_DATA_TABLESPACE
Table 1-54: IF_Cross_Connect
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
XCDBAccessID
NUMBER(10)
NOT NULL
Unique sequence number (can be a
foreign key).
foreign key).