ITPub博客

REM =============================================================REMREM rebuild_indx.sqlREMREM Copyright (c) Oracle Software, 1998 - 2000REMREM Author : Jurgen SchelfhoutREMREM The sample program in this article is provided for educationalREM purposes only and i...

virtualbox中加载已有的虚拟硬盘时出现Cannot register the hard disk错误，描述类似下面的。 ERROR: Cannot register the hard disk '/mnt/ee/winxp/xp.vdi' with UUID {395ae4ae-8bf9-42e5-b82a-61af9f95fbf0} be...

[root@rac1 ~]# /u01/app/oracle/product/10.2.0/crs/root.shWARNING: directory '/u01/app/oracle/product/10.2.0' is not owned by rootWARNING: directory '/u01/app/oracle/product' is not owned by rootWARNING: directory '/u01/app/oracle' is not owned by rootWARNING: directory '/u01/app' is not owned by...

1.1.1 安装rpm包将iscsi包cp到本地盘，并在该包所在的目录下运行命令[root@linux ~]# rpm –ivh iscsi-initiator-utils-6.2.0.742-0.5.el5.i386.rpm 运行此命令后，会生成一个目录/etc/iscsi,该目录下有两个文件：Initiatorname.iscsi和iscsid.conf1.1.2 启动ISCSI服务安装完iscsi服务默认是关闭的，需要手工启动[...

iscsi挂载和删除   2011-01-01 11:54:01|  分类： 存储 |字号 订阅 iscsi操作：http://blog.csdn.net/do2jiang/archive/2009/12/29/5097730.aspxhttp://wenku.baidu.com/view/eed83ad6195f312b3169a5c0.htmltrune2fs -c -l -i 0 /dev/sdb1 去掉...

创建测试环境：TEST@ PROD> create table t(id int constraint pk_id2 primary key,val int);TEST@ PROD> select * from t;        ID        VAL---------- ----------         1  &...

http://warehouse.itpub.net/post/777/521637

ORA-01591: lock held by in-doubt distributed transaction 11.38.8621739alter log:Wed Nov 13 16:30:27 CST 2013Error 2068 trapped in 2PC on transaction 11.38.8621739. Cleaning up.Error stack returned to user:ORA-02054: transaction 11.38.8621739 in-doubtORA-02068: following severe error from WMS...

http://tech.it168.com/a2013/0802/1516/000001516310_all.shtml

Oracle Database (includes Oracle Database and Oracle RAC)Note: you must download both zip files to install Oracle Database.p13390677_112040_platform_1of7.zipp13390677_112040_platform_2of7.zip...

Error: Device 'eth0' (/org/freedesktop/NetworkManager/Devices/0) disconnecting failed: This device is not active     最近在升级一台CentOS内核时发现网卡无法连接，由于网卡比较多...

[root@rac2 g01]# /g01/grid/root.shPerforming root user operation for Oracle 11g The following environment variables are set as:    ORACLE_OWNER= grid    ORACLE_HOME=&...

/u01/app/oracle/admin/hanmi/udump/hanmi_ora_27196.trcOracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testi...

1. 安装必要的软件包系统为CentOS 6.0，为最小化安装。a. 安装vncserver服务端和客户端端yum install tigervnc tigervnc-server -y b. 安装fontforgeyum install ...

以下是详细步骤，针对科学上网初学者，所以比较啰嗦：①百度搜索“Chrome”，找到“Chrome 浏览器”（一般在第二个搜索结果），点击进入页面。②点击蓝色小框“下载 Chrome”。③按指示安装好。④打开Chrome浏览...

[oracle@ora bdump]$ tail -f alert_mamiai.logksvcreate: Process(m000) creation failedThu Aug 29 14:31:15 CST 2013PMON failed to acquire latch, see PMON dumpThu Aug 29 14:32:15 CST 2013PMON failed to ac...

dbsnak在微博里这样描述等待事件log file sync和log file parallel write的关系： 前台进程a通知LGWR要刷log buffer了，这时候a就开始等待log file sync，LGWR接到a的请求后开始等待OS把log buffer写回redo log，...

最近在一个数据库遇到了坏块，以下是处理过程。一、坏块的发现及处理首先是在做RMAN备份的时候，看到alert文件有坏块报错：.......Corrupt block relative dba: 0x00925026 (file 2, block 1200166)Frac...

---正在执行的select a.username, a.sid,b.SQL_TEXT, b.SQL_FULLTEXT  from v$session a, v$sqlarea b where a.sql_address = b.address&nb...

当管理的数据库比较多的时候，在sqlplus里切换就是一件麻烦的事。 要非常小心，以防出错。 可以修改sqlplus 的提示符：SQL> ，把这个改成我们用户和实例名，这样就不容易出错。  先看一下Oracle 自定...