andidz87381-CSDN博客

转载诊断：ORA-00376 & ORA-01110

现象：Errors in file /path/of/diag/rdbms/prod/PROD/trace/PROD_ora_13447.trc:ORA-00376: 此时无法读取文件 61ORA-01110: 数据文件 61: '/path/of/datafile/cuxd05.dbf'变化：硬件故障，IO层面错误。分析：此时从v$dataf...

2019-06-06 18:17:00 358

转载 ERROR 1133 (42000): Can't find any matching row in the user table

环境：操作系统：Redhat 7.5 x86-64数据库版本MySQL 5.7.25 现象：ERROR 1133 (42000): Can't find any matching row in the user table变化：新建用户，并进行赋权。原因：创建用户时create user user identified by 'password';默认用户为'user...

2019-06-03 17:48:00 245

转载诊断：MRP0: Background Media Recovery terminated with error 1111

表现：灾备环境，无法继续应用日志。日志：MRP0: Background Media Recovery terminated with error 1111Fri Jan 18 15:55:25 2019Errors in file /oracle/diag/rdbms/orcldg/ORCL/trace/ORCL_dbw0_67731.trc:ORA-0...

2019-01-30 16:43:00 596

转载诊断：RHEL7安装11.2RAC时root.sh错误ohasd failed to start

RHEL 7.5中安装11gRAC时，在grid infrastructure的root.sh执行时，报错：# /oracle/product/11g/grid/root.sh ...Adding Clusterware entries to inittabohasd failed to startFailed to start the Clusterware. ...

2019-01-04 22:11:00 416

转载诊断：CLSRSC-400: A system reboot is required to continue installing.

Linux7.5安装Grid Infrastructure 12.2.0.1时，在root.sh时会报错2018/01/30 09:19:28 CLSRSC-330: Adding Clusterware entries to file ‘oracle-ohasd.service’2018/01/30 09:21:03 CLSRSC-400: A system reboo...

2019-01-02 19:32:00 1977

转载 How To: IDENTIFY THE ASM DEVICE FROM ASMLIB

使用oracleasm querydisk可以查询到device的major和minor，从而对应。for i in `oracleasm listdisks`dooracleasm querydisk -d $idone示例输出：[root@tyzfdb01 ~]# for i in `oracleasm listdisks`> do&...

2018-12-13 12:28:00 103

转载 How To:利用frm和idb文件进行数据恢复.txt

在另外一个机器上准备测试数据，并传输到dbadb05机器的/mysql/backup/reco/位置下。开始尝试恢复数据一、使用mysqlfrm获取表结构信息及DDL语句。[mysql@dbadb05 reco]$ lltotal 108-rw-r----- 1 mysql mysql 8602 Aug 6 11:21 t.frm-rw-r----- 1 mysql ...

2018-08-06 16:37:00 181

转载 Bullet:MySQL增强半同步参数rpl_semi_sync_master_wait_point值AFTER_SYNC和AFTER_COMMIT的对比实验...

MySQL 5.7.22启用增强半同步复制MySQL对该参数值的描述Semisync can wait for slave ACKs at one of two points,AFTER_SYNC or AFTER_COMMIT. AFTER_SYNC is the default value.AFTER_SYNC means that semisynchronous...

2018-08-06 11:10:00 1331

转载诊断：ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance

11g数据库里面一个套RAC环境，之前搭建过DG，后来拆除掉。某次演练重启的时候，碰到数据库无法open的情况。日志显示WARNING: The 'LOG_ARCHIVE_CONFIG' init.ora parameter settingsare inconsistent with another started instance. This may becaused ...

2018-06-26 17:30:00 635

转载诊断：AWR快照停止自动采集

11.2.0.4数据库中，MMON进程，有时候由于一些莫名其妙的原因挂掉，接下来AWR的快照也就无法正常自动生成。MMON进程应该自动重启，却并没有自动被启动。那么我们有可能是遇到了bugBug 19565533 - MMON/MMNL CAN NOT BE AUTOMATICALLY RESTARTED AFTER KILLEDBug 14213856 : MMON A...

2018-06-06 17:40:00 338

转载诊断：Goldengate OGG-01163 Bad column length

故障现象：OGG-01163 Bad column length (27) specified for column MOBILE in table OWNER.TABLE, maximum allowable length is 20.原因：源端修改了字段长度。虽然源端和目标端的长度已经通过DDL语句修改到一致，在extract进程未重启的情况下，生成的trail...

2018-05-22 11:17:00 1853

转载诊断：expdp导出时遇到错误ORA-31693和ORA-00922

11.2.0.1使用数据泵expdp导出时，如果使用parallel，可能会遇到ORA-31693: Table data object "OWNER"."TABLE" failed to load/unload and is being skipped due to error:ORA-00922: missing or invalid option不适用pa...

