2018年10月_布丁很胖

原创 ORA-03113: end-of-file on communication channel

现象SQL> alter database open;alter database open*ERROR at line 1:ORA-03113: end-of-file on communication channelProcess ID: 17076Session ID: 1057 Serial number: 3 查看告警日志如下Errors in f...

2018-10-31 15:59:12 2556

转载 xshell 使用hbase shell backspace无法删除

异常现象： xshell 连接oracle数据库，在sqlplus 界面后出现以下情况按 Backspace 键时，无法正常回退，会静止不动解决方案点击文件》属性》终端》键盘将delete键序列和 backspace键序列设置为ASCII 127 ...

2018-10-30 13:39:24 392

原创多么痛的一次领悟ORA-21561: OID generation failed

环境为 2个节点的11.2.0.4的RAC环境重启异常数据库无法启动，出现报错如下在日志 /opt/app/grid/11.2.0/log/racoa02/agent/ohasd/oraagent_grid/oraagent_grid.log 2018-10-29 23:26:01.841: [ USRTHRD][4040279808]{0:0:2} checkCrs...

2018-10-30 00:53:25 2266

原创 oracle的sga和pga大小设置

racle官方文档推荐:MEMORY_TARGET=物理内存 x 80%MEMORY_MAX_SIZE=物理内存 x 80% 对于OLTP系统： SGA_TARGET=(物理内存 x 80%) x 80%SGA_MAX_SIZE=(物理内存 x 80%) x 80%PGA_AGGREGATE_TARGET=(物理内存 x 80%) x 20% 对于DSS系统：...

2018-10-24 18:40:20 8542

原创 ocr磁盘损坏恢复-只有一个磁盘组

https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1674859.1&id=1294915.1&_adf.ctrl-state=16vz5xe5z5_335&_afrLoop=275662822089522ocr磁盘丢失，只有一个ocr磁盘1、查看备...

2018-10-24 18:39:52 943

原创数据库闪回恢复区满了解决

1、删除归档日志$rman target /RMAN> list archivelog all;RMAN>crosscheck archivelog all;RMAN>change archivelog until logseq=130 thread=1 delete;或者 RMAN>delete expired archivelog all;2、取...

2018-10-24 18:38:59 868

原创 RAC11g安装目录被删除

1、查看安装目录发现丢失[oracle@mdb1 ~]$ ls /opt/.Trash-root/oracle/admin cfgtoollogs checkpoints Clusterware diag mdb1 oradiag_oracle oradiag_root product 本来在/opt/app目录下，却出现在 /opt/.Trash-root ...

2018-10-24 18:38:16 400

转载 ORA-31634: job already exists

ORA-31634: job already existsORA-31664: unable to construct unique job name when defaulted CHANGESThis can occur when either running a single DataPump jobs or when you are executing multiple j...

2018-10-24 18:37:36 1183

转载重装Oracle 10g RAC如何干净的清理系统

重装Oracle 10g RAC如何干净的清理系统重新安装10g RAC，很多东西都要手动清理，如果清理不干净，在重新安装过程中可能出现一些异常情况。所以当要重新安装Oracle 10g RAC，建议将现有系统清理干净，这点应该引起大家重视。下面对干净的清理系统做出如下说明：在不重装操作系统的情况下，做以下的工作来干净清理系统：1.通过参考Metalink文章《How to Cle...

2018-10-24 18:36:49 571

转载 oracle dataguard 三种模式切换

参考链接 http://blog.itpub.net/29475508/viewspace-1248530/ Oracle 11g DataGuard 数据保护模式切换 Data Guard 提供三种数据保护模式：最大保护（Maximum Protection），最高可用（Maximum Availability）和最高性能（Maximum Performance）。如果按照...

2018-10-24 18:36:00 7678

原创 RAC expdp备份失败

问题描述报错信息如下ORA-31693: Table data object "DYESBDB55_GXT"."WF_ACTINSTANCE" failed to load/unload and is being skipped due to error:ORA-31617: unable to open dump file "/bak/expdpbak/DYESBDB55_GXT_0...

2018-10-24 18:34:53 634

原创 ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

2018-10-24 18:31:07 199

原创 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your

错误现象delete from PaidInRecord pr WHERE pr.packageNumberId= 5661 and pr.contractInfoId= 3235 and pr.repaymentApplyId=179389 and pr.isMatchAll=2;ERROR 1064 (42000): You have an error in your SQL synta...

2018-10-24 18:01:40 2930

原创 Got an error reading communication packets

2018-04-27T15:30:46.946313+08:00 417211 [Note] Aborted connection 417211 to db: 'dynetmanage30' user: 'root' host: '192.168.100.27' (Got an error reading communication packets)2018-04-27T19:25:53.40...

2018-10-22 11:20:03 5883

