其他

  1.  五一假期結束，來回折騰了幾天，有點小累。 早上來公司，看了下郵箱，有五十多封郵件。 基本都是系統監控的。 看了一下，沒啥問題，郵件檢查的工作結束。 2.  4月30號早上8：30的汽車，到下午三點多才到安慶。在轉車，到家都下午4點多了， 想想這個交通，真有點可惡。 安慶的發展怎麼就那麼慢。 每次回家看到此景都很不爽。 安慶現在給我的感覺是小地方，發展差。  至於目光短淺，現在是21世紀，到處都在搞數字化，資訊化。 一線城市都在搞數字城市，數字醫院，平安城市，雲中心，都是幾千萬的投入，

 Beginning with Release 11g, Oracle Database includes an advanced fault diagnosability infrastructure for preventing, detecting, diagnosing, and resolving problems.  This note helps to understand the new 11g infrastructure known  as Automatic

On RAC, expdp Removes the Service Name [ID 1269319.1] Modified 25-NOV-2010     Type PROBLEM     Status MODERATED In this Document  Symptoms  Cause  Solution  ReferencesThis document is being delivered to you via Oracle Support's Rapid Visibility

DECLARE l_sql VARCHAR2(2000) := 'select deptno,loc from scott.dept'; l_where VARCHAR2(200); TYPE dept_curtype IS REF CURSOR; dept_cur dept_curtype; TYPE dept_rec IS RECORD( deptno VARCHAR2(200) --attention the record element order ,loc

這個sql咋寫？兩個表的結構一模一樣，資料大部分是重複，小部分不同；要求：1.如果a列資料相同，計算b列相減的結果test1:a    b  xxx  1yyy  2zzz  3 test2：a    bxxx  3zzz  2qqq  1查詢結果結果為：a    bxxx  2zzz  -1yyy  -2qqq  1   Create Table:CREATE TABLE test1(a VARCHAR2(20),b NUMBER);CREATE TABLE test2(a VARCHAR2(

a pack slip denotes what should be "packed" for a delivery. It may consolidate several orders to a route, truck or customer. However, in some businesses the pack slip or packing slip shows what has been "picked" for delivery or shipmenta pick sheet

        When applying a needed patch to the Grid Infrastructure Home for ASM or CRS the opatch utility may error out with the messages: ApplySession failed: ApplySession failed to prepare the system. ApplySession was not able to create the

         In a single asm_diskstring parameter we can have 255 characters and this excludes the asterisk (*) , comma (,) and single-quote ('). This is limited by v$asm_disk.path column's datatype length.        In an ASM instance we can have multiple

LOCK ON SYS.SMON_SCN_TIME [ID 747745.1] Modified 27-NOV-2008     Type PROBLEM     Status MODERATED In this Document  Symptoms  Cause  SolutionThis document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore

  If using pfile, it must be a filesystem file on local filesystem.If using spfile, then it can be in the following locations.-- a filesystem file spfile on local filesystem-- spfile on shared device-- a ASM file in a ASM diskgroup (only for spfile

  安裝RAC Clusterware，在驗證的時候，有2個沒有通過，內容如下： Checking local Cluster Synchronization Services (CSS) status ...Actual Result: Unknown Host Exception has Occurred :60.191.124.236.Check complete. The overall result of this check is: Not executed <<<

 朋友說資料庫異常宕機後，啟動時報600錯誤。 ora-00600:internal error code ,arguments:[kccpb_sanity_check_2],[3106],[3104],[0x000000000],[],[],[],[] 在官網搜了一下，相關的說明如下： Cause       [kccpb_sanity_check_2] indicates that the seq# of the last read block is higher than the seq#

         After installing a non-RAC (Real Application Clusters) 10g database, you notice an ocssd.bin process running.ps -ef | grep ocssd.binoracle 11139 11056 0 14:02:14 pts/52 0:00 grep ocssd.binoracle 1824 1 0 Mar 12 ? 0:01

 After upgrade the ASM instance from release 11.1 to release 11.2 existing database is unable to start/open due to the next error:/u01/app/oracle/product/11.1.0/dbs>sqlplusSQL*Plus: Release 11.1.0.6.0 - Production on Wed Apr 7 15:49:33

EditPlus是一套功能非常強大的文字編輯器，擁有無限制的Undo/Redo（撤銷）、英文拼字檢查、自動換行、列數標記、搜尋取代、同時編輯多檔案、全螢幕瀏覽功能。而它還有一個好用的功能，就是它有監視剪貼簿的功能，能夠同步於剪貼簿自動將文字貼進EditPlus的編輯視窗中，讓你省去做貼上的步驟。另外它也是一個好用的程式碼編輯器，除了支援HTML, CSS, PHP, ASP, Perl, C/C++, Java, JavaScript,

  Patch 8402551 not available to download from Metalink.SolutionPatch 8402551 has been withdrawn because it had some issues, it was replaced by Patch 8969852.Even Patch 8402551 included in Patch 8461420, Patch 8969852 should be applied:1. Download

 This document will list the possible meta characters for asm_diskstring parameter  Solution* and [] are the two valid meta characters for asm_diskstring parameter.SQL> alter system set asm_diskstring='/dev/raw/raw*' scope=both;System altered.SQL&

  運行srvctl 命令報錯：[oracle@rac1 u01]$ srvctl remove asm -n rac1   /u01/app/oracle/product/10.2.0/db_1/jdk/jre/bin/java: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory       

 Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.6Information in this document applies to any platform.GoalThis document describes the procedures for converting from Oracle ASM 10g single-instance to Oracle Real

  朋友說對windows RAC 打上Patch後，有個節點執行個體不能啟動， 其他進程正常。         ORA-00439: feature not enabled: Real Application Clusters        在Metalink上搜了下，都是針對Linux 平台的，window平台的解決方案沒有找到，不過朋友自己解決了這個問題，在有問題的節點上重新打了patch。就ok了。         導致這個錯誤的原因是因為RAC 沒有link 到RDBMS home。