Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

E-Business 19c DB upgrade post step: Update the CDB initialization parameters: which db port of loca

edited Apr 30, 2020 6:26PM in Database Install/Upgrade/Opatch (MOSC) 3 commentsAnswered ✓

I am performing the post steps for a 19c upgrade of an 11.2.0.4 db for EBS and am in the convert to PDB section where the MOS doc: 2552181.1 stated the following:

EBS 12.2.5

CDB=CDBSBX

PDB=SBX

OS=Solaris 11 SPARC 64-bit

Update the CDB initialization parameters

$ cd $ORACLE_HOME/appsutil
$ . ./txkSetCfgCDB.env dboraclehome=<full path of ORACLE_HOME>
$ export ORACLE_SID=<CDB SID>
$ sqlplus "/ as sysdba"
SQL> startup nomount;
SQL> @$ORACLE_HOME/dbs/&lt;source SID>_initparam.sql
SQL> alter system set LOCAL_LISTENER="<hostname>:<port number>" scope=both;
SQL> shutdown;
SQL> startup;

Is the port number for the CDB or PDB? I would assume CDB, but we all know what can go wrong when assuming.

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