原创利用binlog进行日志恢复

过滤查看记录[root@localhost]# /usr/bin/mysqlbinlog --no-defaults /var/lib/mysql/mysql-bin.000001 | more全部执行[root@localhost]# /usr/bin/mysqlbinlog --no-defaults /var/lib/mysql/mysql-bin.000001 | /usr/b...

2018-10-22 11:19:27 808

转载 Mysql查看执行计划-explain

Mysql查看执行计划-explain参考链接 https://www.2cto.com/database/201202/120118.html Mysql查看执行计划一.语法 explain <sql语句> 例如: explain select * from t3 where id=3952602; 二.explain输出解释...

2018-10-22 11:18:58 132

原创 Last_IO_Error: Got fatal error 1236 from master when reading data from binary lo

Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file' 这是典型的mysql主从不同步问题，由于mysql主库binlog丢失，导致mysql从无法同步主...

2018-10-22 11:17:58 1520

原创 ERROR 1040 (HY000): Too many connections

mysql连接报错查看端口连接数 tcp 0 0 aaaa:53069 192.168.12.13:mysql TIME_WAIT root 0出现很多 TIME_WAIT 1、解决 TIME_WAIT vi /etc/sysctl.conf 编辑文件，加入以下内容...

2018-10-22 11:17:20 999

原创 mysql的binlog清除

1、binlog设置相关参数expire_logs_day 设置binlog老化日期触发时机是binlog发生切换： binlog大小超过max_binlog_size 手动执行flush logs 重新启动时(mysql将会new一个新文件用于记录binlog) 2、参数在线更改该参数可以在线修改 mysql> show va...

2018-10-22 11:16:30 148

原创 msyql 用户和权限操作

1、查看有哪些用户mysql> use mysql;Database changedmysql> select host,user,password from user; +----------------------+---------------+-------------------------------------------+| host ...

2018-10-22 11:14:33 153

转载 mysql参数之innodb_buffer_pool_size大小设置

mysql> show global variables like 'innodb_buffer_pool_size';+-------------------------+-----------+| Variable_name | Value |+-------------------------+-----------+| innodb_buf...

2018-10-22 11:13:53 3751

原创 mysql 大小写敏感

mysql大小写敏感分表名大小写敏感和表字段大小写敏感 1、表名大小写敏感mysql> show variables like 'lower%';+------------------------+-------+| Variable_name | Value |+------------------------+-------+| lower_...

2018-10-22 11:12:33 219

原创 oracle standby库异常

Datafile 1 (ckpscn 3391666) is orphaned on incarnation#=6MRP0: Detected orphaned datafiles!Recovery will possibly be retried after flashback...Errors in file /opt/app/oracle/diag/rdbms/oradbsdb/...

2018-10-22 11:11:17 622

原创 ERROR 1366 (HY000): Incorrect string value: '\xA6' for column 'jy_message' at row 1

这个问题是字符集导致的查看数据库字符集mysql> show variables like 'character%';+--------------------------+-----------------------------------------+| Variable_name | Value ...

2018-10-17 15:09:19 306

转载 Redis配置文件详解

redis是一款开源的、高性能的键-值存储（key-value store），和memcached类似，redis常被称作是一款key-value内存存储系统或者内存数据库，同时由于它支持丰富的数据结构，又被称为一种数据结构服务器（data structure server）。编译完redis，它的配置文件在源码目录下 redis.conf ，将其拷贝到工作目录下即可使用，下面具体解释red...

2018-10-11 18:22:51 754

原创 2995 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

问题描述由于误操作，将mysql的mysql库删除，导致数据库启动异常，mysql启动报错，报错如下2018-10-11 16:30:11 2995 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist181011 16:30:11 mysqld_safe my...

2018-10-11 17:04:35 1331

原创通过sql_id查找sid,serial#

/home/oracle/script/sidget.sh source /home/oracle/.bashrcsqlplus "/ as sysdba" <<EOFspool /tmp/sid.txt append;select sid,serial#,username ,osuser from v$session where (sql_hash_value,s...

2018-10-11 16:07:39 5163

转载 SCAN 监听手动转移

[grid@rac-1 ~]$ srvctl status scanSCAN VIP scan1 is enabledSCAN VIP scan1 is running on node rac-2[grid@rac-1 ~]$ srvctl status scan_listenerSCAN Listener LISTENER_SCAN1 is enabledSCAN liste...

2018-10-11 16:04:16 1305

原创 msyql 密码忘记 5.6.23

问题描述：登录数据库，无法登录[root@proxy02 mysql]# ./bin/mysql -uroot -proot -S /data/soft/mysql/tmp/mysql.sockWarning: Using a password on the command line interface can be insecure.ERROR 1045 (28000): Acc...

2018-10-11 15:49:42 227

li66934791的博客