自定义博客皮肤VIP专享

*博客头图:

格式为PNG、JPG,宽度*高度大于1920*100像素,不超过2MB,主视觉建议放在右侧,请参照线上博客头图

请上传大于1920*100像素的图片!

博客底图:

图片格式为PNG、JPG,不超过1MB,可上下左右平铺至整个背景

栏目图:

图片格式为PNG、JPG,图片宽度*高度为300*38像素,不超过0.5MB

主标题颜色:

RGB颜色,例如:#AFAFAF

Hover:

RGB颜色,例如:#AFAFAF

副标题颜色:

RGB颜色,例如:#AFAFAF

自定义博客皮肤

-+
  • 博客(35)
  • 收藏
  • 关注

原创 离线部署Oceanbase企业版1-1-1集群

一步一步带你了解ob企业版安装配置与优化

2024-04-28 08:50:13 673

原创 cisp应试总结

cisp应试注意点

2024-04-26 13:39:52 249

原创 一文带你了解rac进行IPV6改造

一文带你了解oracle rac进行ipv6改造,实现ipv4/ipv6双栈运行

2024-04-25 22:11:37 397 1

原创 离线部署Oceanbase单节点集群

纯纯适合小白的一步步教你离线安装部署OB单节点集群

2024-04-12 22:24:08 121

原创 点个关注撒~~

VX上点个关注 交个朋友撒

2024-04-10 15:37:14 373

原创 Verification of shared storage accessibility was unsuccessful,NODE_STATUS::db03:EFAIL,PRVF-4009

然后从db01、db02分别重新ssh db03,之后会重新生成对应的ssh key值 ,再次验证便可成功。直观的感觉是到db03节点的用户等效性未设置,即ssh互信,可是经过测试三个节点之间的互信是没有问题的!将db03节点的所有key值 删除,(包括主机名、IP分别开头的所有行)三个节点的rac,打补丁在做analyze冲突检测时发生了错误。清晰了,ssh key值验证失败,

2024-04-08 22:55:38 710

原创 打补丁时报OPATCHAUTO-72083 Can‘t locate File/Basename.pm ZipUnzip.pl line 3 Basename.pm: (null)

rac打补丁时遇到OPATCHAUTO-72083等

2024-04-08 14:01:13 482

原创 hpux oracle 19c irman ioracle idrdactl idrdalsnr idrdaproc rac_on dnfs_on

hpux 11.31 oracle 19cRAC安装遇到的问题

2022-06-23 11:19:47 654 1

原创 hpux oracle19c dbca DBT-05509 Failed To Connect To The Specified Database

hpux11.31+oracle 19cRAC安装遇到的问题

2022-06-23 11:05:44 3627 2

原创 hpux oracle INS-06006 PRVF-7546

hpux11.31+oracle 19c安装遇到的问题

2022-06-23 10:57:34 1867

原创 /usr/lib/hpux32/dld.so: Unable to find library ‘libintl.so‘

Unable to find library 'libintl.so'

2022-06-14 10:26:38 700

原创 老DBA学习达梦dca的总结

最近报名学习了国产达梦数据库DCA的课程,在此将所有干货记录于此,希望能帮助到需要的人。说在前面的重点:1.考试时一定要细心,第一遍创建索引时没看到考卷要求的名字,检查时发现索引名起错了;创建表时字段为varchar,想当然的弄了个varchar2,当时真是瞎,瞎瞎瞎!2.备份那块一定要多练习,尤其是开启归档,如果考试时一直提示你归档配置不对,不要着急,心平气和地把manager退掉再重连3.考试时肯定不是建立5236端口的,如果嫌登陆麻烦可以运行dca.sh建立个网络服务名,你懂的4.第1点反复

2022-04-07 16:15:00 1284

原创 insert /* KSXM:TAKE_SNPSHOT */ into sys.optstat_snapshot$

