My Oracle Support Banner

Master Note for Oracle Utilities LODESTAR Database (LSDB) (Doc ID 1119623.1)

Last updated on MARCH 02, 2020

Applies to:

Oracle Utilities Billing Component - Version DNU4.53 to DNU1.6.0
Oracle Utilities Rate Management - Version DNU4.53 to DNU1.6.0
Oracle Utilities Transaction Management - Version DNU4.53 to DNU1.6.0
Oracle Utilities Portfolio Management - Version DNU4.53 to DNU1.6.0
Oracle Utilities Energy Information Platform - Version DNU4.53 and later
Information in this document applies to any platform.

Details

Master Note for Oracle Utilities LSDB (Lodestar Database)

Oracle Utilities LODESTAR Energy Information Platform
Oracle Utilities Meter Data Management
Oracle Utilities Billing Component
Oracle Utilities Quotations Management
Oracle Utilities Portfolio Management
Oracle Utilities Rate Management
Oracle Utilities Transaction Management
Oracle Utilities Load Analysis

Purpose

The purpose of this article is to provide a comprehensive source for finding information related to the LODESTAR Database (LSDB). Topics covered include upgrading, patching and maintenance of the schema version, known issues and errors, and troubleshooting help.

Audience

The information in this article is intended for DBAs and systems administrators familiar with Oracle Utilities Meter Data Applications.


Add this Document to your Favorites! This article will be updated frequently with the latest tips and resources for Meter Data Applications.



Actions

Getting Started

  • <Document 752238.1> - Requirements for Running the Lodestar Database Scripts
  • <Document 555488.1> - How To Find the Database Schema Version
  • <Document 728157.1> - What is the Base Schema Version for the LODESTAR Relational Database for Software Version 4.53?
  • <Document Note 740441.1> - Can Unused Base Data be Removed from the Database?

Supported Database Environments

  • <Document 461557.1> - Required system information including operating systems, database, ODBC driver versions, and MDAC [version 4.0 and 4.1]
  • <Document 555269.1> - Required System Information Including Operating Systems, Database, ODBC Driver, and MDAC Versions for Version 4.52
  • <Document 555278.1> - Required System Information Including Operating Systems, Database, ODBC Driver, and MDAC Versions for Version 4.53
  • <Document 739127.1> - Required ODBC Driver for LODESTAR version with Oracle Server 10g - 10.02.00.04 [version 4.53 and 4.54]
  • <Document 746665.1> - Oracle 10g R2 Required ODBC Patches and Oracle Data Provider for Meter Data Applications Version 1.5
  • <Document 880286.1>- Slow performance of Oracle Database on Solaris platform 

 

Is Oracle 11g RAC certified with Meter Data Applications?
Oracle 11g RAC is certified with version 1.6 and version 1.5.0.6.0 and higher. This will not be certified with any earlier versions (v4.x).



Upgrading LSDB Schema Version

When upgrading to a new version of Meter Data Applications the database schema (Lodestar Database) needs to be updated also.

  • <Document 750297.1> - Upgrading the LODESTAR Relational Database Schema to v1.6.1
  • <Document 728718.1> - How to Obtain the Database Upgrade Scripts from v4.52 to v4.53
  • <Document 750297.1> - How to Update your Relational Database When Upgrading to Version 1.5
  • <Document 988235.1> - Instructions for Upgrading a Standalone Security Schema from 4.5 to 1.5
  • <Document 751177.1> - The "admin" User is Unable to Navigate in EIP after Upgrading or Installing Version 1.5
  • <Document 972916.1> - Are Database Scripts Required to Update the Meter Data Applications (LODESTAR EIP) 1.5 LSDB Schema from 5.42.014 to 5.42.015?

Upgrading to Load Analysis version 9.1

  • <Document 790641.1> - How to Update the LODESTAR Relational Database (LSDB) Schema when Upgrading from Version 9.0 to 9.1

Database Customizations

Database customizations are also referred to as metadata requests or data model changes.
  • <Document 456678.1> - Database Change Request Instructions and Spreadsheet
  • <Document 873702.1> - What are the supported names for Interval Data Tables?
  • <Document 758782.1> - Can Metadata be Created for Views within the Lodestar Relational Database (LSDB)?

Database Errors

  • <Document 784742.1> - "Table or view does not exist" error when launching web if using a standalone security database
  • <Document 855592.1> - Account locked out of Data Base with Error (0x900022b4): LSDB5160: Unable to execute stored procedure 'gtmsigd.LSP_KILL_EXPR_SESS' [Oracle][ODBC][Ora][ORA-28000: the account is locked
  • <Document 864350.1> - "Type Mismatch Error" after Modify Column Datatype from VARCHAR2 to CLOB in LSDB (Lodestar Database).
  • <Document 784742.1> - "Table or view does not exist" error when launching web if using a standalone security database 
  • <Document 1078517.1> - When Configuring Data Access for a Database View an Error Occurs, Error (0x90430001): ExecuteReaderException: ORA-00936: missing expression

 

Known Issues

  • <Document 784742.1> - "Table or view does not exist" error when launching web if using a standalone security database
  • <Document 751177.1> - The "admin" User is Unable to Navigate in EIP after Upgrading or Installing Version 1.5
  • <Document 854741.1> - Slow performance when performing queries on EIP framework
  • <Document 880286.1> - Slow performance of Oracle Database on Solaris platform 
  • <Document 1263318.1> - Unable to Run Database Scripts (Buildora) with Oracle 11gR2 Client

Performance

  • <Document 854741.1> - Slow performance when performing queries on EIP framework
  • <Document 880286.1> - Slow performance of Oracle Database on Solaris platform

Contacts

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Details
 Master Note for Oracle Utilities LSDB (Lodestar Database)
 Purpose
 Audience
Actions
 Getting Started
 Supported Database Environments
 Upgrading LSDB Schema Version
 Upgrading to Load Analysis version 9.1
 Database Customizations
 Database Errors
 Known Issues
 Performance
Contacts
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.