2018-05-10 15:36:00 563

转载诊断：记一次存储异常CRASH致数据库无法正常打开的恢复

数据库存储异常crash，首先控制文件出现问题ORA-01122: ????? 1 ????ORA-01110: ???? 1: '/oracledata/oradata/orc11rac/orc11rac/system01.dbf'ORA-01207: ????????? - ??????/home/oracle>oerr ora 12070...

2018-05-07 14:26:00 228

转载 Script:shell脚本生成随机字符串

#!/bin/bash# bash generate random alphanumeric string## bash generate random 32 character alphanumeric string (upper and lowercase) and NEW_UUID=$(cat /dev/urandom | tr -dc 'a-zA-Z0-9...

2018-02-24 10:24:00 440

转载 How To:分析ORACLE监听日志中的IP信息

有时候需要分析出ORACLE日志监听中的IP信息，分享一个组合命令，Linux的shell下运行正常。grep "HOST=.*establish.*\* 0" listener.log | awk -F'*' '{match($3,/[0-9]+\.[0-9]+\.[0-9]+\.[0-9]+/); ip = substr($3,RSTART,RLENGTH);cnt[ip]+...

2018-02-02 14:06:00 614

转载诊断：ORA-38760: This database instance failed to turn on flashback database

$ oerr ora 3876038760, 00000, "This database instance failed to turn on flashback database"// *Cause: Database flashback is on but this instance failed to// start generating flashba...

2018-01-04 11:30:00 274

转载 How To:Linux下如何通过命令检查网卡是否插上网线

主要工具为ethtool来检查，主要关注的字段为"Link detected"，注意如下的输出，其中em4实际物理上并未插上网线，而em1是插上网线的：# ethtool em4Settings for em4: Supported ports: [ TP ] Supported link modes: 10baseT/Half 10b...

2017-06-15 01:55:00 136

转载 Bullet:ORACLE Using SQL Plan Management(一)

