-
编辑 删除
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...
-
编辑 删除
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的测试记录
---第一种情况---halt -q模拟hang(23)机# halt -q....Halt completed....alert*.log内容如下:Tue Jan 20 08:58:05 2009Reconfiguration started (old inc 4, new inc 6)List of nodes: 0 Global Resourc...
-
编辑 删除
修改rac参数
alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.4)(PORT = 1521))' sid='yb2'
-
编辑 删除
查看表空间使用情况
column TABLESPACE_NAME format a20;SELECT dts.tablespace_name, NVL(ddf.bytes / 1024 / 1024, 0) avail,NVL(ddf.bytes - NVL(dfs.bytes, 0), 0)/1024/1024 used,NVL(dfs.bytes / 1024 / 1024, 0) free,TO_CHAR(NV...
-
编辑 删除
hang oracle
sqlplus -prelim / as sysdba
-
编辑 删除
新的一年开始了
2008年结束了，经历了最艰苦的一年，也是难以忘怀的一年。希望在2009年能够在工作中更顺利，自己有所进展。
-
编辑 删除
linux学习点滴
＃Redhat 4安装oracle的设置cat >> /etc/sysctl.conf <<EOFkernel.shmall = 2097152kernel.shmmax = 2147483648kernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 65536net.ipv4.ip_local_port_ran...
-
编辑 删除
oracle rac
mkdir ~/.sshchmod 700 ~/.sshssh-keygen -t rsaocfs2-2.6.9-55.ELsmpocfs2-2.6.9-55.ELsmphttp://oss.oracle.com/projects/ocfs2/files/RedHat/RHEL4/i386/1.2.5-2/ srvctl stop service -d <database name> -s ...
-
编辑 删除
erp clone record
cp -R /u01/oratest/testdata /u02/oraprod/proddatacp -R /u01/oratest/testdb /u02/oraprod/proddb/dev/fslv01 135.00 93.40 31...
-
编辑 删除
asm 小结
ORA-15000: command disallowed by current instance typeexport ORACLE_SID=+ASMselect name,state from v$asm_diskgroup;ALTER DISKGROUP dgroup1 MOUNTALTER DISKGROUP dgroup1 DISMOUNT;create diskgroup dgr...
-
编辑 删除
erp concurrent process can not start
Concurrent Managers Fail to Start, Verify that findev has been registered for concurrent processingSymptomsAfter migration of the Applications tier the concurrent managers do not start. Only a single...
-
编辑 删除
Lock Escalation
Lock EscalationThe creation of additional Interested Transaction Lists (ITL) slots is subject to free space in the datablock because each ITL takes approximately 24 bytes of free space in the variabl...
