Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

startup upgrade issue

User_PO3C5Oct 15 2017 — edited Feb 5 2018

HI Experts

cluster_database parameter  not changing , can you assist me  ?

SQL> alter system set cluster_database=false scope=spfile sid='*';

System altered.

SQL> show parameter cluster

NAME                                 TYPE        VALUE

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

cluster_database                     boolean     TRUE

cluster_database_instances           integer     4

cluster_interconnects                string

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup upgrade

ORACLE instance started.

Total System Global Area 8551575552 bytes

Fixed Size                  2270360 bytes

Variable Size            3623881576 bytes

Database Buffers         4898947072 bytes

Redo Buffers               26476544 bytes

Database mounted.

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE

Process ID: 62348

Session ID: 534 Serial number: 3

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 5 2018
Added on Oct 15 2017
8 comments
3,263 views