ITPub博客

配置双监听脚本[oracle@node11 admin]$ more listener.oraLISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.22)(PORT = 1521))    )  )LISTENER_ADG =  (DESCRIPTION_LIST =    (DESCRIPT...

[oracle@node1 trace]$ tail -f al*Errors in file /u01/app/oracle/diag/rdbms/test/test/trace/test_arc3_1213.trc:ORA-16055: FAL request rejectedARCH: FAL archive failed. Archiver continuingORACLE Instance test - Archival Error. Archiver continuing.Sat Nov 19 16:38:06 2016FAL[server, ARC3]: FAL ar...

1，报错日志[oracle@bjdb ~]$ rman target sys/oracle@test auxiliary sys/oracle@testadg1Recovery Manager: Release 11.2.0.1.0 - Production on Sat Nov 19 16:08:36 2016Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.connected to target database: TEST (DBID=2129218971)...

[root@shdb oracle]# cd scls_scr/[root@shdb scls_scr]# lltotal 4drwxr-xr-x 4 root oinstall 4096 Feb  1  2016 node1[root@shdb install]# pwd/u01/11.2.0/grid/install[root@shdb install]# [root@shdb install]# ./rootcrs.pl -deconfig -force2016-10-06 15:50:33: Parsing the host name2...

1，昨天进行停机维护，领导交代在维护任务完成后，作一次压力测试2，测试主要分为三个部分      一、现有的情况是应用通过weblogic 以负载均衡的方式均衡的链接到rac的三个实例上。而压力测到200+200并发的时候就出现了返回超时现象，cpu和内存的空闲率都达到了60%     、通过weblogic将...

SCOTT@ prod1>select count(*) from t2;  COUNT(*)----------     72594SCOTT@ prod1>select num_rows,blocks from user_tables;  NUM_ROWS     BLOCKS---------- ----------     72594       1059SCOTT@ prod1>select 72594/1059 from dual;...

SCOTT@ prod1>select sid from v$mystat where rownum=1;       SID----------        61SCOTT@ prod1>select  sid,serial# from v$session where sid=61;       SID    SERIAL#---------- ----------        61 &...

1，备份repo mv /etc/yum.repos.d/rhel-debuginfo.repo /etc/yum.repos.d/rhel-debuginfo.repo.repo.bakcd /etc/yum.repos.d/2，下载repo[root@node1 yum.repos.d]# wget http://mirrors.sohu.com/help/CentOS-Base-sohu.repo--2016-09-18 16:13:12--  http://mirrors.sohu.com/help/CentOS-Base-sohu....

temp = input('请输入一个年份:')while not temp.isdigit():    temp = input('抱歉输入有误，请从新输入:')    year = int(temp)if year%400 == 0:    print(temp + ' 是闰年啊')else:    if (year/4 == int(year/4) and (year/100 != int(year/100))):  &n...

Note:#PostgreSQL and PHP supports Batched Queries.#Awesome, huh?Version:SELECT VERSION()Directories:SELECT current_setting(‘data_directory’)SELECT current_setting(‘hba_file’)SELECT current_setting(‘config_file’)SELECT current_setting(‘ident_f...

pg_basebackup检查归档是否打开test=# select pg_switch_xlog(); pg_switch_xlog---------------- 0/2E40BB10(1 row) test=# checkpoint;CHECKPOINTtest=# -bash-4.1$ lltotal 0-bash-4.1$ ll...

三种级别record lock  锁住某一行记录  gap lock     锁住某一段范围中的记录 next key lock 是前两者效果的叠加实验环境mysql> select @@tx_isolation;+-----------------+| @@tx_isolation  |+-----------------+| REPEATABLE-READ |+-----------------+1 row in set ...

写在前面的话：总是在灾难发生后，才想起容灾的重要性；总是在吃过亏后，才记得曾经有人提醒过。(一)核心军规(1)不在数据库做运算   cpu计算务必移至业务层；(2)控制单表数据量   int型不超过10...

[root@centos ~]# service iptables stopiptables: Setting chains to policy ACCEPT: filter [  OK  ]iptables: Flushing firewall rules: [  OK  ]iptables: Unloading modules: [  OK  ][root@centos ~]# chkconfig iptables off[root@centos ~]# [root@centos ~]# ...

简介最近领导安排一个任务，需要将备库上的两个账号下的所有表，迁移到测试库上，用来搭建一个测试库。源库    系统版本aix6.1     oracle 11.1目标库  系统版本rehat6.5 oracle 11.2.0.4实施过程一、对于a用户和b用户下的大部分表，都是通过impdp+dblink 的方式实现了迁移二、一张...

环境centos6.7mysql5.7.12        一、centos 配置yum修改centos参数[root@centos yum.repos.d]# cat CentOS-Media.repo# CentOS-Media.repo##  This repo can be used with mounted DVD media, verify the mount point for#  CentOS-6.  You can use thi...

[root@centos bin]# service mysqld stopShutting down MySQL.[  OK  ][root@centos bin]# ./mysqld_safe --skip-grant-tables&[1] 21267[root@centos bin]# 2016-05-16T18:14:00.092388Z mysqld_safe Logging to '/soft/data//centos.err'.2016-05-16T18:14:00.120089Z mysqld_safe Starting mysqld daemon...

 Data guard搭建一、准备工作 Oracle版本11.2.0.1，操作系统版本时红帽5.5基本步骤1.1打开force logSQL> ALTER DATABASE FORCE LOGGING; 1.2备份主库run {sql 'alter system switch logfile';shutdown immediate;startup mount;backup...

一、sqlnet.ora文件添加wallet路径beijing:/u01/app/oracle/admin/prod/wallet$ more /u01/app/oracle/product/11.1.0/db_1/network/admin/sqlnet.ora # sqlnet.ora Network Configuration File: /u01/app/oracle/product/11.1.0/db_1/network/admin/sqlnet.ora# Generated by Oracle configuration tools.NAMES...

1,首先生成一张表mysql> select * from t;+------+| id   |+------+|    1 ||    2 |+------+2 rows in set (0.01 sec)2，备份这张表所在的数据库[root@node1 backup]# mysqldump -u root -p  --master-data=2 --databases testdb > test2.sqlEnter password: [root@node1...