- 博客(35)
- 收藏
- 关注
RSS订阅原创 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
715
原创 打补丁时报OPATCHAUTO-72083 Can‘t locate File/Basename.pm ZipUnzip.pl line 3 Basename.pm: (null)
rac打补丁时遇到OPATCHAUTO-72083等
2024-04-08 14:01:13
485
原创 hpux oracle 19c irman ioracle idrdactl idrdalsnr idrdaproc rac_on dnfs_on
hpux 11.31 oracle 19cRAC安装遇到的问题
2022-06-23 11:19:47
656
1
原创 hpux oracle19c dbca DBT-05509 Failed To Connect To The Specified Database
hpux11.31+oracle 19cRAC安装遇到的问题
2022-06-23 11:05:44
3644
2
原创 /usr/lib/hpux32/dld.so: Unable to find library ‘libintl.so‘
Unable to find library 'libintl.so'
2022-06-14 10:26:38
704
原创 老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
147
原创 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
100
原创 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
215
原创 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
359
原创 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
2754
原创 lob表删除后dba_objects信息仍在
今天在删除带有Lob字段的表后发现个问题，表的定义已经没有了，但Lob信息仍然保留在dba_objects中，后经查找mos将回收站清理后不复存在13:05:23 ljc1>select * from v$version;BANNER ...
2019-04-01 15:28:58
768
原创 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
1315
原创 重建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关注的人