Table of Contents

• Title and Copyright Information
• My Oracle Support
• What's New in This Guide
• 1 Introduction
  • 1.1 Overview
  • 1.2 Scope and Audience
  • 1.3 Documentation Admonishments
  • 1.4 Manual Organization
  • 1.5 My Oracle Support (MOS)
  • 1.6 Emergency Response
  • 1.7 Related Publications
  • 1.8 Customer Training
  • 1.9 Locate Product Documentation on the Oracle Help Center Site
• 2 Database Administration Overview
  • 2.1 Introduction
  • 2.2 Overview of Database Functions
    • 2.2.1 Managing LSMS Functions
    • 2.2.2 Number Pooling EDR
    • 2.2.3 SPID Security for Locally Provisioned Data
      • 2.2.3.1 Types of Data Protected by SPID Security
    • 2.2.4 Wireless Short Message Service Center (WSMSC) Support
    • 2.2.5 Custom TN Filters
    • 2.2.6 Enhanced LSMS Filters
      • 2.2.6.1 Regional TN Filters
      • 2.2.6.2 GTT Groups
    • 2.2.7 LSMS to TekPath Audit
  • 2.3 Using Login Sessions
    • 2.3.1 Logging In to LSMS Server Command Line
    • 2.3.2 Logging in from One Server to the Mate’s Command Line
    • 2.3.3 Starting an LSMS GUI Session
    • 2.3.4 Logging in to the LSMS Console Window
    • 2.3.5 Modifying Title Bar in LSMS Console Window
  • 2.4 Navigating the GUI
    • 2.4.1 Displaying Icons for Inactive NPACs
    • 2.4.2 NPAC Status Icon Pop-up Menus
    • 2.4.3 EMS Status Area (General Description)
    • 2.4.4 EMS Status Icon Pop-up Menus
    • 2.4.5 Notification Area
    • 2.4.6 Field Syntax for the LSMS GUI
  • 2.5 GUI Structure
  • 2.6 GUI Function Access
  • 2.7 Data Entry Dialogs
  • 2.8 User/Session Menu
    • 2.8.1 Logging Out of the LSMS GUI
• 3 Managing NPAC Relations
  • 3.1 Resynchronizing LSMS and NPAC Data
    • 3.1.1 Resynchronizing an Individual TN Using the GUI
    • 3.1.2 Resynchronizing a Range of TNs Using the GUI
    • 3.1.3 Resynchronizing for a Defined Period of Time Using the GUI
    • 3.1.4 Resynchronizing an Individual NPB Using the GUI
    • 3.1.5 Resynchronizing a Range of NPBs Using the GUI
  • 3.2 Viewing an NPAC Service Provider Network
  • 3.3 Managing NPAC Service Provider Local Routing Number (LRN)
    • 3.3.1 Adding an NPAC Service Provider LRN
    • 3.3.2 Viewing an NPAC Service Provider LRN
    • 3.3.3 Deleting an NPAC Service Provider LRN
  • 3.4 Managing NPAC Service Provider NPA-NXX
    • 3.4.1 Adding an NPAC Service Provider NPA-NXX
    • 3.4.2 Viewing an NPAC Service Provider NPA-NXX
    • 3.4.3 Deleting an NPAC Service Provider NPA-NXX
• 4 Managing Locally Provisioned Data
  • 4.1 Introduction
    • 4.1.1 Entering Locally Provisioned Data on a Shadow LSMS
  • 4.2 EMS Routing
    • 4.2.1 Modify EMS Routing
    • 4.2.2 View EMS Routing
  • 4.3 Custom TN Filters
    • 4.3.1 Create Custom TN Filters Dialog Overview
    • 4.3.2 Create a Custom TN Filter
    • 4.3.3 Modify a Custom TN Filter
    • 4.3.4 View a Custom TN Filter
    • 4.3.5 Delete a Custom TN Filter
  • 4.4 GTT Groups
    • 4.4.1 Create GTT Group
    • 4.4.2 Modify GTT Group
    • 4.4.3 View GTT Group
    • 4.4.4 Delete GTT Group
  • 4.5 Default GTT
    • 4.5.1 Create Default GTT
    • 4.5.2 Modify a Default GTT
    • 4.5.3 View a Default GTT
    • 4.5.4 Delete a Default GTT
  • 4.6 Override GTT
    • 4.6.1 Create an Override GTT
    • 4.6.2 Modify an Override GTT
    • 4.6.3 View an Override GTT
    • 4.6.4 Delete an Override GTT
  • 4.7 TN/NPB Query
    • 4.7.1 TN Field Descriptions
    • 4.7.2 NPB Query
    • 4.7.3 NPB Field Descriptions
  • 4.8 NPA Splits
    • 4.8.1 Create NPA Split
    • 4.8.2 Modify NPA Split
    • 4.8.3 Delete NPA Split
    • 4.8.4 Reversing (Correcting) an NPA Split Entry Made in Error
  • 4.9 Input Data By File
  • 4.10 Default GTT Input File
    • 4.10.1 Creating or Modifying the File
    • 4.10.2 Importing the File
    • 4.10.3 Default GTT Result File
  • 4.11 Override GTT Input File
    • 4.11.1 Creating or Modifying the File
    • 4.11.2 Importing the File
    • 4.11.3 Override GTT Result File
  • 4.12 NPA-NXX Split Input File
    • 4.12.1 Creating or Modifying the File
    • 4.12.2 Importing the File
    • 4.12.3 NPA-NXX Split Result File
  • 4.13 Custom TN Filter Input File
    • 4.13.1 Creating or Modifying the Input File
    • 4.13.2 Importing the File
    • 4.13.3 Custom TN Filter Result File
  • 4.14 Error Codes
