Oracle 单实例19.12升级到19.13

最新推荐文章于 2023-04-09 20:39:42 发布
最新推荐文章于 2023-04-09 20:39:42 发布
阅读量845 收藏 1
点赞数
文章标签： 数据库 oracle cordova plsql mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/hbhe0316/article/details/122701468
版权
该篇博客详细记录了Oracle数据库从19.11版本升级到19.12版本的过程，包括检查当前DB环境、下载相应RU补丁、执行OPatch安装补丁、通过Datapatch加载SQL变更、处理无效对象等关键步骤。在升级过程中，确保关闭所有实例和监听，遵循文档指引进行无冲突安装。
摘要由CSDN通过智能技术生成

1.查看当前DB环境

参考Oracle 单实例19.11升级到19.12https://www.cndba.cn/hbhe0316/article/4713https://www.cndba.cn/hbhe0316/article/4970

[oracle@db01 ~]$ cat /etc/redhat-release 
Red Hat Enterprise Linux Server release 7.9 (Maipo)
[oracle@db01 ~]$ lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 21-OCT-2021 21:43:28

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                21-OCT-2021 21:43:17
Uptime                    0 days 0 hr. 0 min. 11 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/diag/tnslsnr/db01/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db01)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@db01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 21 21:43:08 2021
Version 19.12.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 2516581448 bytes
Fixed Size                  9141320 bytes
Variable Size            1275068416 bytes
Database Buffers         1224736768 bytes
Redo Buffers                7634944 bytes
Database mounted.
Database opened.
SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 HBHE                           MOUNTED
SQL> alter session set container = hbhe;

Session altered.

SQL> alter pluggable database open;

Pluggable database altered.

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         3 HBHE                           READ WRITE NO

2 从MOS下载19.12 的RU 补丁
19.13 DB的RU 编号是：33192793，GI的RU编号是： 33182768。
p33182768_190000_Linux-x86-64.zip
p33192793_190000_Linux-x86-64.ziphttps://www.cndba.cn/hbhe0316/article/4970

3 开始安装RU补丁
3.1 查看OPatch版本https://www.cndba.cn/hbhe0316/article/4970https://www.cndba.cn/hbhe0316/article/4970

