current database

SYS @ srcdb > select name,open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
SRCDB     READ WRITE

SYS @ srcdb > select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE    11.2.0.3.0      Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

before proceeding make sure 12c binaries are installed on your machine.

login to oem and go to database which need to be upgraded. As we can see it is currently on 11.2.0.3 version

click on upgrade database

provide 12c OH details which was installed as a prerequsite and give host credetials which is is the owner of database and OH (oracle in my case). click next

if all validations are passed you should see this screen. Now continue

change the default values of paremeters as you wish. I selected upgrade timezone, gather stats and make tablespace readonly option maunally.

i don’t want to take backup so selected none

this is default and not changed. click next

there wer no listeners so i gace details of new listener to be created

choose deualt options click next

Do a final review and submit the job

you can review the job from results and summary tab.

job completed sucessfully

verify from summary tab as well

Now at database level verify

SYS @ srcdb > select name,open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
SRCDB     READ WRITE

SYS @ srcdb > select * from v$version;

BANNER                                                                               CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production              0
PL/SQL Release 12.1.0.2.0 - Production                                                    0
CORE    12.1.0.2.0      Production                                                                0
TNS for Linux: Version 12.1.0.2.0 - Production                                            0
NLSRTL Version 12.1.0.2.0 - Production                                                    0

verify components status

COLUMN comp_id FORMAT A10
COLUMN comp_name FORMAT A35
COLUMN version FORMAT A14

SELECT comp_id,comp_name,version,status FROM dba_registry;

COMP_ID    COMP_NAME                           VERSION        STATUS
---------- ----------------------------------- -------------- --------------------------------------------
APEX       Oracle Application Express          4.2.5.00.08    VALID
OWB        OWB                                 11.2.0.3.0     VALID
AMD        OLAP Catalog                        11.2.0.3.0     OPTION OFF
SDO        Spatial                             12.1.0.2.0     VALID
ORDIM      Oracle Multimedia                   12.1.0.2.0     VALID
XDB        Oracle XML Database                 12.1.0.2.0     VALID
CONTEXT    Oracle Text                         12.1.0.2.0     VALID
OWM        Oracle Workspace Manager            12.1.0.2.0     VALID
CATALOG    Oracle Database Catalog Views       12.1.0.2.0     VALID
CATPROC    Oracle Database Packages and Types  12.1.0.2.0     VALID
JAVAVM     JServer JAVA Virtual Machine        12.1.0.2.0     VALID

COMP_ID    COMP_NAME                           VERSION        STATUS
---------- ----------------------------------- -------------- --------------------------------------------
XML        Oracle XDK                          12.1.0.2.0     VALID
CATJAVA    Oracle Database Java Packages       12.1.0.2.0     VALID
APS        OLAP Analytic Workspace             12.1.0.2.0     VALID
XOQ        Oracle OLAP API                     12.1.0.2.0     VALID

15 rows selected.

verify listener

[oracle@oel6-node02 ~]$ lsnrctl status LISTENER_12C

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 07-JAN-2021 14:14:38

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oel6-node02.localdomain)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_12C
Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date                07-JAN-2021 12:44:32
Uptime                    0 days 1 hr. 30 min. 5 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/12.1.0.2/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/oel6-node02/listener_12c/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel6-node02.localdomain)(PORT=1522)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=oel6-node02.localdomain)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/srcdb/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "srcdb" has 1 instance(s).
  Instance "srcdb", status READY, has 1 handler(s) for this service...
Service "srcdbXDB" has 1 instance(s).
  Instance "srcdb", status READY, has 1 handler(s) for this service...
The command completed successfully