<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cool0528的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cool0528</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cool0528]]></copyright><item><title><![CDATA[关于oracle调用存储过程 传递 表对象 等其它结构对象的补充]]></title><link>https://blog.youkuaiyun.com/cool0528/article/details/100233419</link><guid>https://blog.youkuaiyun.com/cool0528/article/details/100233419</guid><author>cool0528</author><pubDate>Thu, 12 Aug 2010 10:42:33 +0800</pubDate><description><![CDATA[http://jidongzheng.itpub.net/post/37572/474200
以前在文章
http://jidongzheng.itpub.net/post/37572/465011
提到了使用bulk i...]]></description><category></category></item><item><title><![CDATA[ORA-00368: 重做日志块中的校验和错误]]></title><link>https://blog.youkuaiyun.com/cool0528/article/details/100233411</link><guid>https://blog.youkuaiyun.com/cool0528/article/details/100233411</guid><author>cool0528</author><pubDate>Tue, 25 May 2010 16:27:52 +0800</pubDate><description><![CDATA[ORA-00368: 重做日志块中的校验和错误ORA-00353: 日志损坏接近块 63354 更改 61179964 时间 05/06/2008 18:10:10ORA-00334: 归档日志: 'E:\ORADATA\ORC...]]></description><category></category></item><item><title><![CDATA[使用dblinke的merge]]></title><link>https://blog.youkuaiyun.com/cool0528/article/details/100233408</link><guid>https://blog.youkuaiyun.com/cool0528/article/details/100233408</guid><author>cool0528</author><pubDate>Mon, 17 May 2010 15:28:27 +0800</pubDate><description><![CDATA[使用dblinke的merge
数据库版本 10.2.0.1 【必须】同时有matched和notmatched-- 报语法错误的
数据库版本 10.2.0.4 【不是】必须同时有matched和notmatched

...]]></description><category></category></item><item><title><![CDATA[TNS-12533: TNS:illegal ADDRESS parameters]]></title><link>https://blog.youkuaiyun.com/cool0528/article/details/100233415</link><guid>https://blog.youkuaiyun.com/cool0528/article/details/100233415</guid><author>cool0528</author><pubDate>Thu, 13 May 2010 14:52:00 +0800</pubDate><description><![CDATA[崩溃了。这样也不行tnsping ORCL1报错Used TNSNAMES adapter to resolve the alias)SERVICE_NAME = orcl)= TCP)(HOST = 192.168.4.1)...]]></description><category></category></item><item><title><![CDATA[ora-00600 [kdsgrp1]]]></title><link>https://blog.youkuaiyun.com/cool0528/article/details/100233421</link><guid>https://blog.youkuaiyun.com/cool0528/article/details/100233421</guid><author>cool0528</author><pubDate>Thu, 13 May 2010 12:24:58 +0800</pubDate><description><![CDATA[alter日志中报错ora-00600 [kdsgrp1]看trace文件file# 23 blck# 615 solt 194select /*+index（a index_name）*/ col from table1 ...]]></description><category></category></item><item><title><![CDATA[ORA-00600:  [kcfnew_2], [93][][][]]]></title><link>https://blog.youkuaiyun.com/cool0528/article/details/100233418</link><guid>https://blog.youkuaiyun.com/cool0528/article/details/100233418</guid><author>cool0528</author><pubDate>Mon, 10 May 2010 10:00:49 +0800</pubDate><description><![CDATA[给表添加分区的时候的报错ORA-00600: [kcfnew_2], [93][][][]一看是600只好去baidu google了一把。竟然没有有价值的东西。（补充：这个问题让有metalink账号的兄弟帮我看了，也同样没...]]></description><category></category></item><item><title><![CDATA[ora-00600 [kddummy_blkchk]]]></title><link>https://blog.youkuaiyun.com/cool0528/article/details/100233413</link><guid>https://blog.youkuaiyun.com/cool0528/article/details/100233413</guid><author>cool0528</author><pubDate>Tue, 27 Apr 2010 20:35:35 +0800</pubDate><description><![CDATA[alter system set db_block_checksum=off scope=both;
                                                            
  ...]]></description><category></category></item><item><title><![CDATA[ORA-01115 IO error reading block from file]]></title><link>https://blog.youkuaiyun.com/cool0528/article/details/100233406</link><guid>https://blog.youkuaiyun.com/cool0528/article/details/100233406</guid><author>cool0528</author><pubDate>Mon, 26 Apr 2010 15:42:34 +0800</pubDate><description><![CDATA[SQL&gt; alter database open;alter database open*ERROR at line 1:ORA-01115: IO error reading block from file 92 (bl...]]></description><category></category></item><item><title><![CDATA[TNS-00515]]></title><link>https://blog.youkuaiyun.com/cool0528/article/details/100233404</link><guid>https://blog.youkuaiyun.com/cool0528/article/details/100233404</guid><author>cool0528</author><pubDate>Fri, 23 Apr 2010 20:16:53 +0800</pubDate><description><![CDATA[这个问题是上个linux上Oracle账号被删的续。
