张玉龙-CSDN博客

原创 Eclipse安装慢，卡在绿色进度条一直不动

可能有墙的原因，安装时下载一些东西下载不了，如果不是必须要用新版本，可以选择下载老版本，老版本解压就能用。https://www.eclipse.org/downloads/packages/已共享网盘：链接：https://pan.baidu.com/s/1Zzyl7VUOFoaF45912CcgXQ提取码：njkt...

2021-11-05 10:31:07 23843 2

https://highlightjs.org/static/demo/<link rel="stylesheet" href="https://cdn.jsdelivr.net/gh/highlightjs/cdn-release@11.3.1/build/styles/arta.min.css"><link rel="stylesheet" href="https://cdn.jsdelivr.net/gh/highlightjs/cdn-release@11.3.1/buil

2021-11-04 10:44:45 1649

原创 PostgreSQL高可用测试系列之Patroni + etcd + HAProxy + Keepalived 离线部署

自制的测试环境架构图第一章：介绍测试环境PostgreSQL高可用测试系列之Patroni + etcd + HAProxy + Keepalived 离线部署（一） - 墨天轮第二章： PostgreSQL + replication 部署PostgreSQL高可用测试系列之Patroni + etcd + HAProxy + Keepalived 离线部署（二） - 墨天轮第三章： Etcd 部署和管理PostgreSQL高可用测试系列之Patroni + etcd + HAP

2021-11-03 16:24:12 1318

原创 python中时间日期格式化符号

li = [chr(i) for i in range(ord("a"),ord("z")+1)]for i in li: try: print(i+'----------->'+time.strftime("%"+i, time.localtime())) except ValueError: print(i+'----------->None') continuea----------->Monb-------...

2021-03-15 22:10:00 412

翻译 Reusing the Source Standby Database Files When Plugging a non-CDB as a PDB into the Primary Database

Reusing the Source Standby Database Files When Plugging a non-CDB as a PDB into the Primary Database of a Data Guard Configuration (Doc ID 2273304.1)APPLIES TO:Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterOracle Database Cloud Sche

2020-08-10 10:28:56 351

翻译 Relocating a PDB

您可以将PDB移动到其他CDB或application container。8.1About PDB Relocation在relocation期间，源PDB可以以 read/write 模式打开并且功能齐全。当源PDB通过活动会话打开时，PDB relocation将执行源PDB数据文件的在线块级副本，redo和undo。当目标PDB由于ALTER PLUGGABLE DATABASE OPEN语句而联机时，Oracle数据库将终止活动会话并关闭源PDB。下图显示了common PDB.

2020-08-04 17:50:50 462

翻译使用AutoUpgrade进行Oracle数据库升级_1

https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/using-autoupgrade-oracle-database-upgrades.html#GUID-71883C8C-7A34-4E93-8955-040CB04F2109Using AutoUpgrade for Oracle Database Upgrades使用AutoUpgrade进行Oracle数据库升级About Oracle Database

2020-07-22 16:48:52 2315

原创 Oracle RAC 19.3打补丁到19.6 Datapatch ORA-29516 ORA-00604 and ORA-29532 java.lang.ArrayIndexOutOfBoundsE

先安装19.3.0.0.0的GI和DB软件，然后安装19.6.0.0.0的GI和DB补丁，最后DBCA建库，建库耗时很长，用了3个多小时，然而数据库没有成功apply RU，并且数据库组件SDO INVALID。SQL> select status,description from dba_registry_sqlpatch;STATUS DE...

2020-04-09 16:12:05 1462

原创 CRS-2101:The OLR was formatted using version 3

11.2.0.4 GI 在 RHEL 7 上安装，执行root.sh脚本出现以下错误信息Adding Clusterware entries to inittabohasd failed to startFailed to start the Clusterware. Last 20 lines of the alert log follow:2020-03-07 11:56:17....

2020-03-07 12:10:20 4280

转载如何确定一个dmp文件是传统export(exp)导出的还是DataPump Export(expdp)导出的？ (Doc ID 2533832.1)

