Dream of Mirror Ruins

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

All steps in this procedure are run as the oracle user that is a member of the OSDBA group. OS authentication is used to connect to both the source and destination databases. Initial Setup 1.1 创建 xtts 目录，解压 rman_xttconvert_v3.zip 软件包 mkdir -p /home/oracle/xtts/backupmkdir -p /home/oracle/xtts/backup_incrmkdir -p /home/oracle/xtts/scriptscd /home/oracle/xttsunzip rman_xttconvert_v3.zip 1.2 配置 xtt.properties 参数 cat > xtt.properties << 'EOF'tablespaces=TBS_COCO,ITPUX01,ITPUX02,ITPUX03...

All steps in this procedure are run as the oracle user that is a member of the OSDBA group. OS authentication is used to connect to both the source and destination databases. Initial Setup 1.1 创建 xtts 目录，解压 rman_xttconvert_v3.zip 软件包 mkdir -p /home/oracle/xtts/backupmkdir -p /home/oracle/xtts/backup_incrmkdir -p /home/oracle/xtts/scriptscd /home/oracle/xttsunzip rman_xttconvert_v3.zip 1.2 配置 xtt.properties 参数 cat > xtt.properties << 'EOF'tablespaces=TBS_COCO,ITPUX01,ITPUX02,ITPUX03...

Prerequisites of XTTS 平台字节序和字符集，不支持 Windows 平台，源端与目标端的字符集需相同 -- 查询平台和字节序col PLATFORM_NAME format a30SELECT d.PLATFORM_ID,d.PLATFORM_NAME, tp.ENDIAN_FORMAT FROM V$TRANSPORTABLE_PLATFORM tp, V$DATABASE d WHERE tp.PLATFORM_NAME = d.PLATFORM_NAME;-- 查询字符集select * from nls_database_parameters where parameter like '%CHARACTERSET%';select userenv('language') from dual; 数据库时区，源端与目标端的时区需相同 select dbtimezone from dual; 数据库版本及补丁，源端 ≥10.2.0.3 企业版，目标端 ≥11.2.0.4 企业版 select * from v$version;SELECT * ...

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

CRS-1714 Unable to discover any voting files APPLIES TO Operating System - Oracle Linux Server 7.9 Oracle Database - Enterprise Edition - Version 11.2.0.4.0 Oracle Grid Infrastructure - Version 11.2.0.4.0 SYMPTOMS 操作系统重启后，crs 无法正常启动 [grid@rac1 ~]$ crsctl stat res -tCRS-4535: Cannot communicate with Cluster Ready ServicesCRS-4000: Command Status failed, or completed with errors. 查看 /u01/app/11.2.0/grid/log/rac1/alertrac1.log 日志，出现无法识别到 voting files 报错 [cssd(3348)]CRS-1714:Unable to discov...

CRS-4124 Oracle High Availability Services startup failed APPLIES TO Operating System - Oracle Linux Server 7.9 Oracle Database - Enterprise Edition - Version 11.2.0.3.0 - 11.2.0.4.0 Oracle Grid Infrastructure - Version 11.2.0.2 - 11.2.0.4.0 SYMPTOMS When installing the GI software and executing root.sh, an error occurs: CRS-4124: Oracle High Availability Services startup failed.CRS-4000: Command Start failed, or completed with errors.ohasd failed to start: Inappropriate ioctl for device...

Error in invoking target agent nmhs of makerfile ins_emagent.mk APPLIES TO Operating System - Red Hat Enterprise Linux Server 7.9 Oracle Database - Enterprise Edition - version 11.2.0.4 Oracle Grid Infrastructure - version 11.2.0.4 SYMPTOMS During runInstaller(OUI), popup make error in invoking target 'agent nmhs', found errors in install log /u01/app/oraInventory/logs/installActions2023-08-07_01-52-08PM.log INFO: make[1]: *** [/u01/app/oracle/product/11.2.0.4/db_1/sysman/lib/emdctl] Er...

ORA-00600 2662 APPLIES TO Operating System - Oracle Linux Server 7.9 Oracle Database - Enterprise Edition - version 11.2.0.4.0 Oracle Grid Infrastructure - version 11.2.0.4.0 SYMPTOMS 在一次数据库恢复过程中，使用_ALLOW_RESETLOGS_CORRUPTION = TRUE 这个隐含参数来强制打开数据库，遇到 ORA-00600: internal error code, arguments: [2662] 报错如下： Errors in file /app/oracle/admin/rac/udump/rac1_ora_3997860.trc:ORA-00600: internal error code, arguments: [2662], [3186] [3707069194], [3186], [3707142625], [29580553], [], [] CAUSE 关...

ORA-00845 APPLIES TO Oracle Database - Enterprise Edition - version 11.2.0.4.0 SYMPTOMS 数据库启动后，alert_orcl.log 日志文件出现如下报错： WARNING: You are trying to use the MEMORY_TARGET feature. This feature requires the /dev/shm file system to be mounted for at least 830472192 bytes. /dev/shm is either not mounted or is mounted with available space less than this size. Please fix this so that MEMORY_TARGET can work as expected. Current available is 453869568 and used is 55934976 bytes. Ensure that the...