监听不能启动时报错。**************************host=localhost*********************TNS-00515 ： 因目标...]]></description><category></category></item><item><title><![CDATA[This account is currently not available]]></title><link>https://blog.youkuaiyun.com/cool0528/article/details/100233416</link><guid>https://blog.youkuaiyun.com/cool0528/article/details/100233416</guid><author>cool0528</author><pubDate>Thu, 22 Apr 2010 17:38:23 +0800</pubDate><description><![CDATA[这个东西和oracle基本没什么关系。
问题不知道哪个大哥把linux上的oracle用户给删除了。重新创建oracle。su - oracle是报错This account is currently not availabl...]]></description><category></category></item><item><title><![CDATA[SQL: LIKE Condition 【转】]]></title><link>https://blog.youkuaiyun.com/cool0528/article/details/100233412</link><guid>https://blog.youkuaiyun.com/cool0528/article/details/100233412</guid><author>cool0528</author><pubDate>Thu, 22 Apr 2010 11:20:55 +0800</pubDate><description><![CDATA[The LIKE condition allows you to use wildcards in the where clause of an SQL statement. This allows you to perform...]]></description><category></category></item><item><title><![CDATA[ORA-00600: internal error code, arguments: [kddummy_blkchk],]]></title><link>https://blog.youkuaiyun.com/cool0528/article/details/100233409</link><guid>https://blog.youkuaiyun.com/cool0528/article/details/100233409</guid><author>cool0528</author><pubDate>Thu, 15 Apr 2010 10:34:42 +0800</pubDate><description><![CDATA[现象数据库启动后自动关闭。
错误信息ORA-00600: internal error code, arguments: [kddummy_blkchk], ［65］，［3］。。。。
问题描述DUMMYFILEFORB...]]></description><category></category></item><item><title><![CDATA[to_number() to_char()]]></title><link>https://blog.youkuaiyun.com/cool0528/article/details/100233400</link><guid>https://blog.youkuaiyun.com/cool0528/article/details/100233400</guid><author>cool0528</author><pubDate>Sat, 10 Apr 2010 10:44:45 +0800</pubDate><description><![CDATA[把一个很长的数字转化成字符串没有问题
把一个很长的字符串转换成数字可能会有问题。
to_char()
to_number()
                                                ...]]></description><category></category></item><item><title><![CDATA[oracle 10g awr]]></title><link>https://blog.youkuaiyun.com/cool0528/article/details/100233405</link><guid>https://blog.youkuaiyun.com/cool0528/article/details/100233405</guid><author>cool0528</author><pubDate>Wed, 07 Apr 2010 13:49:22 +0800</pubDate><description><![CDATA[awr默认每个小时收集一次统计信息，并且保留7天的数据。
SQL&gt; select * from dba_hist_wr_control;
DBID SNAP_INTERVAL RETENTION TOPNSQL----...]]></description><category></category></item><item><title><![CDATA[oracle 10g awr]]></title><link>https://blog.youkuaiyun.com/cool0528/article/details/100233410</link><guid>https://blog.youkuaiyun.com/cool0528/article/details/100233410</guid><author>cool0528</author><pubDate>Wed, 07 Apr 2010 13:39:14 +0800</pubDate><description><![CDATA[Automatic Workload Repository (AWR) in Oracle Database 10gOracle have provided many performance gathering and repo...]]></description><category></category></item><item><title><![CDATA[ORA-01578 ORA-01110 SYSAUX]]></title><link>https://blog.youkuaiyun.com/cool0528/article/details/100233402</link><guid>https://blog.youkuaiyun.com/cool0528/article/details/100233402</guid><author>cool0528</author><pubDate>Tue, 06 Apr 2010 22:07:53 +0800</pubDate><description><![CDATA[Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_smon_529.trc:ORA-01578: ORACLE data block corrupted (file # 3...]]></description><category></category></item><item><title><![CDATA[ORA-00376 ORA-01110]]></title><link>https://blog.youkuaiyun.com/cool0528/article/details/100233407</link><guid>https://blog.youkuaiyun.com/cool0528/article/details/100233407</guid><author>cool0528</author><pubDate>Tue, 06 Apr 2010 11:17:57 +0800</pubDate><description><![CDATA[执行SQL语句是报错。SQL&gt;select * from table_name;ORA-00376: file 12 cannot be read at this timeORA-01110:...]]></description><category></category></item><item><title><![CDATA[ORA-00600 [kcratr1_lastbwr]]]></title><link>https://blog.youkuaiyun.com/cool0528/article/details/100233395</link><guid>https://blog.youkuaiyun.com/cool0528/article/details/100233395</guid><author>cool0528</author><pubDate>Mon, 05 Apr 2010 18:55:49 +0800</pubDate><description><![CDATA[ksedmp: internal or fatal errorORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [...]]></description><category></category></item><item><title><![CDATA[Oracle中导出修复数据块损坏]]></title><link>https://blog.youkuaiyun.com/cool0528/article/details/100233398</link><guid>https://blog.youkuaiyun.com/cool0528/article/details/100233398</guid><author>cool0528</author><pubDate>Mon, 29 Mar 2010 10:19:34 +0800</pubDate><description><![CDATA[SQLPLUS中或是Alter日志有如下类似的错误信息：ORA-01578: ORACLE 数据块损坏（文件号4，块号35）ORA-01110: 数据文件 4: 'E:\BLOCK.DBF'
从日...]]></description><category></category></item><item><title><![CDATA[ORA-01122 ORA-01207问题(转)]]></title><link>https://blog.youkuaiyun.com/cool0528/article/details/100233394</link><guid>https://blog.youkuaiyun.com/cool0528/article/details/100233394</guid><author>cool0528</author><pubDate>Mon, 15 Mar 2010 23:16:44 +0800</pubDate><description><![CDATA[ORA-01122错误的解决方法(如果要重建控制文件，先看看数据文件是否一至,文件不一致，可以用强制同步的办法，但就怕数据表会有问题)在重建控制文件前先试试面的方法recover database using backup co...]]></description><category></category></item></channel></rss>