Management policy - AUTOMATIC vs MANUAL for database in Oracle RAC

When the Cluster is started, if the database automatically starts, it indicates that the Management Policy is set to AUTOMATIC.

To change the Management Policy from AUTOMATIC to MANUAL, follow the steps below:

1. Execute the following command to modify the management policy:

   srvctl modify database -d <database_name> -y MANUAL

2. Verify the change using:

   srvctl config database -d <database_name>

   Ensure that the Management Policy is now set to MANUAL.

This change prevents the database from starting automatically when the Cluster is started.

[oracle@rac09-p ~]$ srvctl config database -d DEVDB

Database unique name: DEVDB

Database name:

Oracle home: /u02/app/oracle/database/19.3.0/dbhome_1

Oracle user: oracle

Spfile:

Password file:

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools:

Disk Groups: DATA01

Mount point paths:

Services:

Type: RAC

Start concurrency:

Stop concurrency:

OSDBA group: dba

OSOPER group: oper

Database instances: DEVDB1,DEVDB2

Configured nodes: rac09-p,rac10-p

CSS critical: no

CPU count: 0

Memory target: 0

[oracle@rac09-p ~]$ srvctl config database -d DEVDB

Database unique name: DEVDB

Database name:

Oracle home: /u02/app/oracle/database/19.3.0/dbhome_1

Oracle user: oracle

Spfile:

Password file:

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools:

Disk Groups: DATA01

Mount point paths:

Services:

Type: RAC

Start concurrency:

Stop concurrency:

OSDBA group: dba

OSOPER group: oper

Database instances: DEVDB1,DEVDB2

Configured nodes: rac09-p,rac10-p

CSS critical: no

CPU count: 0

Memory target: 0

Maximum memory: 0

Default network number for database services:

Database is administrator managed

[oracle@rac09-p ~]$

[oracle@rac09-p ~]$ srvctl modify database -d DEVDB -y MANUAL

Now Crosscheck the output

[oracle@rac09-p ~]$ srvctl config database -d DEVDB

Database unique name: DEVDB

Database name:

Oracle home: /u02/app/oracle/database/19.3.0/dbhome_1

Oracle user: oracle

Spfile:

Password file:

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: MANUAL

Server pools:

Disk Groups: DATA01

Mount point paths:

Services:

Type: RAC

Start concurrency:

Stop concurrency:

OSDBA group: dba

OSOPER group: oper

Database instances: DEVDB1,DEVDB2

Configured nodes: rac09-p,rac10-p

CSS critical: no

CPU count: 0

Memory target: 0

Maximum memory: 0

Default network number for database services:

Database is administrator managed