PLS-00201: identifier 'DBMS_LOB' must be declared - OPAL Demonstration Customers did Not Load After Installation
(Doc ID 3068393.1)
Last updated on MARCH 05, 2025
Applies to:
Oracle Utilities Network Management System - Version 2.6.0.2.0 to 2.6.0.2.0 [Release 2.6]Oracle Network Management for Utilities - DMS - Version 2.6.0.2.0 to 2.6.0.2.0 [Release 2.6]
Information in this document applies to any platform.
Symptoms
On : 2.6.0.2.0 version, Installation
Customers did not load with NMS 2.6.0.2.1 installation with the OPAL demonstration model data.
After installing NMS 2.6.0.2.1 with OPAL demonstration data, everything appeared to work as expected.
But, searching for customers did not return any data. A search in the CES_CUSTOMERS table found it was empty, but in the NMS_ADMIN schema, the CES_CUSTOMERS_1B table did have customer data. A review of the setup log found some ORA errors and wondering if these have any issue with customer loading during setup.
ERROR
-----------------------
ISQL loading /user/nms/sql/OPAL_schema_callentry.sql
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 19 19:56:57 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.24.0.0.0
PL/SQL procedure successfully completed.
Materialized view created.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
dbms_lob.createtemporary(myclob,true);
*
ERROR at line 7:
ORA-06550: line 7, column 5:
PLS-00201: identifier 'DBMS_LOB' must be declared
ORA-06550: line 7, column 5:
PL/SQL: Statement ignored
ORA-06550: line 504, column 5:
PLS-00201: identifier 'DBMS_LOB' must be declared
ORA-06550: line 504, column 5:
PL/SQL: Statement ignored
PL/SQL procedure successfully completed.
CREATE INDEX street_intersection_one_text_1 ON street_intersection_view_1(street_one)
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-11701: thesaurus nms_roads_thes does not exist
ORA-06512: at "CTXSYS.DRUE", line 186
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 320
CREATE INDEX street_intersection_two_text_1 ON street_intersection_view_1(street_two)
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-11701: thesaurus nms_roads_thes does not exist
ORA-06512: at "CTXSYS.DRUE", line 186
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 320
Index created.
Synonym created.
Grant succeeded.
Grant succeeded.
Commit complete.
Cause
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
| Symptoms |
| Cause |
| Solution |