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 - Productionbefore 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
DBATracker 