Help Center/ MapReduce Service/ Component Operation Guide (LTS) (Ankara Region)/ Using CDL/ CDL FAQs/ Error ORA-01284 Is Reported When An Oracle Job Is Started
Updated on 2024-11-29 GMT+08:00
View PDF
Share

Error ORA-01284 Is Reported When An Oracle Job Is Started

Symptom

After DDL is enabled by default for Oracle jobs, the following error message is displayed: 
Error at database tier, Please check : java.sql.SQLException: ORA-01284: file /oracle/database/dictionary.ora cannot be opened
ORA-06512: at "SYS.DBMS_LOGMNR", line 58
ORA-06512: at line 2

Possible Cause

For databases of certain versions, dictionary_location needs to be manually specified.

Troubleshooting Method

Manually create the /oracle/database/ directory and grant permissions to database users. Set the initialization parameter UTL_FILE_DIR and restart the database.

Procedure

  1. Log in to the active node as user root and run the following command to create a directory:

    mkdir -p /oracle/database/

  2. Run the following command to grant permissions (ensure that upper-layer directories also have the corresponding permissions. Permissions of database users and groups vary based on the site requirements):

    chown -R oracle:osintall /oracle

  3. Run the following command to modify the database parameters. The value of sid depends on the actual situation.

    alter system set UTL_FILE_DIR='/oracle/database/dictionary.ora' scope=spfile sid='orcl';

  4. Restart the database.
Parent topic: CDL FAQs