[oracle@db01 ~]$  cd $ORACLE_HOME/OPatch
[oracle@db01 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.27

OPatch succeeded.

3.2 检查Patch是否冲突https://www.cndba.cn/hbhe0316/article/4970

[oracle@db01 tmp]$ cd /tmp/33192793/
[oracle@db01 33192793]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.27
Copyright (c) 2021, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/19.3.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.3.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.27
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2021-10-21_21-52-40PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

3.3 应用patch
如果是物理DG，那么主备库都需要安装Patch，可以先在备库安装，再安装主库，操作步骤可以参考：Document 278641.1。
对于RAC 环境，可以使用OPatch rolling 方式来安装，这样没有停机时间，具体操作可以参考：Document 244241.1。
对于单实例，必须关闭待升级ORACLE HOME关联的所有实例和监听，并且包括退出所有的sqlplus窗口。
关闭实例和监听，并退出sqlplus。https://www.cndba.cn/hbhe0316/article/4970https://www.cndba.cn/hbhe0316/article/4970

[oracle@db01 33192793]$ lsnrctl stop

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 21-OCT-2021 21:53:53

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The command completed successfully
SQL>    shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
[oracle@db01 33192793]$ cd /tmp/33192793/
[oracle@db01 33192793]$ $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.27
Copyright (c) 2021, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/19.3.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.3.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.27
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2021-10-21_21-56-11PM_1.log

Verifying environment and performing prerequisite checks...

--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...

Oracle Interim Patch Installer version 12.2.0.1.27
Copyright (c) 2021, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/19.3.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.3.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.27
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2021-10-21_21-57-07PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   33192793  

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/19.3.0/dbhome_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '33192793' to OH '/u01/app/oracle/product/19.3.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.perlint, 5.28.1.0.0...

Patching component oracle.rdbms.locator, 19.0.0.0.0...

Patching component oracle.perlint.expat, 2.0.1.0.4...

Patching component oracle.rdbms.rsf, 19.0.0.0.0...

Patching component oracle.rdbms.util, 19.0.0.0.0...

Patching component oracle.rdbms, 19.0.0.0.0...

Patching component oracle.assistants.acf, 19.0.0.0.0...

Patching component oracle.assistants.deconfig, 19.0.0.0.0...

Patching component oracle.assistants.server, 19.0.0.0.0...

Patching component oracle.buildtools.rsf, 19.0.0.0.0...

Patching component oracle.ctx, 19.0.0.0.0...

Patching component oracle.dbjava.ic, 19.0.0.0.0...

Patching component oracle.dbjava.jdbc, 19.0.0.0.0...

Patching component oracle.dbjava.ucp, 19.0.0.0.0...

Patching component oracle.duma, 19.0.0.0.0...

Patching component oracle.javavm.client, 19.0.0.0.0...

Patching component oracle.ldap.owm, 19.0.0.0.0...

Patching component oracle.ldap.rsf, 19.0.0.0.0...

Patching component oracle.marvel, 19.0.0.0.0...

Patching component oracle.network.rsf, 19.0.0.0.0...

Patching component oracle.odbc.ic, 19.0.0.0.0...

Patching component oracle.oracore.rsf, 19.0.0.0.0...

Patching component oracle.precomp.common.core, 19.0.0.0.0...

Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...

Patching component oracle.rdbms.deconfig, 19.0.0.0.0...

Patching component oracle.rdbms.oci, 19.0.0.0.0...

Patching component oracle.rhp.db, 19.0.0.0.0...

Patching component oracle.sdo, 19.0.0.0.0...

Patching component oracle.sdo.locator.jrf, 19.0.0.0.0...

Patching component oracle.sqlplus, 19.0.0.0.0...

Patching component oracle.sqlplus.ic, 19.0.0.0.0...

Patching component oracle.wwg.plsql, 19.0.0.0.0...

Patching component oracle.rdbms.crs, 19.0.0.0.0...

Patching component oracle.network.listener, 19.0.0.0.0...

Patching component oracle.network.client, 19.0.0.0.0...

Patching component oracle.ctx.rsf, 19.0.0.0.0...

Patching component oracle.rdbms.scheduler, 19.0.0.0.0...

Patching component oracle.rdbms.hs_common, 19.0.0.0.0...

Patching component oracle.xdk, 19.0.0.0.0...

Patching component oracle.ons.ic, 19.0.0.0.0...

Patching component oracle.xdk.xquery, 19.0.0.0.0...

Patching component oracle.rdbms.drdaas, 19.0.0.0.0...

Patching component oracle.javavm.server, 19.0.0.0.0...

Patching component oracle.ovm, 19.0.0.0.0...

Patching component oracle.dbdev, 19.0.0.0.0...

Patching component oracle.rdbms.dv, 19.0.0.0.0...

Patching component oracle.precomp.rsf, 19.0.0.0.0...

Patching component oracle.ctx.atg, 19.0.0.0.0...

Patching component oracle.ldap.security.osdt, 19.0.0.0.0...

Patching component oracle.ldap.client, 19.0.0.0.0...

Patching component oracle.ldap.rsf.ic, 19.0.0.0.0...

Patching component oracle.xdk.parser.java, 19.0.0.0.0...

Patching component oracle.oraolap.dbscripts, 19.0.0.0.0...

Patching component oracle.odbc, 19.0.0.0.0...

Patching component oracle.sdo.locator, 19.0.0.0.0...

Patching component oracle.dbtoolslistener, 19.0.0.0.0...

Patching component oracle.ons, 19.0.0.0.0...

Patching component oracle.oraolap.api, 19.0.0.0.0...

Patching component oracle.rdbms.hsodbc, 19.0.0.0.0...

Patching component oracle.rdbms.rman, 19.0.0.0.0...

Patching component oracle.rdbms.install.common, 19.0.0.0.0...

Patching component oracle.nlsrtl.rsf, 19.0.0.0.0...

Patching component oracle.rdbms.install.plugins, 19.0.0.0.0...

Patching component oracle.rdbms.lbac, 19.0.0.0.0...

Patching component oracle.mgw.common, 19.0.0.0.0...

Patching component oracle.xdk.rsf, 19.0.0.0.0...

Patching component oracle.oraolap, 19.0.0.0.0...

Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0...

Patching component oracle.precomp.common, 19.0.0.0.0...

Patching component oracle.precomp.lang, 19.0.0.0.0...

Patching component oracle.jdk, 1.8.0.201.0...
Patch 33192793 successfully applied.
Sub-set patch [32904851] has become inactive due to the application of a super-set patch [33192793].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2021-10-21_21-57-07PM_1.log

OPatch succeeded.

3.4 加载变化的SQL到数据库
安装补丁之后，还需要将有变化的SQL加载到数据库中，这里可以直接运行Datapatch工具将这些修改的SQL重新加载到数据库中，如果是RAC环境，只需要在一个节点执行就可以了。https://www.cndba.cn/hbhe0316/article/4970

[oracle@db01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 21 22:08:39 2021
Version 19.13.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 2516581448 bytes
Fixed Size                  9141320 bytes
Variable Size            1275068416 bytes
Database Buffers         1224736768 bytes
Redo Buffers                7634944 bytes
Database mounted.
Database opened.
SQL> alter session set container = hbhe;

Session altered.

SQL> alter pluggable database open;

Pluggable database altered.

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         3 HBHE                           READ WRITE NO
SQL> quit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.13.0.0.0
[oracle@db01:/u01/app/oracle/product/19.3.0/db/OPatch]$ cd $ORACLE_HOME/OPatch
[oracle@db01:/u01/app/oracle/product/19.3.0/db/OPatch]$ ./datapatch -verbose
SQL Patching tool version 19.13.0.0.0 Production on Fri Oct 22 10:22:52 2021
Copyright (c) 2012, 2021, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_11392_2021_10_22_10_22_52/sqlpatch_invocation.log

Connecting to database...OK
Gathering database info...done
Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of interim SQL patches:
  No interim patches found

Current state of release update SQL patches:
  Binary registry:
    19.13.0.0.0 Release_Update 211004165050: Installed
  SQL registry:
    Applied 19.12.0.0.0 Release_Update 210716141810 successfully on 22-OCT-21 10.05.02.897199 AM

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  No interim patches need to be rolled back
  Patch 33192793 (Database Release Update : 19.13.0.0.211019 (33192793)):
    Apply from 19.12.0.0.0 Release_Update 210716141810 to 19.13.0.0.0 Release_Update 211004165050
  No interim patches need to be applied

Installing patches...
Patch installation complete.  Total patches installed: 1

Validating logfiles...done
Patch 33192793 apply: SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33192793/24462514/33192793_apply_CXMTDB_2021Oct22_10_23_12.log (no errors)
SQL Patching tool complete on Fri Oct 22 10:25:20 2021

3.6 处理无效对象https://www.cndba.cn/hbhe0316/article/4970

https://www.cndba.cn/hbhe0316/article/4970 
SQL> @?/rdbms/admin/utlrp.sql

Session altered.


TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN              2021-10-21 22:46:09

DOC>   The following PL/SQL block invokes UTL_RECOMP to recompile invalid
DOC>   objects in the database. Recompilation time is proportional to the
DOC>   number of invalid objects in the database, so this command may take
DOC>   a long time to execute on a database with a large number of invalid
DOC>   objects.
DOC>
DOC>   Use the following queries to track recompilation progress:
DOC>
DOC>   1. Query returning the number of invalid objects remaining. This
DOC>      number should decrease with time.
DOC>         SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);
DOC>
DOC>   2. Query returning the number of objects compiled so far. This number
DOC>      should increase with time.
DOC>         SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
DOC>
DOC>   This script automatically chooses serial or parallel recompilation
DOC>   based on the number of CPUs available (parameter cpu_count) multiplied
DOC>   by the number of threads per CPU (parameter parallel_threads_per_cpu).
DOC>   On RAC, this number is added across all RAC nodes.
DOC>
DOC>   UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel
DOC>   recompilation. Jobs are created without instance affinity so that they
DOC>   can migrate across RAC nodes. Use the following queries to verify
DOC>   whether UTL_RECOMP jobs are being created and run correctly:
DOC>
DOC>   1. Query showing jobs created by UTL_RECOMP
DOC>         SELECT job_name FROM dba_scheduler_jobs
DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>
DOC>   2. Query showing UTL_RECOMP jobs that are running
DOC>         SELECT job_name FROM dba_scheduler_running_jobs
DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>#

PL/SQL procedure successfully completed.


TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END              2021-10-21 22:46:11

DOC> The following query reports the number of invalid objects.
DOC>
DOC> If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
DOC>#

OBJECTS WITH ERRORS
-------------------
                  0

DOC> The following query reports the number of exceptions caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC> Note: Typical compilation errors (due to coding errors) are not
DOC>       logged into this table: they go into DBA_ERRORS instead.
DOC>#

ERRORS DURING RECOMPILATION
---------------------------
                          0


Function created.


PL/SQL procedure successfully completed.


Function dropped.


PL/SQL procedure successfully completed.

版权声明：本文为博主原创文章，未经博主允许不得转载。

Linux,oracle

hbhe0316
关注
Oracle 19C 单机环境升级RU(19.3升级至19.12)
IT邦德
05-09 3059
本篇介绍了Oracle 19C 单机环境升级RU(19.3升级至19.12)的详细过程
ORACLE19C RAC 19.3.0升级19.12.0
xielong8866的博客
08-04 412
ORACLE19C RAC 19.3.0升级19.12.0 oui-patch.xml Permission denied
Oracle 19c RAC 19.3 升级到19.12
hbhe0316的专栏
10-16 1972
1.查看当前环境 [grid@rac01 ~]$ crsctl query crs softwareversion Oracle Clusterware version on node [rac01] is [19.0.0.0.0] [grid@rac01 ~]$ crsctl query crs releaseversion Oracle High Availability Services release version on the local node is [19.0.0.0.0] [grid
Oracle 19.13发布
hbhe0316的专栏
10-21 321
19.13 DB的RU 编号是：33192793，GI的RU编号是： 33182768。https://www.cndba.cn/hbhe0316/article/4967 1.grid介质下载https://www.cndba.cn/hbhe0316/article/4967https://www.cndba.cn/hbhe0316/article/4967https://ww...
Linux安装Oracle 19.13(图形版)
运维@小兵的博客
04-12 2760
文章目录一、关闭防火墙及selinux`禁用SELinux``禁用firewalld`二、安装19c安装辅助设置包三、安装数据库依赖包四、安装vnc软件五、创建安装目录并设置权限六、添加oracle用户环境变量七、安装数据库软件`下载数据库软件``解压``使用vncviewer软件连接到数据库主机``启动数据库安装程序`八、创建数据库`启动dbca`九、安装数据库监听器 一、关闭防火墙及selinux 禁用SELinux setenforce 0 #仅对当前系统生效 sed -i -e s'/SELIN
Oracle 19C Rac-19.5升级至19.13变更升级文档-实战完整版
最新发布
力哥讲技术
04-09 742
Oracle 19C RAC是一种高可用性的数据库架构，由多个节点组成的集群共同运行，实现了数据的自动备份和故障转移。小版本升级是为了保证系统的稳定性和安全性，以及修复一些已知的问题和漏洞。在升级前，需要进行充分的准备工作，包括备份数据、检查硬件和软件兼容性、关闭相关服务等。升级过程中需要注意一些细节问题，如避免中途断电或网络中断、检查升级日志以及测试数据是否能够正常访问等。升级成功后，需要进行一些后续操作，如重新启动相关服务、检查数据库性能等。
Oracle 19.12 RAC RMAN迁移至19.12单机环境
hbhe0316的专栏
10-04 308
测试环境： Oracle 19.12 RAC + Redhat 7.9 源库： db_name=cxmtdb SID=cxmtdb1/cxmtdb2 IP: 192.168.56.200/201目标库,目标库只安装软件，不创建库。 db_name=cxmtdb SID=cxmtdb IP：192.168.56.101 1.从生产库创建PFILE create pfile='/...
Oracle 单实例19.11升级到19.12
hbhe0316的专栏
10-10 448
1.查看当前DB环境 [oracle@db01 ~]$ cat /etc/redhat-release Red Hat Enterprise Linux Server release 7.9 (Maipo) [oracle@db01 ~]$ lsnrctl status LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 13-SEP-2021 21:33:46 Copyright (c) 1991, 2021, Oracle. All r
Oracle数据库补丁加载-19.13升级到19.15
oradbm的博客
02-01 865
将数据库全部关闭，并将JVM补丁加载到ORACLE_HOME。此内容可以在数据库补丁加载的read me中可以查询到。根据上述1中的补丁加载对应的软件进行补丁加载。根据上述1中的补丁加载对应的软件进行补丁加载。主机 Rdehat linux 7.9。数据库环境19.13 RAC环境。节点2按照如上操作即可。
oracle（索引）12.19
weixin_45392911的博客
12-19 392
索引 堆表（hot） 【存储内容按照某种内容排序组成索引】 数据插入时时存储位置时随机的，主要是数据库内部的空闲情况决定，获取数据是按照命中率计算，全表扫表时不见得先插入的数据先查到。 索引组织表<聚集索引>（iot） 【索引提高dql速度 降低dml速度】 数据存储是把表按照索引的方式存储的，数据是有序的，数据的位置是预先定好的，与插入的顺序没有关系。 索引表的查询效率比堆表高（...
oracle19c,19.0.0时区版本35补丁p31335037_190000_Linux-x86-64.zip
11-11
oracle19.0时区版本35补丁p31335037_190000_Linux-x86-64.zip 注意：此补丁只适用于oracle19.3版本用来添加35版本时区，其他版本使用会报错 我会再上传一个适用于19c所有oracle版本的35版本时区补丁 补丁用于解决ORA-39405 TSTZ版本问题的错误 用于把oracle19.0数据库加TSTZ35版本的补丁 可通过SQL> SELECT * FROM v$timezone_file;命令查询时区版本 Oracle Database 19 Release 19.0.0.0.190416DBRU CORE Patch for Bug#
对 oracle 19.9 数据库安装 19.13 补丁步骤
whn1977的博客
10-27 1074
前提检查 df -h 磁盘空间要充足 crsctl stat res 集群状态要正常，最好重启主机再检查一遍（时钟不同步可能起不来，权限、密码可能导致不正常） select name,database_role,open_mode from gv$database; 数据库角色是primary，open_mode=read write 上传介质到 /ora_soft RU 19.13 介质 :p33248471_190000_Linux-x86-64-ojvm-gi-19.13.0.0.211019.zip
ORACLE Primavera P6 / Unifier 19.12 免费虚拟机
Oracle Primavera P6 & Unifier 项目(协同)管理
01-20 1533
Primavera 19.12版本的免费预构建Oracle Primavera Applications VirtualBox appliance
Oracle 19C利用Create Database手工创建数据库
小小星月明的博客
07-14 3216
oracle 手动建库create database
redhat 8.5 oracle 19.3 restart环境升级
hbhe0316的专栏
01-14 299
1.查看当前环境 [grid@asm01 ~]$ crsctl query has softwareversion Oracle High Availability Services version on the local node is [19.0.0.0.0] [grid@asm01 ~]$ crsctl query has releaseversion Oracle...
重庆思庄oracle技术分享-oracle数据库坏块恢复—存在rman备份
duanweifang的博客
02-03 106
重庆思庄oracle技术分享-oracle数据库坏块恢复—存在rman备份
RedHat 8.5 下oracle 19.3升级至19.13
hbhe0316的专栏
01-01 678
1.查看当前DB环境 https://www.cndba.cn/hbhe0316/article/103900 [root@node01 ~]# cat /etc/redhat-release Red Hat Enterprise Linux release 8.5 (Ootpa) [root@node01 ~]# su - oracle [oracle@no...
oracle安装_Oracle 最新版本安装教程(19.3)
weixin_39588265的博客
12-06 877
安装数据库前的准备工作，先关闭电脑上的杀毒软件，同时准备好数据库安装目录，这个磁盘空间最好大一些。准备好后，开始参考如下步骤一步步的安装即可。第一步核对下当前的操作系统是那个版本，根据操作系统，我们来下载对应的数据库安装包。操作系统如下图所示。第二步下载准备数据库安装包访问oracle数据库官方网址,如下图所示第三步下载完成后解压到当前目录，此时该目录的空间要足够大，如下图所示第...
Oracle 19.12 Windows工具包：数据导入导出工具
最后，【压缩包子文件的文件名称列表】中的instantclient_19_12暗示了该工具包是针对Oracle Instant Client版本19.12的，这个信息对于确保兼容性非常重要，因为不同的Oracle数据库和客户端版本之间的工具可能不完全...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值