一元云购网站建设模块/网站流量排行
1.组件信息
source /home/oracle/.bash_profile11g && sqlplus "/ as sysdba"<<EOF
set line 200
col COMP_NAME for a40
select comp_name,VERSION,STATUS from dba_registry;
exit;
EOF
COMP_NAME VERSION STATUS
---------------------------------------- ------------------------------ ----------------------
OWB 11.2.0.4.0 VALID
Oracle Application Express 3.2.1.00.12 VALID
Oracle Enterprise Manager 11.2.0.4.0 VALID
OLAP Catalog 11.2.0.4.0 VALID
Spatial 11.2.0.4.0 VALID
Oracle Multimedia 11.2.0.4.0 VALID
Oracle XML Database 11.2.0.4.0 VALID
Oracle Text 11.2.0.4.0 VALID
Oracle Expression Filter 11.2.0.4.0 VALID
Oracle Rules Manager 11.2.0.4.0 VALID
Oracle Workspace Manager 11.2.0.4.0 VALID
COMP_NAME VERSION STATUS
---------------------------------------- ------------------------------ ----------------------
Oracle Database Catalog Views 11.2.0.4.0 VALID
Oracle Database Packages and Types 11.2.0.4.0 VALID
JServer JAVA Virtual Machine 11.2.0.4.0 VALID
Oracle XDK 11.2.0.4.0 VALID
Oracle Database Java Packages 11.2.0.4.0 VALID
OLAP Analytic Workspace 11.2.0.4.0 VALID
Oracle OLAP API 11.2.0.4.0 VALID
18 rows selected.
废弃的组件：EM
从18c开始,Oracle不会自动更新APEX组件，需要手动更新。
OLAP删除
2.查看刷新的物化视图
source /home/oracle/.bash_profile11g && sqlplus "/ as sysdba"<<EOF
SELECT o.name FROM sys.obj$ o, sys.user$ u, sys.sum$ s WHERE o.type# = 42 AND bitand(s.mflags, 8) =8;
exit;
EOF
升级前确保无物化视图正在刷新
SQL> SELECT o.name FROM sys.obj$ o, sys.user$ u, sys.sum$ s WHERE o.type# = 42 AND bitand(s.mflags, 8) =8;
no rows selected
3.删除EM组件
source /home/oracle/.bash_profile11g && emctl stop dbconsole &&sqlplus '/ as sysdba'<<EOF
SET ECHO ON;
SET SERVEROUTPUT ON;
@/u01/app/oracle/product/19c/dbhome_1/rdbms/admin/emremove.sql
exit;
EOF
$ cd $ORACLE_HOME
$ rm -rf HOSTNAME_SID
$ rm -rf oc4j/j2ee/OC4J_DBConsole_HOSTNAME_SID
结果：
[oracle@19crac1 ~]$ source /home/oracle/.bash_profile11g && sqlplus '/ as sysdba'<<EOF
> @/u01/app/oracle/product/19c/dbhome_1/rdbms/admin/emremove.sql
> exit;
> EOF
SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 9 17:31:40 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> old 70: IF (upper('&LOGGING') = 'VERBOSE')
new 70: IF (upper('VERBOSE') = 'VERBOSE')
PL/SQL procedure successfully completed.
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
4.删除OLAP组件
source /home/oracle/.bash_profile11g && sqlplus "/ as sysdba"<<EOF
@?/olap/admin/catnoamd.sql;
exit;
EOF
5.手动升级APEX组件
Ø 下载补丁包：http://www.oracle.com/technetwork/developer-tools/apex/all-archives-099381.html
[oracle@19crac1 ~]$ source .bash_profile11g
[oracle@19crac1 ~]$ cd apex
[oracle@19crac1 apex]$ ls -ltr
[oracle@19crac1 apex]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 9 20:16:40 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> @apexins.sql SYSAUX SYSAUX TEMP /i/
...set_appun.sql
PL/SQL procedure successfully completed.
检查APEX版本
source /home/oracle/.bash_profile11g && sqlplus '/ as sysdba'<<EOF
COL COMP_NAME FORMAT A40
COL STATUS FORMAT A12
Set lines 200
SELECT COMP_NAME, STATUS, VERSION FROM DBA_REGISTRY WHERE COMP_NAME='Oracle Application Express';
exit;
EOF
结果
COMP_NAME STATUS VERSION
---------------------------------------- ------------ ------------------------------
Oracle Application Express VALID 3.2.1.00.12
Ø 一定要注意归档空间的使用率，有可能归档满了，升级卡住
Ø 详细日志
6.确认兼容性参数
source /home/oracle/.bash_profile11g && sqlplus '/ as sysdba'<<EOF
show parameter compatible;
exit;
EOF
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL>
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 11.2.0.4.0
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
注意升级 19c 的 COMPATIBLE 参数的最小值为“11.2.0”, 确保您的 COMPATIBLE 参数设置为11.2.0或更高
7.配置FRA
source /home/oracle/.bash_profile11g && sqlplus '/ as sysdba'<<EOF
show parameter db_recovery_file_dest;
exit;
EOF
8.清理回收站
source /home/oracle/.bash_profile11g && sqlplus "/ as sysdba"<<EOF
purge dba_recyclebin;
exit;
EOF
9.创建闪回点
source /home/oracle/.bash_profile11g && sqlplus "/ as sysdba"<<EOF
create restore point syncdb_20200924_19c guarantee flashback database;
select name,guarantee_flashback_database,to_char(scn) from v\$restore_point;
exit;
EOF
结果：
SQL>
Restore point created.
SQL>
NAME
--------------------------------------------------------------------------------
GUA TO_CHAR(SCN)
--- ----------------------------------------
SYNCDB_20200924_19C
YES 994270
10.收集数据字典统计信息
source /home/oracle/.bash_profile11g && sqlplus '/ as sysdba'<<EOF
EXECUTE DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;
EXECUTE DBMS_STATS.GATHER_DICTIONARY_STATS;
exit;
EOF
11.备份数据库
$ . .bash_profile11g
$ rman target /
RUN
{
ALLOCATE CHANNEL chan_name TYPE DISK;
BACKUP DATABASE FORMAT '/tmp/orcl_2_%U' TAG before_upgrade;
BACKUP CURRENT CONTROLFILE FORMAT '/tmp/controlfile';
}
12.升级前预检查
拷贝jar到/tmp
19c环境
[root@19crac1 ~]# su - oracle
[oracle@19crac1 ~]$ cp /u01/app/oracle/product/19c/dbhome_1/rdbms/admin/preupgrade.jar /tmp
11g环境下执行
source /home/oracle/.bash_profile11g && mkdir -p /home/oracle/nxtest/log && $ORACLE_HOME/jdk/bin/java -jar /tmp/preupgrade.jar FILE TEXT DIR /home/oracle/nxtest/log
结果：
==================
PREUPGRADE SUMMARY
==================
/home/oracle/nxtest/log/preupgrade.log
/home/oracle/nxtest/log/preupgrade_fixups.sql
/home/oracle/nxtest/log/postupgrade_fixups.sql
Execute fixup scripts as indicated below:
Before upgrade:
Log into the database and execute the preupgrade fixups
@/home/oracle/nxtest/log/preupgrade_fixups.sql
After the upgrade:
Log into the database and execute the postupgrade fixups
@/home/oracle/nxtest/log/postupgrade_fixups.sql
Preupgrade complete: 2020-09-24T11:07:15
13.执行升级前修复脚本
[oracle@19crac1 ~]$ source .bash_profile11g
[oracle@19crac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 9 20:56:30 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> @/home/oracle/nxtest/log/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: 2020-09-24 11:07:11
For Source Database: ORCL
Source Database Version: 11.2.0.4.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. parameter_min_val NO Manual fixup recommended.
3. em_present NO Manual fixup recommended.
4. invalid_objects_exist NO Manual fixup recommended.
5. apex_manual_upgrade NO Manual fixup recommended.
6. trgowner_no_admndbtrg YES None.
7. tablespaces_info NO Informational only.
Further action is optional.
8. exf_rul_exists NO Informational only.
Further action is optional.
9. 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.
14.修改废弃参数（此步骤在前面可以避免）
删除19c废弃或者不兼容的参数
source /home/oracle/.bash_profile11g && sqlplus "/ as sysdba"<<EOF
alter system set sec_case_sensitive_logon=true;
exit;
EOF
15.修改oratab文件
echo "orcl:/u02/app/oracle/product/11.2.0/dbhome_1:N">>/etc/oratab
deep:/u01/app/oracle/product/19.3.0/db_1:N
prod:/u01/app/oracle/product/12.2.0/db_1:N
orcl:/u01/app/oracle/product/11.2.0/db_1:N
16.拷贝spfile至19c的home dbs下，并重启库至upgrade
[oracle@19crac1 nxtest]$ cp /u02/app/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl1.ora /u01/app/oracle/product/19c/dbhome_1/dbs/
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 1002437904 bytes
Fixed Size 8903952 bytes
Variable Size 276824064 bytes
Database Buffers 708837376 bytes
Redo Buffers 7872512 bytes
Database mounted.
Database opened.
17.执行升级脚本（19c目录下）
[oracle@19crac1 nxtest]$ cd $ORACLE_HOME
[oracle@19crac1 dbhome_1]$ cd bin/
[oracle@19crac1 bin]$ ./dbupgrade -n 4 -l /home/oracle/nxtest
结果
Argument list for [/u01/app/oracle/product/19c/dbhome_1/rdbms/admin/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 = /home/oracle/nxtest –日志文件存放位置
Priority List Name L = 0
Upgrade Mode active M = 0
SQL Process Count n = 4 --和CPU_COUNT参数一样即可
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.4.0.0.0DBRU_LINUX.X64_190626]
/u01/app/oracle/product/19c/dbhome_1/rdbms/admin/orahome = [/u01/app/oracle/product/19c/dbhome_1]
/u01/app/oracle/product/19c/dbhome_1/bin/orabasehome = [/u01/app/oracle/product/19c/dbhome_1]
catctlGetOraBaseLogDir = [/u01/app/oracle/product/19c/dbhome_1]
Analyzing file /u01/app/oracle/product/19c/dbhome_1/rdbms/admin/catupgrd.sql
Log file directory = [/home/oracle/nxtest]
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/home/oracle/nxtest/catupgrd_catcon_73530.lst]
catcon::set_log_file_base_path: catcon: See [/home/oracle/nxtest/catupgrd*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/home/oracle/nxtest/catupgrd_*.lst] files for spool files, if any
Number of Cpus = 2
Database Name = orcldg
DataBase Version = 11.2.0.4.0
Parallel SQL Process Count = 4
Components in [orcldg]
Installed [APEX APS CATALOG CATJAVA CATPROC CONTEXT JAVAVM ORDIM OWM SDO XDB XML XOQ]
Not Installed [DV EM MGW ODM OLS RAC WK]
------------------------------------------------------
Phases [0-107] Start Time:[2019_12_11 09:00:06]
------------------------------------------------------
*********** Executing Change Scripts ***********
Serial Phase #:0 [orcldg] Files:1 Time: 81s
*************** Catalog Core SQL ***************
Serial Phase #:1 [orcldg] Files:5 Time: 34s
Restart Phase #:2 [orcldg] Files:1 Time: 1s
*********** Catalog Tables and Views ***********
Parallel Phase #:3 [orcldg] Files:19 Time: 14s
Restart Phase #:4 [orcldg] Files:1 Time: 2s
************* Catalog Final Scripts ************
Serial Phase #:5 [orcldg] Files:7 Time: 11s
***************** Catproc Start ****************
Serial Phase #:6 [orcldg] Files:1 Time: 11s
***************** Catproc Types ****************
Serial Phase #:7 [orcldg] Files:2 Time: 8s
Restart Phase #:8 [orcldg] Files:1 Time: 1s
**************** Catproc Tables ****************
Parallel Phase #:9 [orcldg] Files:67 Time: 23s
Restart Phase #:10 [orcldg] Files:1 Time: 3s
************* Catproc Package Specs ************
Serial Phase #:11 [orcldg] Files:1 Time: 42s
Restart Phase #:12 [orcldg] Files:1 Time: 1s
************** Catproc Procedures **************
Parallel Phase #:13 [orcldg] Files:94 Time: 6s
Restart Phase #:14 [orcldg] Files:1 Time: 1s
Parallel Phase #:15 [orcldg] Files:121 Time: 9s
Restart Phase #:16 [orcldg] Files:1 Time: 1s
Serial Phase #:17 [orcldg] Files:22 Time: 3s
Restart Phase #:18 [orcldg] Files:1 Time: 2s
***************** Catproc Views ****************
Parallel Phase #:19 [orcldg] Files:32 Time: 13s
Restart Phase #:20 [orcldg] Files:1 Time: 3s
。。。。。。
*************** Catproc CDB Views **************
Serial Phase #:31 [orcldg] Files:1 Time: 2s
Restart Phase #:32 [orcldg] Files:1 Time: 2s
Serial Phase #:34 [orcldg] Files:1 Time: 0s
***************** Catproc PLBs *****************
Serial Phase #:35 [orcldg] Files:294 Time: 16s
Serial Phase #:36 [orcldg] Files:1 Time: 0s
Restart Phase #:37 [orcldg] Files:1 Time: 1s
Serial Phase #:38 [orcldg] Files:6 Time: 5s
Restart Phase #:39 [orcldg] Files:1 Time: 0s
*************** Catproc DataPump ***************
Serial Phase #:40 [orcldg] Files:3 Time: 35s
Restart Phase #:41 [orcldg] Files:1 Time: 1s
****************** Catproc SQL *****************
Parallel Phase #:42 [orcldg] Files:13 Time: 84s
Restart Phase #:43 [orcldg] Files:1 Time: 2s
Parallel Phase #:44 [orcldg] Files:11 Time: 9s
Restart Phase #:45 [orcldg] Files:1 Time: 3s
Parallel Phase #:46 [orcldg] Files:3 Time: 3s
Restart Phase #:47 [orcldg] Files:1 Time: 2s
************* Final Catproc scripts ************
Serial Phase #:48 [orcldg] Files:1 Time: 7s
Restart Phase #:49 [orcldg] Files:1 Time: 2s
************** Final RDBMS scripts *************
Serial Phase #:50 [orcldg] Files:1 Time: 12s
************ Upgrade Component Start ***********
Serial Phase #:51 [orcldg] Files:1 Time: 2s
Restart Phase #:52 [orcldg] Files:1 Time: 2s
********** Upgrading Java and non-Java *********
Serial Phase #:53 [orcldg] Files:2 Time: 283s
***************** Upgrading XDB ****************
Restart Phase #:54 [orcldg] Files:1 Time: 2s
Serial Phase #:56 [orcldg] Files:3 Time: 19s
Serial Phase #:57 [orcldg] Files:3 Time: 5s
。。。。。。
**************** Upgrading ORDIM ***************
Restart Phase #:67 [orcldg] Files:1 Time: 2s
Serial Phase #:69 [orcldg] Files:1 Time: 5s
Parallel Phase #:70 [orcldg] Files:2 Time: 29s
。。。。。
***************** Upgrading SDO ****************
Restart Phase #:74 [orcldg] Files:1 Time: 1s
Serial Phase #:76 [orcldg] Files:1 Time: 30s
Serial Phase #:77 [orcldg] Files:2 Time: 5s
。。。。。。
******* Upgrading ODM, WK, EXF, RUL, XOQ *******
Serial Phase #:95 [orcldg] Files:1 Time: 11s
Restart Phase #:96 [orcldg] Files:1 Time: 2s
*********** Final Component scripts ***********
Serial Phase #:97 [orcldg] Files:1 Time: 3s
************* Final Upgrade scripts ************
Serial Phase #:98 [orcldg] Files:1 Time: 274s
******************* Migration ******************
Serial Phase #:99 [orcldg] Files:1 Time: 34s
*** End PDB Application Upgrade Pre-Shutdown ***
Serial Phase #:100 [orcldg] Files:1 Time: 2s
Serial Phase #:101 [orcldg] Files:1 Time: 0s
Serial Phase #:102 [orcldg] Files:1 Time: 60s
***************** Post Upgrade *****************
Serial Phase #:103 [orcldg] Files:1 Time: 22s
**************** Summary report ****************
Serial Phase #:104 [orcldg] Files:1 Time: 3s
*** End PDB Application Upgrade Post-Shutdown **
Serial Phase #:105 [orcldg] Files:1 Time: 2s
Serial Phase #:106 [orcldg] Files:1 Time: 0s
Serial Phase #:107 [orcldg] Files:1 Time: 40s
------------------------------------------------------
Phases [0-107] End Time:[2019_12_11 09:30:19]
------------------------------------------------------
Grand Total Time: 1814s
LOG FILES: (/home/oracle/nxtest/catupgrd*.log)
Upgrade Summary Report Located in:
/home/oracle/nxtest/upg_summary.log
Grand Total Upgrade Time: [0d:0h:30m:14s]
18.启动数据库
SQL> startup ORACLE instance started.
Total System Global Area 1002437904 bytes
Fixed Size 8903952 bytes
Variable Size 276824064 bytes
Database Buffers 708837376 bytes
Redo Buffers 7872512 bytes
Database mounted.
Database opened.
19.执行升级后修复脚本
SQL> @/home/oracle/nxtest/log/postupgrade_fixups.sql
结果：
[oracle@19crac1 log]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Dec 11 09:46:37 2019
Version 19.4.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.4.0.0.0
SQL> @/home/oracle/nxtest/log/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-12-10 16:07:18
For Source Database: ORCL
Source Database Version: 11.2.0.4.0
For Upgrade to Version: 19.0.0.0.0
Preup Preupgrade
Action Issue Is
Number Preupgrade Check Name Remedied Further DBA Action
------ ------------------------ ---------- --------------------------------
19. old_time_zones_exist NO Manual fixup recommended.
20. post_dictionary YES None.
21. post_fixed_objects NO Informational only.
Further action is optional.
22. upg_by_std_upgrd YES None.
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.
20.数据库状态查询
Col Comp_name Format a22
Col Status Format a12
Select Comp_name, status, Version
From Dba_Registry
Order by Comp_name;
set line 200
col COMP_ID format a10
col COMP_NAME format a35
select substr(comp_id,1,15) comp_id,substr(comp_name,1,30)
comp_name,substr(version,1,10) version,status
from dba_registry order by modified;
编译无效对象：
@?/rdbms/admin/utlrp.sql
注意: 之前版本的 utluNNNs.sql 在 19c 上被替换为 utlusts.sql
SQL> @?/rdbms/admin/utlusts.sql
结果：
（1）注意这里的提示：大部分的组件状态都为upgrade，重新编译即可。
（2）标数据库的 time zone 文件版本比较老了，需要手动升级
21.升级time zine文件版本
echo "orcl:/u02/app/oracle/product/11.2.0/dbhome_1:N">>/etc/oratab
19c此升级脚本数据库自带
@?/rdbms/admin/utltz_upg_check.sql ---检查当前版本
@?/rdbms/admin/utltz_upg_apply.sql --更新应用
结果：
SQL> @?/rdbms/admin/utltz_upg_check.sql
Session altered.
INFO: Starting with RDBMS DST update preparation.
INFO: NO actual RDBMS DST update will be done by this script.
INFO: If an ERROR occurs the script will EXIT sqlplus.
INFO: Doing checks for known issues ...
INFO: Database version is 19.0.0.0 .
INFO: Database RDBMS DST version is DSTv14 .
INFO: No known issues detected.
INFO: Now detecting new RDBMS DST version.
A prepare window has been successfully started.
INFO: Newest RDBMS DST version detected is DSTv32 .
INFO: Next step is checking all TSTZ data.
INFO: It might take a while before any further output is seen ...
A prepare window has been successfully ended.
INFO: A newer RDBMS DST version than the one currently used is found.
INFO: Note that NO DST update was yet done.
INFO: Now run utltz_upg_apply.sql to do the actual RDBMS DST update.
INFO: Note that the utltz_upg_apply.sql script will
INFO: restart the database 2 times WITHOUT any confirmation or prompt.
Session altered.
SQL> @?/rdbms/admin/utltz_upg_apply.sql
Session altered.
INFO: If an ERROR occurs, the script will EXIT SQL*Plus.
INFO: The database RDBMS DST version will be updated to DSTv32 .
WARNING: This script will restart the database 2 times
WARNING: WITHOUT asking ANY confirmation.
WARNING: Hit control-c NOW if this is not intended.
INFO: Restarting the database in UPGRADE mode to start the DST upgrade.
Database closed.
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 1002437904 bytes
Fixed Size 8903952 bytes
Variable Size 612368384 bytes
Database Buffers 373293056 bytes
Redo Buffers 7872512 bytes
Database mounted.
Database opened.
INFO: Starting the RDBMS DST upgrade.
INFO: Upgrading all SYS owned TSTZ data.
INFO: It might take time before any further output is seen ...
An upgrade window has been successfully started.
INFO: Restarting the database in NORMAL mode to upgrade non-SYS TSTZ data.
Database closed.
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 1002437904 bytes
Fixed Size 8903952 bytes
Variable Size 612368384 bytes
Database Buffers 373293056 bytes
Redo Buffers 7872512 bytes
Database mounted.
Database opened.
INFO: Upgrading all non-SYS TSTZ data.
INFO: It might take time before any further output is seen ...
INFO: Do NOT start any application yet that uses TSTZ data!
INFO: Next is a list of all upgraded tables:
Table list: "MDSYS"."SDO_DIAG_MESSAGES_TABLE"
Number of failures: 0
Table list: "APEX_190200"."WWV_FLOW_ACTIVITY_LOG1$"
Number of failures: 0
Table list: "APEX_190200"."WWV_FLOW_ACTIVITY_LOG2$"
Number of failures: 0
Table list: "APEX_190200"."WWV_FLOW_DEBUG_MESSAGES"
Number of failures: 0
Table list: "APEX_190200"."WWV_FLOW_DEBUG_MESSAGES2"
Number of failures: 0
Table list: "APEX_190200"."WWV_FLOW_FEEDBACK"
Number of failures: 0
Table list: "APEX_190200"."WWV_FLOW_FEEDBACK_FOLLOWUP"
Number of failures: 0
Table list: "APEX_190200"."WWV_FLOW_ISSUE_NOTIFICATIONS"
Number of failures: 0
Table list: "APEX_190200"."WWV_FLOW_WORKSHEET_NOTIFY"
Number of failures: 0
Table list: "APEX_190200"."WWV_QS_RANDOM_NAMES"
Number of failures: 0
Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_L"
Number of failures: 0
Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_S"
Number of failures: 0
INFO: Total failures during update of TSTZ data: 0 .
An upgrade window has been successfully ended.
INFO: Your new Server RDBMS DST version is DSTv32 .
INFO: The RDBMS DST update is successfully finished.
INFO: Make sure to exit this SQL*Plus session.
INFO: Do not use it for timezone related selects.
Session altered.
SQL> SELECT version FROM v$timezone_file;
VERSION
----------
32
22.编译失效对象
执行 utlrp.sql (多次) 来使它们生效，直到失效对象的个数不再改变。
@?/rdbms/admin/utlrp.sql
23.再次查询数据库状态
SQL> @?/rdbms/admin/utlusts.sql
Oracle Database Release 19 Post-Upgrade Status Tool 12-11-2019 10:34:0
Database Name: ORCL
Component Current Full Elapsed Time
Name Status Version HH:MM:SS
Oracle Server VALID 19.4.0.0.0 00:11:33
JServer JAVA Virtual Machine VALID 19.4.0.0.0 00:02:42
Oracle XDK VALID 19.4.0.0.0 00:00:26
Oracle Database Java Packages VALID 19.4.0.0.0 00:00:10
OLAP Analytic Workspace VALID 19.4.0.0.0 00:00:08
Oracle Text VALID 19.4.0.0.0 00:00:26
Oracle Workspace Manager VALID 19.4.0.0.0 00:00:45
Oracle Real Application Clusters VALID 19.4.0.0.0 00:00:00
Oracle XML Database VALID 19.4.0.0.0 00:02:10
Oracle Multimedia VALID 19.4.0.0.0 00:00:39
Spatial VALID 19.4.0.0.0 00:03:05
Oracle OLAP API VALID 19.4.0.0.0 00:00:08
Datapatch 00:04:24
Final Actions 00:05:07
Post Upgrade 00:00:19
Post Compile 00:00:02
Total Upgrade Time: 00:28:23
Database time zone version is 32. It meets current release needs.
务必保证各个组件状态都为VALID
24.更新oratab文件
vi /etc/oratab
orcl:/u01/app/oracle/product/19c/dbhome_1:N
25.检查失效对象
SQL> select owner,object_type,count(*) from dba_objects where status='INVALID' group by owner,object_type order by owner,object_type;
OWNER OBJECT_TYPE COUNT(*)
--------------- ----------------------- ----------
APEX_190200 PACKAGE BODY 3
EXFSYS FUNCTION 8
EXFSYS PACKAGE BODY 5
EXFSYS PROCEDURE 6
EXFSYS TYPE 1
EXFSYS TYPE BODY 2
26.删除闪回点
drop restore point syncdb_20191209_19c;
27.单库配置为RAC
SQL> alter system set cluster_database=true scope=spfile;
SQL> create pfile='/tmp/orcl.ora' from spfile;
echo "orcl2.instance_number=2
orcl1.instance_number=1" >>/tmp/orcl.ora
SQL> create spfile='+datadg/orcldg/spfile.ora' from pfile='/tmp/orcl.ora';
SQL> shutdown immediate
[oracle@19crac1 log]$ srvctl add database -db orcl -dbname orcl -oraclehome /u01/app/oracle/product/19c/dbhome_1 -dbtype RAC -spfile '+datadg/orcldg/spfile.ora' -startoption open -stopoption immediate -diskgroup DATADG,ARCHDG
[oracle@19crac1 log]$ srvctl add instance -db orcl -instance orcl1 -n 19crac1
[oracle@19crac1 log]$ srvctl add instance -db orcl -instance orcl2 -n 19crac2
[oracle@19crac1 log]$ cd $ORACLE_HOME
[oracle@19crac1 dbhome_1]$ cd dbs
[oracle@19crac1 dbs]$ mv spfileorcl1.ora spfileorcl1.ora.bak
[oracle@19crac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Dec 11 11:04:16 2019
Version 19.4.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SQL> create spfile='+datadg/orcldg/spfile.ora' from pfile='/tmp/orcl.ora';
File created.
SQL> startup
ORACLE instance started.
Total System Global Area 1002437904 bytes
Fixed Size 8903952 bytes
Variable Size 612368384 bytes
Database Buffers 373293056 bytes
Redo Buffers 7872512 bytes
Database mounted.
Database opened.
修改service_name
SQL>alter system set service_name='orcl';--与源库保持一致
SQL> exit
节点二创建审计目录
[oracle@19crac2 dbs]cd /u01/app/oracle/admin/
[oracle@19crac2 dbs]mkdir -p orcldg/adump
[oracle@19crac2 dbs]SQL>startup
2个节点全部关闭数据库
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
用srvctl命令启动
[grid@19crac1 ~]$ srvctl start database -d orcl
资源状态：
[grid@19crac1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE 19crac1 STABLE
ONLINE ONLINE 19crac2 STABLE
ora.chad
ONLINE ONLINE 19crac1 STABLE
ONLINE ONLINE 19crac2 STABLE
ora.net1.network
ONLINE ONLINE 19crac1 STABLE
ONLINE ONLINE 19crac2 STABLE
ora.ons
ONLINE ONLINE 19crac1 STABLE
ONLINE ONLINE 19crac2 STABLE
ora.proxy_advm
OFFLINE OFFLINE 19crac1 STABLE
OFFLINE OFFLINE 19crac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.19crac1.vip
1 ONLINE ONLINE 19crac1 STABLE
ora.19crac2.vip
1 ONLINE ONLINE 19crac2 STABLE
ora.ARCHDG.dg(ora.asmgroup)
1 ONLINE ONLINE 19crac1 STABLE
2 ONLINE ONLINE 19crac2 STABLE
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE 19crac1 STABLE
2 ONLINE ONLINE 19crac2 STABLE
ora.DATADG.dg(ora.asmgroup)
1 ONLINE ONLINE 19crac1 STABLE
2 ONLINE ONLINE 19crac2 STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE 19crac1 STABLE
ora.OCRDG.dg(ora.asmgroup)
1 ONLINE ONLINE 19crac1 STABLE
2 ONLINE ONLINE 19crac2 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE 19crac1 Started,STABLE
2 ONLINE ONLINE 19crac2 Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE 19crac1 STABLE
2 ONLINE ONLINE 19crac2 STABLE
ora.cvu
1 ONLINE ONLINE 19crac1 STABLE
ora.orcl.db
1 ONLINE ONLINE 19crac1 Open,HOME=/u01/app/o
racle/product/19c/db
home_1,STABLE
2 ONLINE ONLINE 19crac2 Open,HOME=/u01/app/o
racle/product/19c/db
home_1,STABLE
ora.qosmserver
1 ONLINE ONLINE 19crac1 STABLE
ora.scan1.vip
1 ONLINE ONLINE 19crac1 STABLE
--------------------------------------------------------------------------------
28.调整密码文件位置
echo "orcl:/u02/app/oracle/product/11.2.0/dbhome_1:N">>/etc/oratab
[grid@19crac1 ~]$ asmcmd
ASMCMD> cd datadg
ASMCMD> pwcopy --dbuniquename orcl '/u02/app/oracle/product/11.2.0/dbhome_1/dbs/orapworcl1' '+datadg/orcldg/orapworcl'
copying /u02/app/oracle/product/11.2.0/dbhome_1/dbs/orapworcl1 -> +datadg/orcldg/orapworcl
ASMCMD-9453: failed to register password file as a CRS resource
29.手动注册crs资源（root用户）
[root@19crac1 ~]# cd /u01/app/19c/grid/bin/
[root@19crac1 bin]# ./srvctl modify database -d orcl -pwfile '+datadg/orcldg/orapworcl'
[root@19crac1 bin]# su - grid
Last login: Wed Dec 11 16:15:14 CST 2019
[grid@19crac1 ~]$ srvctl config database -d orcl
Database unique name: orcl
Database name: orcl
Oracle home: /u01/app/oracle/product/19c/dbhome_1
Oracle user: oracle
Spfile: +datadg/orcldg/spfile.ora
Password file: +datadg/orcldg/orapworcl
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATADG,ARCHDG
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: dba
Database instances: orcl1,orcl2
Configured nodes: 19crac1,19crac2
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
[grid@19crac1 ~]$
30.删除11204 db soft
[root@19crac1 bin]# rm -rf /u02
报错处理：https://www.cnblogs.com/djiankuo/p/6653180.html
[oracle@deep bin]$ ./dbupgrade -n 4 -l /home/oracle/nxtest
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = "",
LANG = "en_US.utf-8"
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
Argument list for [/u01/app/oracle/product/19.3.0/db_1/rdbms/admin/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 = /home/oracle/nxtest
Priority List Name L = 0
Upgrade Mode active M = 0
SQL Process Count n = 4
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]
相关文章：
Linux下Oracle 11g升级19c实录
1.组件信息 source /home/oracle/.bash_profile11g && sqlplus "/ as sysdba"<<EOF set line 200 col COMP_NAME for a40 select comp_name,VERSION,STATUS from dba_registry; exit; EOF COMP_NAME VERSION …...
haproxy实验-2
haproxy中的算法 静态算法：按照事先定义好的规则轮询公平调度，不关心后端服务器的当前负载、连接数和响应速度 等，且无法实时修改权重(只能为0和1,不支持其它值)，只能靠重启HAProxy生效。 static-rr：基于权重的轮询…...
動態PPTP代理IP是什麼？
PPTP即Point-to-Point Tunneling Protocol，點對點隧道協議，是一種常用的VPN協議，主要用於創建虛擬專用網路。通過將用戶的網路流量加密並通過一個中間伺服器傳輸，實現了對用戶IP地址的隱藏和數據的保護。而動態PPTP代理IP則是在傳…...
《全面解析 Nginx：从下载安装到高级应用与问题解决》
Nginx 一、Nginx 简介 什么是 Nginx 以及其功能 Nginx 是一款高性能的 HTTP 和反向代理的 Web 服务器，在处理高并发方面表现卓越，具备强大的能力来承受高负载，有相关报告指出其能够支持高达 50,000 个并发连接数。其显著特点为占用内存少、…...
python获取视频时长
今天有个需求，需要获取视频时长： 方法一：使用moviepy库打开视频文件并获取视频剪辑对象，然后通过剪辑对象获得视频时长。方法二：使用cv2库通过打开视频文件并获取帧率和总帧数两个属性，计算视频时长。 请…...
php-xlswriter实现数据导出excel单元格合并，内容从指定行开始写
最终效果图： 代码： public function export_data() {$list $this->get_list_organ();$content [];$content[] []; // 第2行不设置内容，设置为空foreach ($list as $key > $value) {$content[] [$value[organ_name], $value[clas…...
注意力模型QKV矩阵与位置向量计算
注意力模型QKV矩阵计算 在注意力机制中，Query (Q)、Key (K) 和 Value (V) 矩阵是通过对输入向量进行线性变换得到的，而这些矩阵的初始化与更新与神经网络的权重类似。 1. Q, K, V矩阵的初始化 线性变换：在注意力机制中，输入序列…...
glm4-9B-chat，使用提示工程激活模型最大潜力
文章目录 安全与免责申明简介GLM4-9B直接问答提示工程 激活能力 安全与免责申明 本文旨在研究大模型的安全，交流大模型目前安全方面的一些不足。 所有的实验与讨论的目的均是在进行科学研究的实验的需要。 简介 本文使用Ollama和LangChain，通过提示词…...
[Linux]在Ubuntu中如何正确安装python
一、在Ubuntu中python常见的安装方式 在Ubuntu中我们常用的python安装方式有使用包管理工具安装或者使用源码安装，下面我们来讲解一下这两种安装方式的优缺点。首先是使用包管理工具安装，我们可以直接使用“apt install python3.9”来安装一个我们想要的…...
[Vue3 + TS + Vite]文件选择器-组件
文件选择器组件代码 <script setup lang"ts"> import { ref, onMounted, defineProps, defineEmits, computed, toRaw } from vue;// 定义props interface Props {buttonTextUnactive?: string;buttonTextActive?: string;onFatherClick?: boolean; }// 定…...
Chrome书签搜索插件
效果展示 这是一个chroma插件，可以按住 ctrl/command B 进行搜索您的书签，并且点击打开您的书签。支持上下切换回车打开新页面。 扩展下载地址 bookmark-search 欢迎有任何问题给我提 issues...
MATLAB算法实战应用案例精讲-【人工智能】联邦学习（二）（附python代码实现）
目录 前言 几个高频面试题目 面向隐私保护的机器学习（PPML）和安全机器学习（Secure ML）的区别： 联邦学习、安全计算是什么关系？ 联邦学习有哪些类型？如何区分横向联邦学习和纵向联邦学习？ 什么是IID？什么是Non-iid？ 联邦学习训练后的模型是一个公共的模型，而…...
在 C++ 中实现一个简单的图形用户界面（GUI）应用
在 C 中实现一个简单的图形用户界面（GUI）应用 图形用户界面（GUI）应用程序是现代软件开发中不可或缺的一部分。它们为用户提供了直观的交互方式，使得操作更加简单和高效。本文将介绍如何在 C 中实现一个简单的 GUI 应用…...
如何编写一个CMakeLists.txt文件（由简到难，较详细）
在Linux系统下，经常使用CMakeLists.txt文件来链接、编译C工程，大部分人clone的代码里都是有CMakeLists.txt文件的，只需要cmake .. 和make就完事了，但在工作中，你必须要有从无到有编写CMakeLists.txt文件的能力。 一、…...
数据结构----链表
一丶概念 链表又称单链表、链式存储结构，用于存储逻辑关系为“一对一”的数据。 和顺序表不同同，使用链表存储数据，不强制要求数据在内存中集中存储，各个元素可以分散存储在内存中。 二丶特点 特点：内存不连续…...
【Qt】内置对话框
一.Qt内置对话框 Qt 提供了多种可复⽤的对话框类型，即 Qt 标准对话框。Qt标准对话框全部继承于QDialog类。常⽤标准对话框如下： 二.内置对话框分类 1.消息对话框 QMessageBox 1.1 概念 消息对话框是应⽤程序中最常⽤的界⾯元素。消息对话框主要⽤于为…...
excel常规操作
一、去重 IF(COUNTIF($D$1:D2,D2)>1,"",C2) —— D是去重的列 二、不同列匹配 VLOOKUP(A1,E:F,2,0) vlookup(查找值, 查找区域, 返回查找区域的第几列数据, 精确查找输入参数"0"or"false" 或 模糊查找输入参数"1"or"true…...
uniapp webview子页面向父页面发送数据和触发事件，重点在第3条！！！
1、众所周知H5中iframe可以用过postmessage进行，从H5子页面向H5父页面进行通信。方法如下： // 子页面 window.parent.postMessage({ data: 你的消息 }, *);// 父页面 <iframe src"xxxxxxxxxxx"></iframe> window.addEventListene…...
【STM32实物】基于STM32+ESP32+手机APP设计的智能宠物喂食系统实物源码原理图PCB设计文档演示视频——（文末工程资料下载）
基于STM32+ESP32+手机APP设计的智能宠物喂食系统 演示视频 基于STM32+ESP32+手机APP设计的智能宠物喂食系统 摘 要 近年来，宠物在人们生活中越来越不可或缺，给人们带来的陪伴和快乐。然而，由于种种原因，主人不能时刻照顾宠物的饮食，所以宠物喂食装置变得尤为重要。传…...
EMC学习笔记5——辐射骚扰发射
辐射骚扰发射是基本的实验项目，目的是检验设备在工作时有没有产生意外的过强电磁辐射。 例如发电机，在工作时会产生意外的电磁波辐射，因为电子设备中隐藏了一些天线，这些隐藏的天线在辐射电磁波。 一、两种基本的天线结构 如前面…...
深入理解浏览器解析机制和XSS向量编码
基础部分 1.<a href"%6a%61%76%61%73%63%72%69%70%74:%61%6c%65%72%74%28%31%29">aaa</a> <a>标签可以识别，但是解析不了， 是在协议的编码顺序上，先认协议 URL 编码 "javascript:alert(1)" 2.<a …...
winform 大头针实现方法——把窗口钉在最上层
平时我们再使用成熟的软件的时候，会发现有个大头针的功能挺不错的。就是点一下大头针，窗口就会钉住，一直保持在最上面一层，这样可以一边设置参数，一边观察这个窗口里面的变化，比较方便。下面我就来简单实现…...
中间件|day1.Redis
Redis 定义 Redis 是一个开源（BSD许可）的，内存中的数据结构存储系统，它可以用作数据库、缓存和消息中间件。 它支持多种类型的数据结构，如 字符串（strings）， 散列（hash…...
PMP到底有什么用？
PMP 就是项目管理证书，全称是项目管理专业人士资格认证，对于一个在项目管理岗位混迹五年的老油条来说，PMP 证书是敲开项目管理岗位的第一块砖，每年考 PMP 的人都很多，要是 PMP 证书没有价值，还会有那么多人…...
apache huidi 时间旅行Time Travel）机制
Apache Hudi（Hadoop Upserts Deletes and Incrementals）是一个数据管理框架，它帮助你高效地管理存储在分布式存储系统（如HDFS或云存储）上的大型数据集。其一个关键特性是“时间旅行”，这允许你在特定时间点查询数据的历史版本。 什么是Apache Hudi中的时间旅行？ Apach…...
Python 数据可视化，怎么选出合适数据的图表
数据可视化最佳实践 1. 引言：为什么数据可视化最佳实践很重要 数据可视化是数据分析和决策过程中不可或缺的一部分。通过有效的可视化，复杂的数据可以转化为易于理解的信息，从而帮助观众快速做出正确的判断。然而，糟糕的可视化可…...
c# 元组
文章目录 元组的定义元组的使用示例使用场景创建一个列表 在 C# 中，元组（Tuple）是一种用于存储多个值的数据结构，它可以方便地将不同类型的多个值打包在一起。元组在 C# 7.0 及更高版本中得到了增强，允许更方便地创建和…...
自定义注解
目录 使用注解定义分布式锁 Aop例子 retention 表示在什么时候可以用，runtime表示在运行期可以用 target表示可以用在哪些上面 inherited表示可以被继承 切点和切面类 重点是 pjp.proceed(args) 这个就是执行目标方法，下面的这一段没啥意思 也可…...
报错：Can‘t find Python executable “python“, you can set the PYTHON env variable
将项目导入vscode,执行npm install命令后，报错了，报错的信息是node-sass安装失败，同时提示需要python环境的错误信息，这是因为安装node-sass失败了，而node-sass依赖于Python环境。 1.报错：Cant find Python…...
C++中的错误处理机制
异常的引出 如过你写过不少的程序的话，相信你应该遇到过一些程序所不能处理的错误而导致程序崩溃的问题吧，比如说：操作野指针，访问空指针，函数的除零错误，数组越界，在栈上开辟空间过大导致栈溢…...