Error 'PLS-00201: identifier 'DBMS_LOCK' must be declared' when running USP_CHECKBATCHJOBSTATUS

Technote (troubleshooting)


Problem(Abstract)

Error 'PLS-00201: identifier 'DBMS_LOCK' must be declared' when running USP_CHECKBATCHJOBSTATUS.

Symptom

English:


PLS-00201: identifier 'DBMS_LOCK' must be declared

German:

FUNCTION schemaname.USP_CHECKBATCHJOBSTATUS
On line: 14
PLS-00201: Bezeichner 'DBMS_LOCK' muss deklariert werden

Cause

The Oracle schema (the user used by the Controller application server to connect to the Oracle database) does not have access to the DBMS_LOCK package.

  • In other words, the Oracle schema was not created with the required permissions (as per Cognos recommendations).

TIP: For full details of the permissions/script for how to create a new schema, see separate IBM Technote #.

Environment

Oracle database.

Resolving the problem

Grant Execute permission to the Oracle user/schema used for the Controller application repository, by running the following script:

    GRANT execute ON DBMS_LOCK TO <schema_name>;

Steps:

1. Launch an Oracle tool (for example "SQL Plus Worksheet")
2. Connect/logon to the database, using administrative credentials
3. Run the following script:
    GRANT execute ON DBMS_LOCK TO <schema_name>;

Related information

ProvenPractices: 06. Guide to installing Oracle 10G Server _and creating databases_

Historical Number

1037350

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos Controller
Controller

Software version:

8.3

Operating system(s):

Windows

Reference #:

1347515

Modified date:

2013-10-08

Translate my page

Machine Translation

Content navigation