Guest

Preview Tool

Cisco Bug: CSCtd89038 - ORA error message displayed during import_full_db.sh procedure

Last Modified

Aug 24, 2010

Products (1)

  • Cisco Prime Optical

Known Affected Releases

9.1(0.316) 9.2(0.1)

Description (partial)

Symptom:
An Oracle error message is displayed in the output of the import_full_db.sh script.

Conditions:
This problem occurs when you run the /opt/CiscoTransportManagerServer/bin/import_full_db.sh script. In the output, the following error message is displayed:

SQL> BEGIN DBMS_JOB.SUBMIT(:jobno,'Login_Disable;',TRUNC(SYSDATE)+1+6/24, 'TRUNC(SYSDATE+1)+6/24'); END;

*
ERROR at line 1:
ORA-06550: line 1, column 93:
PLS-00201: identifier 'LOGIN_DISABLE' must be declared
ORA-06550: line 1, column 93:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_JOB", line 79
ORA-06512: at "SYS.DBMS_JOB", line 136
ORA-06512: at line 1

This problem occurs because an SQL procedure in the import_full_db.sh script is executed multiple times, which generates errors when the script runs.

Despite the errors, the import procedure completes successfully. You can restart the CTM server after the script completes.
Bug details contain sensitive information and therefore require a Cisco.com account to be viewed.

Bug Details Include

  • Full Description (including symptoms, conditions and workarounds)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.