Database - RAC/Scalability (MOSC)

MOSC Banner

Unable to set cluster_database to false

edited Oct 18, 2016 11:52AM in Database - RAC/Scalability (MOSC) 4 commentsAnswered ✓

Hello,

I want to drop a 2 instances RAC database, so when I execute request alter system set cluster_database=FALSE scope=spfile; before dropping database, the cluster_database value is not modified.

Here's my process :

SQL> alter system set cluster_database=FALSE scope=spfile;

System altered.

SQL> shutdown abort

ORACLE instance shut down.

SQL> startup mount exclusive restrict

ORACLE instance started.

Total System Global Area 2.0110E+10 bytes

Fixed Size                  2261888 bytes

Variable Size            3623881856 bytes

Database Buffers         1.6442E+10 bytes

Redo Buffers               41762816 bytes

Database mounted.

SQL> select logins,parallel from v$instance;

LOGINS     PAR

---------- ---

RESTRICTED YES

SQL> set head off

SQL> select name,type,value from v$parameter where name like '%cluster%';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center