• 5 LSMS Reports
  • 5.1 Introduction
  • 5.2 Service Provider Administrative Data Reports
    • 5.2.1 Creating a Service Provider Administrative Data Report
    • 5.2.2 Viewing a Service Provider Administrative Data Report
    • 5.2.3 Deleting a Service Provider Administrative Data Report
  • 5.3 Service Provider Network Data Reports
    • 5.3.1 Creating a Service Provider Network Data Report
    • 5.3.2 Viewing a Service Provider Network Data Report
    • 5.3.3 Deleting a Service Provider Network Data Report
  • 5.4 EMS Configuration Data Reports
    • 5.4.1 Creating an EMS Configuration Data Report
    • 5.4.2 Viewing an EMS Configuration Data Report
    • 5.4.3 Deleting an EMS Configuration Data Report
  • 5.5 Default GTT Data Reports
    • 5.5.1 Creating a Default GTT Data Report
    • 5.5.2 Viewing a Default GTT Data Report
    • 5.5.3 Deleting a Default GTT Data Report
  • 5.6 Override GTT Data Reports
    • 5.6.1 Creating an Override GTT Data Report
    • 5.6.2 Viewing an Override GTT Data Report
    • 5.6.3 Deleting an Override GTT Data Report
  • 5.7 NPA Split Data Reports
    • 5.7.1 Creating NPA Split Data Reports
    • 5.7.2 Viewing NPA Split Data Reports
    • 5.7.3 Deleting NPA Split Data Reports
  • 5.8 NPAC Audit Report
  • 5.9 LSMS Subscriptions by LRN Reports
    • 5.9.1 Creating an LSMS Subscription by LRN Report
    • 5.9.2 Viewing an LSMS Subscription by LRN Report
    • 5.9.3 Deleting an LSMS Subscription by LRN Report
  • 5.10 LSMS Subscriptions by Service Provider Data Reports
    • 5.10.1 Creating an LSMS Subscription by Service Provider Data Report
    • 5.10.2 Viewing an LSMS Subscription by Service Provider Data Report
    • 5.10.3 Deleting an LSMS Subscription by Service Provider Data Report
  • 5.11 LSMS Number Pool Blocks by LRN Data Reports
    • 5.11.1 Creating an LSMS Number Pool Block by LRN Data Report
    • 5.11.2 Viewing an LSMS Number Pool Block by LRN Data Report
    • 5.11.3 Deleting an LSMS Number Pool Block by LRN Data Report
  • 5.12 LSMS Number Pool Blocks by Service Provider Data Reports
    • 5.12.1 Creating an LSMS Number Pool Block by Service Provider Data Report
    • 5.12.2 Viewing an LSMS Number Pool Block by Service Provider Data Report
    • 5.12.3 Deleting an LSMS Number Pool Block by Service Provider Data Report
  • 5.13 Service Provider Data Reports
    • 5.13.1 Creating a Service Provider Data Report
    • 5.13.2 Viewing a Service Provider Data Report
    • 5.13.3 Deleting Service Provider Data Report
  • 5.14 Permission Group Data Report
    • 5.14.1 Creating a Permission Group Data Report
    • 5.14.2 Viewing a Permission Group Data Report
    • 5.14.3 Deleting a Permission Group Data Report
  • 5.15 Report Generator
    • 5.15.1 USING REGION <database>;
    • 5.15.2 SELECT <column> FROM <table> WHERE <expression>;
    • 5.15.3 LQL Table Names
    • 5.15.4 WHERE Expressions
    • 5.15.5 SQL Data Types
    • 5.15.6 SV Table
    • 5.15.7 NPB Table
    • 5.15.8 DGTT Table
    • 5.15.9 OGTT Table
    • 5.15.10 SPLIT Table
    • 5.15.11 Avoiding Overly General Queries
    • 5.15.12 Relationship to SQL
    • 5.15.13 DISPLAY <RECORDS|COUNTS>;
    • 5.15.14 SAVE <COMMANDS|RESULTS> <IN <filename>|OFF>;
    • 5.15.15 STATUS;
    • 5.15.16 HELP;
    • 5.15.17 EXIT;
    • 5.15.18 LQL Output
    • 5.15.19 LQL Errors
    • 5.15.20 LQL Examples
• 6 LSMS Logs and Measurements
  • 6.1 Introduction
    • 6.1.1 Viewing a Log File
  • 6.2 Log File Names and Locations
    • 6.2.1 LSMS Log File Names and Locations
  • 6.3 Removing Accumulated Logs
  • 6.4 Measurement Logs
    • 6.4.1 Printing Measurement Logs from Linux and Windows Computers
      • 6.4.1.1 Printing Measurement Logs from a Linux Computer
      • 6.4.1.2 Printing Measurement Logs from a Windows Computer
      • 6.4.1.3 Exiting Measurement Log Windows
  • 6.5 Security Logs
    • 6.5.1 Viewing Security Logs
  • 6.6 NPAC Transactions Logs
  • 6.7 Local Data Transactions Logs
  • 6.8 Audit Logs
    • 6.8.1 Viewing Audit Log Files
    • 6.8.2 Audit Log File Contents
  • 6.9 NPA Split Logs
  • 6.10 Activity Logs
  • 6.11 Alarm Logs
  • 6.12 CMIP Logs
  • 6.13 Event Logs
  • 6.14 Trace Logs
  • 6.15 eagleagent Logs
    • 6.15.1 eagleagent Transactions Log
    • 6.15.2 Rejected Transactions Log
    • 6.15.3 Measurement Logs
  • 6.16 LSMS Evaluation Log Files
  • 6.17 Bulk Data Downloads for Notifications (Optional)