收集统计信息时,活动连接中根本看不到收集统计信息的sql,而是如下的sql_id=3wh9htctp7199SQL_ID 3wh9htctp7199, child number 12insert /* KSXM:TAKE_SNPSHOT */ into sys.optstat_snapshot$ (obj#,inserts, updates, deletes, timestamp, flags) (select m.obj#, m.inserts,m.updates, m.deletes, sys

2021-01-09 13:55:38 919

原创 shadow tables

A shadow table is a column-organized copy of a row-organized table that includes all columns or a subset of columns. Shadow tables are implemented as materialized query tables (MQTs) that are maintained by replication.Using shadow tables, you can get the

2020-11-09 10:59:02 194

原创 Parameters in DB2 SQL procedures

https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.apdv.sqlpl.doc/doc/c0020495.html

2020-11-09 09:26:58 83

原创 HADR

HADR不支持双活,pureScale支持双活High availability disaster recovery (HADR) in Db2 pureScale environmentshttps://www.ibm.com/support/knowledgecenter/SSEPGG_11.5.0/com.ibm.db2.luw.admin.ha.doc/doc/c0061084.html

2020-11-08 21:19:20 146

原创 create index

The INCLUDE clause, applicable only on unique indexes, specifies additional columns to be appended to the set of index key columns. Any columns included with this clause are not used to enforce uniqueness. These included columns can improve the performance

2020-11-07 20:49:57 78

原创 Read stability (RS)

https://www.ibm.com/support/knowledgecenter/SSEPGG_11.5.0/com.ibm.db2.luw.admin.perf.doc/doc/c0004121.html#c0004121__rs

2020-11-07 15:40:32 86

原创 extended row size

https://www.ibm.com/support/knowledgecenter/SSEPGG_11.5.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0061057.html

2020-11-07 15:36:16 99

原创 trusted context

The trust relationship is based upon the following set of attributes:System authorization ID: Represents the user that establishes a database connectionIP address (or domain name): Represents the host from which a database connection is establishedData

2020-11-07 15:29:20 93

原创 trigger

INSTEAD OF triggers describe how to perform insert, update, and delete operations against complex views. INSTEAD OF triggers allow applications to use a view as the sole interface for all SQL operations (insert, delete, update and select)。INSTEAD OF触发器描述了

2020-11-07 14:48:57 109

原创 DB2 compatibility DB2_COMPATIBILITY_VECTOR

DB2 offers compatibility features through the DB2_COMPATIBILITY_VECTOR registry variable or the SQL_COMPAT global variable that improve application compatibility with which of the following? (Choose two.)A. OracleB. SybaseC. NetezzaD. MongoDBE. Micros

2020-09-17 09:26:01 212

原创 DB2 BLU acceleration fundamental

Which of the following is fundamental to BLU acceleration?A. pureScaleB. Column organized tablesC. Multidimensional clusteringD. Purchasing new hardware that is compatible with BLU acceleration and compressionhttp://www.redbooks.ibm.com/abstracts/tips

2020-09-16 10:30:50 137

原创 DB2 get_privileges

How can you tell what privileges on a table or view have been granted to a user? (Choose two.)A. db2look with the –x optionB. db2pd with the –auth optionC. Query the SYSCAT.DBAUTH viewD. Query the SYSCAT.TABLES viewE. Query the SYSCAT.TABAUTH viewhtt

2020-09-16 09:52:03 121

原创 DB2 pureScale

Which of the following is designed for continuous availability, increased throughput of many concurrent short queries, and easy scalability?A. DB2 HADRB. DB2 pureScaleC. DB2 Express-CD. DS2 Database Partitioning FeatureB:https://www.ibm.com/support/kn

2020-09-15 22:08:35 409

原创 DB2 create database

Which of the following authorities are sufficient for creating a database? (Choose two.)A. DBADMB. SYSADMC. SECADMD. SYSCTRLE. SYSMAINTcreate database:https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r00

2020-09-15 20:23:19 192

原创 DB2 create function

What type of function is created using the following command? CREATE FUNCTION TAN (X DOUBLE)RETURNS DOUBLELANGUAGE SQLCONTAINS SQLNO EXTERNAL ACTION DETERMINISTIC RETURN SIN(X)/COS(X)A. RowB. TableC. ScalarD. ExternalCREATE FUNCTION (SQL scalar, t

2020-09-15 20:20:57 420

原创 DB2 authorities

Which of the following authorities is sufficient for connecting to a database?A. SQLADMB. CONNECTC. DATAACESSD. ACCESSCTRLhttps://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.sec.doc/doc/c0005524.htmlSQLADMAllows the holde

2020-09-15 20:10:54 110

原创 db2 super exclusive(Z) lock

Which of the following statements describe super exclusive (Z) locks for a table? (Choose two.)A. No other applications can access the tableB. Only uncommitted read (UR) applications can access the tableC. The lock owner and other applications can read,

2020-09-15 20:04:54 257

原创 PerlEngine.execute:354 status is = 2

环境: 12.1 pdb今天在dbca建库时,最后一步完成创建时就会接收到报错:Error in Process: /oracle/app/oracle/12.1.0/perl/bin/perl创建cdb环境时,12.1版本组件不可选,创建一次要1个多小时,折腾了几次都是在最后一步报错使用网上找的帖子使用系统perl对oracle程序里的perl进行软链接$ ln -s /usr/bin...

2019-04-26 10:02:47 358

原创 asm参数无备份情况下修改参数不当导致asm实例无法启动的修复

修复过程如下:1.以独占模式启动集群crsctl start crs -excl -nocrs这时asm会由于原有参数不对启动失败2.手动启动asm可利用之前备份的pfile,没有备份的情况下可cp其它系统的pfile进行启动3.根据pfile生成spfile如果下一步验证失败,可在本步指定生成spfile的名称4.验证spfile是否有效asmcmd>spget5.验证...

2019-04-25 23:06:34 379

原创 ORA-00600 [ktspgfb-1]

故障描述:db alert日志显示4月1日18:00后报错“DDE: Problem Key ‘ORA 600 [ktspgfb-1]’ was completely flood controlled (0x6)”原因分析:参照官方metalink 1968287.1所述,为主机异常重启时oracle系统视图位图信息产生损坏所致。解决措施:新建表空间EOMS35DB2将可疑的lob字...

2019-04-17 22:50:20 2748

原创 lob表删除后dba_objects信息仍在

今天在删除带有Lob字段的表后发现个问题,表的定义已经没有了,但Lob信息仍然保留在dba_objects中,后经查找mos将回收站清理后不复存在13:05:23 ljc1>select * from v$version;BANNER ...

2019-04-01 15:28:58 767

原创 ORA-00245

Sat Nov 21 00:00:26 2015Control file backup creation failed:failure to open backup target file /oracle/app/oracle/12.1.0/dbs/snapcf_thradb2.f.需要把控制文件快照文件设置到一个共享存储上,否则对于RAC,会不时出现这种错误grid$asmcmd:mk...

2019-03-26 23:30:10 1314

原创 重建oracle inventory

重建Oracle inventory有的时候在打psu,或升级,运行opatch时经常会遇到 OPatch failed with error code 73 的问题,这种问题有时是由于oraInventory被异常删除导致的,可采用重建方法解决:10gr1$cd $ORACLE_HOME/oui/bin./runInstaller−silent−attachHomeORACLEHOME=...

2019-03-23 15:51:16 452

空空如也

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

提示
确定要删除当前文章?
取消 删除