<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[u010692693的专栏]]></title><description><![CDATA[]]></description><link>https://blog.csdn.net/u010692693</link><language>zh-cn</language><generator>https://blog.csdn.net/</generator><copyright><![CDATA[Copyright &copy; u010692693]]></copyright><item><title><![CDATA[Eclipse安装慢，卡在绿色进度条一直不动]]></title><link>https://blog.csdn.net/u010692693/article/details/121157741</link><guid>https://blog.csdn.net/u010692693/article/details/121157741</guid><author>u010692693</author><pubDate>Fri, 05 Nov 2021 10:31:07 +0800</pubDate><description><![CDATA[可能有墙的原因，安装时下载一些东西下载不了，如果不是必须要用新版本，可以选择下载老版本，老版本解压就能用。

https://www.eclipse.org/downloads/packages/






已共享网盘：

链接：https://pan.baidu.com/s/1Zzyl7VUOFoaF45912CcgXQ
提取码：njkt
...]]></description><category></category></item><item><title><![CDATA[Markdown编辑器 代码高亮]]></title><link>https://blog.csdn.net/u010692693/article/details/121137565</link><guid>https://blog.csdn.net/u010692693/article/details/121137565</guid><author>u010692693</author><pubDate>Thu, 04 Nov 2021 10:44:45 +0800</pubDate><description><![CDATA[https://highlightjs.org/static/demo/


&lt;link rel="stylesheet" href="https://cdn.jsdelivr.net/gh/highlightjs/cdn-release@11.3.1/build/styles/arta.min.css"&gt;
&lt;link rel="stylesheet" href="https://cdn.jsdelivr.net/gh/highlightjs/cdn-release@11.3.1/buil]]></description><category></category></item><item><title><![CDATA[PostgreSQL高可用测试系列之Patroni + etcd + HAProxy + Keepalived 离线部署]]></title><link>https://blog.csdn.net/u010692693/article/details/121123843</link><guid>https://blog.csdn.net/u010692693/article/details/121123843</guid><author>u010692693</author><pubDate>Wed, 03 Nov 2021 16:24:12 +0800</pubDate><description><![CDATA[自制的测试环境架构图



第一章： 介绍测试环境

PostgreSQL高可用测试系列之Patroni + etcd + HAProxy + Keepalived 离线部署（一） - 墨天轮
第二章： PostgreSQL + replication 部署

PostgreSQL高可用测试系列之Patroni + etcd + HAProxy + Keepalived 离线部署（二） - 墨天轮
第三章： Etcd 部署和管理

PostgreSQL高可用测试系列之Patroni + etcd + HAP]]></description><category></category></item><item><title><![CDATA[python中时间日期格式化符号]]></title><link>https://blog.csdn.net/u010692693/article/details/114854820</link><guid>https://blog.csdn.net/u010692693/article/details/114854820</guid><author>u010692693</author><pubDate>Mon, 15 Mar 2021 22:10:00 +0800</pubDate><description><![CDATA[li = [chr(i) for i in range(ord("a"),ord("z")+1)]
for i in li:
    try:
        print(i+'-----------&gt;'+time.strftime("%"+i, time.localtime()))
    except ValueError:
        print(i+'-----------&gt;None')
    continue



a-----------&gt;Mon
b-------...]]></description><category></category></item><item><title><![CDATA[Reusing the Source Standby Database Files When Plugging a non-CDB as a PDB into the Primary Database]]></title><link>https://blog.csdn.net/u010692693/article/details/107904750</link><guid>https://blog.csdn.net/u010692693/article/details/107904750</guid><author>u010692693</author><pubDate>Mon, 10 Aug 2020 10:28:56 +0800</pubDate><description><![CDATA[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 later
Oracle Database Cloud Sche]]></description><category></category></item><item><title><![CDATA[Relocating a PDB]]></title><link>https://blog.csdn.net/u010692693/article/details/107788376</link><guid>https://blog.csdn.net/u010692693/article/details/107788376</guid><author>u010692693</author><pubDate>Tue, 04 Aug 2020 17:50:50 +0800</pubDate><description><![CDATA[您可以将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.]]></description><category></category></item><item><title><![CDATA[使用AutoUpgrade进行Oracle数据库升级_1]]></title><link>https://blog.csdn.net/u010692693/article/details/107516459</link><guid>https://blog.csdn.net/u010692693/article/details/107516459</guid><author>u010692693</author><pubDate>Wed, 22 Jul 2020 16:48:52 +0800</pubDate><description><![CDATA[https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/using-autoupgrade-oracle-database-upgrades.html#GUID-71883C8C-7A34-4E93-8955-040CB04F2109

