Unable to start the cdb database, getting errors ORA-00119: invalid specification for system parameter CONNECTION_BROKERS. ORA-00876: invalid CONNECTION_BROKERS specification #1

 


Solution:

In a new terminal perform the below steps. Ref. (SR 3-35030139875)

1. create pfile from spfile;
2. edit pfile and remove or comment out parameter CONNECTION_BROKERS in pfile
3. create spfile from pfile
4. startup database

[oraprod@deverpdb01 ~]$ cd /oraprod/oracle/db/19.3.0/
[oraprod@deverpdb01 19.3.0]$ cd dbs
[oraprod@deverpdb01 dbs]$ cd ..
[oraprod@deverpdb01 19.3.0]$ . 19cdb.env
[oraprod@deverpdb01 19.3.0]$ echo $ORACLE_HOME
/oraprod/oracle/db/19.3.0
[oraprod@deverpdb01 19.3.0]$ echo $ORACLE_SID
UPGCDB
[oraprod@deverpdb01 bin]$ export ORACLE_SID=upgcdb

[oraprod@deverpdb01 bin]$ ./sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Nov 30 13:45:10 2023
Version 19.21.0.0.0

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

Connected to an idle instance.

SQL> create pfile from spfile;

File created.

-       edit pfile and remove or comment out parameter CONNECTION_BROKERS in pfile


SQL> create spfile from pfile;

File created.

SQL> startup;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 2147481624 bytes
Fixed Size 9168920 bytes
Variable Size 587202560 bytes
Database Buffers 1526726656 bytes
Redo Buffers 24383488 bytes
Database mounted.
Database opened.
SQL>


Comments

Post a Comment

Popular posts from this blog

adop phase=prepare failed with error "data dictionary corrupted"

  After fresh clone when I run adop phase=prepare then prepare phase failed with the error "data dictionary corrupted". Solution: Follow the instructions in the "Fix data dictionary corruption" section of My Oracle Support Knowledge Document 1531121.1 . *  Fix Data Dictionary Corruption ( Conditional ) Copy the script $AD_TOP/patch/115/sql/adzddmpfix.sql to the database tier. On the database tier, connect to the database as SYSDBA. Run the $AD_TOP/patch/115/sql/adzddmpfix.sql script. [oraprod@deverpdb01 12.1.0]$ sqlplus / as sysdba SQL> @adzddmpfix.sql On the application tier, run the $AD_TOP/sql/ADZDDBCC.sql script again to identify whether data dictionary corruption is still present. [applprod@deverpapp01 sql]$ cd $AD_TOP/sql [applprod@deverpapp01 sql]$ sqlplus apps @ADZDDBCC.sql a.     If no corruption is found, proceed with the upgrade or patching cycle. b.   ...
Read more

Apply Latest CPU Patch of April 2024 on Oracle EBS R12.2.7 Application and Database 19c

Image
  Ref: Oracle E-Business Suite Release 12.2 Critical Patch Update Availability Document (April 2024) (Doc ID 3007752.1) As mentioned in the above document, before applying the Latest CPU patch we need to run ECPUC tool to identify any missing patches at Application node. To run ECPUC, download  Patch 35583866  and follow the instructions in the patch  Readme.txt  file. 3.2.1 EBS CPU Patches and Security Fixes  [applprod@upgapp03 oracle]$ . EBSapps.env run [applprod@upgapp03 scripts]$ cd $PATCH_TOP [applprod@upgapp03 patch]$ pwd /applprod/oracle/fs_ne/EBSapps/patch [applprod@upgapp03 patch]$ cd ECPUC/ [applprod@upgapp03 ECPUC]$ unzip p35583866_R12_GENERIC.zip [applprod@upgapp03 ECPUC]$ sqlplus apps/apps@UPG SQL> @ECPUC.sql SECTION-2 Oracle E-Business Suite (EBS): Instance Information ======================================================================== ***************************************************************************...
Read more

upgrade the AD/TXK Delta Patch to 14 in Oracle EBS R12.2.7

Image
  Environment: - Multi-node Applications (1 Internal Node & 1 External Node)    - Single Database Node - Version: Oracle EBS R12.2.7 and Database 19c ----------------------------------------------------------------------------------------------------------- We have to upgrade the AD/TXK level to 14. Follow the read me of AD patch 33600809 and perform all the steps as per read me and apply the patch using ADOP - Usually there will be only 2 patches to be applied to upgrade to AD/TXK. i.e. one patch for AD and another patch for TXK. But, in our environment we have Arabic Language enabled so I have to apply the AD/TXK patches for Arabic also. But, if no additional language is installed then you have to apply only English language patches which is the default. Below are the 4 patches which I have downloaded for English and Arabic If you have only English language in your setup then you have to download and install the below 2 patches only. 33600809:u33600809.drv  ...
Read more