mapletree
an Oracle player in Ottawa
博文
(2007-08-13 17:56:53)
夏天快要過去了，我把肩頭曬傷了。我最愛玩那個大漏鬥，從高高的管道裏滑下來，象一條魚一樣甩到漏鬥裏，沿著內壁甩幾圈，撲通一聲大頭朝下栽到3米深的池子裏，暈頭轉向，一頭霧水地摸出來，岸上站著的人狂笑。回來肩頭的輕微灼傷變成了疼痛，在床上烙餅一樣地翻過來又翻過去，怎麽躺都不舒服，這把骨頭還真是欠練啊。[閱讀全文]
(2007-08-11 19:59:54)
CPUpatchissecurity-related,applyingitneedsdowntime.
here'sanvulnerabilityfiexedinCPUJul2007:
abugrelatedwithFRAfixedin10.2.0.3patch.
thesymptomis:v$recovery_file_dest.space_reclaimable(0)isnotconsistentwithV$FLASH_RECOVERY_AREA_USAGE.percent_space_reclaimable
so,althoughthere'senoughspaceinFRA,westillgotalarmedthattheFRAisover85%
SQL>selectname,
2round(space_limit...[閱讀全文]
here'sanvulnerabilityfiexedinCPUJul2007:
abugrelatedwithFRAfixedin10.2.0.3patch.
thesymptomis:v$recovery_file_dest.space_reclaimable(0)isnotconsistentwithV$FLASH_RECOVERY_AREA_USAGE.percent_space_reclaimable
so,althoughthere'senoughspaceinFRA,westillgotalarmedthattheFRAisover85%
SQL>selectname,
2round(space_limit...[閱讀全文]
(2007-08-11 19:22:01)
ORA-00607:Internalerroroccurredwhilemakingachangetoadatablock
ORA-00600:internalerrorcode,arguments:[4193],[674],[558],[],[],[],[],[]
SatAug417:35:322007
Errorsinfile/opt/ora9/admin/ora9i/udump/ora9i_ora_4433.trc:
ORA-00607:Internalerroroccurredwhilemakingachangetoadatablock
ORA-00600:internalerrorcode,arguments:[4193],[544],[542],[],[],[],[],[]
Error607happenedduringdbopen...[閱讀全文]
ORA-00600:internalerrorcode,arguments:[4193],[674],[558],[],[],[],[],[]
SatAug417:35:322007
Errorsinfile/opt/ora9/admin/ora9i/udump/ora9i_ora_4433.trc:
ORA-00607:Internalerroroccurredwhilemakingachangetoadatablock
ORA-00600:internalerrorcode,arguments:[4193],[544],[542],[],[],[],[],[]
Error607happenedduringdbopen...[閱讀全文]
(2007-08-11 19:09:02)
theoriginalrequestis:
mypcismydesktop(windowsxp),titan(RHELAS4)istheclientgateway,eplse1(RHELAS4)istheclientserver,
there'sanEM(10gdbconsole)runningoneplse1,nowweneedtoaccessEMonmypc.
1>usingportforwardingenableSQL*Netconnection
gateway:tools(216.246.110.4)
targetserver:delphi(10.0.4.2)
mypc:windowsXP
putty-ssh-L90001:10.0.4.2:1521maple@216.246.110.4--connecti...[閱讀全文]
mypcismydesktop(windowsxp),titan(RHELAS4)istheclientgateway,eplse1(RHELAS4)istheclientserver,
there'sanEM(10gdbconsole)runningoneplse1,nowweneedtoaccessEMonmypc.
1>usingportforwardingenableSQL*Netconnection
gateway:tools(216.246.110.4)
targetserver:delphi(10.0.4.2)
mypc:windowsXP
putty-ssh-L90001:10.0.4.2:1521maple@216.246.110.4--connecti...[閱讀全文]
(2007-08-08 18:01:54)
曼緹莎，聽起來象是一個女孩子的名字。
實際上她的意思是：科學計數法的實數那部分。
金山糍粑的解釋是越看越懵的那種：尾數。我是怎麽遇到這麽個變態的詞的呢？
看數值型數據(number)在oracle的內部存儲方式，它們是以科學計數法的形式存儲的。
初看之下，我也不明白，在M-W上搜，
Marc問我在作什麽，我說我在學新詞兒。他馬上拽過一張紙，給我舉了一個[閱讀全文]
實際上她的意思是：科學計數法的實數那部分。
金山糍粑的解釋是越看越懵的那種：尾數。我是怎麽遇到這麽個變態的詞的呢？
看數值型數據(number)在oracle的內部存儲方式，它們是以科學計數法的形式存儲的。
初看之下，我也不明白，在M-W上搜，
Marc問我在作什麽，我說我在學新詞兒。他馬上拽過一張紙，給我舉了一個[閱讀全文]
(2007-08-08 18:00:54)
trytorollupapartitiontable,it's300Gintotal,around2000partitions.
theplanistoexportoldpartitions,compressthem,thendroptheoldpartitions.
eg,partitionp20021018,it's500MBindba_segments,whileitsdumpfileis2GB,
thisisodd,normally,thedumpfilesizeissmallerthantheirsegmentsize.asexportdumpfileformatisinternal,foundnorelatedinformation,notsurewhatwaswrittenintothedumpfile.
atfirstIthoughtinde...[閱讀全文]
theplanistoexportoldpartitions,compressthem,thendroptheoldpartitions.
eg,partitionp20021018,it's500MBindba_segments,whileitsdumpfileis2GB,
thisisodd,normally,thedumpfilesizeissmallerthantheirsegmentsize.asexportdumpfileformatisinternal,foundnorelatedinformation,notsurewhatwaswrittenintothedumpfile.
atfirstIthoughtinde...[閱讀全文]
(2007-08-07 18:09:36)
--automaticallystartupandshutdown,withmultipleORACLE_HOMEs
normallythisisnotaproblem,butthere'sproblemwhen8iand10gco-existinoratab,andthedefaultORACLE_HOMEissetto8i.as$ORACLE_HOME/bin/dbstartupwillpickup'svrmglr'insteadof'sqlplus/assysdba'
$ORACLE_HOME/bin/dbstart|Ensuresacleanstartupofdatabaseinstance(s),evenaftersystemfailure
-------------------------|--------------------------------...[閱讀全文]
normallythisisnotaproblem,butthere'sproblemwhen8iand10gco-existinoratab,andthedefaultORACLE_HOMEissetto8i.as$ORACLE_HOME/bin/dbstartupwillpickup'svrmglr'insteadof'sqlplus/assysdba'
$ORACLE_HOME/bin/dbstart|Ensuresacleanstartupofdatabaseinstance(s),evenaftersystemfailure
-------------------------|--------------------------------...[閱讀全文]
(2007-08-06 10:23:14)
createaVBinstallationpackage.2errors:
1>system.invalidoperationexception
becausethedatagridocxdidnotgetregistered,butit'snotdbgrid32.ocx,msdatgrid.ocx,
it'sMSCHRT20.OCX,withAxInterop.MSChart20Lib.dll,Interop.MSChart20Lib.dllinthesamedirectoryastheexe.
Itotallyforgotaboutthis,it'sdevelopedbyme18monthsago,nowittookme2weekendstofigureitout!
2>Runtime.InteropServices.COMExcept...[閱讀全文]
1>system.invalidoperationexception
becausethedatagridocxdidnotgetregistered,butit'snotdbgrid32.ocx,msdatgrid.ocx,
it'sMSCHRT20.OCX,withAxInterop.MSChart20Lib.dll,Interop.MSChart20Lib.dllinthesamedirectoryastheexe.
Itotallyforgotaboutthis,it'sdevelopedbyme18monthsago,nowittookme2weekendstofigureitout!
2>Runtime.InteropServices.COMExcept...[閱讀全文]
