ITPub博客

---第一种情况---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...

 alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.4)(PORT = 1521))' sid='yb2' 

--Aix OS1;修改/etc/hosts2;修改nodeapps#export ORACLE_HOME=/opt/app/oracle/product/10.2.0/db_1#/opt/app/oracle/product/10.2.0/crs/bin/srvctl modify nodeapps -n app1 -A 10.1.1.3/255.255.255.0/en2#/opt/a...

SELECT      A.VALUE "GC BLOCKS LOST 1",      B.VALUE "GC BLOCKS CORRUPT 1",      C.VALUE "GC BLOCKS LOST 2",  &nbsp...

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...

sqlplus -prelim / as sysdba

2008年结束了，经历了最艰苦的一年，也是难以忘怀的一年。希望在2009年能够在工作中更顺利，自己有所进展。

SQL> connect / as sysdbaSQL> shutdown abort;SQL> startup nomount;SQL> alter database mount exclusive;SQL> alter system enable restricted session;SQL> drop database;[@more@]

好几个月没发帖了，好几个月没看书了，颓废了。[@more@]z

＃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...

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 ...

cp -R /u01/oratest/testdata /u02/oraprod/proddatacp -R /u01/oratest/testdb   /u02/oraprod/proddb/dev/fslv01      135.00     93.40   31...

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...

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...

tnsping service_name 返回状态正常！sqlplus userid/passwd@service_name 出现ORA-12514错误.前几天11g中也碰到了这个问题，今天的版本是Release 10.2.0.1.0也遭错误.解决办法是修改listener.ora中SID_LIST_LISTEN...

SQL> host oerr ora 1251412514, 00000, "TNS:listener does not currently know of service requested in connect descriptor"// *Cause: The listener received a request to establish a connection to a// database or other service. The connect descriptor received by the listener// specified a service name for a service (usually a database service)// that either has not yet dynamically registered with the listener or has// not been statically configured for the listener. This may be a tempor

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...

新的一年到了，希望自己不要荒废，革命尚未成功，自励一下。[@more@]

SQL> create or replace Function RevStr(P_str in varchar2) return varchar2 is 2 l_RevStr varchar2(2000); 3 begin 4 for x in 1 .. length(P_str) loop 5 l_RevStr := substr(P_str, x, 1) || l_RevStr; 6 end loop; 7 return l_RevStr; 8 end; 9 /函数已创建。SQL> select RevStr('高级会员') from dual;REVSTR('高级会员')--------------------------------------------------------------------------------员会级高[@more@]

declare l_Lnum number default 1; l_Sdrow number default 0; l_Edrow number default 0; begin l_Sdrow :=&Sdrow; l_Edrow :=&Edrow; while l_Lnum <= trunc(l_Sdrow/l_Edrow) loop delete from test1 where rownum <=l_Edrow; commit; l_Lnum :=l_Lnum + 1; end loop; if mod(l_Sdrow,l_Edrow) <&gt