Using AutoUpgrade for Oracle Database Upgrades

使用AutoUpgrade进行Oracle数据库升级

About Oracle Database]]></description><category></category></item><item><title><![CDATA[Oracle RAC 19.3打补丁到19.6 Datapatch ORA-29516 ORA-00604 and ORA-29532 java.lang.ArrayIndexOutOfBoundsE]]></title><link>https://blog.csdn.net/u010692693/article/details/105413130</link><guid>https://blog.csdn.net/u010692693/article/details/105413130</guid><author>u010692693</author><pubDate>Thu, 09 Apr 2020 16:12:05 +0800</pubDate><description><![CDATA[先安装19.3.0.0.0的GI和DB软件，然后安装19.6.0.0.0的GI和DB补丁，最后DBCA建库，建库耗时很长，用了3个多小时，然而数据库没有成功apply RU，并且数据库组件SDO INVALID。


SQL&gt; select status,description from dba_registry_sqlpatch;

STATUS          DE...]]></description><category></category></item><item><title><![CDATA[CRS-2101:The OLR was formatted using version 3]]></title><link>https://blog.csdn.net/u010692693/article/details/104712471</link><guid>https://blog.csdn.net/u010692693/article/details/104712471</guid><author>u010692693</author><pubDate>Sat, 07 Mar 2020 12:10:20 +0800</pubDate><description><![CDATA[11.2.0.4 GI 在 RHEL 7 上安装，执行root.sh脚本出现以下错误信息


Adding Clusterware entries to inittab
ohasd failed to start
Failed to start the Clusterware. Last 20 lines of the alert log follow:
2020-03-07 11:56:17....]]></description><category></category></item><item><title><![CDATA[如何确定一个dmp文件是传统export(exp)导出的还是DataPump Export(expdp)导出的？ (Doc ID 2533832.1)]]></title><link>https://blog.csdn.net/u010692693/article/details/104543499</link><guid>https://blog.csdn.net/u010692693/article/details/104543499</guid><author>u010692693</author><pubDate>Thu, 27 Feb 2020 19:51:28 +0800</pubDate><description><![CDATA[适用于:

Oracle Database - Enterprise Edition - 版本 10.2.0.1 和更高版本
本文档所含信息适用于所有平台

目标

如何确定一个dmp文件是exp导出的还是expdp导出的？

解决方案


DBMS_DATAPUMP.GET_DUMPFILE_INFO()存储过程可以从dump文件中获取信息。
Filetype返回以下文件类型：

 1： Da...]]></description><category></category></item><item><title><![CDATA[如何从 ASH 找到消耗 PGA 和 临时表空间 较多的 Top SQL_ID (Doc ID 2610646.1)]]></title><link>https://blog.csdn.net/u010692693/article/details/104515643</link><guid>https://blog.csdn.net/u010692693/article/details/104515643</guid><author>u010692693</author><pubDate>Wed, 26 Feb 2020 13:42:32 +0800</pubDate><description><![CDATA[适用于:

Oracle Database - Enterprise Edition - 版本 11.2.0.1 和更高版本
本文档所含信息适用于所有平台

目标

提供一些诊断脚本，用于从 ASH 中找到最消耗 PGA 或者临时段的 sql_id。

这有助于诊断 ORA-1652 错误。



解决方案

最消耗 PGA 的 sql_id：

select *
from (select in...]]></description><category></category></item><item><title><![CDATA[测试案例 - 12c 版本，如何将 Non-CDB 转换为 PDB 数据库 (Doc ID 2610618.1)]]></title><link>https://blog.csdn.net/u010692693/article/details/104515510</link><guid>https://blog.csdn.net/u010692693/article/details/104515510</guid><author>u010692693</author><pubDate>Wed, 26 Feb 2020 13:32:45 +0800</pubDate><description><![CDATA[适用于:

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...]]></description><category></category></item><item><title><![CDATA[不可视索引和相同列上的多个索引]]></title><link>https://blog.csdn.net/u010692693/article/details/103829574</link><guid>https://blog.csdn.net/u010692693/article/details/103829574</guid><author>u010692693</author><pubDate>Sat, 04 Jan 2020 08:48:03 +0800</pubDate><description><![CDATA[在删除一个索引之前，建议先将索引设置为不可视(invisible)状态，不可视状态相当于将索引隐藏起来。但是索引上的维护工作还会继续(DML操作的同时维护索引上的数据)。因为可能需要快速启用这个不可视索引。

