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

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

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

今天給12R2打db補(bǔ)丁，以閱女無數(shù)的心態(tài)三下五去二開始，結(jié)果直接干骨頭上了，報(bào)錯(cuò)結(jié)果如下：

[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，結(jié)合MOS相關(guān)提示，處理過程如下：

1、查詢無效對(duì)象：

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

2、重編譯下對(duì)象

Sqlplus / as sysdba

?$ORACLE_HOME/rdbms/admin/catproc

?$ORACLE_HOME/rdbms/admin/utlrp

3、重新運(yùn)行更新數(shù)據(jù)字典腳本

su - oracle

cd /oracle/product/12.2.0/OPatch

./datapatch -verbose

執(zhí)行成功無報(bào)錯(cuò)。