2019-7-10:昨天團隊會議，當leader開講時，讓我百感交集。3個月零17天前，當時來到現場出現三個有意思的現象，一是客戶對交付極度不滿意；二是現場項目經理自嗨感爆棚；三是團隊每天都像木偶一樣拴在項目經理身上，跳大繩一樣的在辦公室里東竄西跳。現象有了，問題出在哪里？根源在哪里？如果是你怎么解決這個問題？這些需要了解的可以私信我，這里就不占用過多時間。今天早上我想表達是這件事情的結果：一、辦公室里不是一個人在跳大繩了，而是整個團隊自覺有序，激情洋溢的群體跳大繩；二、整個團隊積極向上，那些90后的孩子們因為找到了方法，得到了認可，臉上洋溢的那種自信和從容，真的讓人看到感覺很溫暖，更讓人感到幸福；三、因為團隊找到了自己節奏，客戶對交付質量“群眾性滿意”（群眾性滿意是指所有客戶干系人都滿意）。客戶滿意認可，團隊則效率越高，效率越高，客戶滿意認可，以此形成良好的正向循環。下面這張圖就是我們團隊遇到問題，處理問題的思維模型：

2019-07-09 :早上睜開眼，圈里看到這個圖： 

自己奔四了，在剛畢業的那幾年，每個月都是月初工資沒幾天，就和兄弟夜宵沒了，回頭想想，那些最終成為能談心，能溝通的兄弟，反而是那些很少胡吃海喝的，胡吃海喝的除了胡吃海喝，好像就沒有別的了。所以，要盡早養成不亂花錢，攢錢的習慣，這就和我們說的陽光燦爛的日子修屋頂一個道理，因為意外和美好哪個先來，只有老天知道，但老天從來不泄漏哪個先來。管理其實也是一樣的，當棘手的事情逐漸解決，慢慢向好之后，我們要做是如何保持，如何未雨綢繆，黑天鵝，灰犀牛，不是我們不愿意，不喜歡，他就不來找咱，凡人的我們決定不了明天的陰晴圓缺，但我們可以為明天的陰晴圓缺儲備對應的措施。生于憂患 死于安樂。

今天給12R2打db補丁，以閱女無數的心態三下五去二開始，結果直接干骨頭上了，報錯結果如下：

[oracle@xxxx:/oracle/product/12.2.0/OPatch]$  ./datapatch -verbose

SQL Patching tool version 12.2.0.1.0Production on Fri Apr 19 16:56:58 2019

Copyright (c) 2012, 2019, Oracle.  All rights reserved.

Log file for this invocation: /oracle/app/cfgtoollogs/sqlpatch/sqlpatch_35782718_2019_04_19_16_56_58/sqlpatch_invocation.log

Connecting to database...OK

Bootstrapping registry and package tocurrent versions...done

Determining current state...done

Current state of SQL patches:

Patch 29249637 (OJVM RELEASE UPDATE:12.2.0.1.190416 (29249637)):

 Installed in the binary registry only

Bundle series DBRU:

  ID190416 in the binary registry and ID 190416 with errors in the SQL registry

Adding patches to installation queue andperforming prereq checks...

Installation queue:

 Nothing to roll back

  Thefollowing patches will be applied:

   29249637 (OJVM RELEASE UPDATE: 12.2.0.1.190416 (29249637))

   29314339 (DATABASE APR 2019 RELEASE UPDATE 12.2.0.1.190416)

Installing patches...

Patch installation complete.  Total patches installed: 2

Validating logfiles...

Patch 29249637 apply: SUCCESS

 logfile:/oracle/app/cfgtoollogs/sqlpatch/29249637/22825875/29249637_apply_BSSJFDB_2019Apr19_16_58_47.log(no errors)

Patch 29314339 apply: WITH ERRORS

 logfile:/oracle/app/cfgtoollogs/sqlpatch/29314339/22848642/29314339_apply_BSSJFDB_2019Apr19_17_00_14.log(errors)

   Error at line 3727: Warning: Package Body created with compilationerrors.

   Error at line 32342: Warning: Package Body created with compilationerrors.

   Error at line 32349: 4675/4  PL/SQL: Statement ignored

   Error at line 32350: 4675/23 PLS-00302: component ISNONORACLECLOUD must be declared

   Error at line 32372: 4675/4  PL/SQL: Statement ignored

   Error at line 32373: 4675/23 PLS-00302: component ISNONORACLECLOUD must be declared

   Error at line 33026: Warning: Trigger created with compilation errors.

   Error at line 33033: 0/0     PLS-00905: object GSMADMIN_INTERNAL.DBMS_GSM_POOLADMIN is invalid

   Error at line 33050: Warning: Trigger created with compilation errors.

   Error at line 33057: 0/0     PLS-00905: object GSMADMIN_INTERNAL.DBMS_GSM_POOLADMIN is invalid

   Error at line 33064: Warning: Trigger created with compilation errors.

   Error at line 33071: 0/0     PLS-00905: object GSMADMIN_INTERNAL.DBMS_GSM_POOLADMIN is invalid

Please refer to MOS Note 1609718.1 and/orthe invocation log

/oracle/app/cfgtoollogs/sqlpatch/sqlpatch_35782718_2019_04_19_16_56_58/sqlpatch_invocation.log

for information on how to resolve the aboveerrors.

SQL Patching tool complete on Fri Apr 1917:00:53 2019

擼了擼MOS，結合MOS相關提示，處理過程如下：

1、查詢無效對象：

select owner,object_type,object_name,status from dba_objects where status = INVALID order by owner;

2、重編譯下對象

Sqlplus / as sysdba

?$ORACLE_HOME/rdbms/admin/catproc

?$ORACLE_HOME/rdbms/admin/utlrp

3、重新運行更新數據字典腳本

su - oracle

cd /oracle/product/12.2.0/OPatch

./datapatch -verbose

執行成功無報錯。