- 博客(52)
- 收藏
- 关注
RSS订阅转载 ASM磁盘组丢失member kfed修复
1.报错SQL> alter diskgroup datadg mount;alter diskgroup datadg mount*ERROR at line 1:ORA-15032: not all...
2015-06-18 17:30:07
186
转载 VNC连接图形界面
[root@localhost ~]# rpm -qa |grep vncvnc-4.1.2-14.el5_6.6vnc-server-4.1.2-14.el5_6.6[root@localhost ~]#[r...
2015-06-18 17:28:03
163
转载 Python连接Oracle相关步骤和错误记录
1.下载python 2.7.6 amd 64bit2.下载 cx_oracle https://pypi.python.org/pypi/cx_Oracle/5.1.3 asd-python-2.7版本3.安装cli...
2015-06-18 17:24:07
135
转载 启动CRS单实例、设置自动启动
[grid@yws ~]$ crsctl start hasCRS-4123: Oracle High Availability Services has been started.[grid@yws ~]$...
2015-06-18 17:19:26
417
转载 deconfig crs grid single instance
[root@yws 11.2.0]# /u01/app/grid/11.2.0/perl/bin/perl -I/u01/app/grid/11.2.0/perl/lib -I/u01/app/grid/11.2.0/crs/i...
2015-06-18 17:16:53
157
转载 ENABLE_DDL_LOGGING 参数使用 监控对象的DDL
当需要确定某些ddl操作什么时候发生，确定是表啥时间被动了，可以设置此参数。 此参数支持动态调整。alter system set enable_ddl_logging=true;效果图如下：S...
2015-05-15 17:26:45
501
转载 利用调度任务定时删除分区
生产环境需要定期删除分区历史数据，自己写了一个，拿出来分享下吧。1.创建调度任务字典表-- Create tablecreate table SCHEDULER_CONF_DIC( OWNER_NAME...
2015-04-23 16:24:37
108
转载 mysql安装 (yum 安装)
[root@localhost usr]# rpm -qa |grep mysql* --检查安装了什么包mysql-5.0.77-4.el5_6.6libdbi-dbd-mysql-0.8.1a-1.2.2[r...
2015-03-22 22:48:18
92
转载 Mysql 基础数据类型(无时间相关类型)
数据类型无时间相关类型--zerofill不满足位数的用0填充mysql> use ywsDatabase changedmysql> create table t1(id1 int,...
2015-03-13 00:30:31
70
转载 Mysql 基础操作 DDL DML DCL
mysql 基础操作 包括DDL DML DCL示例c:\Program Files\MySQL\MySQL Server 5.1>cd binc:\Program Files\MySQL\MySQL Se...
2015-03-13 00:01:31
72
转载 dbms_scheduler创建job
1.创建目录和需要的shell和txt [root@lk ~]# mkdir /job [root@lk ~]# chown oracle.oinstall /job [root@lk ~]# su - ora...
2015-02-10 15:01:45
85
转载 Dataguard 重建
一套dg出现gap现象，不幸的是备库需要的归档在主库已经被删除，需要重做dg，当然并不是全部的重建，参数文件的一些参数是不用调整了。备份下主库： run { allocate channe...
2014-12-04 21:11:46
316
转载 DataGuard切换(主库为Rac+备库为Rac)
前段时间做了一次主备库的切换，大体写下操作步骤和记录，分享下。环境： db version:11.2.0.3主库：两节点的RAC 备库：两节点的RAC ...
2014-11-13 14:05:22
148
转载 数据库限制/允许某些IP访问
TCP.EXCLUDED_NODESPurposeTo specify which clients are denied access to the database.Syntax...
2014-10-16 17:47:38
619
转载 DBMS_REPAIR Examples
DBMS_REPAIR Examples Examples: Building a Repair Table or Orphan Key Table TheAD...
2014-08-21 15:59:49
82
转载 Health Monitor 健康检查
About Health Monitor Checks Health Monitor checks (also known as checkers, health checks, or checks) e...
2014-08-21 15:46:09
349
转载 Installation Dialogs Language
Installation Dialogs Language Oracle Universal Installer runs in the language of the operating sys...
2014-08-21 14:21:49
160
转载 表空间日常管理
以下操作请在测试机器上进行试验后，然后再生产上操作。1.表空间热备份开始：ALTER TABLESPACE tbs_01 BEGIN BACKUP;结束ALTER TABLES...
2014-08-14 15:16:25
71
转载 普通表转换分区表-在线重定义
普通表转化分区表—在线重定义以下为YWS表为示例： Sys用户授权SQL> grant execute on DBMS_REDEFINITION to ; 1．获取原来表的元数据。...
2014-07-15 10:15:33
110
转载 ASMCMD - cp
ASMCMD> help cp cp Enables you to copy files between Oracle ASM disk ...
2014-05-16 09:46:38
124
转载 查看表最后DML和DDL时间
查看表最后DML和DDL时间SQL> create table uuu as select * from emp;表已创建。SQL> select ora_rowscn,t.* f...
2014-05-06 23:17:06
1115
转载 DBMS_WORKLOAD_REPOSITORY.DROP_SNAPSHOT_RANGE 手工清理awr
DBMS_WORKLOAD_REPOSITORY TheDBMS_WORKLOAD_REPOSITORYpackage lets you manage the Workload Repo...
2014-05-06 20:20:47
746
转载 DBMS_JOB.SUBMIT 建立job定时调度
SUBMIT Procedure This procedure submits a new job. It chooses the job from the sequencesys.jobseq....
2014-05-05 22:30:24
247
转载 SQL*Net more data from dblink Reference Note
Versions 7.3.4.5 - 11.2.0.3 P1 = driver id ...
2014-05-05 22:00:08
233
转载 Fails to Join the Cluster as CRSD and EVMD are in INTERMEDIATE State
Applies to: Oracle Database - Enterprise Edition - Version 11.2.0...
2014-04-11 23:05:54
715
转载 11r2升级准备utlu112i.sql的使用以及dbtimezone
把11g rdbms/admin下的utlu112i.sql 拿到要升级的库上SQL> spool upgrade.txtSQL> @?/rdbms/admin/utlu112i.sqlOrac...
2014-03-25 20:25:30
240
转载 ARCH wait on SENDREQ 等待事件
ARCH wait on SENDREQ CauseHigh ARCH wait on SENDREQ wait events found in statspack report."ARCH wait on ...
2014-03-24 15:47:22
571
转载 给实例添加额外的thread
查看日志SQL> set linesize 1000SQL> / GROUP# STATUS TYPE MEMBER ...
2014-03-24 15:43:19
314
转载 Oracle 隐藏参数使用
executables from Oracle. Now we are ready to explore some ways that the undocumented Oracle parameters are used to...
2014-03-24 14:20:15
155
转载 使用rman将数据库迁移到ASM实例
使用rman将数据库迁移到ASM实例一、创建ASM实例并启动ASM实例；我们可以手动创建ASM实例，也可以使用DBCA来创建ASM实例；[oracle@10g ~]$ export ORACLE_SID=+A...
2014-03-24 14:16:03
128
转载 High "Resmgr:Cpu Quantum" Wait Events
High "Resmgr:Cpu Quantum" Wait Events In 11g Even When Resource Manager Is Disabled (文档 ID 949033.1)APPLIES TO:...
2014-03-21 16:34:00
86
转载 grid 常用命令和基础概念 （Oracle RAC Administration）
添加redoALTER DATABASE ADD LOGFILE THREAD 2 GROUP 4;ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 5;ALTER DATABASE...
2014-03-02 11:11:58
491
转载 Strace 验证CKPT进程三秒工作机制
简单记录.[oracle@yws ~]$ ps -ef |grep ckpt|grep -v grep |awk '{print $2}'10217[oracle@yws ~]$ ltrace -t -p 1...
2014-02-28 22:10:24
57
转载 Strace sqlplus scott/tiger@yws 很好处理tns问题
从函数调用角度查看Oracle登录发生了什么.当你hang 在sqlplus / as sysdba ,或者sqlplu username/password@tnsname ,可以尝试跟踪下.很清晰的看出来哪里有问题. ...
2014-02-28 21:43:07
127
转载 Wait event (二) 摘自官档 Oracle版权所有
SQL*Net Events The following events signify that the database process is waiting for acknowledgment from ...
2014-02-19 21:32:16
423
转载 AUL 挖取11g UNDO段名称
挖取11g undosegment 名称。下载老楼的AUL.1.创建配置文件。 点击(此处)折叠或打开 SQL> spool d...
2014-02-16 20:53:50
115
转载 ORA-30046: Undo tablespace UNDOTBS1 not found in control file 无undo启动库
本来是要模拟ora 1173，但是出现其他的情况，简单记录下。环境：win7+11.2.0.1 点击(此处)折叠或打开 C:\Users...
2014-02-16 16:09:55
259
转载 Linux 6.4 网卡 not active 解决
点击(此处)折叠或打开 [root@localhost Desktop]# service network restart ...
2014-02-15 12:14:11
269
转载 Oracle 12c 安装记录（-）准备
安装12c 点击(此处)折叠或打开 127.0.0.1 localhost localhost.localdomain localhost4 lo...
2014-02-15 12:08:44
68
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人