SQL Plan Management如何工作？当一个SQL硬解析时，基于成本的优化器CBO会生成多个执行计划，并从这些执行计划中选择一个优化器认为最低成本的执行计划。如果SQL plan baseline生效，优化器会将刚刚生成的执行计划与SQL plan baseline中的执行计划进行比较。如果该执行计划和基线中的执行计划匹配，且基线中的执行计划标记为可接受(accep...

2017-04-08 17:30:00 91

转载诊断：ORA-01919: role ‘PLUSTRACE’ does not exist

如下错误SQL> grant plustrace to scott;grant plustrace to scott*ERROR at line 1:ORA-01919: role 'PLUSTRACE' does not exist原因Role 'PLUSTRACE' 不存在解决办法以SYS身份运行如下脚本SQL> @?/sqlplu...

2017-02-20 13:54:00 895

转载 Bullet:关于ORACLE中的HASH JOIN的参数变化

Oracle在7.3引入了hash join。但是在Oracle 10g及其以后的Oracle数据库版本中，优化器，实际是CBO，也是因为HASH JOIN仅适用于CBO，在解析目标SQL时是否考虑HASH JOIN受到隐含参数_hash_join_enabled，该参数在Oracle 10g以前的版本中的参数名为hash_join_enabled，非隐含参数。_hash_joi...

2017-02-16 13:14:00 85

转载 How To:防火墙规则去重

主要命令iptables-save| awk ' !x[$0]++ | iptables-restore演示：[root@testname ~]# iptables -vLChain INPUT (policy ACCEPT 0 packets, 0 bytes)pkts bytes target prot opt in out source ...

2017-02-16 13:03:00 136

转载随笔：一道数学计算题，筐里最少多少各鸡蛋？

某天，群里面发了一个数学题，蛮好玩儿的。问：一筐鸡蛋，1个1个的拿，正好拿完；2个2个的拿，还剩1个；3个3个的拿，正好拿完；4个4个的拿，还剩1个；5个5个的拿，还差1个；6个6个的拿，还剩3个；7个7个的拿，正好拿完；8个8个的拿，还剩1个；9个9个的拿，正好拿完。问，筐里最少有多少鸡蛋？想呢：1. 1个1个的拿，正好拿完...

2017-02-15 14:59:00 143

转载 How To:使用dmidecode获取机器序列号(Serial number)

使用dmidecode可以获取关于机器的诸多信息，比如机器的序列号[root@dc1db01 ~]# dmidecode -s system-serial-numberprocessor的主频[root@dc1db01 ~]# dmidecode -s processor-frequency2200 MHz2200 MHz...

2015-11-28 11:24:00 1526

转载 Bullet:Python的函数中参数是引用吗？

别的语言中关于函数有传值和传引用的区分。关于此，流传很广的一个说法是他们在现象的区别之一就是值传递后的变化，受到影响的就是引用，未受到影响的就是传值。在学习中，也曾碰到过这个问题，网上关于这个也是有着一些争论，各执一词。但是官方文档中，却明确写着是call by object reference。https://docs.python.org/2/tutoria...

2015-11-27 00:55:00 111

转载 How To:python pip install

官方网站https://pypi.python.org/pypi/pip/下载需要的版本wget https://pypi.python.org/packages/source/p/pip/pip-7.1.2.tar.gz#md5=3823d2343d9f3aaab21cf9c917710196 --no-check-certificate...

2015-11-24 23:36:00 102

转载 How To: set udev rule for setting the disk permission on ASM disks when using multipath on Linux 6.x

在RHEL6.4上安装11gR2的RAC时，使用了MULTIPATH来聚合绑定多路径的磁盘，并且修改磁盘的权限，赋予grid:asmadmin用户和组。此时，在安装时可以发现磁盘，日志如下INFO: ... discoveryString = /dev/mapper/*INFO: Executing [/tmp/OraInstall2014-11-24_04-55-14P...

2015-11-01 17:45:00 176

转载 How To : Modify ASM SYS password using asmcmd 11g R2 and upper

修改RAC 11gR2及以上版本的ASM的SYS的密码方法[grid]$ asmcmdASMCMD> orapwusr --modify --password sysEnter password: ***ASMCMD> exit 转载于:https://www.cnblogs.com/syksky/p/4928095.html...

2015-11-01 16:34:00 88

转载 How To: Multipath Linux x86-64 Release 6.4

[root@node01 ~]# lsb_release -aLSB Version: :base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarchDistr...

2015-11-01 16:29:00 76

转载 How To:配置Linux iSCSI客户端

1、安装客户端[root@node01 Packages]# rpm -Uvh iscsi-initiator-utils-6.2.0.873-2.el6.x86_64.rpmwarning: iscsi-initiator-utils-6.2.0.873-2.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID f...

2015-11-01 14:48:00 90

转载 How To:配置Openfiler磁盘

目录1、系统登陆2、启用iSCSI Target服务3、初始化卷组4、映射LUN5、查看状态1、系统登陆Openfiler系统安装完毕之后，使用提示的地址登陆:https://172.1.2.200:446默认的用户名为：openfiler默认的密码为：password2、启用iSCSI Target服务选择...

2015-11-01 13:53:00 479

转载 Perl Connect to Database without password as sysdba

1 #!/oracle/product/11g/db/perl/bin/perl 2 use lib '/oracle/product/11g/db/perl/lib/site_perl/5.10.0'; 3 use DBI; 4 use DBD::Oracle qw(:ora_session_modes); 5 print $DBI::VERSION,"\n";...

2015-09-05 05:03:00 97

转载 Bequeath Connection and SYS Logon

The following example illustrates how to use the internal_logon and SYSDBA arguments to specify the SYS login. This example works regardless of the database's national-language settings of the da...

2015-09-05 05:01:00 96

转载 recreate dbcontrol on database 11.2.0.1 using emca

[oracle@osb ~]$ env | grep ORAORACLE_SID=ACEORACLE_BASE=/oracleORACLE_TERM=xtermORACLE_HOME=/oracle/product/11201/db[oracle@osb ~]$ emca -config dbcontrol db -repos recreateSTARTED ...

2015-08-08 12:27:00 96

转载 Use emcli to delete obsolete agent targets in Oracle EM Cloud Control 12c

[oracle@oem ~]$ cd /oem/oms/oms/bin登录到oms中[oracle@oem bin]$ ./emcli login -username=sysmanEnter password :Login successful同步信息[oracle@oem bin]$ ./emcli syncSynchronized succe...

2015-07-16 14:51:00 125

转载 Configuring SSL on Enterprise Manager and the SLB (Release 12.1.0.2 and later)

From: http://docs.oracle.com/html/E24089_42/ha_setup.htm#sthref833If the SLB is configured to use Third-Party/Custom SSL certificates, you must ensure that the CA certificates are properly c...

2015-07-07 20:55:00 98

转载 Oracle query that count connections by minute with start and end times provided

数据结构类似SQL> select * from t;B E N----------------- ----------------- --------------------20150106 01:00:02 20150106 01:00:42 A20150106 01:00:02 2015010...

2015-06-30 05:51:00 64

转载 Enable ssh root login in Solaris

1. Change the file/etc/ssh/sshd_configwithPermitRootLogin yesto replacePermitRootLogin no2. restart the services#svcadm restart svc:/network/ssh:default转载于:https://www.cnblogs.com/syk...

2015-06-28 14:24:00 90

转载 solaris roles cannot login directly

2015-06-28 14:22:00 129