Category: 1Z0-043

Exam 1Z0-043: Database 10g – Administration II

What action would you take to overcome this error?

You want to create a consumer group, GROUP1, and you execute the following command in the command-line interface:
SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP(
CONSUMER_GROUP =>’group1′,
COMMENT => ‘New Group’);
This command errors out displaying the following message:
ERROR at line 1:
ORA-29371: pending area is not active
ORA-06512: at “SYS.DBMS_RMIN”, line 115
ORA-06512: at “SYS.DBMS_RESOURCE_MANAGER”, line 108
ORA-06512: at line 1
What action would you take to overcome this error?


Page 1 of 1912345...10...Last »