- 博客(334)
- 资源 (3)
- 收藏
- 关注
原创 ORA-01136: specified size of file ORA-01110
SQL> alter database create datafile 97 as '+DATAGRP1';alter database create datafile 97 as '+DATAGRP1'*ERROR at line 1:ORA-01136: specified size of file 97 (12800 blocks) is less than original sizeof 4194048 blocksORA-01110: data file 97: ..
2020-12-22 09:33:35 671
原创 No X11 DISPLAY variable was set, but this program performed an operation
ERROR: Unable to verify the graphical display setup. This application requires X display. Make sure that xdpyinfo exist under PATH variable.No X11 DISPLAY variable was set, but this program performe...
2019-09-20 22:47:50 3984
原创 xhost: unable to open display ""
查了半天资料怎么DISPLAY都没用最后xstart工具连接报错 ”已拒绝X11转移申请“https://blog.csdn.net/scofy0/article/details/42774983原来X11 forwarding依赖“xorg-x11-xauth”软件包,所以必须先安装“xorg-x11-xauth”软件包。yum install xorg-x11-xauth)...
2019-09-20 22:46:49 555
原创 03、redis sentinel 测试实验
安装参考:https://blog.csdn.net/EVISWANG/article/details/945531001、配置文件:主节点配置:cat redis-7000.confport 7000daemonize yespidfile/var/run/redis-7000.pidlo...
2019-07-03 10:33:27 319
原创 02、Redis 主从配置
安装参考:https://blog.csdn.net/EVISWANG/article/details/945531001、编辑配置文件:主库:/opt/redis/config/redis-6379.confdaemonize yespidfile/var/run/redis-6379.pidport 6379lo...
2019-07-03 10:32:36 151
原创 01、redis安装\启动方式\验证
安装cd /optwget http://download.redis.io/releases/redis-3.0.7.tar.gztar -xzf redis-3.0.7.tar.gzln -s redis-3.0.7redis为了方便目录管理和升级cd redismake && make install...
2019-07-03 10:31:43 1004
原创 RMAN-03002 RMAN-20242: specification does not match any archived log in the repository
RMAN> run{ ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE'; SEND 'NB_ORA_SERV=nbusrv, NB_ORA_CLIENT=Pbdopdb'; restore archivelog from sequence 34722 until sequence 34723 INCARNATION ALL; RELEAS...
2019-03-21 15:29:25 6824
原创 RMAN-03002 ORA-01861: literal does not match format string
RMAN> run{ ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE'; SEND 'NB_ORA_SERV=nbusrv, NB_ORA_CLIENT=Pbddb'; set until time='2019-03-14 23:30:00'; restore database; RELEASE CHANNEL ch00;}2&...
2019-03-20 17:56:17 828
原创 cp Oracle 数据库软件到不同主机
1.从其他主机上压缩数据库软件用root用户压缩:tar cvf Oracle.tar /oracle/product/db11gr2 2.用root用户tar数据库软件包Oracle .tar解压tar -xvf Oracle .tar配置/etc/oraInst.loc文件oracle@Ttest55:/oracle/admin/audit/bdump/cat /e...
2019-01-23 15:54:04 264
原创 DBCA libawt.so: libXt.so.6: cannot open shared object file: No such file or directory
[Toracledb01:oracle:dev10gk]$ netcaException in thread "main" java.lang.UnsatisfiedLinkError: /oracle/product/10205/jdk/jre/lib/i386/libawt.so: libXt.so.6: cannot open shared object file: No such fil...
2019-01-23 15:52:57 1703
原创 ORA-39014 ORA-39029 ORA-31671ORA-00028
impdp \'/ as sysdba\' directory=dp_dir dumpfile=ATS003_20190107_%U.dmp logfile=ATS003_20190107_imp3.log schemas=ATS003 remap_schema=ATS003:ATS003 TRANSFORM=SEGMENT_ATTRIBUTES:N...................
2019-01-11 14:52:51 2932 1
原创 11g修改内存大小
1.确认当前参数文件SQL> show parameter pfile NAME TYPE VALUE------------------------------------ ----------- ------------------------------spfile ...
2019-01-05 09:24:34 1698
原创 DG 备库 snapshot database
snapshot database状态下允许对备库进行读写,且在切回物理备库时恢复原有状态。同时主库日志仍然会向备库传输,当备库从snapshot状态切回到物理备库后,应用这些日志。1)备库设置闪回区使用snapshot database需要配置以下2个参数,不需要打开flashback。(也可以在前面配置备库参数时进行设置)SQL> alter system set db_r...
2018-12-25 22:42:15 439
原创 Oracle 主备库切换 switchover
1. 检查主库状态: SQL> select switchover_status from v$database; SWITCHOVER_STATUS ---------------------------------------- TO STANDBY2. 检查备库状态(MRP0进程是否存在): select count(*) num from v$pr...
2018-12-25 21:29:06 931
原创 drop diskgroup ORA-15039 ORA-15027
SQL>drop diskgroup DATAGRP1 including contents;[DBT-30012] Dropping disk group DATAGRP1 failed.ORA-15039: diskgroup not droppedORA-15027: active use of diskgroup "DATAGRP1" precludes its dismou...
2018-12-18 18:00:48 701
原创 ORA-01536: space quota exceeded for tablespace '
SQL> create unique index fqzrule.PK_DD_POLICY122T on fqzrule.DD_POLICY (TRIM(POLICY_ID)) tablespace FQZDATATBS ; 2 create unique index fqzrule.PK_DD_POLICY122T on fqzrule.DD_POLICY (TRIM(POLIC...
2018-12-11 11:07:09 585
原创 ORA-28040: No Matching Authentication Protocol and ORA-01017: invalid username/password (Doc ID 2436
1、问题描述:周末给业务装了套Oracle 12CR2压测数据库,业务反应连接时报错如下ORA-28040: No Matching Authentication Protocol 2、问题解决:于$ORACLE_HOME/network/admin/下添加了sqlnet.ora文件设置SQLNET.ALLOWED_LOGON_VERSION_SERVER=8后又报错 ORA...
2018-12-10 11:14:11 955
原创 enq: US - contention
查询等待事件:SQL> 1 select s.event, count(s.event) 2 from v$session s, v$process p 3 where s.PADDR = p.ADDR 4 group by s.event 5* order by 2 descSQL> EVENT ...
2018-12-07 18:33:47 542
原创 enq: HW - contention
SQL> l 1 select s.event, count(s.event) 2 from v$session s, v$process p 3 where s.PADDR = p.ADDR 4 group by s.event 5* order by 2 descSQL> EVENT ...
2018-12-07 18:32:33 408
原创 sysbench 压测 安装
sysbench是一款开源的多线程性能测试工具,可以执行CPU/内存/线程/IO/数据库等方面的性能测试。更重要的我们是用来做OLTP的测试http://imysql.com/2014/10/17/sysbench-full-user-manual.shtml下载地址:http://imysql.com/wp-content/uploads/2014/09/sysbench-0...
2018-12-01 22:53:58 509
原创 Linux 压测工具 stress 安装下载
下载地址http://people.seas.harvard.edu/~apw/stress/将stress-1.0.4.tar.gz复制到“/etc/local/src/”目录下:执行以下命令安装:Step1 #cd /usr/local/srcStep2 #tar -xzpvf stress-1.0.4.tar.gzStep3 #cd stress-1.0.4Step4...
2018-12-01 18:36:54 8248 1
原创 resetlogs 无法创建redo ORA-00344: unable to re-create online log
数据库rman恢复recoverSQL> recover database using backup controlfile until time '2018-11-27 02:00:00';ORA-00279: change 10495820489810 generated at 11/27/2018 00:00:15 needed forthread 1ORA-0028...
2018-11-30 23:12:16 2752
原创 Linux lvm 文件目录扩容
[root@Tdb1 ~]# df -hFilesystem Size Used Avail Use% Mounted on/dev/mapper/VolGroup-lv_root 158G 13G 137G 9% /tmpfs 253G 115G 138G 46% /dev/shm/...
2018-11-21 22:56:21 1926
原创 SGA size can not be greater than maximum shared memeory segment size
[root@Tdb1 ~]# vi /etc/sysctl.confkernel.shmmax = 4294967296这个值修改为 kernel.shmmax = 88719476736
2018-11-16 15:39:48 379
原创 ORA-00059: maximum number of DB_FILES exceeded
SQL> alter tablespace XNCBS add datafile '+DATRP' SIZE 5g autoextend on next 200MERROR at line 1:ORA-00059: maximum number of DB_FILES exceededSQL> SELECT name, issys_modifiable from v$pa...
2018-11-16 15:23:51 360
原创 ORA-00604: error occurred at recursive SQL level ORA-04024: self-deadlock detected while trying to
[oracle@ ~]$ sqlplus / as sysdbaSQL*Plus: Release 12.2.0.1.0 Production on Fri Nov 9 14:30:17 2018Copyright (c) 1982, 2016, Oracle. All rights reserved.Connected to:Oracle Database 12c Enter...
2018-11-09 15:44:27 1957
原创 ORA-39194: Table mode jobs require the tables to be comma separated.
一、问题概述expdp通过parfile导数时候报错如下:ORA-39194: Table mode jobs require the tables to be comma separated.相关脚本为:userid='sys/uyeer432@pnccist as sysdba'directory=LZLLdumpfile=expdp_%Y%M%U.dmplogfile...
2018-11-09 10:36:15 4215
原创 SQL Profiles的force_match参数在不改变代码的情况下解决没有使用绑定变量的问题
How To Use SQL Profiles for Queries Using Different Literals Using the Force_Match Parameter of DBMS_SQLTUNE.ACCEPT_SQL_PROFILE (Doc ID 1253696.1)如何使用SQL Profiles的force_match参数在不改变代码的情况下解决没有使用绑定变量的问...
2018-08-07 07:22:32 673
原创 local_listener
数据库监听无法创建总是报错这个端口已被占用,服务名已被占用hosts文件ip地址错误sqlplus / as sysdba 查看数据库实例没问题通过监听连接不正常[oracle@centos02 admin]$ sqlplus scott/tiger@evistestSQL*Plus: Release 11.2.0.4.0 Production on Mon Aug 6 21:34...
2018-08-07 07:21:16 1126
原创 MySQL 5.5初始化报错 undefined symbol: _ZZ16randomized_indexPKvjE5seed1 Installation of system tables fai
一、问题描述二进制安装MySQL5.5,初始化报错如下:[root@redhat01 mysql]# /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/mysql3306/dataInstalling MySQL system tables...
2018-06-22 22:10:35 1477
原创 orabbix 启动报错 WARNING: Error while registering Oracle JDBC Diagnosability MBean.
一. 报错信息如下:[root@adminm conf]# /etc/init.d/orabbix startStarting Orabbix service:[root@adminm conf]# Jan 22, 2018 2:37:06 p.m. oracle.jdbc.driver.OracleDriver registerMBeansWARNING: Error while
2018-01-22 17:32:40 1950
原创 oracle 11.2.0.4 归档满了之后 用户限制连接, awr快照停止生成
AWR Snapshots Are Not Being Created Because MMON Is Not Being Respawned (Doc ID 2023652.1)To BottomTo Bottom APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Rel
2018-01-22 11:25:44 433
原创 sqoop import 从Oracle往Hadoop导数据报 Io exception: The Network Adapter could not establish the connection
一.问题描述 在Hadoop集群的一个节点上用sqoop import 从Oracle 取数据总报如下错误:17/12/28 19:16:48 INFO mapreduce.Job: Task Id : attempt_1512535288105_6822_m_000000_0, Status : FAILEDError: java.lang.RuntimeExceptio
2018-01-03 17:16:33 4637 6
原创 ORA-00257: archiver error. Connect internal only, until freed.
[oracle@DW--cognos-1-10 admin]$ sqlplus cognos/SQL*Plus: Release 11.2.0.4.0 Production on Mon Nov 20 10:21:25 2017Copyright (c) 1982, 2013, Oracle. All rights reserved.ERROR:ORA-00257: archiv
2017-11-20 12:41:51 449
原创 mysql 5.6_38 linux 安装
删除老版本:查看安装包:[root@centos1 opt]# rpm -qa | grep -i mysqlmysql-libs-5.1.73-7.el6.x86_64mysql-server-5.1.73-7.el6.x86_64zabbix-server-mysql-2.4.8-1.el6.x86_64perl-DBD-MySQL-4.013-3.el6.x86_64
2017-10-19 17:36:12 4611 1
原创 apply opatch has modification time 2.8e+04 s in the future
一. 问题描述[oracle@localhost 24006111]$ /u01/app/oracle/product/11.2/db_1/OPatch/opatch applyOracle Interim Patch Installer version 11.2.0.3.14Copyright (c) 2017, Oracle Corporation. All rights res
2017-10-18 14:14:52 630
原创 mysql 日期值insert 到 oracle
只需要将insert语句的'2016-4-28 09:58:52'全部转换成to_date('2016-4-28 09:58:52','yyyy-mm-dd HH24:mi:ss')可以用
2017-10-10 13:43:23 372
原创 mysql PXC 安装
导言实验环境说明:OS版本 CentOS7PXC版本 Percona-XtraDB-Cluster-5.7.18-rel15-29.20.1.Linux.x86_64.ssl101.tar.gzXtrabackup版本 percona-xtrabackup-24-2.4.7-2.el6.x86_64.rpm服务器说明:主机名称 IP 配置 用途c1 10.194.41.231 1核
2017-09-13 15:28:40 1310
原创 基于时间点RMAN恢复
二. 恢复步骤:1. 参数文件恢复[oracle@localhost ~]$ rman target /Recovery Manager: Release 11.2.0.4.0 - Production on Tue Sep 5 05:50:45 2017Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights
2017-09-13 15:24:37 1069
Oracle 9i_10g编程艺术:深入数据库体系结构
2016-01-05
Oracle Database 9i10g11g编程艺术深入数据库体系结构(第2版)英文版.pdf
2015-11-18
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人