使索引不可视的方法：


alter index idx1 invisible;
create index ... invisible;

使索引可视的方法：


alter index i...]]></description><category></category></item><item><title><![CDATA[在Session被kill后，如何查找进程标识符(pid, spid) (Doc ID 387077.1)]]></title><link>https://blog.csdn.net/u010692693/article/details/103309127</link><guid>https://blog.csdn.net/u010692693/article/details/103309127</guid><author>u010692693</author><pubDate>Fri, 29 Nov 2019 14:00:41 +0800</pubDate><description><![CDATA[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....]]></description><category></category></item><item><title><![CDATA[How to Kill a Session on RAC Database In Instance Independent Fashion. (Doc ID 869777.1)]]></title><link>https://blog.csdn.net/u010692693/article/details/103309017</link><guid>https://blog.csdn.net/u010692693/article/details/103309017</guid><author>u010692693</author><pubDate>Fri, 29 Nov 2019 13:29:57 +0800</pubDate><description><![CDATA[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 later
Oracle Database Cloud Schema Se...]]></description><category></category></item><item><title><![CDATA[示例：Oracle创建索引时中断，再次创建报错ORA-00955，rebuild报错ORA-08104，使用DBMS_REPAIR.ONLINE_INDEX_CLEAN解决]]></title><link>https://blog.csdn.net/u010692693/article/details/103306184</link><guid>https://blog.csdn.net/u010692693/article/details/103306184</guid><author>u010692693</author><pubDate>Fri, 29 Nov 2019 10:43:35 +0800</pubDate><description><![CDATA[创建测试环境


create table t as select * from dba_objects;
insert into t select * from t;       --多次执行，模拟大数据量，这样创建索引时间长，容易模拟故障

SQL&gt; select count(*) from t;

  COUNT(*)
----------
  11041152


exec DBMS...]]></description><category></category></item><item><title><![CDATA[SecureCRT中SFTP的使用]]></title><link>https://blog.csdn.net/u010692693/article/details/103304099</link><guid>https://blog.csdn.net/u010692693/article/details/103304099</guid><author>u010692693</author><pubDate>Fri, 29 Nov 2019 09:04:37 +0800</pubDate><description><![CDATA[当你有SecureCRT可以远程连接服务器

如果想在远程服务器上下载或上传文件，而此时没有FTP软件，可以考虑使用SecureCRT的中SFTP命令行功能



SFTP命令支持TAB键补全

帮助命令

sftp&gt; help

上传 put

下载 get

sftp&gt; lcd d:/zylong
sftp&gt; get /home/oracle/awrrpt_1_76170_7...]]></description><category></category></item><item><title><![CDATA[示例，RHEL 7.x 上因大页内存参数设置过大，重启系统启动失败，使用救援模式修复系统]]></title><link>https://blog.csdn.net/u010692693/article/details/103298266</link><guid>https://blog.csdn.net/u010692693/article/details/103298266</guid><author>u010692693</author><pubDate>Thu, 28 Nov 2019 18:13:06 +0800</pubDate><description><![CDATA[错误配置hugepages设置导致此问题。发现hugepages 大小大于总内存大小


[root@test ~]# cat /etc/sysctl.conf |grep vm.nr_hugepages
vm.nr_hugepages = 282

[root@test ~]# cat /proc/meminfo |grep MemTotal
MemTotal:        1882300 k...]]></description><category></category></item><item><title><![CDATA[如何通过Systemd将Oracle Linux 7.x引导到救援模式或紧急模式 (Doc ID 2153996.1)]]></title><link>https://blog.csdn.net/u010692693/article/details/103286858</link><guid>https://blog.csdn.net/u010692693/article/details/103286858</guid><author>u010692693</author><pubDate>Thu, 28 Nov 2019 08:56:39 +0800</pubDate><description><![CDATA[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 later
Linux x86-64

GOAL

This article explai...]]></description><category></category></item><item><title><![CDATA[如何从ISO映像将Oracle Linux 7.x引导到救援模式 (Doc ID 2302734.1)]]></title><link>https://blog.csdn.net/u010692693/article/details/103286775</link><guid>https://blog.csdn.net/u010692693/article/details/103286775</guid><author>u010692693</author><pubDate>Thu, 28 Nov 2019 08:41:01 +0800</pubDate><description><![CDATA[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 later
Linux x86-64

GOAL

When there is some issue that causes t...]]></description><category></category></item></channel></rss>