-
编辑 删除
ph2_cly (0) out of bounds in PH2POP
On : 11.2.0.2 version, Data Pump Importimpdp failed with following error:ERROR-----------------------ORA-39083: Object type ALTER_FUNCTION failed to create with error:ORA-04045: errors during recompil...
-
编辑 删除
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, 2011, Oracle. All rights reserved.^C^CERROR:ORA-09925: 无法创建审计线索文件 IBM AIXR...
-
编辑 删除
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:\abcd_ora_389488.trcSystem State 1~~~~~~~~~~~~~~~~1:2: waiting for 'pmon timer' &...
-
编辑 删除
Changes the attributes of a asm template
chtmpl -G diskgroup { [--striping {coarse|fine}] [--redundancy {high|mirror|unprotected} ] [--primary {hot|cold}] [--secondary {hot|cold}]} templateSQL> SELECT dg.name AS diskgroup, t.name,...
-
编辑 删除
ASM manage script
SELECT dg.name AS diskgroup, SUBSTR(a.name, 1, 18) AS name, SUBSTR(a.value, 1, 24) AS value, ...
-
编辑 删除
asm utility ->kfed
->kfed p=read dev='/dev/sdb1'kfbh.endian: 1 ; 0x00...
-
编辑 删除
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 reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 ...
-
编辑 删除
ASM Startup Issues
If ASM has problems starting, check the following:1:If ASM cannot start and the message “Cannot contact Cluster Manager” displays, Make sure that CSS is started and is running in the correct m...
-
编辑 删除
Diskgroup Cannot be Mounted
Diskgroups that have not been mounted result in relational database management system (RDBMS) instances not being able to start up. When diskgroups do not get mounted, this typically is a result of di...
-
编辑 删除
ping 来辨别操作系统
--局域网内几乎没什么问题 C:\Documents and Settings\Administrator>ping 10.169.10.1 ---Windows 2003Pinging 10.169.10.1 with 32 bytes of data:Reply from 10.169.10.1: bytes=32 time=2ms TTL=124Reply f...
-
编辑 删除
Linux 系统中的光纤卡问题
linux 5 + rac 10.2.0.4磁盘经常非常繁忙,导致经常出现数据库hang的情况,一节点无故重启。简要做如下记录:--get wwwn on Linux OS[root@prod01 host5]# pwd/sys/class/fc_host/host5[root@test01 host5]# ls -ls por...
-
编辑 删除
ping 来帮你识别操作系统
C:\Documents and Settings\Administrator>ping 10.168.10.1Pinging 10.173.10.1 with 32 bytes of data:Reply from 10.173.10.1: bytes=32 time=2ms TTL=124Reply from 10.173.10.1: bytes=32 time=1ms TTL=124Re...
-
编辑 删除
processes of Grid Infrastructure
12.0.2.2 grid processes->ps -ef|grep d.bin|grep -v grep--lower stackroot 24584 1 0 Apr26 ? 00:02:...
-
编辑 删除
Linux 5 rac vipca的bug
1: vipca 中 unset LD_ASSUME_KERNEL2: srvctl 中 unset LD_ASSUME_KERNEL3:oifcfg setif -global en0/10.182.0.0:public oifcfg setif -global en0/192.168.0.0:cluster_interconnect
-
编辑 删除
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. CAUSE: Prior to installing Oracle RAC, you must create a valid &...
-
编辑 删除
System表空上对象无法回闪
SQL> create table ta(a number);Table created.SQL> create table tb(a number) tablespace system;Table created.SQL> drop table ta;Table dropped.SQL> drop table tb;Table dropped.SQL> flashback tab...
-
编辑 删除
aix backup and restore
find ./proddb -print | backup -i -f ./proddb.bkrestore -xdqvf ./proddb.bk find ./prodora -print | backup -i -f ./prodora.bkrestore -xdqvf ./prodora.bk restore -xdqvf ./prodappl.bkrestore -xd...
-
编辑 删除
ocr 记录
rac1->ocrcheckStatus of Oracle Cluster Registry is as follows : Version &nb...
-
编辑 删除
init.crs
#init.crs stop# ps -ef|grep init root 1 0 0 11:45:51 - 0:00 /etc/init &nbs...
-
编辑 删除
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/app/oracle/product...
