Dream of Mirror Ruins

Patch 34086870 - Oracle JavaVM Component Release Update 19.16.0.0.220719 p34086870_190000_Linux-x86-64 ・ p34086870_190000_Linux-x86-64_README Record

Patch 20299014 - Database Patch Set Update 10.2.0.5.19 (Includes CPUJul2015) p20299014_10205_Linux-x86-64 ・ p20299014_10205_Linux-x86-64_README Record 操作系统版本 : CentOS Linux release 7.9.2009 (Core) 数据库版本 : Oracle 10.2.0.5.0 simple instance OPatch : p6880880_102000_Linux-x86-64.zip DB PSU : p20299014_10205_Linux-x86-64.zip 说明：p20299014 补丁包无 CRS 的补丁修复，所以直接打数据库 PSU 即可 Update OPatch [root@centos7 ~]# chmod 775 /soft/p6880880_102000_Linux-x86-64-opatch.zip[root@centos7 ~]# chown /soft/oracl...

Patch 34133642 - Database Release Update 19.16.0.0.220719 p34133642_190000_Linux-x86-64 ・ p34133642_190000_Linux-x86-64_README Record System Operation: RHEL 8.7 Database Software: 19.3.0.0.0 Single Instance CDB Check the current opatch version and patches. ~]# /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/opatch versionOPatch Version: 12.2.0.1.17OPatch succeeded.~]$ $ORACLE_HOME/OPatch/opatch lspatches29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)29517242;Database Release Update :...

Patch 31718723 - Oracle Grid Infrastructure Patch Set Update 11.2.0.4.201020 p31718723_112040_Linux-x86-64 ・ p31718723_112040_Linux-x86-64_README Record

Patch 34130714 - GI Release Update 19.16.0.0.220719 p34130714_190000_Linux-x86-64 ・ p34130714_190000_Linux-x86-64_README Record System Operation: RHEL 8.7 Database Software: 19.3.0.0.0 RAC with 3 nodes Update OPatch utility version to 12.2.0.1.30 or later. Patch 6880880_190000 - record 2 Validation of Oracle Inventory on each node. ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME~]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME Download and U...

Patch 6880880 - OPatch for DB 19.0.0.0.0 p6880880_190000_Linux-x86-64 Update OPatch Utility To update Opatch, use the following instructions: Download the OPatch utility to a temporary directory. For each Oracle RAC database home and the GI home that are being patched, run the following commands as the home owner to extract the OPatch utility. ~]$ unzip <OPATCH-ZIP> -d <ORACLE_HOME>~]$ <ORACLE_HOME>/OPatch/opatch version Record 1: Update OPatch utility version to ...

Block Browser and EDitor building For 9i and 10g ~]$ cd $ORACLE_HOME/rdbms/liblib]$ make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbedlib]$ ./bbedPassword: blockeditBBED: Release 2.0.0.0.0 - Limited Production on Tue Mar 8 14:35:08 2022Copyright (c) 1982, 2007, Oracle. All rights reserved.************* !!! For Oracle Internal Use only !!! ***************BBED> For 11g and latest ~]$ curl -o /soft/bbed_10g_x64.tar.gz /assets/software/tools/bbed_10g_x64.tar.gz~]$ mkdir /soft/bbed_10g_x64...

Oracle Database DataPump EXPDP/IMPDP Create the datapump directory and grant privileges. -- Query datapump directory.set linesize 200 pages 100col privilege for a10col directory_path for a40select t.owner, privilege, directory_name, directory_path from user_tab_privs t, all_directories d where t.table_name(+) = d.directory_name order by 3, 2;select * from dba_directories;-- Create directory.create directory dpdir as '/home/oracle/dpdir';grant read,write on directory dpdir to sys,system;--...

Overview of XTTS XTTS (Cross Platform Transportable Tablespaces) 属于跨平台迁移表空间，它是从 Oracle 8i 开始就引入的一种基于表空间传输的物理迁移方法，命名为 TTS，经历各个版本的不断演进，从 11gR2 开始，在相对停机时间要求日益减少的情况，为了应对越来越大的数据量跨平台迁移，Oracle 推出了新的解决方案 — 加强版 TTS（以下简称 XTTS），XTTS 使用增量备份的方式实现跨平台的数据迁移，从真正意义上大大缩短停机时间。在 U2L 如火如荼的今天，通过 XTTS 快捷、高效、平稳、安全的将 Oracle 数据库 “小型机 + 集中式存储” 环境迁移至 “X86 架构平台 + 分布式存储” 已然成为一大神技。 XTTS 的发展历史： 从 8i，tts 技术的诞生，引入了相同平台相同块大小之间的表空间传输。到了 9i，tts 开始支持同平台中，不同块大小的表空间传输。 10g 时代，不仅引入了跨平台的表空间传输方案，也就是我们说的 xtts；10gR2 开始支持传输整个数据库。 11gR1 ...

Oracle OSWatcher Black Box OSWatcher (oswbb) is a collection of UNIX shell scripts intended to collect and archive operating system and network metrics to aid support in diagnosing performance issues. OSWatcher operates as a set of background processes on the server and gathers OS data on a regular basis, invoking such Unix utilities as vmstat, netstat and iostat. Installing with TAR file RHEL 6/7 Upload the oswbbxxx.tar file. mkdir /u01/oswatchertar -xvf /soft/oswbb840.tar -C /u01/oswa...