- 博客(47)
- 收藏
- 关注
转载 ph2_cly (0) out of bounds in PH2POP
On : 11.2.0.2 version, Data Pump Importimpdp failed with following error:ERROR-----------------------ORA-39083: Ob...
2012-07-12 16:34:29
425
转载 ORA-09925 ORA-01075:
->sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Tue Jul 3 18:26:27 2012Copyright (c) 1982, ...
2012-07-03 18:54:15
489
转载 awk -f ass109.awk
C:\Program Files\GnuWin32\bin>awk -f ass109.awk E:\abcd_ora_389488.trcAss.Awk Version 1.0.9 - Processing E:\abc...
2011-06-25 20:57:52
151
转载 Changes the attributes of a asm template
chtmpl -G diskgroup { [--striping {coarse|fine}][--redundancy {high|mirror|unprotected} ] [--primary {hot|cold}] ...
2011-06-24 14:59:36
84
转载 ASM manage script
SELECT dg.name AS diskgroup, SUBSTR(a.name, 1, 18) AS name, SUBSTR(a.value, 1, 24) AS value, rea...
2011-06-08 16:32:25
60
转载 asm utility ->kfed
->kfed p=read dev='/dev/sdb1'kfbh.endian: 1 ; 0x000: 0x01...
2011-05-30 15:29:45
65
转载 get spfile content from disk when asm failure
SQL*Plus: Release 11.2.0.2.0 Production on Wed May 18 15:59:27 2011Copyright (c) 1982, 2010, Oracle. All rights...
2011-05-30 15:27:29
58
转载 ASM Startup Issues
If ASM has problems starting, check the following:1:If ASM cannot start and the message “Cannot contact Cluster Ma...
2011-05-24 15:06:35
101
转载 Diskgroup Cannot be Mounted
Diskgroups that have not been mounted result in relational database management system (RDBMS) instances not being ...
2011-05-24 14:47:26
282
转载 ping 来辨别操作系统
--局域网内几乎没什么问题C:\Documents and Settings\Administrator>ping 10.169.10.1 ---Windows 2003Pinging 10.169.10.1 with ...
2011-05-24 14:36:12
126
转载 Linux 系统中的光纤卡问题
linux 5 + rac 10.2.0.4磁盘经常非常繁忙,导致经常出现数据库hang的情况,一节点无故重启。简要做如下记录:--get wwwn on Linux OS[root@prod01 host5]# pwd/sys...
2011-05-24 10:45:45
513
转载 ping 来帮你识别操作系统
C:\Documents and Settings\Administrator>ping 10.168.10.1Pinging 10.173.10.1 with 32 bytes of data:Reply fro...
2011-05-23 19:41:39
136
转载 processes of Grid Infrastructure
12.0.2.2 grid processes->ps -ef|grep d.bin|grep -v grep--lower stackroot 24584 1 0 Apr26 ? 0...
2011-04-30 17:15:38
67
转载 Linux 5 rac vipca的bug
1: vipca 中 unset LD_ASSUME_KERNEL2: srvctl 中 unset LD_ASSUME_KERNEL3:oifcfg setif -global en0/10.182.0.0:publi...
2011-04-19 11:03:22
52
转载 11gr2 rac [INS-35354]
[FATAL] [INS-35354] The system on which you are attempting to install Oracle RAC is not part of a valid cluster....
2010-09-28 13:32:39
238
转载 System表空上对象无法回闪
SQL> create table ta(a number);Table created.SQL> create table tb(a number) tablespace system;Table cr...
2010-03-29 09:50:20
47
转载 aix backup and restore
find ./proddb -print | backup -i -f ./proddb.bkrestore -xdqvf ./proddb.bk find ./prodora -print | backup -i -...
2009-03-11 13:40:09
96
转载 ocr 记录
rac1->ocrcheckStatus of Oracle Cluster Registry is as follows : Version : 2...
2009-02-21 21:03:50
56
转载 init.crs
#init.crs stop# ps -ef|grep init root 1 0 0 11:45:51 - 0:00 /etc/init root 217256 1...
2009-02-20 13:44:16
100
转载 Rac convert to single instance
$ make -f ins_rdbms.mk rac_off rm -f /opt/app/oracle/product/10.2.0/db_2/lib/libskgxp10.a cp /opt/ap...
2009-02-20 13:07:10
78
转载 rac的测试记录
---第一种情况---halt -q模拟hang(23)机# halt -q....Halt completed....alert*.log内容如下:Tue Jan 20 08:58:05 2009Reconfigura...
2009-01-22 16:39:21
539
转载 修改rac参数
alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.4)(PORT = 1521))' sid='yb2' ...
2009-01-18 21:28:21
58
转载 10g rac modify vip address
--Aix OS1;修改/etc/hosts2;修改nodeapps#export ORACLE_HOME=/opt/app/oracle/product/10.2.0/db_1#/opt/app/oracle/product/...
2009-01-18 21:20:36
34
转载 global cache block transfer lost and corrupt statistics
SELECT A.VALUE "GC BLOCKS LOST 1", B.VALUE "GC BLOCKS CORRUPT 1", C.VALUE "GC BLOCKS LOST 2", ...
2009-01-18 21:18:11
119
转载 查看表空间使用情况
column TABLESPACE_NAME format a20;SELECT dts.tablespace_name, NVL(ddf.bytes / 1024 / 1024, 0) avail,NVL(ddf.bytes ...
2009-01-18 21:15:38
30
转载 10g drop database
SQL> connect / as sysdbaSQL> shutdown abort;SQL> startup nomount;SQL> alter database mount exclusive;S...
2008-09-29 18:57:15
45
转载 linux学习点滴
#Redhat 4安装oracle的设置cat >> /etc/sysctl.conf <kernel.shmall = 2097152kernel.shmmax = 2147483648kernel.sh...
2008-04-09 20:46:11
77
转载 oracle rac
mkdir ~/.sshchmod 700 ~/.sshssh-keygen -t rsaocfs2-2.6.9-55.ELsmpocfs2-2.6.9-55.ELsmphttp://oss.oracle.com/proje...
2008-04-01 20:56:44
65
转载 erp clone record
cp -R /u01/oratest/testdata /u02/oraprod/proddatacp -R /u01/oratest/testdb /u02/oraprod/proddb/dev/fslv01...
2008-03-28 16:29:17
133
转载 asm 小结
ORA-15000: command disallowed by current instance typeexport ORACLE_SID=+ASMselect name,state from v$asm_diskgro...
2008-03-24 23:17:03
85
转载 erp concurrent process can not start
Concurrent Managers Fail to Start, Verify that findev has been registered for concurrent processingSymptomsAfter...
2008-03-24 09:18:06
102
转载 ORACLE ORA-12514
tnsping service_name 返回状态正常!sqlplus userid/passwd@service_name 出现ORA-12514错误.前几天11g中也碰到了这个问题,今天的版本是Release 10.2.0...
2008-03-24 09:15:48
57
转载 ora-12514
SQL> host oerr ora 1251412514, 00000, "TNS:listener does not currently know of service requested in connect des...
2008-03-04 20:39:30
67
转载 Lock Escalation
Lock EscalationThe creation of additional Interested Transaction Lists (ITL) slots is subject to free space in t...
2008-01-06 22:17:49
98
转载 RevStr
SQL> create or replace Function RevStr(P_str in varchar2) return varchar2 is 2 l_RevStr varchar2(2000); 3 ...
2007-09-22 19:04:09
123
转载 bulk delete example
declare l_Lnum number default 1; l_Sdrow number default 0; l_Edrow number default 0; ...
2007-08-14 22:32:35
70
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人