Database - RAC/Scalability (MOSC)

MOSC Banner

Unable to start CDB in 2 node RAC

CDB uatcdb
instance1 uatcdb1
instance2 uatcdb2

2 node rac

How to modify parameter when we are unable to start instance.

steps followed:


For some reasom,we have added a below parameter which created an issue.
=====
1) [orauat@erpuatdb1 u02]$ export ORACLE_SID=uatcdb1
[orauat@erpuatdb1 u02]$ export PATH=$ORACLE_HOME/bin:$PATH
[orauat@erpuatdb1 u02]$ sqlplus "/as sysdba"

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jan 25 15:15:17 2023
Version 19.17.0.0.0

Copyright (c) 1982, 2022, Oracle. All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.17.0.0.0

SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.

Total System Global Area 2097151344 bytes
Fixed Size         9137520 bytes
Variable Size       855638016 bytes
Database Buffers     1224736768 bytes
Redo Buffers        7639040 bytes

SQL> alter system set CONNECTION_BROKERS="((TYPE=DEDICATED)(BROKERS=1)), ((TYPE=EMON)(BROKERS=1))" scope=spfile;

System altered.

SQL>shut immediate

SQL>startup
ORA-32004: obsolete or deprecated

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