1. Environment
Database Name : test
DB VERSION : 12.2.0.1
DB Home Path : /u01/app/oracle/product/11.2.0.4/dbhome_1
Datafile Location : /u02/oradata/DELL
Target DB VERSION : 19300
Target DB Path : /u01/app/oracle/product/19300/dbhome_1
Upgrade Method : Manual
2. Run preupgrade script
[oracle@localhost bin]$ java -jar /u01/app/oracle/product/1930/dbhome_1/rdbms/admin/preupgrade.jar
==================
PREUPGRADE SUMMARY
==================
/u01/app/oracle/cfgtoollogs/test/preupgrade/preupgrade.log
/u01/app/oracle/cfgtoollogs/test/preupgrade/preupgrade_fixups.sql
/u01/app/oracle/cfgtoollogs/test/preupgrade/postupgrade_fixups.sql
Execute fixup scripts as indicated below:
Before upgrade:
Log into the database and execute the preupgrade fixups
@/u01/app/oracle/cfgtoollogs/test/preupgrade/preupgrade_fixups.sql
After the upgrade:
Log into the database and execute the postupgrade fixups
@/u01/app/oracle/cfgtoollogs/test/preupgrade/postupgrade_fixups.sql
Preupgrade complete: 2019-09-18T13:56:31
3. View Preupgrade log
[oracle@localhost bin]$ cat /u01/app/oracle/cfgtoollogs/test/preupgrade/preupgrade.log
Report generated by Oracle Database Pre-Upgrade Information Tool Version
19.0.0.0.0 Build: 1 on 2019-09-18T13:56:28
Upgrade-To version: 19.0.0.0.0
=======================================
Status of the database prior to upgrade
=======================================
Database Name: TEST
Container Name: test
Container ID: 0
Version: 12.2.0.1.0
DB Patch Level: No Patch Bundle applied
Compatible: 12.2.0
Blocksize: 8192
Platform: Linux x86 64-bit
Timezone File: 26
Database log mode: ARCHIVELOG
Readonly: FALSE
Edition: EE
Oracle Component Upgrade Action Current Status
---------------- -------------- --------------
Oracle Server [to be upgraded] VALID
JServer JAVA Virtual Machine [to be upgraded] VALID
Oracle XDK for Java [to be upgraded] VALID
Real Application Clusters [to be upgraded] OPTION OFF
Oracle Workspace Manager [to be upgraded] VALID
OLAP Analytic Workspace [to be upgraded] VALID
Oracle Label Security [to be upgraded] VALID
Oracle Database Vault [to be upgraded] VALID
Oracle Text [to be upgraded] VALID
Oracle XML Database [to be upgraded] VALID
Oracle Java Packages [to be upgraded] VALID
Oracle Multimedia [to be upgraded] VALID
Oracle Spatial [to be upgraded] VALID
Oracle OLAP API [to be upgraded] VALID
==============
BEFORE UPGRADE
==============
REQUIRED ACTIONS
================
1. Set DB_RECOVERY_FILE_DEST_SIZE initialization parameter to at least 9944
MB. Check alert log during the upgrade to ensure there is remaining free
space available in the recovery area.
DB_RECOVERY_FILE_DEST_SIZE is set at 8016 MB. There is currently 2690 MB
of free space remaining, which may not be adequate for the upgrade.
Currently:
Fast recovery area : /u01/app/oracle/fast_recovery_area/test
Limit : 8016 MB
Used : 5326 MB
Available : 2690 MB
The database has archivelog mode enabled, and the upgrade process will
need free space to generate archived logs to the recovery area specified
by initialization parameter DB_RECOVERY_FILE_DEST. The logs generated
must not overflow the limit set by DB_RECOVERY_FILE_DEST_SIZE, as that
can cause the upgrade to not proceed.
RECOMMENDED ACTIONS
===================
2. (AUTOFIXUP) Gather stale data dictionary statistics prior to database
upgrade in off-peak time using:
EXECUTE DBMS_STATS.GATHER_DICTIONARY_STATS;
Dictionary statistics do not exist or are stale (not up-to-date).
Dictionary statistics help the Oracle optimizer find efficient SQL
execution plans and are essential for proper upgrade timing. Oracle
recommends gathering dictionary statistics in the last 24 hours before
database upgrade.
For information on managing optimizer statistics, refer to the 12.2.0.1
Oracle Database SQL Tuning Guide.
INFORMATION ONLY
================
3. To help you keep track of your tablespace allocations, the following
AUTOEXTEND tablespaces are expected to successfully EXTEND during the
upgrade process.
Min Size
Tablespace Size For Upgrade
---------- ---------- -----------
SYSAUX 570 MB 589 MB
SYSTEM 820 MB 927 MB
TEMP 32 MB 150 MB
UNDOTBS1 65 MB 439 MB
Minimum tablespace sizes for upgrade are estimates.
4. Check the Oracle Backup and Recovery User's Guide for information on how
to manage an RMAN recovery catalog schema.
If you are using a version of the recovery catalog schema that is older
than that required by the RMAN client version, then you must upgrade the
catalog schema.
It is good practice to have the catalog schema the same or higher version
than the RMAN client version you are using.
ORACLE GENERATED FIXUP SCRIPT
=============================
All of the issues in database TEST
which are identified above as BEFORE UPGRADE "(AUTOFIXUP)" can be resolved by
executing the following
SQL>@/u01/app/oracle/cfgtoollogs/test/preupgrade/preupgrade_fixups.sql
=============
AFTER UPGRADE
=============
REQUIRED ACTIONS
================
None
RECOMMENDED ACTIONS
===================
5. Upgrade the database time zone file using the DBMS_DST package.
The database is using time zone file version 26 and the target 19 release
ships with time zone file version 32.
Oracle recommends upgrading to the desired (latest) version of the time
zone file. For more information, refer to "Upgrading the Time Zone File
and Timestamp with Time Zone Data" in the 19 Oracle Database
Globalization Support Guide.
6. To identify directory objects with symbolic links in the path name, run
$ORACLE_HOME/rdbms/admin/utldirsymlink.sql AS SYSDBA after upgrade.
Recreate any directory objects listed, using path names that contain no
symbolic links.
Some directory object path names may currently contain symbolic links.
Starting in Release 18c, symbolic links are not allowed in directory
object path names used with BFILE data types, the UTL_FILE package, or
external tables.
7. (AUTOFIXUP) Gather dictionary statistics after the upgrade using the
command:
EXECUTE DBMS_STATS.GATHER_DICTIONARY_STATS;
Oracle recommends gathering dictionary statistics after upgrade.
Dictionary statistics provide essential information to the Oracle
optimizer to help it find efficient SQL execution plans. After a database
upgrade, statistics need to be re-gathered as there can now be tables
that have significantly changed during the upgrade or new tables that do
not have statistics gathered yet.
8. Gather statistics on fixed objects after the upgrade and when there is a
representative workload on the system using the command:
EXECUTE DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;
This recommendation is given for all preupgrade runs.
Fixed object statistics provide essential information to the Oracle
optimizer to help it find efficient SQL execution plans. Those
statistics are specific to the Oracle Database release that generates
them, and can be stale upon database upgrade.
For information on managing optimizer statistics, refer to the 12.2.0.1
Oracle Database SQL Tuning Guide.
ORACLE GENERATED FIXUP SCRIPT
=============================
All of the issues in database TEST
which are identified above as AFTER UPGRADE "(AUTOFIXUP)" can be resolved by
executing the following
SQL>@/u01/app/oracle/cfgtoollogs/test/preupgrade/postupgrade_fixups.sql
[oracle@localhost bin]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Wed Sep 18 13:59:02 2019
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
4.Run preupgrade_fixups.sql
SQL> @/u01/app/oracle/cfgtoollogs/test/preupgrade/preupgrade_fixups.sql
Executing Oracle PRE-Upgrade Fixup Script
Auto-Generated by: Oracle Preupgrade Script
Version: 19.0.0.0.0 Build: 1
Generated on: 2019-09-18 13:55:58
For Source Database: TEST
Source Database Version: 12.2.0.1.0
For Upgrade to Version: 19.0.0.0.0
Preup Preupgrade
Action Issue Is
Number Preupgrade Check Name Remedied Further DBA Action
------ ------------------------ ---------- --------------------------------
1. min_recovery_area_size NO Manual fixup required.
2. dictionary_stats YES None.
3. tablespaces_info NO Informational only.
Further action is optional.
4. rman_recovery_version NO Informational only.
Further action is optional.
The fixup scripts have been run and resolved what they can. However,
there are still issues originally identified by the preupgrade that
have not been remedied and are still present in the database.
Depending on the severity of the specific issue, and the nature of
the issue itself, that could mean that your database is not ready
for upgrade. To resolve the outstanding issues, start by reviewing
the preupgrade_fixups.sql and searching it for the name of
the failed CHECK NAME or Preupgrade Action Number listed above.
There you will find the original corresponding diagnostic message
from the preupgrade which explains in more detail what still needs
to be done.
PL/SQL procedure successfully completed.
5.Stop LISTENER
[oracle@localhost] lsntctl stop listener
6.Ceate Flashback Guaranteed Restore Point
SQL> create restore point pre_upgrade guarantee flashback database;
Restore point created.
SQL> select NAME,GUARANTEE_FLASHBACK_DATABASE,TIME from V$restore_point;
7.Shutdown Database
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
8.Copy init and password files from 11g to 12c dbs home
[oracle@localhost dbs]$ cp orapwtest inittest.ora /u01/app/oracle/product/1930/dbhome_1/dbs
9.Startup DB in Upgrade mode
[oracle@localhost dbs]$ export ORACLE_HOME=/u01/app/oracle/product/1930/dbhome_1
[oracle@localhost dbs]$ export ORACLE_SID=test
[oracle@localhost dbs]$ export PATH=$ORACLE_HOME/bin:$PATH
[oracle@localhost dbs]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Sep 18 14:06:24 2019
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup upgrade;
ORACLE instance started.
Total System Global Area 1157627168 bytes
Fixed Size 8895776 bytes
Variable Size 318767104 bytes
Database Buffers 822083584 bytes
Redo Buffers 7880704 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
10.Run catctl.pl with catupgrd.sql
[oracle@localhost dbs]$ cd $ORACLE_HOME/ rdbms/admin/
[oracle@localhost admin]$ $ORACLE_HOME/perl/bin/perl catctl.pl -n 8 catupgrd.sql
Argument list for [catctl.pl]
For Oracle internal use only A = 0
Run in c = 0
Do not run in C = 0
Input Directory d = 0
Echo OFF e = 1
Simulate E = 0
Forced cleanup F = 0
Log Id i = 0
Child Process I = 0
Log Dir l = 0
Priority List Name L = 0
Upgrade Mode active M = 0
SQL Process Count n = 8
SQL PDB Process Count N = 0
Open Mode Normal o = 0
Start Phase p = 0
End Phase P = 0
Reverse Order r = 0
AutoUpgrade Resume R = 0
Script s = 0
Serial Run S = 0
RO User Tablespaces T = 0
Display Phases y = 0
Debug catcon.pm z = 0
Debug catctl.pl Z = 0
catctl.pl VERSION: [19.0.0.0.0]
STATUS: [Production]
BUILD: [RDBMS_19.3.0.0.0DBRU_LINUX.X64_190417
/u01/app/oracle/product/1930/dbhome_1/rdbms/admin/orahome = [/u01/app/oracle/product/1930/dbhome_1]
/u01/app/oracle/product/1930/dbhome_1/bin/orabasehome = [/u01/app/oracle/product/1930/dbhome_1]
catctlGetOraBaseLogDir = [/u01/app/oracle/product/1930/dbhome_1]
Analyzing file /u01/app/oracle/product/1930/dbhome_1/rdbms/admin/catupgrd.sql
Log file directory = [/tmp/cfgtoollogs/upgrade20190918140958]
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/tmp/cfgtoollogs/upgrade20190918140958/catupgrd_catcon_10872.lst]
catcon::set_log_file_base_path: catcon: See [/tmp/cfgtoollogs/upgrade20190918140958/catupgrd*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/tmp/cfgtoollogs/upgrade20190918140958/catupgrd_*.lst] files for spool files, if any
Number of Cpus = 2
Database Name = test
DataBase Version = 12.2.0.1.0
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/u01/app/oracle/product/1930/dbhome_1/cfgtoollogs/test/upgrade20190918141013/catupgrd_catcon_10872.lst]
catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/1930/dbhome_1/cfgtoollogs/test/upgrade20190918141013/catupgrd*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/1930/dbhome_1/cfgtoollogs/test/upgrade20190918141013/catupgrd_*.lst] files for spool files, if any
Log file directory = [/u01/app/oracle/product/1930/dbhome_1/cfgtoollogs/test/upgrade20190918141013]
Parallel SQL Process Count = 8
Components in [test]
Installed [APS CATALOG CATJAVA CATPROC CONTEXT DV JAVAVM OLS ORDIM OWM SDO XDB XML XOQ]
Not Installed [APEX EM MGW ODM RAC WK]
------------------------------------------------------
Phases [0-107] Start Time:[2019_09_18 14:10:27]
------------------------------------------------------
*********** Executing Change Scripts ***********
Serial Phase #:0 [test] Files:1 Time: 123s
*************** Catalog Core SQL ***************
Serial Phase #:1 [test] Files:5 Time: 118s
Restart Phase #:2 [test] Files:1 Time: 6s
*********** Catalog Tables and Views ***********
Parallel Phase #:3 [test] Files:19 Time: 51s
Restart Phase #:4 [test] Files:1 Time: 4s
************* Catalog Final Scripts ************
Serial Phase #:5 [test] Files:7 Time: 54s
***************** Catproc Start ****************
Serial Phase #:6 [test] Files:1 Time: 41s
***************** Catproc Types ****************
Serial Phase #:7 [test] Files:2 Time: 48s
Restart Phase #:8 [test] Files:1 Time: 5s
**************** Catproc Tables ****************
Parallel Phase #:9 [test] Files:67 Time: 63s
Restart Phase #:10 [test] Files:1 Time: 6s
************* Catproc Package Specs ************
Serial Phase #:11 [test] Files:1 Time: 233s
Restart Phase #:12 [test] Files:1 Time: 3s
************** Catproc Procedures **************
Parallel Phase #:13 [test] Files:94 Time: 24s
Restart Phase #:14 [test] Files:1 Time: 5s
Parallel Phase #:15 [test] Files:120 Time: 85s
Restart Phase #:16 [test] Files:1 Time: 5s
Serial Phase #:17 [test] Files:22 Time: 36s
Restart Phase #:18 [test] Files:1 Time: 5s
***************** Catproc Views ****************
Parallel Phase #:19 [test] Files:32 Time: 109s
Restart Phase #:20 [test] Files:1 Time: 8s
Serial Phase #:21 [test] Files:3 Time: 108s
Restart Phase #:22 [test] Files:1 Time: 5s
Parallel Phase #:23 [test] Files:25 Time: 390s
Restart Phase #:24 [test] Files:1 Time: 4s
Parallel Phase #:25 [test] Files:12 Time: 229s
Restart Phase #:26 [test] Files:1 Time: 4s
Serial Phase #:27 [test] Files:1 Time: 0s
Serial Phase #:28 [test] Files:3 Time: 11s
Serial Phase #:29 [test] Files:1 Time: 0s
Restart Phase #:30 [test] Files:1 Time: 6s
*************** Catproc CDB Views **************
Serial Phase #:31 [test] Files:1 Time: 3s
Restart Phase #:32 [test] Files:1 Time: 5s
Serial Phase #:34 [test] Files:1 Time: 0s
***************** Catproc PLBs *****************
Serial Phase #:35 [test] Files:293 Time: 91s
Serial Phase #:36 [test] Files:1 Time: 0s
Restart Phase #:37 [test] Files:1 Time: 4s
Serial Phase #:38 [test] Files:6 Time: 15s
Restart Phase #:39 [test] Files:1 Time: 5s
*************** Catproc DataPump ***************
Serial Phase #:40 [test] Files:3 Time: 128s
Restart Phase #:41 [test] Files:1 Time: 6s
****************** Catproc SQL *****************
Parallel Phase #:42 [test] Files:13 Time: 239s
Restart Phase #:43 [test] Files:1 Time: 8s
Parallel Phase #:44 [test] Files:11 Time: 21s
Restart Phase #:45 [test] Files:1 Time: 4s
Parallel Phase #:46 [test] Files:3 Time: 5s
Restart Phase #:47 [test] Files:1 Time: 4s
************* Final Catproc scripts ************
Serial Phase #:48 [test] Files:1 Time: 21s
Restart Phase #:49 [test] Files:1 Time: 4s
************** Final RDBMS scripts *************
Serial Phase #:50 [test] Files:1 Time: 8s
************ Upgrade Component Start ***********
Serial Phase #:51 [test] Files:1 Time: 2s
Restart Phase #:52 [test] Files:1 Time: 4s
********** Upgrading Java and non-Java *********
Serial Phase #:53 [test] Files:2 Time: 712s
***************** Upgrading XDB ****************
Restart Phase #:54 [test] Files:1 Time: 5s
Serial Phase #:56 [test] Files:3 Time: 17s
Serial Phase #:57 [test] Files:3 Time: 10s
Parallel Phase #:58 [test] Files:10 Time: 9s
Parallel Phase #:59 [test] Files:25 Time: 20s
Serial Phase #:60 [test] Files:4 Time: 19s
Serial Phase #:61 [test] Files:1 Time: 0s
Serial Phase #:62 [test] Files:32 Time: 12s
Serial Phase #:63 [test] Files:1 Time: 0s
Parallel Phase #:64 [test] Files:6 Time: 10s
Serial Phase #:65 [test] Files:2 Time: 51s
Serial Phase #:66 [test] Files:3 Time: 65s
**************** Upgrading ORDIM ***************
Restart Phase #:67 [test] Files:1 Time: 4s
Serial Phase #:69 [test] Files:1 Time: 6s
Parallel Phase #:70 [test] Files:2 Time: 80s
Restart Phase #:71 [test] Files:1 Time: 4s
Parallel Phase #:72 [test] Files:2 Time: 5s
Serial Phase #:73 [test] Files:2 Time: 5s
***************** Upgrading SDO ****************
Restart Phase #:74 [test] Files:1 Time: 4s
Serial Phase #:76 [test] Files:1 Time: 109s
Serial Phase #:77 [test] Files:2 Time: 6s
Restart Phase #:78 [test] Files:1 Time: 4s
Serial Phase #:79 [test] Files:1 Time: 104s
Restart Phase #:80 [test] Files:1 Time: 7s
Parallel Phase #:81 [test] Files:3 Time: 169s
Restart Phase #:82 [test] Files:1 Time: 5s
Serial Phase #:83 [test] Files:1 Time: 16s
Restart Phase #:84 [test] Files:1 Time: 3s
Serial Phase #:85 [test] Files:1 Time: 33s
Restart Phase #:86 [test] Files:1 Time: 4s
Parallel Phase #:87 [test] Files:4 Time: 240s
Restart Phase #:88 [test] Files:1 Time: 5s
Serial Phase #:89 [test] Files:1 Time: 5s
Restart Phase #:90 [test] Files:1 Time: 4s
Serial Phase #:91 [test] Files:2 Time: 21s
Restart Phase #:92 [test] Files:1 Time: 4s
Serial Phase #:93 [test] Files:1 Time: 3s
Restart Phase #:94 [test] Files:1 Time: 3s
******* Upgrading ODM, WK, EXF, RUL, XOQ *******
Serial Phase #:95 [test] Files:1 Time: 40s
Restart Phase #:96 [test] Files:1 Time: 3s
*********** Final Component scripts ***********
Serial Phase #:97 [test] Files:1 Time: 6s
************* Final Upgrade scripts ************
Serial Phase #:98 [test] Files:1 Time: 603s
******************* Migration ******************
Serial Phase #:99 [test] Files:1 Time: 4s
*** End PDB Application Upgrade Pre-Shutdown ***
Serial Phase #:100 [test] Files:1 Time: 3s
Serial Phase #:101 [test] Files:1 Time: 0s
Serial Phase #:102 [test] Files:1 Time: 92s
***************** Post Upgrade *****************
Serial Phase #:103 [test] Files:1 Time: 74s
**************** Summary report ****************
Serial Phase #:104 [test] Files:1 Time: 10s
*** End PDB Application Upgrade Post-Shutdown **
Serial Phase #:105 [test] Files:1 Time: 3s
Serial Phase #:106 [test] Files:1 Time: 0s
Serial Phase #:107 [test] Files:1 Time: 30s
------------------------------------------------------
Phases [0-107] End Time:[2019_09_18 15:34:04]
------------------------------------------------------
Grand Total Time: 5022s
LOG FILES: (/u01/app/oracle/product/1930/dbhome_1/cfgtoollogs/test/upgrade20190918141013/catupgrd*.log)
Upgrade Summary Report Located in:
/u01/app/oracle/product/1930/dbhome_1/cfgtoollogs/test/upgrade20190918141013/upg_summary.log
Grand Total Upgrade Time: [0d:1h:23m:42s]
[oracle@localhost admin]$ sqlplus / as sysdba
11.Run postupgrade_fixups.sql
SQL> @/u01/app/oracle/cfgtoollogs/test/preupgrade/postupgrade_fixups.sql
Session altered.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Package created.
No errors.
Package body created.
PL/SQL procedure successfully completed.
No errors.
Package created.
No errors.
Package body created.
No errors.
Executing Oracle POST-Upgrade Fixup Script
Auto-Generated by: Oracle Preupgrade Script
Version: 19.0.0.0.0 Build: 1
Generated on: 2019-09-18 13:56:28
For Source Database: TEST
Source Database Version: 12.2.0.1.0
For Upgrade to Version: 19.0.0.0.0
Preup Preupgrade
Action Issue Is
Number Preupgrade Check Name Remedied Further DBA Action
------ ------------------------ ---------- --------------------------------
5. old_time_zones_exist NO Manual fixup recommended.
6. dir_symlinks YES None.
7. post_dictionary YES None.
8. post_fixed_objects NO Informational only.
Further action is optional.
The fixup scripts have been run and resolved what they can. However,
there are still issues originally identified by the preupgrade that
have not been remedied and are still present in the database.
Depending on the severity of the specific issue, and the nature of
the issue itself, that could mean that your database upgrade is not
fully complete. To resolve the outstanding issues, start by reviewing
the postupgrade_fixups.sql and searching it for the name of
the failed CHECK NAME or Preupgrade Action Number listed above.
There you will find the original corresponding diagnostic message
from the preupgrade which explains in more detail what still needs
to be done.
PL/SQL procedure successfully completed.
Session altered.
12.Run catuppst.sql
@/u01/app/oracle/product/19300/dbhome_1/rdbms/admin/catuppst.sql
13.Drop Restore point
SQL> drop restore point PRE_UPGRADE;
Restore point dropped.
14.Restart the database
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1157627168 bytes
Fixed Size 8895776 bytes
Variable Size 318767104 bytes
Database Buffers 822083584 bytes
Redo Buffers 7880704 bytes
Database mounted.
Database opened.
15.Start Listener from 19c home
[oracle@localhost] lsntctl start listener
16.Verify DBA_REGISTRY
SQL> select name,open_mode,version from v$database,v$instance;
NAME OPEN_MODE VERSION
--------- -------------------- -----------------
TEST READ WRITE 19.0.0.0.0
SQL> select COMP_ID,COMP_NAME,VERSION,STATUS from dba_registry;
COMP_ID COMP_NAME VERSION STATUS
---------- ---------------------------------------- --------------- ------------ --------------------------------
CATALOG Oracle Database Catalog Views 19.0.0.0.0 UPGRADED
CATPROC Oracle Database Packages and Types 19.0.0.0.0 UPGRADED
JAVAVM JServer JAVA Virtual Machine 19.0.0.0.0 UPGRADED
XML Oracle XDK 19.0.0.0.0 UPGRADED
CATJAVA Oracle Database Java Packages 19.0.0.0.0 UPGRADED
APS OLAP Analytic Workspace 19.0.0.0.0 UPGRADED
RAC Oracle Real Application Clusters 19.0.0.0.0 UPGRADED
XDB Oracle XML Database 19.0.0.0.0 UPGRADED
OWM Oracle Workspace Manager 19.0.0.0.0 UPGRADED
CONTEXT Oracle Text 19.0.0.0.0 UPGRADED
ORDIM Oracle Multimedia 19.0.0.0.0 UPGRADED
SDO Spatial 19.0.0.0.0 UPGRADED
XOQ Oracle OLAP API 19.0.0.0.0 UPGRADED
OLS Oracle Label Security 19.0.0.0.0 UPGRADED
DV Oracle Database Vault 19.0.0.0.0 UPGRADED
15 rows selected.
17.Edit oratab
test:/u01/app/oracle/product/12.2.0/dbhome_1:N
test:/u01/app/oracle/product/1930/dbhome_1:N
No comments:
Post a Comment