Resource manager plan is not active or is not managing CPU usage

Error

SQL> EXECUTE dbms_stats.gather_table_stats(ownname=>'ROCFM',tabname=>'SUBSCRIBER',cascade=>true);
BEGIN dbms_stats.gather_table_stats(ownname=>'ROCFM',tabname=>'SUBSCRIBER',cascade=>true); END;

*
ERROR at line 1:
ORA-20000: Unable to gather statistics concurrently: Resource manager plan is not active or is not managing CPU usage
ORA-06512: at "SYS.DBMS_STATS", line 34757

ORA-06512: at line 1


Cause

Resource Manager must be enabled in 12c in order to use any value other than OFF for the CONCURRENT preference (which enables concurrent statistics gathering).

Solution

SQL> alter system set resource_manager_plan = 'DEFAULT_PLAN' ;

System altered.

SQL> EXECUTE dbms_stats.gather_table_stats(ownname=>'ROCFM',tabname=>'SUBSCRIBER',cascade=>true);


PL/SQL procedure successfully completed.


SQL> 

How to Stop Oracle Audit Vault Services

Simple article on stopping Oracle Audit Vault Services.

Follow below  sequence of steps:

/usr/local/dbfw/bin/javafwk stop --> From root
/usr/local/dbfw/bin/dbfwdb stop --> From oracle
/usr/local/dbfw/bin/asmdb stop --> From root

[root@auditvault02 ~]# /usr/local/dbfw/bin/javafwk stop
Stopping Java framework...                                 [  OK  ]
[root@auditvault02 ~]#

[root@auditvault02 ~]# su - oracle
[oracle@auditvault02 ~]$
[oracle@auditvault02 ~]$ /usr/local/dbfw/bin/dbfwdb stop
Shutting down the database
Database shut down
[oracle@auditvault02 ~]$
[oracle@auditvault02 ~]$ lsnrctl stop

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 27-SEP-2018 10:51:53

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The command completed successfully
[oracle@auditvault02 ~]$
[oracle@auditvault02 ~]$

[root@auditvault02 ~]#
[root@auditvault02 ~]# /usr/local/dbfw/bin/asmdb stop
[root@auditvault02 ~]#

[root@auditvault02 ~]#
[root@auditvault02 ~]# su - grid
[grid@auditvault02 ~]$ lsnrctl stop LISTENER_ASM

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 27-SEP-2018 10:51:34

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1523)))
The command completed successfully
[grid@auditvault02 ~]$


Now follow the reverse to restart up avdf DB and APP services.