适用于:Oracle Database - Enterprise Edition - 版本 10.2.0.1 和更高版本本文档所含信息适用于所有平台目标如何确定一个dmp文件是exp导出的还是expdp导出的？解决方案DBMS_DATAPUMP.GET_DUMPFILE_INFO()存储过程可以从dump文件中获取信息。Filetype返回以下文件类型： 1： Da...

2020-02-27 19:51:28 644

转载如何从 ASH 找到消耗 PGA 和临时表空间较多的 Top SQL_ID (Doc ID 2610646.1)

适用于:Oracle Database - Enterprise Edition - 版本 11.2.0.1 和更高版本本文档所含信息适用于所有平台目标提供一些诊断脚本，用于从 ASH 中找到最消耗 PGA 或者临时段的 sql_id。这有助于诊断 ORA-1652 错误。解决方案最消耗 PGA 的 sql_id：select *from (select in...

2020-02-26 13:42:32 503

转载测试案例 - 12c 版本，如何将 Non-CDB 转换为 PDB 数据库 (Doc ID 2610618.1)

适用于:Oracle Database - Enterprise Edition - 版本 12.1.0.1 到 12.1.0.2 [发行版 12.1]Oracle Database Cloud Schema Service - 版本 N/A 和更高版本Oracle Database Exadata Cloud Machine - 版本 N/A 和更高版本Oracle Cloud Inf...

2020-02-26 13:32:45 509

原创不可视索引和相同列上的多个索引

在删除一个索引之前，建议先将索引设置为不可视(invisible)状态，不可视状态相当于将索引隐藏起来。但是索引上的维护工作还会继续(DML操作的同时维护索引上的数据)。因为可能需要快速启用这个不可视索引。使索引不可视的方法：alter index idx1 invisible;create index ... invisible;使索引可视的方法：alter index i...

2020-01-04 08:48:03 202

翻译在Session被kill后，如何查找进程标识符(pid, spid) (Doc ID 387077.1)

How To Find The Process Identifier (pid, spid) After The Corresponding Session Is Killed? (Doc ID 387077.1)APPLIES TO:Oracle Database - Enterprise Edition - Version 9.2.0.1 to 12.2.0.1 [Release 9....

2019-11-29 14:00:41 542

翻译 How to Kill a Session on RAC Database In Instance Independent Fashion. (Doc ID 869777.1)

How to Kill a Session on RAC Database In Instance Independent Fashion. (Doc ID 869777.1)APPLIES TO:Oracle Database - Enterprise Edition - Version 11.1.0.6 and laterOracle Database Cloud Schema Se...

2019-11-29 13:29:57 158

原创示例：Oracle创建索引时中断，再次创建报错ORA-00955，rebuild报错ORA-08104，使用DBMS_REPAIR.ONLINE_INDEX_CLEAN解决

创建测试环境create table t as select * from dba_objects;insert into t select * from t; --多次执行，模拟大数据量，这样创建索引时间长，容易模拟故障SQL> select count(*) from t; COUNT(*)---------- 11041152exec DBMS...

2019-11-29 10:43:35 1874

原创 SecureCRT中SFTP的使用

当你有SecureCRT可以远程连接服务器如果想在远程服务器上下载或上传文件，而此时没有FTP软件，可以考虑使用SecureCRT的中SFTP命令行功能SFTP命令支持TAB键补全帮助命令sftp> help上传 put下载 getsftp> lcd d:/zylongsftp> get /home/oracle/awrrpt_1_76170_7...

2019-11-29 09:04:37 533

原创示例，RHEL 7.x 上因大页内存参数设置过大，重启系统启动失败，使用救援模式修复系统

错误配置hugepages设置导致此问题。发现hugepages 大小大于总内存大小[root@test ~]# cat /etc/sysctl.conf |grep vm.nr_hugepagesvm.nr_hugepages = 282[root@test ~]# cat /proc/meminfo |grep MemTotalMemTotal: 1882300 k...

2019-11-28 18:13:06 1921

翻译如何通过Systemd将Oracle Linux 7.x引导到救援模式或紧急模式 (Doc ID 2153996.1)

How to Bootup Oracle Linux 7.x into Rescue Mode or Emergency Mode Through Systemd (Doc ID 2153996.1)APPLIES TO:Linux OS - Version Oracle Linux 7.0 and laterLinux x86-64GOALThis article explai...

2019-11-28 08:56:39 1116

翻译如何从ISO映像将Oracle Linux 7.x引导到救援模式 (Doc ID 2302734.1)

How to Bootup Oracle Linux 7.x into Rescue Mode From ISO Image (Doc ID 2302734.1)APPLIES TO:Linux OS - Version Oracle Linux 7.0 and laterLinux x86-64GOALWhen there is some issue that causes t...

2019-11-28 08:41:01 514

翻译如何将Oracle Linux 5.x引导到救援模式 (Doc ID 1516777.1)

How to Boot Oracle Linux 5.x into Rescue Mode (Doc ID 1516777.1)APPLIES TO:Linux OS - Version Oracle Linux 4.4 to Oracle Linux 5.11 [Release OL4U4 to OL5U11]Oracle Cloud Infrastructure - Version ...

2019-11-28 08:21:17 660

翻译配置大页重启OS失败，Kernel Panic - not syncing: Out of memory and no killable processes"(Doc ID 2156783.1)

After Configuring Hugepages Linux Server Crashes with "Kernel Panic - not syncing: Out of memory and no killable processes" During the Bootup (Doc ID 2156783.1)APPLIES TO:Linux OS - Version Oracle...

2019-11-28 08:20:52 795

翻译在Linux IA64上使用hugepages分配48GB SGA的示例 (Doc ID 397568.1)

Linux IA64 example of allocating 48GB SGA using hugepages (Doc ID 397568.1)APPLIES TO:Linux OS - Version 2.6.9 to 2.6.9Oracle Cloud Infrastructure - Version N/A and laterLinux Itanium***Checked...

2019-11-27 15:58:23 169

翻译 Oracle Linux: 如何计算HugePages保留的内存 (Doc ID 2546416.1)

Oracle Linux: How To Calculate The Memory Reserved By HugePages (Doc ID 2546416.1)APPLIES TO:Linux OS - Version Oracle Linux 6.0 and laterLinux x86Linux x86-64GOALCalculate the percentage o...

2019-11-27 15:30:04 315

翻译何时以及为何在Linux x86-64上使用HugePages? (Doc ID 2314903.1)

When And Why To Use HugePages on Linux x86-64? (Doc ID 2314903.1)APPLIES TO:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 12.2.0.1 [Release 10.2 to 12.2]Oracle Database - Standard Ed...

2019-11-27 14:29:55 215

翻译 HugePages on Oracle Linux 64-bit (Doc ID 361468.1)

HugePages on Oracle Linux 64-bit (Doc ID 361468.1)APPLIES TO:Oracle Cloud Infrastructure - Database Service - Version N/A and laterOracle Database Cloud Exadata Service - Version N/A and laterOr...

2019-11-27 12:35:44 328

翻译如何将使用AMM（自动内存管理）数据库转换为已配置有大页Hugepages的数据库 (Doc ID 2128928.1)

How To Convert A Database Using AMM (Automatic Memory Management) To A Database That Has Been Configured With Hugepages (Doc ID 2128928.1)APPLIES TO:Oracle Database - Enterprise Edition - Version ...

2019-11-27 11:00:52 485

翻译什么是Memlock？如何计算Memlock的值？(Doc ID 2511230.1)

What is Memlock and How to Calculate the Values for Memlock? (Doc ID 2511230.1)APPLIES TO:Linux OS - Version Oracle Linux 6.10 to Oracle Linux 7.6 [Release OL6U10 to OL7U6]Linux x86Linux x86-64...

2019-11-27 10:22:07 9248 2

翻译 Oracle Linux: 用于计算推荐的Linux HugePages/HugeTLB配置的值的Shell脚本(Doc ID 401749.1)

Oracle Linux: Shell Script to Calculate Values Recommended Linux HugePages / HugeTLB Configuration (Doc ID 401749.1)APPLIES TO:Oracle Database - Enterprise EditionOracle Database Cloud Schema Ser...

2019-11-27 10:05:38 399

翻译如何计算某个进程使用的 Hugepage Size (Doc ID 2493079.1)

How to Calculate Hugepage Size Which is Used by a Certain Process (Doc ID 2493079.1)APPLIES TO:Linux OS - Version Oracle Linux 5.8 with Unbreakable Enterprise Kernel [2.6.39] and laterLinux x86-6...

2019-11-27 09:55:40 951

翻译 Oracle Linux: 如何在Oracle Linux 7上禁用透明HugePages (Doc ID 2336923.1)

Oracle Linux: How To Disable Transparent HugePages On Oracle Linux 7 (Doc ID 2336923.1)APPLIES TO:Linux OS - Version Oracle Linux 7.3 with Unbreakable Enterprise Kerne [4.1.12] and laterInformati...

2019-11-27 09:31:22 296

翻译 ALERT: 禁用透明 HugePages on SLES11, RHEL6, RHEL7, OL6, OL7, and UEK2 and above (Doc ID 1557478.1)

ALERT: Disable Transparent HugePages on SLES11, RHEL6, RHEL7, OL6, OL7, and UEK2 and above (Doc ID 1557478.1)APPLIES TO:Oracle Database - Enterprise EditionOracle Database - Standard EditionOrac...

2019-11-27 09:00:30 290

转载 Export/Import DataPump Parameter VERSION (Doc ID 553337.1)

Export/Import DataPump Parameter VERSION - Compatibility of Data Pump Between Different Oracle Versions (Doc ID 553337.1)APPLIES TO:Enterprise Manager for Oracle Database - Version 10.1.0.2 and la...

2019-11-25 16:59:32 4158

原创 Oracle AHF 只提取 orachk

root@orcl1:/home/oracle/ahf> ./ahf_setup -extract orachkAHF Installer for Platform Linux Architecture x86_64AHF Installation Log : /tmp/ahf_install_75012_2019_11_21-08_38_48.logStarting ...

2019-11-25 15:31:51 841

原创数据泵通过dblink使用参数network_link执行IMPDP/EXPDP

ORCL1 是源端，ORCL2是目标端1. IMPDP + network_link, 直接将源端数据导入到目标库中(DUMP文件不落地)--在ORCL2上创建DBLINK到ORCL1create [public] database link <link_name> connect to <user on export instance> identified ...

2019-11-25 15:21:48 619

翻译使用带有NETWORK_LINK的IMPDP传输LOB时的性能问题 (Doc ID 1488229.1)

Performance Problems When Transferring LOBs Using IMPDP With NETWORK_LINK (Doc ID 1488229.1)SYMPTOMSA severe performance impact is experienced when using IMPDP with the NETWORK_LINK command line o...

2019-11-25 10:29:57 448

翻译 Ora-01031 将Flashback_time选项与EXPDP/IMPDP Network_link一起使用时权限不足(Doc ID 436106.1)

Ora-01031: Insufficient Privileges, When Using The Flashback_time Option with EXPDP/IMPDP Network_link (Doc ID 436106.1)APPLIES TO:Oracle Database - Enterprise Edition - Version 10.1.0.2 and later...

2019-11-25 09:55:28 738

翻译 QREF: SQL Statement HINTS (Doc ID 29236.1)

QREF: SQL Statement HINTS (Doc ID 29236.1)PURPOSEList and explain some of the hints for the CBO列出并解释有关CBO的一些HintDETAILSGeneral"A statement block can have only one comment containing hin...

2019-11-23 01:16:32 465

翻译索引跳跃扫描 Index Skip Scan Feature (Doc ID 212391.1)

Index Skip Scan Feature (Doc ID 212391.1)APPLIES TO:Oracle Database - Enterprise Edition - Version 10.2.0.4 and laterOracle Database Cloud Schema Service - Version N/A and laterOracle Database E...

2019-11-23 00:52:01 190

翻译索引快速全扫描(Fast Full Scan)用法，以避免全表扫描(Full Table Scans) (Doc ID 70135.1)

Index Fast Full Scan Usage To Avoid Full Table Scans (Doc ID 70135.1)APPLIES TO:Oracle Database - Enterprise Edition - Version 7.3.0.0 to 12.1.0.2 [Release 7.3.0 to 12.1]Oracle Database Cloud Sch...

2019-11-23 00:42:12 2198

空空如也

空空如也