19c单机应用19.23补丁过程

最新推荐文章于 2024-06-12 07:22:08 发布
最新推荐文章于 2024-06-12 07:22:08 发布
阅读量689 收藏 7
点赞数 22
分类专栏： Oracle_19c 文章标签： oracle 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/kevinyu998/article/details/139130176
版权


[root@hydb ~]#  su - oracle
Last login: Wed May 22 18:38:02 CST 2024 on pts/0
orcl:/home/oracle@hydb> cd /home/oracle/update/36233126/36233263
orcl:/home/oracle/update/36233126/36233263@hydb>  opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.42
Copyright (c) 2024, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/19.0.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.0.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.42
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2024-05-22_18-42-56PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
orcl:/home/oracle/update/36233126/36233263@hydb>opatch apply
Oracle Interim Patch Installer version 12.2.0.1.42
Copyright (c) 2024, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/19.0.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.0.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.42
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2024-05-22_18-43-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.42
Copyright (c) 2024, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/19.0.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.0.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.42
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2024-05-22_18-43-56PM_1.log

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

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.0.0/db_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '36233263' to OH '/u01/app/oracle/product/19.0.0/db_1'
ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.crypto.rsf, 19.0.0.0.0 ] , [ oracle.pg4mq, 19.0.0.0.0 ] , [ oracle.precomp.companion, 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.net.cman, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.pg4appc, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.sdo.companion, 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.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.blaslapack, 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.dbdev, 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.ldap.security.osdt, 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.ons, 19.0.0.0.0...

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

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

Patching component oracle.perlint, 5.28.1.0.0...

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

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

Patching component oracle.rdbms.crs, 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.rdbms.rsf.ic, 19.0.0.0.0...

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

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

Patching component oracle.rsf, 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.xdk.rsf, 19.0.0.0.0...

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

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

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

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

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

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

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

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

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

Patching component oracle.xdk, 19.0.0.0.0...

Patching component oracle.odbc, 19.0.0.0.0...

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

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

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

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

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

Patching component oracle.install.deinstalltool, 19.0.0.0.0...

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

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

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

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

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

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

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

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

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

Patching component oracle.oraolap, 19.0.0.0.0...

Patching component oracle.ovm, 19.0.0.0.0...

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

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

Patching component oracle.dbtoolslistener, 19.0.0.0.0...

Patching component oracle.ldap.ssl, 19.0.0.0.0...

Patching component oracle.rdbms.install.plugins, 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 36233263 successfully applied.
Sub-set patch [29517242] has become inactive due to the application of a super-set patch [36233263].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2024-05-22_18-43-56PM_1.log

OPatch succeeded.
orcl:/home/oracle/update/36233126/36233263@hydb>sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed May 22 18:52:39 2024
Version 19.23.0.0.0

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

Connected to an idle instance.

SYS@orcl> startup;
ORACLE instance started.

Total System Global Area 1.6106E+10 bytes
Fixed Size           18424632 bytes
Variable Size         9865003008 bytes
Database Buffers     6207569920 bytes
Redo Buffers           15126528 bytes
Database mounted.
Database opened.
SYS@orcl> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.23.0.0.0
orcl:/home/oracle/update/36233126/36233263@hydb>cd ~
orcl:/home/oracle@hydb>$ORACLE_HOME/OPatch/datapatch -verbose
SQL Patching tool version 19.23.0.0.0 Production on Wed May 22 18:53:23 2024
Copyright (c) 2012, 2024, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_21872_2024_05_22_18_53_24/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.23.0.0.0 Release_Update 240406004238: Installed
  SQL registry:
    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 14-NOV-23 09.37.53.317148 PM

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  No interim patches need to be rolled back
  Patch 36233263 (Database Release Update : 19.23.0.0.240416 (36233263)):
    Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.23.0.0.0 Release_Update 240406004238
  No interim patches need to be applied

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

Validating logfiles...done
Patch 36233263 apply: SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/36233263/25638263/36233263_apply_orcl_2024May22_18_54_31.log (no errors)

Automatic recompilation incomplete; run utlrp.sql to revalidate.
SQL Patching tool complete on Wed May 22 19:02:26 2024
orcl:/home/oracle@hydb>sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed May 22 19:04:16 2024
Version 19.23.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.23.0.0.0

SYS@orcl> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@orcl>  exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.23.0.0.0
orcl:/home/oracle@hydb>  cd /home/oracle/update/36199232
orcl:/home/oracle/update/36199232@hydb>  opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.42
Copyright (c) 2024, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/19.0.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.0.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.42
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2024-05-22_19-06-33PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
orcl:/home/oracle/update/36199232@hydb>  opatch apply
Oracle Interim Patch Installer version 12.2.0.1.42
Copyright (c) 2024, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/19.0.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.0.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.42
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2024-05-22_19-06-51PM_1.log

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

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.0.0/db_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '36199232' to OH '/u01/app/oracle/product/19.0.0/db_1'

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

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

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

Patching component oracle.rdbms, 19.0.0.0.0...

Patching component oracle.javavm.client, 19.0.0.0.0...
Patch 36199232 successfully applied.
Log file location: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2024-05-22_19-06-51PM_1.log

OPatch succeeded.
orcl:/home/oracle/update/36199232@hydb>sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed May 22 19:08:31 2024
Version 19.23.0.0.0

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

Connected to an idle instance.

SYS@orcl> startup;
ORACLE instance started.

Total System Global Area 1.6106E+10 bytes
Fixed Size           18424632 bytes
Variable Size         9965666304 bytes
Database Buffers     6106906624 bytes
Redo Buffers           15126528 bytes
Database mounted.
Database opened.
SYS@orcl>  exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.23.0.0.0
orcl:/home/oracle/update/36199232@hydb>  cd ~
orcl:/home/oracle@hydb>$ORACLE_HOME/OPatch/datapatch -verbose
SQL Patching tool version 19.23.0.0.0 Production on Wed May 22 19:09:11 2024
Copyright (c) 2012, 2024, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_31593_2024_05_22_19_09_11/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:
Interim patch 36199232 (OJVM RELEASE UPDATE: 19.23.0.0.240416 (36199232)):
  Binary registry: Installed
  SQL registry: Not installed

Current state of release update SQL patches:
  Binary registry:
    19.23.0.0.0 Release_Update 240406004238: Installed
  SQL registry:
    Applied 19.23.0.0.0 Release_Update 240406004238 successfully on 22-MAY-24 07.02.06.242470 PM

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  No interim patches need to be rolled back
  No release update patches need to be installed
  The following interim patches will be applied:
    36199232 (OJVM RELEASE UPDATE: 19.23.0.0.240416 (36199232))

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

Validating logfiles...done
Patch 36199232 apply: SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/36199232/25601966/36199232_apply_orcl_2024May22_19_09_31.log (no errors)
SQL Patching tool complete on Wed May 22 19:10:15 2024
orcl:/home/oracle@hydb>sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed May 22 19:10:24 2024
Version 19.23.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.23.0.0.0

SYS@orcl> @$ORACLE_HOME/rdbms/admin/utlrp.sql

Session altered.


TIMESTAMP
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN          2024-05-22 19:10:54

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          2024-05-22 19:11:05

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
-------------------
          2

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.

SYS@orcl> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@orcl> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.23.0.0.0
orcl:/home/oracle@hydb> exit
logout
[root@hydb ~]# reboot
 

bestsun999
关注
  • 22
    点赞
  • 踩
  • 7
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Oracle 19c 单实例 19.3.0 升级到19.11.0
hbhe0316的专栏
10-09 783
1.查看当前DB环境 [oracle@db01 ~]$ cat /etc/redhat-release Red Hat Enterprise Linux Server release 7.9 (Maipo) [oracle@db01 ~]$ uname -r 3.10.0-1160.el7.x86_64 [oracle@db01 ~]$ lsnrctl status LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 12-SEP-2021 2
oracle 19.23 Patch发布（含下载链接）
xiaofan23z的专栏
04-17 942
从2018年开始Oracle 更新了版本的命名规则，原本的12.2.0​.2被命名为18C，之后12C的长期支持版本被命名为19C（本来为12.2.0.3），之后又在2021发布了过渡版本21C，以及大家等待已久的oracle 23C。按照惯例23C应该在2023年10月中旬发布，但是可能是23C被赋予了太多的期望，增加了太多新功能，导致发布日期一延再延​；昨天会后和O记的员工求证23C​何时发布？----------------历史文章推荐------------------
Oracle 19c 19.10DBRU 最新补丁升级看这一篇就够了
JiekeXu的博客
03-21 7813
作者 | JiekeXu来源 |JiekeXu DBA之路（ID: JiekeXu_IT）大家好，我是 JiekeXu,很高兴又和大家见面了,今天和大家聊聊 Oracle 19c RU...
Oracle 19c补丁升级（Windows）
不会编程的猫星人
04-11 901
Oracle 19c补丁升级（Windows）
19c 单实例打补丁
weixin_43475880的博客
03-27 1584
修改权限： chmod 775 -R $ORACLE_HOME/OPatch chmod 777 -R /u01/orasoft chown -R oracle:oinstall /u01/orasoft 冲突检查： $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/orasoft/32545008/32545013 $ORACLE_HOME/OPatch/opatch prereq
Oracle 19C 静默安装、补丁升级
zhanglei_16的博客
10-30 2832
https://www.cnblogs.com/zhangrui153169/p/12710490.html Oracle 19c(19.3) 单机数据库静默安装 一、环境介绍 操作系统：CentOS 7.4 数据库版本：Oracle database 19.3 主机名：oradb31 IP地址：192.168.1.31 安装目录：/opt/oracle/product/19.3/db_1 数据库名称：orcl 字符集：AL32UTF8 二、环境准备 2.1：关闭防火墙 systemctl stop
oracle 19C驱动 ojdbc8.jar orai18n.jar
08-18
官网下载的 19.3驱动 需要请自行下载，oracle 19c驱动 ojdbc8.jar orai18n.jar。 其他的标记的太高了，所以自行下载了。
Linux7.6+Oracle 19c+文件系统单机安装.pdf
09-27
熟练掌握在VMware下安装Linux7.6环境 熟练掌握在Linux环境下安装Oracle19c数据库 熟练掌握Linux环境下对Oracle数据库的运维操作
19c-手工建库.pdf
09-13
Oracle 19c 手工建库详解 以下是 Oracle 19c 手工建库的详细步骤和知识点总结： 一、启动实例 1. 设置 ORACLE_SID：export ORACLE_SID=CDB 2. 创建口令文件：orapwd file=$ORACLE_HOME/dbs/orapwCDB password=...
Oracle 19C OCP课堂笔记.zip
12-23
Oracle 19C OCP课堂笔记.zip
ORACLE 19C SQL调优指南.chm
04-19
Oracle 19C SQL调优优化指南，全面提升SQL优化能力，DBA必备，开发必备
Prerequisite check "CheckActiveFilesAndExecutables" failed Following active executables are not used
sqlora的专栏
11-15 4468
oracle19.3.0.0 rac+centos7.6 补丁为19.5.0.0 报错现象： 节点2打补丁失败。 [grid@rac2 ~]$ cd /oracle/app/patch/30116789/30125133 [grid@rac2 30125133]$ opatch apply Oracle Interim Patch Installer version 12.2.0.1.17...
Oracle 19c 19.3通过opatch打补丁升级到19.4
allway2的博客
08-17 5902
cd 29834717 [oracle@oracle19c 29834717]$ ls etc files README.html README.txt [oracle@oracle19c 29834717]$ /opt/oracle/product/19c/dbhome_1/OPatch/opatch apply Oracle 临时补丁程序安装程序版本 12.2.0.1.17 版权所有 (...
oracle 中fuser,fuser命令缺失导致19c打补丁失败 – 提供7*24专业数据库(Oracle,SQL Server,MySQL等)恢复和Oracle技术服务@Tel:+86 13429...
weixin_32809369的博客
04-10 656
Oracle 19.3数据库打最新补丁报错[oracle@www.xifenfei.com 30125133]$ opatch apply ./Oracle Interim Patch Installer version 12.2.0.1.18Copyright (c) 2019, Oracle Corporation. All rights reserved.Oracle Home ...
【OPatch】从 Oracle Database 19.3 升级到 Oracle Database
wangxi06的专栏
04-14 526
1. 背景介绍 由于Oracle Database 19c会作为Oracle长期支持的版本，官方也建议大家选择19c这个版本。而最新推出的20c会作为一个全新的发布序列，当前版本是20.1，此版本的生命周期也会比较短，因此可以再观望一下20c的后续版本。我安装了在Oracle官网可以下载到的19.3的版本，完成了升级到19.6版本的操作过程，给此项目工作提供文档支持。 2. 升级过程 可以从MOS获得 Database 19.6 的 patch，名称如下： 登录后复制 Patch 30463595:
oracle19.3升级到19.6
old boy的博客
03-09 5756
         本章介绍如何将oracle19.3升级到19.6，Oracle Database 19c会作为Oracle长期支持的版本，所以建议大家安装oracle19c，但是官方安装包下载的时候只有oracle19.3.0的安装包能够下载，19.4到19.6只能通过升级的方式安装，没有独立的安装包。 1、升级前...
Linux 7.9 平台下 Oracle DG 19.3升级至19.12
hbhe0316的专栏
10-16 279
在19c 的Data Guard 环境，我们RU的升级可以直接按照Patch readme中的步骤进行，如下： 1.停备库 2.升级Opatch 3.升级备库（RU） 4.启动备库 5.停主库 6.升级OPatch 7.升级主库（RU+datapatch+utlrp） 8.启动主库 1.检查主库状态 SQL> col status for a15 SQL> col error for a20 SQL> select status,error from v$archive_dest w
Oracle中如何定义定时器
最新发布
codemami的博客
06-12 534
在上述示例中，MY_PROGRAM是程序名，MY_SCHEDULE是调度名，MY_JOB是作业名。提交作业后，可以使用DBMS_JOB.RUN过程来手动运行作业，或者等待作业在指定的时间自动运行。start_date指定了作业的开始时间，repeat_interval指定了作业的重复执行规则。Oracle定时器是一种工具，用于在指定的时间间隔或特定时间自动执行数据库任务或存储过程。program_action字段中填写的是你的PL/SQL代码或存储过程的名称。作业定义了要执行的程序和使用的调度。
19c rac ora.LISTENER.lsnr state INTERMEDIATE
06-06
当 `ora.LISTENER.lsnr` 的状态为 `INTERMEDIATE` 时，表示该资源正在进行某些操作，例如正在启动或者停止。在这种情况下，你可以等待一段时间，然后再次运行以下命令来检查资源的状态： ``` $ crsctl stat res ora.LISTENER.lsnr -t ``` 如果该资源已经启动成功，则状态应该为 `ONLINE`。如果该资源启动失败，则状态可能为 `OFFLINE` 或者 `UNKNOWN`，你可以根据具体的错误信息来解决问题。 如果一段时间后该资源的状态仍然为 `INTERMEDIATE`，则可以尝试使用以下命令强制停止该资源： ``` $ crsctl stop resource ora.LISTENER.lsnr -f ``` 然后再使用 `crsctl start resource` 命令重新启动该资源。如果问题仍然存在，请检查日志文件以获取更多信息。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值