<\/p>\n
So what oracle internal objects were changed in October 2018 – <\/strong>181016<\/strong><\/span>?<\/p>\n P.S: Nothing was changed for 11.2 in Oracle objects.<\/strong><\/span><\/p>\n And created?<\/p>\n P.S: Nothing was added for 11.2 \/ 12.2 \/ 18 in Oracle objects.<\/strong><\/span><\/p>\n So which are exactly the objects modified by 181016?<\/p>\n P.S: Useful Links:<\/p>\nVERSION PATCH OWNER TYPE TOTAL\r\n---------- --------------- ---------- --------------- ----------\r\n12.1.0.2 BP SYS PACKAGE 1\r\n12.1.0.2 BP SYS PACKAGE BODY 5\r\n12.1.0.2 BP SYS VIEW 3\r\n12.1.0.2 BP SYSTEM FUNCTION 1\r\n12.1.0.2 PSU SYS PACKAGE BODY 2\r\n12.1.0.2 PSU & BP SYS PACKAGE BODY 1\r\n12.2.0.1 JUL2018RUR DVSYS TYPE 5\r\n12.2.0.1 JUL2018RUR SYS PACKAGE BODY 6\r\n12.2.0.1 RU SYS PACKAGE 1\r\n12.2.0.1 RU SYS PACKAGE BODY 3\r\n18.0.0.0 18.2RUR SYS PACKAGE 2\r\n18.0.0.0 18.2RUR SYS PACKAGE BODY 1\r\n18.0.0.0 18.3RUR SYS PACKAGE 2\r\n18.0.0.0 18.3RUR SYS PACKAGE BODY 1\r\n18.0.0.0 RU CTXSYS PACKAGE BODY 1\r\n18.0.0.0 RU SYS PACKAGE 4\r\n18.0.0.0 RU SYS PACKAGE BODY 6\r\n18.0.0.0 RU SYS PROCEDURE 2\r\n<\/pre>\n
VERSION PATCH OWNER TYPE TOTAL\r\n---------- --------------- ---------- --------------- ----------\r\n12.1.0.2 BP SYSTEM FUNCTION 1\r\n12.1.0.2 BP SYSTEM TYPE 2<\/pre>\n
VERSION PATCH OWNER TYPE NAME ACTION\r\n---------- --------------- ---------- --------------- ------------------------------ ------\r\n12.1.0.2 BP SYSTEM FUNCTION LOGMNR$GSBA_GG_TABF_PUBLIC NEW\r\n12.1.0.2 BP SYSTEM TYPE LOGMNR$GSBA_GG_REC NEW\r\n12.1.0.2 BP SYSTEM TYPE LOGMNR$GSBA_GG_RECS NEW\r\n12.1.0.2 BP SYS PACKAGE DBMS_BACKUP_RESTORE MOD\r\n12.1.0.2 BP SYS PACKAGE BODY DBMS_BACKUP_RESTORE MOD\r\n12.1.0.2 BP SYS PACKAGE BODY DBMS_STATS MOD\r\n12.1.0.2 BP SYS PACKAGE BODY LOGMNR_DICT_CACHE MOD\r\n12.1.0.2 BP SYS VIEW LOGSTDBY_RU_UNSUPPORT_TAB_12_1 MOD\r\n12.1.0.2 BP SYS VIEW LOGSTDBY_SUPPORT_TAB_12_1 MOD\r\n12.1.0.2 BP SYS VIEW LOGSTDBY_UNSUPPORT_TAB_12_1 MOD\r\n12.1.0.2 BP SYSTEM FUNCTION LOGMNR$TAB_GG_TABF_PUBLIC MOD\r\n12.1.0.2 PSU & BP SYS PACKAGE BODY DBMS_AQADM_SYS MOD\r\n12.1.0.2 PSU & BP SYS PACKAGE BODY DBMS_PRVTAQIM MOD\r\n12.1.0.2 PSU & BP SYS PACKAGE BODY DBMS_RCVMAN MOD\r\n12.2.0.1 JUL2018RUR DVSYS TYPE SYS_YOID0000072649$ MOD\r\n12.2.0.1 JUL2018RUR DVSYS TYPE SYS_YOID0000072661$ MOD\r\n12.2.0.1 JUL2018RUR DVSYS TYPE SYS_YOID0000072667$ MOD\r\n12.2.0.1 JUL2018RUR DVSYS TYPE SYS_YOID0000072694$ MOD\r\n12.2.0.1 JUL2018RUR DVSYS TYPE SYS_YOID0000072697$ MOD\r\n12.2.0.1 JUL2018RUR SYS PACKAGE BODY DBMS_XSTREAM_ADM_INTERNAL MOD\r\n12.2.0.1 JUL2018RUR SYS PACKAGE BODY DBMS_XSTREAM_ADM_UTL MOD\r\n12.2.0.1 JUL2018RUR SYS PACKAGE BODY DBMS_XSTREAM_AUTH_IVK MOD\r\n12.2.0.1 JUL2018RUR SYS PACKAGE BODY DBMS_XSTREAM_GG_INTERNAL MOD\r\n12.2.0.1 JUL2018RUR SYS PACKAGE BODY DBMS_XSTREAM_UTL_IVK MOD\r\n12.2.0.1 RU SYS PACKAGE DBMS_RCVMAN MOD\r\n12.2.0.1 RU SYS PACKAGE BODY DBMS_QOPATCH MOD\r\n12.2.0.1 RU SYS PACKAGE BODY DBMS_STATS MOD\r\n12.2.0.1 RU & JUL2018RUR SYS PACKAGE BODY DBMS_RCVMAN MOD\r\n18.0.0.0 RU CTXSYS PACKAGE BODY DRIUTL MOD\r\n18.0.0.0 RU SYS PACKAGE DBMS_ISCHED MOD\r\n18.0.0.0 RU SYS PACKAGE DBMS_RCVMAN MOD\r\n18.0.0.0 RU SYS PACKAGE BODY DBMS_ISCHED MOD\r\n18.0.0.0 RU SYS PACKAGE BODY DBMS_QOPATCH MOD\r\n18.0.0.0 RU SYS PACKAGE BODY DBMS_REGISTRY MOD\r\n18.0.0.0 RU SYS PACKAGE BODY DBMS_SCHEDULER MOD\r\n18.0.0.0 RU SYS PACKAGE BODY DBMS_STATS MOD\r\n18.0.0.0 RU SYS PROCEDURE DBMS_FEATURE_ACTIVE_DATA_GUARD MOD\r\n18.0.0.0 RU SYS PROCEDURE SCHEDULER$_JOB_EVENT_HANDLER MOD\r\n18.0.0.0 RU & 18.3RUR & SYS PACKAGE DBMS_BACKUP_RESTORE MOD\r\n 18.2RUR\r\n18.0.0.0 RU & 18.3RUR & SYS PACKAGE DBMS_REGISTRY MOD\r\n 18.2RUR\r\n18.0.0.0 RU & 18.3RUR & SYS PACKAGE BODY DBMS_RCVMAN MOD\r\n 18.2RUR<\/pre>\n
What changed for each? (click to see the changes)<\/strong><\/h2>\n
\n
\n
\n
\n
Changed Objects<\/h2>\n
\n<\/strong><\/span>> = Added Lines
\n< = Removed Lines<\/strong><\/span><\/p>\n12.1.0.2<\/strong><\/h3>\n
8242a8243,8248\r\n> \r\n> FUNCTION createTempXmlFile\r\n> RETURN varchar2;\r\n> -- This procedure returns a temporary filename.\r\n> -- The temporary filename is derived from ?\/dbs location.\r\n> \r\n<\/pre>\n
2804c2804,2815\r\n< TMP_STR := NLS_UPPER(LTRIM(RTRIM(SORT_TAB(I))));\r\n---\r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> TMP_STR := NLS_UPPER(LTRIM(RTRIM(SORT_TAB(I))), 'nls_sort=binary');\r\n<\/pre>\n
9045a9046,9063\r\n> \r\n> \r\n> FUNCTION KRBI_CREATE_XML RETURN VARCHAR2;\r\n> PRAGMA INTERFACE (C, KRBI_CREATE_XML);\r\n> \r\n> FUNCTION CREATETEMPXMLFILE RETURN VARCHAR2 IS \r\n> FNAME VARCHAR2(1024);\r\n> BEGIN\r\n> ICDSTART(214);\r\n> FNAME := KRBI_CREATE_XML;\r\n> ICDFINISH;\r\n> RETURN FNAME;\r\n> EXCEPTION\r\n> WHEN OTHERS THEN\r\n> ICDFINISH;\r\n> RAISE;\r\n> END;\r\n> \r\n<\/pre>\n
1714c1714,1725\r\n< TMP_STR := NLS_UPPER(LTRIM(RTRIM(SORT_TAB(I))));\r\n---\r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> TMP_STR := NLS_UPPER(LTRIM(RTRIM(SORT_TAB(I))), 'nls_sort=binary');\r\n<\/pre>\n
1706c1706,1717\r\n< TMP_STR := NLS_UPPER(LTRIM(RTRIM(SORT_TAB(I))));\r\n---\r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> TMP_STR := NLS_UPPER(LTRIM(RTRIM(SORT_TAB(I))), 'nls_sort=binary');\r\n<\/pre>\n
23754a23755\r\n> END IF;\r\n23756,23779c23757,23777\r\n< \r\n< \r\n< \r\n< \r\n< \r\n< \r\n< \r\n< IF (AVAILABLE_FROMSCN_ACT IS NULL OR\r\n< (USABLE_INCR.DFNUMBER_OBJ = LOCAL.DFNUMBER_OBJ AND\r\n< USABLE_INCR.DFCREATIONSCN_OBJ = LOCAL.DFCREATIONSCN_OBJ AND\r\n< LOCAL.TOSCN_ACT < AVAILABLE_FROMSCN_ACT)) THEN\r\n< IF (AVAILABLE_FROMSCN_ACT IS NULL) THEN\r\n< DEB(DEB_PRINT, 'available_fromSCN_act set to ' ||\r\n< AVAILABLE_FROMSCN_ACT || ' for file# ' ||\r\n< LOCAL.DFNUMBER_OBJ || ', creation_scn '||\r\n< LOCAL.DFCREATIONSCN_OBJ);\r\n< ELSE\r\n< DEB(DEB_PRINT, 'broken chain, available_fromSCN_act set to ' ||\r\n< AVAILABLE_FROMSCN_ACT || ' for file ' ||\r\n< LOCAL.DFNUMBER_OBJ || ', creation_scn '||\r\n< LOCAL.DFCREATIONSCN_OBJ);\r\n< END IF;\r\n< USABLE_INCR := LOCAL;\r\n< AVAILABLE_FROMSCN_ACT := LOCAL.FROMSCN_ACT;\r\n---\r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> IF (AVAILABLE_FROMSCN_ACT IS NULL OR\r\n> (USABLE_INCR.DFNUMBER_OBJ = LOCAL.DFNUMBER_OBJ AND\r\n> USABLE_INCR.DFCREATIONSCN_OBJ = LOCAL.DFCREATIONSCN_OBJ AND\r\n> LOCAL.TOSCN_ACT < AVAILABLE_FROMSCN_ACT)) THEN\r\n> IF (AVAILABLE_FROMSCN_ACT IS NULL) THEN\r\n> DEB(DEB_PRINT, 'available_fromSCN_act set to ' ||\r\n> AVAILABLE_FROMSCN_ACT || ' for file# ' ||\r\n> LOCAL.DFNUMBER_OBJ || ', creation_scn '||\r\n> LOCAL.DFCREATIONSCN_OBJ);\r\n> ELSE\r\n> DEB(DEB_PRINT, 'broken chain, available_fromSCN_act set to ' ||\r\n> AVAILABLE_FROMSCN_ACT || ' for file ' ||\r\n> LOCAL.DFNUMBER_OBJ || ', creation_scn '||\r\n> LOCAL.DFCREATIONSCN_OBJ);\r\n23780a23779,23780\r\n> USABLE_INCR := LOCAL;\r\n> AVAILABLE_FROMSCN_ACT := LOCAL.FROMSCN_ACT;\r\n<\/pre>\n
23947a23948\r\n> END IF;\r\n23949,23972c23950,23970\r\n< \r\n< \r\n< \r\n< \r\n< \r\n< \r\n< \r\n< IF (AVAILABLE_FROMSCN_ACT IS NULL OR\r\n< (USABLE_INCR.DFNUMBER_OBJ = LOCAL.DFNUMBER_OBJ AND\r\n< USABLE_INCR.DFCREATIONSCN_OBJ = LOCAL.DFCREATIONSCN_OBJ AND\r\n< LOCAL.TOSCN_ACT < AVAILABLE_FROMSCN_ACT)) THEN\r\n< IF (AVAILABLE_FROMSCN_ACT IS NULL) THEN\r\n< DEB(DEB_PRINT, 'available_fromSCN_act set to ' ||\r\n< AVAILABLE_FROMSCN_ACT || ' for file# ' ||\r\n< LOCAL.DFNUMBER_OBJ || ', creation_scn '||\r\n< LOCAL.DFCREATIONSCN_OBJ);\r\n< ELSE\r\n< DEB(DEB_PRINT, 'broken chain, available_fromSCN_act set to ' ||\r\n< AVAILABLE_FROMSCN_ACT || ' for file ' ||\r\n< LOCAL.DFNUMBER_OBJ || ', creation_scn '||\r\n< LOCAL.DFCREATIONSCN_OBJ);\r\n< END IF;\r\n< USABLE_INCR := LOCAL;\r\n< AVAILABLE_FROMSCN_ACT := LOCAL.FROMSCN_ACT;\r\n---\r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> IF (AVAILABLE_FROMSCN_ACT IS NULL OR\r\n> (USABLE_INCR.DFNUMBER_OBJ = LOCAL.DFNUMBER_OBJ AND\r\n> USABLE_INCR.DFCREATIONSCN_OBJ = LOCAL.DFCREATIONSCN_OBJ AND\r\n> LOCAL.TOSCN_ACT < AVAILABLE_FROMSCN_ACT)) THEN\r\n> IF (AVAILABLE_FROMSCN_ACT IS NULL) THEN\r\n> DEB(DEB_PRINT, 'available_fromSCN_act set to ' ||\r\n> AVAILABLE_FROMSCN_ACT || ' for file# ' ||\r\n> LOCAL.DFNUMBER_OBJ || ', creation_scn '||\r\n> LOCAL.DFCREATIONSCN_OBJ);\r\n> ELSE\r\n> DEB(DEB_PRINT, 'broken chain, available_fromSCN_act set to ' ||\r\n> AVAILABLE_FROMSCN_ACT || ' for file ' ||\r\n> LOCAL.DFNUMBER_OBJ || ', creation_scn '||\r\n> LOCAL.DFCREATIONSCN_OBJ);\r\n23973a23972,23973\r\n> USABLE_INCR := LOCAL;\r\n> AVAILABLE_FROMSCN_ACT := LOCAL.FROMSCN_ACT;\r\n<\/pre>\n
1203c1203,1204\r\n< TYPE VARCHARTAB IS TABLE OF VARCHAR2(4000) INDEX BY VARCHAR2(64);\r\n---\r\n> \r\n> TYPE VARCHARTAB IS TABLE OF VARCHAR2(32767) INDEX BY VARCHAR2(64);\r\n<\/pre>\n
5749,5754c5749,5757\r\n< \r\n< UNSUPPORTEDCOLS_LOCAL NUMBER := NULL;\r\n< UNSUPPORTEDCOLS_LOCAL2 NUMBER := NULL;\r\n< COMPLEXTYPECOLS_LOCAL NUMBER := NULL;\r\n< TLOFLAGS_LOCAL NUMBER := NULL;\r\n< LOGMNRMCV_LOCAL VARCHAR2(32) := NULL;\r\n---\r\n> UNSUPPORTEDCOLS_LOCAL NUMBER := 0;\r\n> UNSUPPORTEDCOLS_LOCAL2 NUMBER := 0;\r\n> COMPLEXTYPECOLS_LOCAL NUMBER := 0;\r\n> TLOFLAGS_LOCAL NUMBER := 0;\r\n> LOGMNRMCV_LOCAL VARCHAR2(32) := NULL;\r\n> OWNERNAME VARCHAR2(390);\r\n> OBJNAME VARCHAR2(390);\r\n> LONG_IDEN NUMBER := 0;\r\n> IS_APPLICATION_CON NUMBER := 0;\r\n<\/pre>\n
141c141\r\n< and (c2.type# in (114, 122) or \/* BFILE\/Nested Table *\/\r\n---\r\n> and (c2.type# in (114, 122, 111) or \/* BFILE\/Nested Table\/REF *\/\r\n<\/pre>\n
153c153\r\n< and (c2.type# in (114, 122) or \/* BFILE\/Nested Table *\/\r\n---\r\n> and (c2.type# in (114, 122, 111) or \/* BFILE\/Nested Table\/REF *\/\r\n<\/pre>\n
143c143\r\n< and (c2.type# in (114, 122) or \/* BFILE\/Nested Table *\/\r\n---\r\n> and (c2.type# in (114, 122, 111) or \/* BFILE\/Nested Table\/REF *\/\r\n<\/pre>\n
32c32\r\n< DECODE(BITAND(LOGMNRTLOFLAGS, 14), 0, 'NO', 'YES')\r\n---\r\n> DECODE(BITAND(NVL(LOGMNRTLOFLAGS,0), 14), 0, 'NO', 'YES')\r\n44,45c44,48\r\n< LOGMNR_SPARE9, UNSUPPORTEDCOLS, COMPLEXTYPECOLS, NTPARENTOBJNUM, \r\n< NTPARENTOBJVERSION, NTPARENTINTCOLNUM, LOGMNRTLOFLAGS, \r\n---\r\n> LOGMNR_SPARE9, UNSUPPORTEDCOLS, \r\n> NVL(COMPLEXTYPECOLS,0) COMPLEXTYPECOLS,\r\n> NTPARENTOBJNUM, \r\n> NTPARENTOBJVERSION, NTPARENTINTCOLNUM, \r\n> NVL(LOGMNRTLOFLAGS,0) LOGMNRTLOFLAGS, \r\n<\/pre>\n
12.2.0.1<\/strong><\/h3>\n
2c2\r\n< type \"SYS_YOID0000072649$\" as object( \"SYS_NC00001$\" RAW(16))\r\n---\r\n> type \"SYS_YOID0000072649$\" as object( \"SYS_NC00001$\" VARCHAR2(128 BYTE), \"SYS_NC00002$\" VARCHAR2(128 BYTE), \"SYS_NC00003$\" VARCHAR2(128 BYTE))\r\n<\/pre>\n
2c2\r\n< type \"SYS_YOID0000072661$\" as object( \"SYS_NC00001$\" RAW(16))\r\n---\r\n> type \"SYS_YOID0000072661$\" as object( \"SYS_NC00001$\" VARCHAR2(128 BYTE), \"SYS_NC00002$\" VARCHAR2(128 BYTE))\r\n<\/pre>\n
2c2\r\n< type \"SYS_YOID0000072667$\" as object( \"SYS_NC00001$\" RAW(16))\r\n---\r\n> type \"SYS_YOID0000072667$\" as object( \"SYS_NC00001$\" VARCHAR2(128 BYTE), \"SYS_NC00002$\" VARCHAR2(100 BYTE), \"SYS_NC00003$\" VARCHAR2(128 BYTE), \"SYS_NC00004$\" VARCHAR2(128 BYTE), \"SYS_NC00005$\" VARCHAR2(128 BYTE), \"SYS_NC00006$\" VARCHAR2(128 BYTE), \"SYS_NC00007$\" NUMBER)\r\n<\/pre>\n
2c2\r\n< type \"SYS_YOID0000072694$\" as object( \"SYS_NC00001$\" RAW(16))\r\n---\r\n> type \"SYS_YOID0000072694$\" as object( \"SYS_NC00001$\" VARCHAR2(128 BYTE), \"SYS_NC00002$\" VARCHAR2(128 BYTE), \"SYS_NC00003$\" VARCHAR2(128 BYTE), \"SYS_NC00004$\" VARCHAR2(128 BYTE))\r\n<\/pre>\n
2c2\r\n< type \"SYS_YOID0000072697$\" as object( \"SYS_NC00001$\" RAW(16))\r\n---\r\n> type \"SYS_YOID0000072697$\" as object( \"SYS_NC00001$\" VARCHAR2(128 BYTE), \"SYS_NC00002$\" VARCHAR2(128 BYTE), \"SYS_NC00003$\" VARCHAR2(100 BYTE), \"SYS_NC00004$\" VARCHAR2(128 BYTE), \"SYS_NC00005$\" VARCHAR2(128 BYTE), \"SYS_NC00006$\" VARCHAR2(128 BYTE), \"SYS_NC00007$\" VARCHAR2(128 BYTE))\r\n<\/pre>\n
554c554,555\r\n< stamp number\r\n---\r\n> stamp number,\r\n> order_hint number\r\n699a701\r\n> rl_snapstandby VARCHAR2(3),\r\n3278c3280\r\n< ,nblocks OUT binary_integer -- number of blocks of datafilecopy\r\n---\r\n> ,nblocks OUT number -- number of blocks of datafilecopy\r\n<\/pre>\n
23a24,28\r\n> V_CODE NUMBER;\r\n> V_ERRM VARCHAR2(128);\r\n> \r\n> \r\n> \r\n78c83\r\n< RETURN '$Header: rdbms\/src\/client\/tools\/qpinv\/prvtqopi.sql \/st_rdbms_12.2.0.1.0dbbp\/3 2018\/05\/02 15:37:07 surman Exp $';\r\n---\r\n> RETURN '$Header: rdbms\/src\/client\/tools\/qpinv\/prvtqopi.sql \/st_rdbms_12.2.0.1.0dbbp\/6 2018\/08\/10 12:48:23 aime Exp $';\r\n127a133,149\r\n> --+\r\n> PROCEDURE LOG_STATUS(MSG VARCHAR2) IS\r\n> BEGIN\r\n> IF DO_DEBUG THEN\r\n> DBMS_OUTPUT.PUT_LINE(MSG);\r\n> END IF;\r\n> DBMS_SYSTEM.KSDWRT(1,MSG);\r\n> \r\n> END;\r\n> \r\n> --+\r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n143a166,171\r\n> T_OP_INST_PATH VARCHAR2(1024) := '';\r\n> T_OP_SCPT_PATH VARCHAR2(1024) := '';\r\n> T_OP_LOG_PATH VARCHAR2(1024) := '';\r\n> T_ROOT VARCHAR2(1024) := '';\r\n> T_ORABASE VARCHAR2(1024) := '';\r\n> OPATCHFILE VARCHAR2(128) := 'opatch';\r\n168,172c196,198\r\n< DBMS_SYSTEM.KSDWRT(1,'QPI: Event 22171584 set. Skipping sanity check');\r\n< DBMS_SYSTEM.KSDWRT(1,'QPI: Please disable the event in case of any errors and try again');\r\n< IF DO_DEBUG THEN\r\n< DBMS_OUTPUT.PUT_LINE('Event 22171584 set. Skipping sanity check');\r\n< END IF;\r\n---\r\n> DBMS_SYSTEM.KSDWRT(3,'QPI: Event 22171584 set. Skipping sanity check');\r\n> DBMS_SYSTEM.KSDWRT(3,'QPI: Please disable the event in case of any errors and try again');\r\n> LOG_STATUS('Event 22171584 set. Skipping sanity check');\r\n195a222,229\r\n> SELECT PLATFORM_ID INTO PFID FROM V$DATABASE;\r\n> NOT_WIN := IS_NON_WINDOWS (PFID);\r\n> \r\n> \r\n> IF NOT NOT_WIN THEN\r\n> OPATCHFILE := 'opatch.bat';\r\n> END IF;\r\n> \r\n208a243,309\r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> T_ROOT := ROOT;\r\n> T_ORABASE := ORABASE;\r\n> T_OP_INST_PATH := OP_INST_PATH;\r\n> T_OP_SCPT_PATH := OP_SCPT_PATH;\r\n> T_OP_LOG_PATH := OP_LOG_PATH;\r\n> \r\n> IF NOT_WIN THEN\r\n> IF SUBSTR( ROOT,-1,1 ) <> '\/' THEN\r\n> T_ROOT := ROOT || '\/';\r\n> LOG_STATUS('QPI: t_root is ' || T_ROOT);\r\n> END IF;\r\n> \r\n> IF SUBSTR( ORABASE,-1,1 ) <> '\/' THEN\r\n> T_ORABASE := ORABASE || '\/';\r\n> LOG_STATUS('QPI: t_orabase is ' || T_ORABASE);\r\n> END IF;\r\n> \r\n> IF SUBSTR( OP_INST_PATH,-1,1 ) <> '\/' THEN\r\n> T_OP_INST_PATH := OP_INST_PATH || '\/';\r\n> LOG_STATUS('QPI: t_op_inst_path is ' || T_OP_INST_PATH);\r\n> END IF;\r\n> \r\n> IF SUBSTR( OP_SCPT_PATH,-1,1 ) <> '\/' THEN\r\n> T_OP_SCPT_PATH := OP_SCPT_PATH || '\/';\r\n> LOG_STATUS('QPI: t_op_scpt_path is ' || T_OP_SCPT_PATH);\r\n> END IF;\r\n> \r\n> IF SUBSTR( OP_LOG_PATH,-1,1 ) <> '\/' THEN\r\n> T_OP_LOG_PATH := OP_LOG_PATH || '\/';\r\n> LOG_STATUS('QPI: t_op_log_path is ' || T_OP_LOG_PATH);\r\n> END IF;\r\n> ELSE\r\n> IF SUBSTR( ROOT,-1,1 ) <> '\\' THEN\r\n> T_ROOT := ROOT || '\\';\r\n> LOG_STATUS('QPI: t_root is ' || T_ROOT);\r\n> END IF;\r\n> \r\n> IF SUBSTR( ORABASE,-1,1 ) <> '\\' THEN\r\n> T_ORABASE := ORABASE || '\\';\r\n> LOG_STATUS('QPI: t_orabase is ' || T_ORABASE);\r\n> END IF;\r\n> \r\n> IF SUBSTR( OP_INST_PATH,-1,1 ) <> '\\' THEN\r\n> T_OP_INST_PATH := OP_INST_PATH || '\\';\r\n> LOG_STATUS('QPI: t_op_inst_path is ' || T_OP_INST_PATH);\r\n> END IF;\r\n> \r\n> IF SUBSTR( OP_SCPT_PATH,-1,1 ) <> '\\' THEN\r\n> T_OP_SCPT_PATH := OP_SCPT_PATH || '\\';\r\n> LOG_STATUS('QPI: t_op_scpt_path is ' || T_OP_SCPT_PATH);\r\n> END IF;\r\n> \r\n> IF SUBSTR( OP_LOG_PATH,-1,1 ) <> '\\' THEN\r\n> T_OP_LOG_PATH := OP_LOG_PATH || '\\';\r\n> LOG_STATUS('QPI: t_op_log_path is ' || T_OP_LOG_PATH);\r\n> END IF;\r\n> \r\n> END IF;\r\n> \r\n230d330\r\n< SELECT PLATFORM_ID INTO PFID FROM V$DATABASE;\r\n245d344\r\n< NOT_WIN := IS_NON_WINDOWS (PFID);\r\n292c391\r\n< UTL_FILE.FGETATTR('OPATCH_INST_DIR', 'opatch', FEXISTS, FILE_LENGTH, BLOCK_SIZE);\r\n---\r\n> UTL_FILE.FGETATTR('OPATCH_INST_DIR', OPATCHFILE, FEXISTS, FILE_LENGTH, BLOCK_SIZE);\r\n294c393\r\n< DBMS_SYSTEM.KSDWRT(1,'QPI: opatch file present');\r\n---\r\n> DBMS_SYSTEM.KSDWRT(3,'QPI: opatch file present, ' || OPATCHFILE);\r\n296a396\r\n> DBMS_SYSTEM.KSDWRT(3,'QPI: opatch executable does not exist, ' || OPATCHFILE);\r\n306c406\r\n< DBMS_SYSTEM.KSDWRT(1,'QPI: qopiprep.bat file present');\r\n---\r\n> DBMS_SYSTEM.KSDWRT(3,'QPI: qopiprep.bat file present');\r\n361,363d460\r\n< IF DO_DEBUG THEN\r\n< DBMS_OUTPUT.PUT_LINE ('QPI: GOT lock at :' || SYSTIMESTAMP);\r\n< END IF;\r\n366a464\r\n> LOG_STATUS('QPI: Obtaining lock FAILED, qp_result=' || QP_RESULT || ' at : ' || SYSTIMESTAMP);\r\n367a466,467\r\n> ELSIF QP_RESULT = 0 OR QP_RESULT = 4 THEN\r\n> LOG_STATUS('QPI: Obtaining lock SUCCESSFUL, qp_result=' || QP_RESULT || ' at : ' || SYSTIMESTAMP);\r\n390,391c490,493\r\n< IF DO_DEBUG THEN\r\n< DBMS_OUTPUT.PUT_LINE ('QPI: Releasing the lock at :' || SYSTIMESTAMP);\r\n---\r\n> IF QP_RESULT = 0 THEN\r\n> LOG_STATUS('QPI: Releasing lock SUCCESSFUL, qp_result=' || QP_RESULT || ' at : ' || SYSTIMESTAMP);\r\n> ELSE\r\n> LOG_STATUS('QPI: Releasing lock FAILED, qp_result=' || QP_RESULT || ' at : ' || SYSTIMESTAMP);\r\n417,418d518\r\n< V_CODE NUMBER;\r\n< V_ERRM VARCHAR2(128);\r\n488,489c588,589\r\n< V_ERRM := SUBSTR(SQLERRM, 1, 64);\r\n< DBMS_OUTPUT.PUT_LINE('Error code ' || V_CODE || ': ' || V_ERRM);\r\n---\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in config_oinv_jobs, Error code ' || V_CODE || ': ' || V_ERRM);\r\n507a608\r\n> PROCEDURE CLEAN_METADATA_PRI;\r\n821,824c922,923\r\n< IF DO_DEBUG THEN\r\n< DBMS_OUTPUT.PUT_LINE('QPI: Cleaning and refreshing metadata..');\r\n< END IF;\r\n< DBMS_SYSTEM.KSDWRT(1,'QPI: Cleaning and refreshing metadata..');\r\n---\r\n> LOG_STATUS('QPI: Cleaning and refreshing metadata..');\r\n> DBMS_SYSTEM.KSDWRT(3,'QPI: Cleaning and refreshing metadata..');\r\n866a966,969\r\n> LOG_STATUS('QPI: Caught error while querying opatch_xml_inv');\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in REFRESH_OPATCH_DATA, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n927a1031,1037\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in get_opatch_install_info, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n976a1087,1093\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in get_opatch_list, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n1033a1151,1157\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in IS_PATCH_INSTALLED, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n1092a1217,1223\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in GET_OPATCH_DATA, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n1158a1290,1296\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in GET_OPATCH_BUGS, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n1182a1321,1324\r\n> QP_RESULT := GET_QOPATCH_LOCK();\r\n> \r\n> LOG_STATUS('QPI: Got lock get_opatch_files');\r\n> \r\n1194a1337,1340\r\n> \r\n> LOG_STATUS('QPI: Release lock get_opatch_files');\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> \r\n1195a1342,1354\r\n> \r\n> EXCEPTION \r\n> WHEN UNABLE_TO_LOCK THEN\r\n> RAISE_APPLICATION_ERROR(-20016, \r\n> 'Unable to get the lock : get_opatch_files : ' || QP_RESULT);\r\n> \r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in GET_OPATCH_FILES, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n1245a1405,1411\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in GET_OPATCH_COUNT, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n1298a1465,1471\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in GET_OPATCH_PREQS, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n1347a1521,1532\r\n> EXCEPTION \r\n> WHEN UNABLE_TO_LOCK THEN\r\n> RAISE_APPLICATION_ERROR(-20016, \r\n> 'Unable to get the lock : get_opatch_install_info : ' || QP_RESULT);\r\n> \r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in GET_OPATCH_OLAYS, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n1402a1588,1594\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in PATCH_CONFLICT_DETECTION, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n1454c1646\r\n< OPATCHFILE CONSTANT VARCHAR2(128) := 'opatch';\r\n---\r\n> OPATCHFILE VARCHAR2(128) := 'opatch';\r\n1491a1684\r\n> OPATCHFILE := 'opatch.bat';\r\n1544a1738\r\n> LOG_STATUS('QPI: opatch executable exists and is readable, ' || OPATCHFILE);\r\n1546a1741\r\n> LOG_STATUS('QPI: opatch executable does not exist or is not redable, ' || OPATCHFILE);\r\n1607,1608d1801\r\n< V_CODE NUMBER;\r\n< V_ERRM VARCHAR2(128);\r\n1689,1690c1882,1883\r\n< V_ERRM := SUBSTR(SQLERRM, 1, 64);\r\n< DBMS_OUTPUT.PUT_LINE('Error code ' || V_CODE || ': ' || V_ERRM);\r\n---\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in add_oinv_job, Error code ' || V_CODE || ': ' || V_ERRM);\r\n1713c1906\r\n< DBMS_SYSTEM.KSDWRT(1,'Node name: ' || PVAL.NODE_NAME || ' Inst:' || PVAL.INST_NAME|| ' Job:' || PVAL.INST_JOB);\r\n---\r\n> DBMS_SYSTEM.KSDWRT(3,'Node name: ' || PVAL.NODE_NAME || ' Inst:' || PVAL.INST_NAME|| ' Job:' || PVAL.INST_JOB);\r\n1720c1913\r\n< DBMS_SYSTEM.KSDWRT(1,'Job: ' || PVAR.JOB_NAME || ' State: ' || PVAR.STATE);\r\n---\r\n> DBMS_SYSTEM.KSDWRT(3,'Job: ' || PVAR.JOB_NAME || ' State: ' || PVAR.STATE);\r\n1781c1974\r\n< CLEAN_METADATA();\r\n---\r\n> CLEAN_METADATA_PRI();\r\n1827a2021\r\n> \r\n2021a2216,2219\r\n> WHEN UNABLE_TO_LOCK THEN\r\n> RAISE_APPLICATION_ERROR(-20016, \r\n> 'Unable to get the lock : get_pending_activity : ' || QP_RESULT);\r\n> \r\n2027a2226,2228\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in get_pending_activity, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n2265a2467,2473\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in get_opatch_lsinventory, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n2647a2856,2862\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in opatch_compare, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n2714a2930,2936\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in get_patch_details, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n2761a2984,2990\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in check_patch_installed, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n2835c3064,3067\r\n< \r\n---\r\n> \r\n> LOG_STATUS('QPI: Release lock opatch_compare_nodes');\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> \r\n2855a3088,3091\r\n> \r\n> LOG_STATUS('QPI: Release lock opatch_compare_nodes');\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> \r\n2862,2866d3097\r\n< IF DO_DEBUG THEN\r\n< DBMS_OUTPUT.PUT_LINE('QPI: Release lock opatch_compare_nodes');\r\n< END IF;\r\n< QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n< \r\n2871a3103,3109\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in OPATCH_COMPARE_NODES, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n2886,2888d3123\r\n< \r\n< \r\n< \r\n2890c3125\r\n< PROCEDURE CLEAN_METADATA IS\r\n---\r\n> PROCEDURE CLEAN_METADATA_PRI IS\r\n2902c3137\r\n< DBMS_OUTPUT.PUT_LINE('QPI: In clean_metadata');\r\n---\r\n> DBMS_OUTPUT.PUT_LINE('QPI: In clean_metadata_pri');\r\n2905,2910d3139\r\n< QP_RESULT := GET_QOPATCH_LOCK();\r\n< \r\n< IF DO_DEBUG THEN\r\n< DBMS_OUTPUT.PUT_LINE('QPI: Got lock clean_metadata');\r\n< END IF;\r\n< \r\n2919c3148\r\n< DBMS_OUTPUT.PUT_LINE('QPI: clean_metadata opatch_inst_job :' || NODECNT );\r\n---\r\n> DBMS_OUTPUT.PUT_LINE('QPI: clean_metadata_pri opatch_inst_job :' || NODECNT );\r\n2951,2955d3179\r\n< IF DO_DEBUG THEN\r\n< DBMS_OUTPUT.PUT_LINE('QPI: Release lock clean_metadata');\r\n< END IF;\r\n< \r\n< QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n2959a3184,3223\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in CLEAN_METADATA_PRI, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> RAISE;\r\n> \r\n> END;\r\n> \r\n> --+\r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> --+\r\n> \r\n> PROCEDURE CLEAN_METADATA IS\r\n> BEGIN\r\n> \r\n> LOG_STATUS('QPI: In clean_metadata');\r\n> \r\n> QP_RESULT := GET_QOPATCH_LOCK();\r\n> \r\n> LOG_STATUS('QPI: Got lock clean_metadata');\r\n> \r\n> CLEAN_METADATA_PRI();\r\n> \r\n> LOG_STATUS('QPI: Release lock clean_metadata');\r\n> \r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> \r\n> EXCEPTION\r\n2961c3225\r\n< RAISE_APPLICATION_ERROR(-20016, \r\n---\r\n> RAISE_APPLICATION_ERROR(-20016,\r\n2963,2964c3227,3234\r\n< WHEN OTHERS THEN\r\n< RAISE;\r\n---\r\n> \r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in CLEAN_METADATA, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n2966a3237\r\n> \r\n<\/pre>\n26424c26424,26425\r\n< ELSIF (LISTBACKUPINMKS(LBSTATE.LBDFRECTABUS, LBREC,\r\n---\r\n> ELSIF (LBREC.FILE_TYPE <> SPFILE_TXT AND\r\n> LISTBACKUPINMKS(LBSTATE.LBDFRECTABUS, LBREC,\r\n<\/pre>\n
545a546\r\n> NULL RL_SNAPSTANDBY,\r\n614a616\r\n> NULL RL_SNAPSTANDBY,\r\n691a694\r\n> NULL RL_SNAPSTANDBY,\r\n756a760\r\n> 'NO' RL_SNAPSTANDBY,\r\n820a825\r\n> NULL RL_SNAPSTANDBY,\r\n892a898\r\n> NULL RL_SNAPSTANDBY,\r\n901,902c907,910\r\n< AL.STAMP LIST_ORDER1,\r\n< -1 LIST_ORDER2,\r\n---\r\n> DECODE(DBINC.SNAPSTANDBY, 1, 0, AL.STAMP)\r\n> LIST_ORDER1,\r\n> DECODE(DBINC.SNAPSTANDBY, 1, AL.STAMP, -1)\r\n> LIST_ORDER2,\r\n963a972,973\r\n> DECODE(DBINC.SNAPSTANDBY, 1, 'YES', 'NO')\r\n> RL_SNAPSTANDBY,\r\n983a994,1007\r\n> LEFT OUTER JOIN\r\n> (SELECT CASE WHEN\r\n> (THIS_DBROLE = 'SNAPSHOT STANDBY' AND\r\n> DBINC.STATUS IN ('CURRENT', 'PARENT') AND\r\n> DBINC.INCARNATION# > DI2.DI2SSBY_PIC)\r\n> THEN 1 ELSE NULL END SNAPSTANDBY,\r\n> DBINC.RESETLOGS_CHANGE#,\r\n> DBINC.RESETLOGS_TIME,\r\n> DBINC.STATUS\r\n> FROM V$DATABASE_INCARNATION DBINC, \r\n> X$KCCDI2 DI2\r\n> ) DBINC\r\n> ON AL.RESETLOGS_CHANGE# = DBINC.RESETLOGS_CHANGE#\r\n> AND AL.RESETLOGS_TIME = DBINC.RESETLOGS_TIME\r\n1054a1079\r\n> NULL RL_SNAPSTANDBY,\r\n1124a1150\r\n> 'NO' RL_SNAPSTANDBY,\r\n8264c8290,8291\r\n< DC.STAMP STAMP\r\n---\r\n> DC.STAMP STAMP,\r\n> 0 ORDER_HINT\r\n8274c8301,8302\r\n< AL.STAMP STAMP\r\n---\r\n> AL.STAMP STAMP,\r\n> 0 ORDER_HINT\r\n8286c8314,8315\r\n< RL.STAMP STAMP\r\n---\r\n> RL.STAMP STAMP,\r\n> 0 ORDER_HINT\r\n8297c8326,8327\r\n< BP.STAMP STAMP\r\n---\r\n> BP.STAMP STAMP,\r\n> 0 ORDER_HINT\r\n8312c8342,8343\r\n< DC.STAMP STAMP\r\n---\r\n> DC.STAMP STAMP,\r\n> 0 ORDER_HINT\r\n8347c8378,8379\r\n< DC.STAMP STAMP\r\n---\r\n> DC.STAMP STAMP,\r\n> 0 ORDER_HINT\r\n8371c8403,8404\r\n< DC.STAMP STAMP\r\n---\r\n> DC.STAMP STAMP,\r\n> 0 ORDER_HINT\r\n8403c8436,8437\r\n< AL.STAMP STAMP\r\n---\r\n> AL.STAMP STAMP,\r\n> 0 ORDER_HINT\r\n8439c8473,8474\r\n< AL.STAMP STAMP\r\n---\r\n> AL.STAMP STAMP,\r\n> 0 ORDER_HINT\r\n8465c8500,8501\r\n< AL.STAMP STAMP\r\n---\r\n> AL.STAMP STAMP,\r\n> 0 ORDER_HINT\r\n8485c8521,8522\r\n< AL.STAMP STAMP\r\n---\r\n> AL.STAMP STAMP,\r\n> 0 ORDER_HINT\r\n8605c8642,8643\r\n< BP.STAMP STAMP\r\n---\r\n> BP.STAMP STAMP,\r\n> 0 ORDER_HINT\r\n8660c8698,8699\r\n< AL.STAMP STAMP\r\n---\r\n> AL.STAMP STAMP,\r\n> DBINC.SNAPSTANDBY ORDER_HINT\r\n8680c8719,8729\r\n< V$DATABASE_INCARNATION DBINC\r\n---\r\n> (SELECT CASE WHEN\r\n> (THIS_DBROLE = 'SNAPSHOT STANDBY' AND\r\n> DBINC.STATUS IN ('CURRENT', 'PARENT') AND\r\n> DBINC.INCARNATION# > DI2.DI2SSBY_PIC)\r\n> THEN 1 ELSE NULL END SNAPSTANDBY,\r\n> DBINC.RESETLOGS_CHANGE#,\r\n> DBINC.RESETLOGS_TIME,\r\n> DBINC.STATUS\r\n> FROM V$DATABASE_INCARNATION DBINC,\r\n> X$KCCDI2 DI2\r\n> ) DBINC\r\n8690a8740\r\n> DBINC.SNAPSTANDBY = 1 OR\r\n8694c8744\r\n< ORDER BY AL.STAMP; \r\n---\r\n> ORDER BY ORDER_HINT, AL.STAMP; \r\n15122c15172,15174\r\n< IF (THIS_CFTYPE = 'STANDBY' OR THIS_CFTYPE = 'FARSYNC') THEN\r\n---\r\n> IF (THIS_CFTYPE = 'STANDBY' OR\r\n> THIS_DBROLE = 'SNAPSHOT STANDBY' OR\r\n> THIS_CFTYPE = 'FARSYNC') THEN\r\n15179a15232\r\n> SETTHIS_DBROLE;\r\n15188a15242\r\n> THIS_DBROLE <> 'SNAPSHOT STANDBY' AND\r\n15807a15862,15865\r\n> THIS_CFTYPE := NULL;\r\n> SETTHIS_CFTYPE;\r\n> THIS_DBROLE := NULL;\r\n> SETTHIS_DBROLE;\r\n17002a17061\r\n> SETTHIS_DBROLE;\r\n17390a17450\r\n> \r\n17710a17771\r\n> NULL RL_SNAPSTANDBY,\r\n17779a17841\r\n> NULL RL_SNAPSTANDBY,\r\n17856a17919\r\n> NULL RL_SNAPSTANDBY,\r\n17921a17985\r\n> 'NO' RL_SNAPSTANDBY,\r\n17985a18050\r\n> NULL RL_SNAPSTANDBY,\r\n18057a18123\r\n> NULL RL_SNAPSTANDBY,\r\n18128a18195\r\n> 'NO' RL_SNAPSTANDBY,\r\n18220a18288\r\n> NULL RL_SNAPSTANDBY,\r\n18290a18359\r\n> 'NO' RL_SNAPSTANDBY,\r\n24509a24579\r\n> END IF;\r\n24511,24534c24581,24601\r\n< \r\n< \r\n< \r\n< \r\n< \r\n< \r\n< \r\n< IF (AVAILABLE_FROMSCN_ACT IS NULL OR\r\n< (USABLE_INCR.DFNUMBER_OBJ = LOCAL.DFNUMBER_OBJ AND\r\n< USABLE_INCR.DFCREATIONSCN_OBJ = LOCAL.DFCREATIONSCN_OBJ AND\r\n< LOCAL.TOSCN_ACT < AVAILABLE_FROMSCN_ACT)) THEN\r\n< IF (AVAILABLE_FROMSCN_ACT IS NULL) THEN\r\n< DEB(DEB_PRINT, 'available_fromSCN_act set to ' ||\r\n< AVAILABLE_FROMSCN_ACT || ' for file# ' ||\r\n< LOCAL.DFNUMBER_OBJ || ', creation_scn '||\r\n< LOCAL.DFCREATIONSCN_OBJ);\r\n< ELSE\r\n< DEB(DEB_PRINT, 'broken chain, available_fromSCN_act set to ' ||\r\n< AVAILABLE_FROMSCN_ACT || ' for file ' ||\r\n< LOCAL.DFNUMBER_OBJ || ', creation_scn '||\r\n< LOCAL.DFCREATIONSCN_OBJ);\r\n< END IF;\r\n< USABLE_INCR := LOCAL;\r\n< AVAILABLE_FROMSCN_ACT := LOCAL.FROMSCN_ACT;\r\n---\r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> IF (AVAILABLE_FROMSCN_ACT IS NULL OR\r\n> (USABLE_INCR.DFNUMBER_OBJ = LOCAL.DFNUMBER_OBJ AND\r\n> USABLE_INCR.DFCREATIONSCN_OBJ = LOCAL.DFCREATIONSCN_OBJ AND\r\n> LOCAL.TOSCN_ACT < AVAILABLE_FROMSCN_ACT)) THEN\r\n> IF (AVAILABLE_FROMSCN_ACT IS NULL) THEN\r\n> DEB(DEB_PRINT, 'available_fromSCN_act set to ' ||\r\n> AVAILABLE_FROMSCN_ACT || ' for file# ' ||\r\n> LOCAL.DFNUMBER_OBJ || ', creation_scn '||\r\n> LOCAL.DFCREATIONSCN_OBJ);\r\n> ELSE\r\n> DEB(DEB_PRINT, 'broken chain, available_fromSCN_act set to ' ||\r\n> AVAILABLE_FROMSCN_ACT || ' for file ' ||\r\n> LOCAL.DFNUMBER_OBJ || ', creation_scn '||\r\n> LOCAL.DFCREATIONSCN_OBJ);\r\n24535a24603,24604\r\n> USABLE_INCR := LOCAL;\r\n> AVAILABLE_FROMSCN_ACT := LOCAL.FROMSCN_ACT;\r\n26424c26493,26494\r\n< ELSIF (LISTBACKUPINMKS(LBSTATE.LBDFRECTABUS, LBREC,\r\n---\r\n> ELSIF (LBREC.FILE_TYPE <> SPFILE_TXT AND\r\n> LISTBACKUPINMKS(LBSTATE.LBDFRECTABUS, LBREC,\r\n26462a26533,26538\r\n> \r\n> \r\n> IF (RECOVERYDESTFILE AND LBREC.RL_SNAPSTANDBY = 'YES') THEN\r\n> IF (DEBUG) THEN \r\n> DEB(DEB_IN, 'snapshot standby archivelog');\r\n> END IF;\r\n26467c26543\r\n< IF ((LBREC.RL_NEXT_CHANGE# >= LBSTATE.LBMINGRSP AND\r\n---\r\n> ELSIF ((LBREC.RL_NEXT_CHANGE# >= LBSTATE.LBMINGRSP AND\r\n28925c29001\r\n< ,NBLOCKS OUT BINARY_INTEGER\r\n---\r\n> ,NBLOCKS OUT NUMBER\r\n<\/pre>\n14406,14409c14406,14411\r\n< TRANSFER_COLUMN_STATS(OWNER, DBMS_STATS_INTERNAL.DQ(TAB_NAME), EXTN_NAME, \r\n< NULL, NULL, NULL,\r\n< NULL, NULL, TRUE, TRUE, NULL, FALSE, FALSE, DSC_NON_FXT, TRUE, \r\n< 'ALL', FALSE, NULL, TRUE);\r\n---\r\n> \r\n> \r\n> TRANSFER_COLUMN_STATS(DBMS_STATS_INTERNAL.DQ(OWNER), \r\n> DBMS_STATS_INTERNAL.DQ(TAB_NAME), DBMS_STATS_INTERNAL.DQ(EXTN_NAME),\r\n> NULL, NULL, NULL, NULL, NULL, TRUE, TRUE, NULL, FALSE, FALSE, \r\n> DSC_NON_FXT, TRUE, 'ALL', FALSE, NULL, TRUE);\r\n<\/pre>\n
445c445\r\n< END IF;\r\n---\r\n> END IF;\r\n496c496\r\n< INCREMENT := INCREMENT + 1; \r\n---\r\n> INCREMENT := INCREMENT + 1;\r\n583c583\r\n< END IF;\r\n---\r\n> END IF;\r\n2727c2727\r\n< \r\n---\r\n> \r\n3310c3310\r\n< HAS_ROLE NUMBER := 0;\r\n---\r\n> HAS_ROLE NUMBER := 0;\r\n3433c3433\r\n< \r\n---\r\n> \r\n3484c3484\r\n< \r\n---\r\n> \r\n<\/pre>\n
687c687\r\n< SCN OCINUMBER, SCN INDICATOR SB2,\r\n---\r\n> SCN OCINUMBER, SCN INDICATOR SB2,\r\n689,690c689,690\r\n< POS OCIRAW, POS INDICATOR SB2,\r\n< POS MAXLEN SB4, POS LENGTH SB4)\r\n---\r\n> POS OCIRAW, POS INDICATOR SB2,\r\n> POS MAXLEN SB4, POS LENGTH SB4)\r\n1526c1526\r\n< DBMS_XSTREAM_ADM_UTL.CONVERT_SCN_TO_POS(PROCESSED_LWM_SCN,\r\n---\r\n> DBMS_XSTREAM_ADM_UTL.CONVERT_SCN_TO_POS(PROCESSED_LWM_SCN, \r\n<\/pre>\n
792c792\r\n< INCREMENT := INCREMENT + 1; \r\n---\r\n> INCREMENT := INCREMENT + 1; \r\n908c908\r\n< END IF; \r\n---\r\n> END IF;\r\n<\/pre>\n
77a78\r\n> PRBA NUMBER := RBA;\r\n87c88\r\n< SEQ# = SEQNO AND RBA = RBA AND INDEX# = INDEX_NUM;\r\n---\r\n> SEQ# = SEQNO AND RBA = PRBA AND INDEX# = INDEX_NUM;\r\n91c92\r\n< SEQ# = SEQNO AND RBA = RBA AND INDEX# = INDEX_NUM;\r\n---\r\n> SEQ# = SEQNO AND RBA = PRBA AND INDEX# = INDEX_NUM;\r\n<\/pre>\n
1438c1438\r\n< ' queue=' || QUEUE_NAME || ' src_db=' || SOURCE_DATABASE || \r\n---\r\n> ' queue=' || QUEUE_NAME || ' src_db=' || SOURCE_DATABASE ||\r\n2908c2908\r\n< END IF;\r\n---\r\n> END IF; \r\n<\/pre>\n
18.0.0.0<\/strong><\/h3>\n
2203a2204,2249\r\n> FUNCTION ENQUOTE_PARTS(P_SPEC IN VARCHAR2, CAPITALIZE IN BOOLEAN := TRUE)\r\n> RETURN VARCHAR2 IS\r\n> L_SPEC DRVUTL.DR_QLID3;\r\n> L_PERIOD1 NUMBER;\r\n> L_PERIOD2 NUMBER;\r\n> BEGIN\r\n> IF INSTR(P_SPEC, '\"') = 1 THEN\r\n> \r\n> L_SPEC := P_SPEC;\r\n> ELSIF INSTR(P_SPEC, '.') = 0 THEN\r\n> \r\n> L_SPEC := DBMS_ASSERT.ENQUOTE_NAME(P_SPEC, CAPITALIZE);\r\n> ELSE\r\n> \r\n> L_PERIOD1 := INSTR(P_SPEC, '.');\r\n> L_PERIOD2 := INSTR(P_SPEC, '.', L_PERIOD1 + 1);\r\n> \r\n> L_SPEC :=\r\n> DBMS_ASSERT.ENQUOTE_NAME(SUBSTR(P_SPEC, 1, L_PERIOD1 - 1), CAPITALIZE) || '.';\r\n> IF L_PERIOD2 = 0 THEN\r\n> L_SPEC := L_SPEC ||\r\n> DBMS_ASSERT.ENQUOTE_NAME(SUBSTR(P_SPEC, L_PERIOD1 + 1), CAPITALIZE);\r\n> ELSE\r\n> L_SPEC := L_SPEC ||\r\n> DBMS_ASSERT.ENQUOTE_NAME(SUBSTR(P_SPEC, L_PERIOD1 + 1,\r\n> (L_PERIOD2 - L_PERIOD1 - 1)), CAPITALIZE) ||\r\n> '.' ||\r\n> DBMS_ASSERT.ENQUOTE_NAME(SUBSTR(P_SPEC, L_PERIOD2 + 1), CAPITALIZE);\r\n> END IF;\r\n> END IF;\r\n> \r\n> RETURN L_SPEC;\r\n> END ENQUOTE_PARTS;\r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n<\/pre>\n
12c12\r\n< bannerVersion CONSTANT VARCHAR2(15) := '18.03.00.00';\r\n---\r\n> bannerVersion CONSTANT VARCHAR2(15) := '18.02.02.00';\r\n24,26c24,26\r\n< fsn CONSTANT NUMBER := instr('18.03.00.00', '.');\r\n< msn CONSTANT NUMBER := instr('18.03.00.00', '.', fsn + 1);\r\n< psn CONSTANT NUMBER := instr('18.03.00.00', '.', msn + 1);\r\n---\r\n> fsn CONSTANT NUMBER := instr('18.02.02.00', '.');\r\n> msn CONSTANT NUMBER := instr('18.02.02.00', '.', fsn + 1);\r\n> psn CONSTANT NUMBER := instr('18.02.02.00', '.', msn + 1);\r\n29c29\r\n< to_number(substr('18.03.00.00', 1, fsn - 1));\r\n---\r\n> to_number(substr('18.02.02.00', 1, fsn - 1));\r\n31c31\r\n< to_number(substr('18.03.00.00', fsn + 1, msn - fsn - 1));\r\n---\r\n> to_number(substr('18.02.02.00', fsn + 1, msn - fsn - 1));\r\n33c33\r\n< to_number(substr('18.03.00.00', msn + 1, psn - msn - 1));\r\n---\r\n> to_number(substr('18.02.02.00', msn + 1, psn - msn - 1));\r\n35c35\r\n< to_number(substr('18.03.00.00', psn + 1));\r\n---\r\n> to_number(substr('18.02.02.00', psn + 1));\r\n<\/pre>\n12c12\r\n< bannerVersion CONSTANT VARCHAR2(15) := '18.03.00.00';\r\n---\r\n> bannerVersion CONSTANT VARCHAR2(15) := '18.04.00.00';\r\n24,26c24,26\r\n< fsn CONSTANT NUMBER := instr('18.03.00.00', '.');\r\n< msn CONSTANT NUMBER := instr('18.03.00.00', '.', fsn + 1);\r\n< psn CONSTANT NUMBER := instr('18.03.00.00', '.', msn + 1);\r\n---\r\n> fsn CONSTANT NUMBER := instr('18.04.00.00', '.');\r\n> msn CONSTANT NUMBER := instr('18.04.00.00', '.', fsn + 1);\r\n> psn CONSTANT NUMBER := instr('18.04.00.00', '.', msn + 1);\r\n29c29\r\n< to_number(substr('18.03.00.00', 1, fsn - 1));\r\n---\r\n> to_number(substr('18.04.00.00', 1, fsn - 1));\r\n31c31\r\n< to_number(substr('18.03.00.00', fsn + 1, msn - fsn - 1));\r\n---\r\n> to_number(substr('18.04.00.00', fsn + 1, msn - fsn - 1));\r\n33c33\r\n< to_number(substr('18.03.00.00', msn + 1, psn - msn - 1));\r\n---\r\n> to_number(substr('18.04.00.00', msn + 1, psn - msn - 1));\r\n35c35\r\n< to_number(substr('18.03.00.00', psn + 1));\r\n---\r\n> to_number(substr('18.04.00.00', psn + 1));\r\n<\/pre>\n12c12\r\n< bannerVersion CONSTANT VARCHAR2(15) := '18.03.00.00';\r\n---\r\n> bannerVersion CONSTANT VARCHAR2(15) := '18.03.01.00';\r\n24,26c24,26\r\n< fsn CONSTANT NUMBER := instr('18.03.00.00', '.');\r\n< msn CONSTANT NUMBER := instr('18.03.00.00', '.', fsn + 1);\r\n< psn CONSTANT NUMBER := instr('18.03.00.00', '.', msn + 1);\r\n---\r\n> fsn CONSTANT NUMBER := instr('18.03.01.00', '.');\r\n> msn CONSTANT NUMBER := instr('18.03.01.00', '.', fsn + 1);\r\n> psn CONSTANT NUMBER := instr('18.03.01.00', '.', msn + 1);\r\n29c29\r\n< to_number(substr('18.03.00.00', 1, fsn - 1));\r\n---\r\n> to_number(substr('18.03.01.00', 1, fsn - 1));\r\n31c31\r\n< to_number(substr('18.03.00.00', fsn + 1, msn - fsn - 1));\r\n---\r\n> to_number(substr('18.03.01.00', fsn + 1, msn - fsn - 1));\r\n33c33\r\n< to_number(substr('18.03.00.00', msn + 1, psn - msn - 1));\r\n---\r\n> to_number(substr('18.03.01.00', msn + 1, psn - msn - 1));\r\n35c35\r\n< to_number(substr('18.03.00.00', psn + 1));\r\n---\r\n> to_number(substr('18.03.01.00', psn + 1));\r\n<\/pre>\n1387c1387,1418\r\n< CUR_SCHEMA IN VARCHAR2);\r\n---\r\n> CUR_SCHEMA IN VARCHAR2,\r\n> LOCK_NAME OUT DBMS_ID,\r\n> LOCK_HANDLE OUT VARCHAR2,\r\n> RECIPIENTS_LIST OUT DBMS_UTILITY.LNAME_ARRAY,\r\n> NEW_RAISE_EVENTS_NUM OUT PLS_INTEGER,\r\n> CANON_JOB_NAME IN OUT DBMS_ID,\r\n> CANON_JOB_SUBNAME IN OUT DBMS_ID,\r\n> CANON_JOB_OWNER IN OUT DBMS_ID,\r\n> CUR_FLAGS OUT NUMBER,\r\n> DOES_SUB_EXIST OUT BOOLEAN,\r\n> DOES_REG_EXIST OUT BOOLEAN,\r\n> REAL_JB_NAME IN VARCHAR2 \r\n> );\r\n> \r\n> PROCEDURE ADD_JOB_EMAIL_NOTIFICATION_PH3\r\n> (\r\n> RECIPIENTS_LIST IN DBMS_UTILITY.LNAME_ARRAY,\r\n> NEW_RAISE_EVENTS_NUM IN PLS_INTEGER,\r\n> CANON_JOB_NAME IN DBMS_ID,\r\n> CANON_JOB_SUBNAME IN DBMS_ID,\r\n> CANON_JOB_OWNER IN DBMS_ID,\r\n> INVOKER IN VARCHAR2,\r\n> SENDER IN VARCHAR2,\r\n> SUBJECT IN VARCHAR2,\r\n> BODY IN VARCHAR2,\r\n> FILTER_CONDITION IN VARCHAR2,\r\n> LOCK_NAME IN DBMS_ID,\r\n> LOCK_HANDLE IN VARCHAR2,\r\n> CUR_FLAGS IN NUMBER,\r\n> RECIPIENTS IN VARCHAR2,\r\n> EVENTS IN VARCHAR2\r\n> );\r\n<\/pre>\n
3289c3289\r\n< ,nblocks OUT binary_integer -- number of blocks of datafilecopy\r\n---\r\n> ,nblocks OUT number -- number of blocks of datafilecopy\r\n<\/pre>\n
13c13\r\n< '18.3.0.0.0';\r\n---\r\n> '18.2.2.0.0';\r\n231,237c231,233\r\n< PROCEDURE RU_apply (comp_version IN VARCHAR2 DEFAULT NULL,\r\n< build_description IN VARCHAR2 DEFAULT NULL,\r\n< build_timestamp IN TIMESTAMP DEFAULT NULL);\r\n< \r\n< PROCEDURE RU_rollback (comp_version IN VARCHAR2 DEFAULT NULL,\r\n< build_description IN VARCHAR2 DEFAULT NULL,\r\n< build_timestamp IN TIMESTAMP DEFAULT NULL);\r\n---\r\n> PROCEDURE RU_apply (comp_version IN VARCHAR2 DEFAULT NULL);\r\n> \r\n> PROCEDURE RU_rollback (comp_version IN VARCHAR2 DEFAULT NULL);\r\n<\/pre>\n
13c13\r\n< '18.3.0.0.0';\r\n---\r\n> '18.4.0.0.0';\r\n<\/pre>\n
13c13\r\n< '18.3.0.0.0';\r\n---\r\n> '18.3.1.0.0';\r\n<\/pre>\n
7763a7764\r\n> \r\n7775,7778c7776,7788\r\n< CUR_SCHEMA IN VARCHAR2) IS\r\n< CANON_JOB_NAME DBMS_ID;\r\n< CANON_JOB_SUBNAME DBMS_ID;\r\n< CANON_JOB_OWNER DBMS_ID;\r\n---\r\n> CUR_SCHEMA IN VARCHAR2,\r\n> LOCK_NAME OUT DBMS_ID,\r\n> LOCK_HANDLE OUT VARCHAR2,\r\n> RECIPIENTS_LIST OUT DBMS_UTILITY.LNAME_ARRAY,\r\n> NEW_RAISE_EVENTS_NUM OUT PLS_INTEGER,\r\n> CANON_JOB_NAME IN OUT DBMS_ID,\r\n> CANON_JOB_SUBNAME IN OUT DBMS_ID,\r\n> CANON_JOB_OWNER IN OUT DBMS_ID,\r\n> CUR_FLAGS OUT NUMBER,\r\n> DOES_SUB_EXIST OUT BOOLEAN,\r\n> DOES_REG_EXIST OUT BOOLEAN,\r\n> REAL_JB_NAME IN VARCHAR2 \r\n> ) IS\r\n7782d7791\r\n< NEW_RAISE_EVENTS_NUM PLS_INTEGER := 0;\r\n7791d7799\r\n< EVENT_10862 PLS_INTEGER := 0;\r\n7798,7799d7805\r\n< LOCK_NAME DBMS_ID;\r\n< LOCK_HANDLE VARCHAR2(128);\r\n7802d7807\r\n< RECIPIENTS_LIST DBMS_UTILITY.LNAME_ARRAY;\r\n7805d7809\r\n< CUR_FLAGS NUMBER;\r\n7807c7811\r\n< REAL_JOB_NAME VARCHAR2(2 * ORA_MAX_NAME_LEN + 5) := JOB_NAME;\r\n---\r\n> REAL_JOB_NAME VARCHAR2(2 * ORA_MAX_NAME_LEN + 5) := REAL_JB_NAME;\r\n7817c7821,7822\r\n< SYS.DBMS_ISCHED.TRACE_EMAIL('Entering add_job_email_notification');\r\n---\r\n> SYS.DBMS_ISCHED.TRACE_EMAIL('Entering ' || \r\n> 'dbms_isched.add_job_email_notification');\r\n7819a7825,7836\r\n> IF DO_TRC THEN\r\n> SYS.DBMS_ISCHED.TRACE_EMAIL('Current user: ' ||\r\n> SYS_CONTEXT('USERENV','CURRENT_USER') );\r\n> SYS.DBMS_ISCHED.TRACE_EMAIL('Session user: ' ||\r\n> SYS_CONTEXT('USERENV','SESSION_USER') );\r\n> SYS.DBMS_ISCHED.TRACE_EMAIL('Current schema: ' ||\r\n> SYS_CONTEXT('USERENV','CURRENT_SCHEMA') );\r\n> END IF;\r\n> \r\n> NEW_RAISE_EVENTS_NUM := 0;\r\n> CUR_FLAGS := 0;\r\n> \r\n7844,7868c7861,7862\r\n< RESOLVE3_NAME(REAL_JOB_NAME, CANON_JOB_NAME, CANON_JOB_SUBNAME,\r\n< CANON_JOB_OWNER, CUR_SCHEMA);\r\n< \r\n< \r\n< FULL_JOB_NAME := '\"'||CANON_JOB_OWNER||'\".\"'||CANON_JOB_NAME||'\"';\r\n< \r\n< \r\n< IF INVOKER != CANON_JOB_OWNER AND INVOKER != 'SYS' AND\r\n< BITAND(SYS_PRIVS, 2) = 0\r\n< THEN\r\n< \r\n< BEGIN\r\n< SYS.DBMS_ISCHED_UTL.CHECK_OBJECT_PRIVS(CANON_JOB_NAME, CANON_JOB_OWNER, 'JOB',\r\n< INVOKER, 'ALTER', TRUE, SYS_PRIVS);\r\n< EXCEPTION WHEN OTHERS THEN\r\n< \r\n< IF SQLCODE = -23306 AND CANON_JOB_SUBNAME IS NULL\r\n< AND REAL_JOB_NAME = JOB_NAME THEN\r\n< REAL_JOB_NAME := '\"'||CUR_SCHEMA||'\".' || JOB_NAME;\r\n< GOTO TRY_RESOLVE_AGAIN;\r\n< ELSE\r\n< RAISE;\r\n< END IF;\r\n< END;\r\n< END IF;\r\n---\r\n> FULL_JOB_NAME := DBMS_ASSERT.ENQUOTE_NAME(CANON_JOB_OWNER, FALSE) ||'.'||\r\n> DBMS_ASSERT.ENQUOTE_NAME(CANON_JOB_NAME , FALSE);\r\n7892c7886,7890\r\n< REAL_JOB_NAME := '\"'||CUR_SCHEMA||'\".' || JOB_NAME;\r\n---\r\n> REAL_JOB_NAME := DBMS_ASSERT.ENQUOTE_NAME(CUR_SCHEMA, FALSE) ||\r\n> '.' || JOB_NAME;\r\n> \r\n> RESOLVE3_NAME(REAL_JOB_NAME, CANON_JOB_NAME, CANON_JOB_SUBNAME,\r\n> CANON_JOB_OWNER, CUR_SCHEMA);\r\n7981,7990d7978\r\n< \r\n< \r\n< \r\n< DBMS_SYSTEM.READ_EV(10862, EVENT_10862);\r\n< IF EVENT_10862 = 0 THEN\r\n< EXECUTE IMMEDIATE\r\n< 'ALTER SESSION SET EVENTS ''10862 TRACE NAME CONTEXT FOREVER, LEVEL 1''';\r\n< END IF;\r\n< \r\n< \r\n7992,7993c7980,7981\r\n< 'select count(*) from sys.dba_QUEUE_SUBSCRIBERS where owner=''SYS''\r\n< and queue_name=''SCHEDULER$_EVENT_QUEUE'' and consumer_name=:lname'\r\n---\r\n> 'select count(*) from sys.user_QUEUE_SUBSCRIBERS where \r\n> queue_name=''SCHEDULER$_EVENT_QUEUE'' and consumer_name=:lname'\r\n7996,8003c7984,7985\r\n< BEGIN\r\n< \r\n< DBMS_AQADM.ADD_SUBSCRIBER\r\n< (QUEUE_NAME => 'SYS.SCHEDULER$_EVENT_QUEUE',\r\n< SUBSCRIBER => SYS.AQ$_AGENT(LOCK_NAME, NULL, NULL));\r\n< EXCEPTION WHEN OTHERS THEN\r\n< IF SQLCODE = -24034 THEN NULL;\r\n< ELSE\r\n---\r\n> DOES_SUB_EXIST := FALSE;\r\n> BEGIN\r\n8005,8007c7987,7994\r\n< IF EVENT_10862 = 0 THEN\r\n< EXECUTE IMMEDIATE 'ALTER SESSION SET EVENTS ' ||\r\n< '''10862 TRACE NAME CONTEXT OFF''' ;\r\n---\r\n> DBMS_AQADM.ADD_SUBSCRIBER\r\n> (QUEUE_NAME => 'SYS.SCHEDULER$_EVENT_QUEUE',\r\n> SUBSCRIBER => SYS.AQ$_AGENT(LOCK_NAME, NULL, NULL));\r\n> EXCEPTION WHEN OTHERS THEN\r\n> IF SQLCODE = -24034 THEN NULL;\r\n> ELSE\r\n> LOCK_ERROR := DBMS_LOCK.RELEASE(LOCKHANDLE=>LOCK_HANDLE);\r\n> RAISE;\r\n8009,8019c7996,7998\r\n< \r\n< LOCK_ERROR := DBMS_LOCK.RELEASE(LOCKHANDLE=>LOCK_HANDLE);\r\n< RAISE;\r\n< END IF;\r\n< END;\r\n< END IF;\r\n< \r\n< \r\n< IF EVENT_10862 = 0 THEN\r\n< EXECUTE IMMEDIATE 'ALTER SESSION SET EVENTS ' ||\r\n< '''10862 TRACE NAME CONTEXT OFF''' ;\r\n---\r\n> END;\r\n> ELSE\r\n> DOES_SUB_EXIST := TRUE;\r\n8025,8029d8003\r\n< IF ROW_COUNT = 0 THEN\r\n< \r\n< SYS.DBMS_AQADM_SYS.ENABLE_DB_ACCESS(LOCK_NAME,INVOKER,TRUE);\r\n< END IF;\r\n< \r\n8033a8008,8012\r\n> EXCEPTION WHEN OTHERS THEN\r\n> LOCK_ERROR := DBMS_LOCK.RELEASE(LOCKHANDLE=>LOCK_HANDLE);\r\n> RAISE;\r\n> END;\r\n> \r\n8035,8042c8014,8020\r\n< \r\n< \r\n< REGINFO := SYS.AQ$_REG_INFO('SYS.SCHEDULER$_EVENT_QUEUE:\"'||LOCK_NAME||'\"',\r\n< DBMS_AQ.NAMESPACE_AQ,\r\n< 'plsql:\/\/SYS.SCHEDULER$_JOB_EVENT_HANDLER',\r\n< NULL);\r\n< REGLIST := SYS.AQ$_REG_INFO_LIST(REGINFO);\r\n< DBMS_AQ.REGISTER ( REGLIST, 1 );\r\n---\r\n> DOES_REG_EXIST := FALSE;\r\n> ELSE \r\n> DOES_REG_EXIST := TRUE;\r\n> END IF;\r\n> \r\n> IF DO_TRC THEN\r\n> SYS.DBMS_ISCHED.TRACE_EMAIL('Exiting dbms_isched.add_job_email_notification');\r\n8045a8024,8078\r\n> \r\n> END;\r\n> \r\n> PROCEDURE ADD_JOB_EMAIL_NOTIFICATION_PH3\r\n> (\r\n> RECIPIENTS_LIST IN DBMS_UTILITY.LNAME_ARRAY,\r\n> NEW_RAISE_EVENTS_NUM IN PLS_INTEGER,\r\n> CANON_JOB_NAME IN DBMS_ID,\r\n> CANON_JOB_SUBNAME IN DBMS_ID,\r\n> CANON_JOB_OWNER IN DBMS_ID,\r\n> INVOKER IN VARCHAR2,\r\n> SENDER IN VARCHAR2,\r\n> SUBJECT IN VARCHAR2,\r\n> BODY IN VARCHAR2,\r\n> FILTER_CONDITION IN VARCHAR2,\r\n> LOCK_NAME IN DBMS_ID,\r\n> LOCK_HANDLE IN VARCHAR2,\r\n> CUR_FLAGS IN NUMBER,\r\n> RECIPIENTS IN VARCHAR2,\r\n> EVENTS IN VARCHAR2\r\n> ) IS\r\n> TYPE EVENT_NAME_LIST IS TABLE OF DBMS_ID;\r\n> TYPE EVENT_NUMBER_LIST IS TABLE OF NUMBER;\r\n> EVENT_NAMES EVENT_NAME_LIST := EVENT_NAME_LIST('JOB_STARTED',\r\n> 'JOB_SUCCEEDED', 'JOB_FAILED', 'JOB_BROKEN', 'JOB_COMPLETED',\r\n> 'JOB_STOPPED', 'JOB_SCH_LIM_REACHED', 'JOB_DISABLED',\r\n> 'JOB_CHAIN_STALLED','JOB_OVER_MAX_DUR','JOB_RUN_COMPLETED','JOB_ALL_EVENTS');\r\n> EVENT_NUMBERS EVENT_NUMBER_LIST :=\r\n> EVENT_NUMBER_LIST(1,2,4,8,16,32,64,128,256,512,2+4+32,1024-1);\r\n> EVENT_10862 PLS_INTEGER := 0;\r\n> LOCK_ERROR PLS_INTEGER;\r\n> FULL_JOB_NAME VARCHAR2(3 * ORA_MAX_NAME_LEN + 8);\r\n> DO_TRC BOOLEAN := FALSE;\r\n> EV_27402 PLS_INTEGER;\r\n> BEGIN\r\n> \r\n> DBMS_SYSTEM.READ_EV(27402, EV_27402);\r\n> IF BITAND(EV_27402,128)=128 THEN DO_TRC := TRUE; END IF;\r\n> \r\n> \r\n> IF DO_TRC THEN\r\n> SYS.DBMS_ISCHED.TRACE_EMAIL('Entered add_job_email_notification_ph3');\r\n> END IF;\r\n> \r\n> IF DO_TRC THEN\r\n> SYS.DBMS_ISCHED.TRACE_EMAIL('Current user: ' ||\r\n> SYS_CONTEXT('USERENV','CURRENT_USER') );\r\n> SYS.DBMS_ISCHED.TRACE_EMAIL('Session user: ' ||\r\n> SYS_CONTEXT('USERENV','SESSION_USER') );\r\n> SYS.DBMS_ISCHED.TRACE_EMAIL('Current schema: ' ||\r\n> SYS_CONTEXT('USERENV','CURRENT_SCHEMA') );\r\n> END IF;\r\n> \r\n> BEGIN \r\n> \r\n8152a8186,8189\r\n> FULL_JOB_NAME := DBMS_ASSERT.ENQUOTE_NAME(CANON_JOB_OWNER, FALSE) ||'.'||\r\n> DBMS_ASSERT.ENQUOTE_NAME(CANON_JOB_NAME , FALSE);\r\n> \r\n> \r\n8159c8196,8197\r\n< FULL_JOB_NAME := FULL_JOB_NAME ||'.\"'||CANON_JOB_SUBNAME||'\"';\r\n---\r\n> FULL_JOB_NAME := FULL_JOB_NAME ||'.'||\r\n> DBMS_ASSERT.ENQUOTE_NAME(CANON_JOB_SUBNAME,FALSE);\r\n8165a8204,8208\r\n> \r\n> \r\n> IF DO_TRC THEN\r\n> SYS.DBMS_ISCHED.TRACE_EMAIL('Exiting add_job_email_notification_ph3');\r\n> END IF;\r\n<\/pre>\n25a26,30\r\n> V_CODE NUMBER;\r\n> V_ERRM VARCHAR2(128);\r\n> \r\n> \r\n> \r\n80c85\r\n< RETURN '$Header: rdbms\/src\/client\/tools\/qpinv\/prvtqopi.sql \/st_rdbms_18.0\/1 2018\/03\/05 00:47:50 sspulava Exp $';\r\n---\r\n> RETURN '$Header: rdbms\/src\/client\/tools\/qpinv\/prvtqopi.sql \/st_rdbms_18.0\/3 2018\/07\/12 07:15:49 apfwkr Exp $';\r\n162a168,173\r\n> T_OP_INST_PATH VARCHAR2(1024) := '';\r\n> T_OP_SCPT_PATH VARCHAR2(1024) := '';\r\n> T_OP_LOG_PATH VARCHAR2(1024) := '';\r\n> T_ROOT VARCHAR2(1024) := '';\r\n> T_ORABASE VARCHAR2(1024) := '';\r\n> OPATCHFILE VARCHAR2(128) := 'opatch';\r\n185,186c196,197\r\n< DBMS_SYSTEM.KSDWRT(1,'QPI: Event 22171584 set. Skipping sanity check');\r\n< DBMS_SYSTEM.KSDWRT(1,'QPI: Please disable the event in case of any errors and try again');\r\n---\r\n> DBMS_SYSTEM.KSDWRT(3,'QPI: Event 22171584 set. Skipping sanity check');\r\n> DBMS_SYSTEM.KSDWRT(3,'QPI: Please disable the event in case of any errors and try again');\r\n210a222,229\r\n> SELECT PLATFORM_ID INTO PFID FROM V$DATABASE;\r\n> NOT_WIN := IS_NON_WINDOWS (PFID);\r\n> \r\n> \r\n> IF NOT NOT_WIN THEN\r\n> OPATCHFILE := 'opatch.bat';\r\n> END IF;\r\n> \r\n223a243,309\r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> T_ROOT := ROOT;\r\n> T_ORABASE := ORABASE;\r\n> T_OP_INST_PATH := OP_INST_PATH;\r\n> T_OP_SCPT_PATH := OP_SCPT_PATH;\r\n> T_OP_LOG_PATH := OP_LOG_PATH;\r\n> \r\n> IF NOT_WIN THEN\r\n> IF SUBSTR( ROOT,-1,1 ) <> '\/' THEN\r\n> T_ROOT := ROOT || '\/';\r\n> LOG_STATUS('QPI: t_root is ' || T_ROOT);\r\n> END IF;\r\n> \r\n> IF SUBSTR( ORABASE,-1,1 ) <> '\/' THEN\r\n> T_ORABASE := ORABASE || '\/';\r\n> LOG_STATUS('QPI: t_orabase is ' || T_ORABASE);\r\n> END IF;\r\n> \r\n> IF SUBSTR( OP_INST_PATH,-1,1 ) <> '\/' THEN\r\n> T_OP_INST_PATH := OP_INST_PATH || '\/';\r\n> LOG_STATUS('QPI: t_op_inst_path is ' || T_OP_INST_PATH);\r\n> END IF;\r\n> \r\n> IF SUBSTR( OP_SCPT_PATH,-1,1 ) <> '\/' THEN\r\n> T_OP_SCPT_PATH := OP_SCPT_PATH || '\/';\r\n> LOG_STATUS('QPI: t_op_scpt_path is ' || T_OP_SCPT_PATH);\r\n> END IF;\r\n> \r\n> IF SUBSTR( OP_LOG_PATH,-1,1 ) <> '\/' THEN\r\n> T_OP_LOG_PATH := OP_LOG_PATH || '\/';\r\n> LOG_STATUS('QPI: t_op_log_path is ' || T_OP_LOG_PATH);\r\n> END IF;\r\n> ELSE\r\n> IF SUBSTR( ROOT,-1,1 ) <> '\\' THEN\r\n> T_ROOT := ROOT || '\\';\r\n> LOG_STATUS('QPI: t_root is ' || T_ROOT);\r\n> END IF;\r\n> \r\n> IF SUBSTR( ORABASE,-1,1 ) <> '\\' THEN\r\n> T_ORABASE := ORABASE || '\\';\r\n> LOG_STATUS('QPI: t_orabase is ' || T_ORABASE);\r\n> END IF;\r\n> \r\n> IF SUBSTR( OP_INST_PATH,-1,1 ) <> '\\' THEN\r\n> T_OP_INST_PATH := OP_INST_PATH || '\\';\r\n> LOG_STATUS('QPI: t_op_inst_path is ' || T_OP_INST_PATH);\r\n> END IF;\r\n> \r\n> IF SUBSTR( OP_SCPT_PATH,-1,1 ) <> '\\' THEN\r\n> T_OP_SCPT_PATH := OP_SCPT_PATH || '\\';\r\n> LOG_STATUS('QPI: t_op_scpt_path is ' || T_OP_SCPT_PATH);\r\n> END IF;\r\n> \r\n> IF SUBSTR( OP_LOG_PATH,-1,1 ) <> '\\' THEN\r\n> T_OP_LOG_PATH := OP_LOG_PATH || '\\';\r\n> LOG_STATUS('QPI: t_op_log_path is ' || T_OP_LOG_PATH);\r\n> END IF;\r\n> \r\n> END IF;\r\n> \r\n243d328\r\n< SELECT PLATFORM_ID INTO PFID FROM V$DATABASE;\r\n258d342\r\n< NOT_WIN := IS_NON_WINDOWS (PFID);\r\n305c389\r\n< UTL_FILE.FGETATTR('OPATCH_INST_DIR', 'opatch', FEXISTS, FILE_LENGTH, BLOCK_SIZE);\r\n---\r\n> UTL_FILE.FGETATTR('OPATCH_INST_DIR', OPATCHFILE, FEXISTS, FILE_LENGTH, BLOCK_SIZE);\r\n307c391\r\n< DBMS_SYSTEM.KSDWRT(1,'QPI: opatch file present');\r\n---\r\n> DBMS_SYSTEM.KSDWRT(3,'QPI: opatch file present, ' || OPATCHFILE);\r\n309a394\r\n> DBMS_SYSTEM.KSDWRT(3,'QPI: opatch executable does not exist, ' || OPATCHFILE);\r\n319c404\r\n< DBMS_SYSTEM.KSDWRT(1,'QPI: qopiprep.bat file present');\r\n---\r\n> DBMS_SYSTEM.KSDWRT(3,'QPI: qopiprep.bat file present');\r\n374d458\r\n< LOG_STATUS ('QPI: GOT lock at :' || SYSTIMESTAMP);\r\n377a462\r\n> LOG_STATUS('QPI: Obtaining lock FAILED, qp_result=' || QP_RESULT || ' at : ' || SYSTIMESTAMP);\r\n378a464,465\r\n> ELSIF QP_RESULT = 0 OR QP_RESULT = 4 THEN\r\n> LOG_STATUS('QPI: Obtaining lock SUCCESSFUL, qp_result=' || QP_RESULT || ' at : ' || SYSTIMESTAMP);\r\n401c488,492\r\n< LOG_STATUS ('QPI: Releasing the lock at :' || SYSTIMESTAMP);\r\n---\r\n> IF QP_RESULT = 0 THEN\r\n> LOG_STATUS('QPI: Releasing lock SUCCESSFUL, qp_result=' || QP_RESULT || ' at : ' || SYSTIMESTAMP);\r\n> ELSE\r\n> LOG_STATUS('QPI: Releasing lock FAILED, qp_result=' || QP_RESULT || ' at : ' || SYSTIMESTAMP);\r\n> END IF;\r\n426,427d516\r\n< V_CODE NUMBER;\r\n< V_ERRM VARCHAR2(128);\r\n493,494c582,583\r\n< V_ERRM := SUBSTR(SQLERRM, 1, 64);\r\n< LOG_STATUS('Error code ' || V_CODE || ': ' || V_ERRM);\r\n---\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in config_oinv_jobs, Error code ' || V_CODE || ': ' || V_ERRM);\r\n799c888\r\n< DBMS_SYSTEM.KSDWRT(1,'QPI: Cleaning and refreshing metadata..');\r\n---\r\n> DBMS_SYSTEM.KSDWRT(3,'QPI: Cleaning and refreshing metadata..');\r\n837a927,930\r\n> LOG_STATUS('QPI: Caught error while querying opatch_xml_inv');\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in REFRESH_OPATCH_DATA, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n892a986,992\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in get_opatch_install_info, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n935a1036,1042\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in get_opatch_list, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n986a1094,1100\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in IS_PATCH_INSTALLED, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n1039a1154,1160\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in GET_OPATCH_DATA, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n1099a1221,1227\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in GET_OPATCH_BUGS, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n1121a1250,1253\r\n> QP_RESULT := GET_QOPATCH_LOCK();\r\n> \r\n> LOG_STATUS('QPI: Got lock get_opatch_files');\r\n> \r\n1133a1266,1269\r\n> \r\n> LOG_STATUS('QPI: Release lock get_opatch_files');\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> \r\n1134a1271,1283\r\n> \r\n> EXCEPTION \r\n> WHEN UNABLE_TO_LOCK THEN\r\n> RAISE_APPLICATION_ERROR(-20016, \r\n> 'Unable to get the lock : get_opatch_files : ' || QP_RESULT);\r\n> \r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in GET_OPATCH_FILES, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n1178a1328,1334\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in GET_OPATCH_COUNT, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n1225a1382,1388\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in GET_OPATCH_PREQS, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n1268a1432,1443\r\n> EXCEPTION \r\n> WHEN UNABLE_TO_LOCK THEN\r\n> RAISE_APPLICATION_ERROR(-20016, \r\n> 'Unable to get the lock : get_opatch_install_info : ' || QP_RESULT);\r\n> \r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in GET_OPATCH_OLAYS, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n1317a1493,1499\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in PATCH_CONFLICT_DETECTION, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n1370c1552\r\n< OPATCHFILE CONSTANT VARCHAR2(128) := 'opatch';\r\n---\r\n> OPATCHFILE VARCHAR2(128) := 'opatch';\r\n1406a1589\r\n> OPATCHFILE := 'opatch.bat';\r\n1453a1637\r\n> LOG_STATUS('QPI: opatch executable exists and is readable, ' || OPATCHFILE);\r\n1455a1640\r\n> LOG_STATUS('QPI: opatch executable does not exist or is not redable, ' || OPATCHFILE);\r\n1514,1515d1698\r\n< V_CODE NUMBER;\r\n< V_ERRM VARCHAR2(128);\r\n1590,1591c1773,1774\r\n< V_ERRM := SUBSTR(SQLERRM, 1, 64);\r\n< LOG_STATUS('Error code ' || V_CODE || ': ' || V_ERRM);\r\n---\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in add_oinv_job, Error code ' || V_CODE || ': ' || V_ERRM);\r\n1612c1795\r\n< DBMS_SYSTEM.KSDWRT(1,'Node name: ' || PVAL.NODE_NAME || ' Inst:' || PVAL.INST_NAME|| ' Job:' || PVAL.INST_JOB);\r\n---\r\n> DBMS_SYSTEM.KSDWRT(3,'Node name: ' || PVAL.NODE_NAME || ' Inst:' || PVAL.INST_NAME|| ' Job:' || PVAL.INST_JOB);\r\n1619c1802\r\n< DBMS_SYSTEM.KSDWRT(1,'Job: ' || PVAR.JOB_NAME || ' State: ' || PVAR.STATE);\r\n---\r\n> DBMS_SYSTEM.KSDWRT(3,'Job: ' || PVAR.JOB_NAME || ' State: ' || PVAR.STATE);\r\n1718a1902\r\n> \r\n1900a2085,2088\r\n> WHEN UNABLE_TO_LOCK THEN\r\n> RAISE_APPLICATION_ERROR(-20016, \r\n> 'Unable to get the lock : get_pending_activity : ' || QP_RESULT);\r\n> \r\n1906a2095,2097\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in get_pending_activity, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n2136a2328,2334\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in get_opatch_lsinventory, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n2635a2834,2840\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in opatch_compare, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n2741a2947,2953\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in get_patch_details, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n2784a2997,3003\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in check_patch_installed, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n2856c3075,3078\r\n< \r\n---\r\n> \r\n> LOG_STATUS('QPI: Release lock opatch_compare_nodes');\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> \r\n2876a3099,3102\r\n> \r\n> LOG_STATUS('QPI: Release lock opatch_compare_nodes');\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> \r\n2883,2885d3108\r\n< LOG_STATUS('QPI: Release lock opatch_compare_nodes');\r\n< QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n< \r\n2890a3114,3120\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in OPATCH_COMPARE_NODES, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n2917a3148\r\n> \r\n2989c3220\r\n< WHEN UNABLE_TO_LOCK THEN\r\n---\r\n> WHEN UNABLE_TO_LOCK THEN \r\n2992,2993c3223,3230\r\n< WHEN OTHERS THEN\r\n< RAISE;\r\n---\r\n> \r\n> WHEN OTHERS THEN \r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in CLEAN_METADATA, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n2995a3233,3234\r\n> \r\n> \r\n<\/pre>\n122c122\r\n< CATALOGVERSION CONSTANT VARCHAR2(11) := '18.03.00.00'; \r\n---\r\n> CATALOGVERSION CONSTANT VARCHAR2(11) := '18.03.01.00'; \r\n<\/pre>\n
122c122\r\n< CATALOGVERSION CONSTANT VARCHAR2(11) := '18.03.00.00'; \r\n---\r\n> CATALOGVERSION CONSTANT VARCHAR2(11) := '18.02.02.00'; \r\n<\/pre>\n
122c122\r\n< CATALOGVERSION CONSTANT VARCHAR2(11) := '18.03.00.00'; \r\n---\r\n> CATALOGVERSION CONSTANT VARCHAR2(11) := '18.04.00.00'; \r\n24765a24766\r\n> END IF;\r\n24767,24790c24768,24788\r\n< \r\n< \r\n< \r\n< \r\n< \r\n< \r\n< \r\n< IF (AVAILABLE_FROMSCN_ACT IS NULL OR\r\n< (USABLE_INCR.DFNUMBER_OBJ = LOCAL.DFNUMBER_OBJ AND\r\n< USABLE_INCR.DFCREATIONSCN_OBJ = LOCAL.DFCREATIONSCN_OBJ AND\r\n< LOCAL.TOSCN_ACT < AVAILABLE_FROMSCN_ACT)) THEN\r\n< IF (AVAILABLE_FROMSCN_ACT IS NULL) THEN\r\n< DEB(DEB_PRINT, 'available_fromSCN_act set to ' ||\r\n< AVAILABLE_FROMSCN_ACT || ' for file# ' ||\r\n< LOCAL.DFNUMBER_OBJ || ', creation_scn '||\r\n< LOCAL.DFCREATIONSCN_OBJ);\r\n< ELSE\r\n< DEB(DEB_PRINT, 'broken chain, available_fromSCN_act set to ' ||\r\n< AVAILABLE_FROMSCN_ACT || ' for file ' ||\r\n< LOCAL.DFNUMBER_OBJ || ', creation_scn '||\r\n< LOCAL.DFCREATIONSCN_OBJ);\r\n< END IF;\r\n< USABLE_INCR := LOCAL;\r\n< AVAILABLE_FROMSCN_ACT := LOCAL.FROMSCN_ACT;\r\n---\r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> IF (AVAILABLE_FROMSCN_ACT IS NULL OR\r\n> (USABLE_INCR.DFNUMBER_OBJ = LOCAL.DFNUMBER_OBJ AND\r\n> USABLE_INCR.DFCREATIONSCN_OBJ = LOCAL.DFCREATIONSCN_OBJ AND\r\n> LOCAL.TOSCN_ACT < AVAILABLE_FROMSCN_ACT)) THEN\r\n> IF (AVAILABLE_FROMSCN_ACT IS NULL) THEN\r\n> DEB(DEB_PRINT, 'available_fromSCN_act set to ' ||\r\n> AVAILABLE_FROMSCN_ACT || ' for file# ' ||\r\n> LOCAL.DFNUMBER_OBJ || ', creation_scn '||\r\n> LOCAL.DFCREATIONSCN_OBJ);\r\n> ELSE\r\n> DEB(DEB_PRINT, 'broken chain, available_fromSCN_act set to ' ||\r\n> AVAILABLE_FROMSCN_ACT || ' for file ' ||\r\n> LOCAL.DFNUMBER_OBJ || ', creation_scn '||\r\n> LOCAL.DFCREATIONSCN_OBJ);\r\n24791a24790,24791\r\n> USABLE_INCR := LOCAL;\r\n> AVAILABLE_FROMSCN_ACT := LOCAL.FROMSCN_ACT;\r\n27205a27206,27208\r\n> \r\n> \r\n> IF (DFREC.PDBID <= 1 OR TRANSLATEPDB2NAME(DFREC.PDBID) IS NOT NULL) THEN\r\n27206a27210\r\n> END IF;\r\n29222c29226\r\n< ,NBLOCKS OUT BINARY_INTEGER\r\n---\r\n> ,NBLOCKS OUT NUMBER\r\n<\/pre>\n
624,625c624,625\r\n< TO_CHAR(P_DATE, 'MM-DD-YYYY HH24:MI:SS') || P_EDITION || 'FBC238'),\r\n< DBMS_CRYPTO.HASH_MD5);\r\n---\r\n> TO_CHAR(P_DATE, 'MM-DD-YYYY HH24:MI:SS','nls_calendar=Gregorian')\r\n> || P_EDITION || 'FBC238'), DBMS_CRYPTO.HASH_MD5);\r\n<\/pre>\n
4389a4390,4408\r\n> DOES_SUB_EXIST BOOLEAN := FALSE;\r\n> DOES_REG_EXIST BOOLEAN := FALSE;\r\n> LOCK_NAME DBMS_ID;\r\n> LOCK_HANDLE VARCHAR2(128);\r\n> LOCK_ERROR PLS_INTEGER;\r\n> REGINFO SYS.AQ$_REG_INFO;\r\n> REGLIST SYS.AQ$_REG_INFO_LIST;\r\n> RECIPIENTS_LIST DBMS_UTILITY.LNAME_ARRAY;\r\n> NEW_RAISE_EVENTS_NUM PLS_INTEGER := 0;\r\n> CANON_JOB_NAME DBMS_ID;\r\n> CANON_JOB_SUBNAME DBMS_ID;\r\n> CANON_JOB_OWNER DBMS_ID;\r\n> CUR_FLAGS NUMBER;\r\n> EV_27402 PLS_INTEGER := 0;\r\n> DO_TRC BOOLEAN := FALSE;\r\n> CURRENT_USER DBMS_ID := SYS_CONTEXT('USERENV','CURRENT_USER');\r\n> CUR_SCHEMA DBMS_ID := SYS_CONTEXT('USERENV','CURRENT_SCHEMA');\r\n> REAL_JOB_NAME VARCHAR2(2 * ORA_MAX_NAME_LEN + 5) := JOB_NAME;\r\n> FULL_JOB_NAME VARCHAR2(3 * ORA_MAX_NAME_LEN + 8);\r\n4392a4412,4429\r\n> SYS.DBMS_SYSTEM.READ_EV(27402, EV_27402);\r\n> IF BITAND(EV_27402,128)=128 THEN DO_TRC := TRUE; END IF;\r\n> \r\n> IF DO_TRC THEN\r\n> SYS.DBMS_ISCHED.TRACE_EMAIL('Entered ' || \r\n> 'dbms_scheduler.add_job_email_notification');\r\n> END IF;\r\n> \r\n> IF DO_TRC THEN\r\n> SYS.DBMS_ISCHED.TRACE_EMAIL('Current user: ' ||\r\n> CURRENT_USER );\r\n> SYS.DBMS_ISCHED.TRACE_EMAIL('Session user: ' ||\r\n> SYS_CONTEXT('USERENV','SESSION_USER') );\r\n> SYS.DBMS_ISCHED.TRACE_EMAIL('Current schema: ' ||\r\n> CUR_SCHEMA );\r\n> END IF;\r\n> \r\n> \r\n4424a4462,4497\r\n> \r\n> \r\n> <<TRY_RESOLVE_AGAIN>>\r\n> \r\n> \r\n> SYS.DBMS_ISCHED.RESOLVE3_NAME(REAL_JOB_NAME, CANON_JOB_NAME, \r\n> CANON_JOB_SUBNAME, CANON_JOB_OWNER, CUR_SCHEMA);\r\n> \r\n> \r\n> FULL_JOB_NAME := SYS.DBMS_ASSERT.ENQUOTE_NAME(CANON_JOB_OWNER, FALSE) ||'.'||\r\n> SYS.DBMS_ASSERT.ENQUOTE_NAME(CANON_JOB_NAME , FALSE);\r\n> \r\n> \r\n> IF CURRENT_USER != CANON_JOB_OWNER AND CURRENT_USER != 'SYS' AND\r\n> BITAND(SYS_PRIVS, 2) = 0\r\n> THEN\r\n> \r\n> BEGIN\r\n> SYS.DBMS_ISCHED_UTL.CHECK_OBJECT_PRIVS(CANON_JOB_NAME, CANON_JOB_OWNER, \r\n> 'JOB', CURRENT_USER, 'ALTER', TRUE, SYS_PRIVS);\r\n> EXCEPTION WHEN OTHERS THEN\r\n> \r\n> IF SQLCODE = -23306 AND CANON_JOB_SUBNAME IS NULL\r\n> AND REAL_JOB_NAME = JOB_NAME THEN\r\n> REAL_JOB_NAME := SYS.DBMS_ASSERT.ENQUOTE_NAME(CUR_SCHEMA, FALSE) ||\r\n> '.' || JOB_NAME;\r\n> GOTO TRY_RESOLVE_AGAIN;\r\n> ELSE\r\n> RAISE;\r\n> END IF;\r\n> END;\r\n> END IF;\r\n> \r\n> \r\n> \r\n> \r\n4427,4428c4500,4541\r\n< SYS_CONTEXT('USERENV','CURRENT_USER'), SYS_PRIVS,\r\n< SYS_CONTEXT('USERENV','CURRENT_SCHEMA'));\r\n---\r\n> CURRENT_USER, SYS_PRIVS,\r\n> CUR_SCHEMA,\r\n> LOCK_NAME, LOCK_HANDLE, RECIPIENTS_LIST, NEW_RAISE_EVENTS_NUM, \r\n> CANON_JOB_NAME, CANON_JOB_SUBNAME, CANON_JOB_OWNER, CUR_FLAGS,\r\n> DOES_SUB_EXIST, DOES_REG_EXIST, REAL_JOB_NAME);\r\n> \r\n> \r\n> \r\n> IF NOT DOES_SUB_EXIST THEN\r\n> \r\n> SYS.DBMS_AQADM.ENABLE_DB_ACCESS(LOCK_NAME,\r\n> SYS.DBMS_ASSERT.ENQUOTE_NAME(CURRENT_USER, FALSE));\r\n> END IF;\r\n> \r\n> BEGIN\r\n> IF NOT DOES_REG_EXIST THEN\r\n> \r\n> \r\n> REGINFO := SYS.AQ$_REG_INFO('SYS.SCHEDULER$_EVENT_QUEUE:\"'||LOCK_NAME||'\"',\r\n> SYS.DBMS_AQ.NAMESPACE_AQ,\r\n> 'plsql:\/\/SYS.SCHEDULER$_JOB_EVENT_HANDLER',\r\n> NULL);\r\n> REGLIST := SYS.AQ$_REG_INFO_LIST(REGINFO);\r\n> SYS.DBMS_AQ.REGISTER ( REGLIST, 1 );\r\n> END IF;\r\n> EXCEPTION WHEN OTHERS THEN\r\n> LOCK_ERROR := SYS.DBMS_LOCK.RELEASE(LOCKHANDLE=>LOCK_HANDLE);\r\n> RAISE;\r\n> END;\r\n> \r\n> \r\n> \r\n> SYS.DBMS_ISCHED.ADD_JOB_EMAIL_NOTIFICATION_PH3(RECIPIENTS_LIST, \r\n> NEW_RAISE_EVENTS_NUM, CANON_JOB_NAME, CANON_JOB_SUBNAME, \r\n> CANON_JOB_OWNER, CURRENT_USER,\r\n> SENDER, SUBJECT, BODY, FILTER_CONDITION, LOCK_NAME, LOCK_HANDLE,\r\n> CUR_FLAGS, RECIPIENTS, EVENTS);\r\n> \r\n> IF DO_TRC THEN\r\n> SYS.DBMS_ISCHED.TRACE_EMAIL('Exiting' ||\r\n> 'dbms_scheduler.add_job_email_notification');\r\n> END IF;\r\n<\/pre>\n15195,15198c15195,15200\r\n< TRANSFER_COLUMN_STATS(OWNER, DBMS_STATS_INTERNAL.DQ(TAB_NAME), EXTN_NAME, \r\n< NULL, NULL, NULL,\r\n< NULL, NULL, TRUE, TRUE, NULL, FALSE, FALSE, DSC_NON_FXT, TRUE, \r\n< 'ALL', FALSE, NULL, TRUE);\r\n---\r\n> \r\n> \r\n> TRANSFER_COLUMN_STATS(DBMS_STATS_INTERNAL.DQ(OWNER), \r\n> DBMS_STATS_INTERNAL.DQ(TAB_NAME), DBMS_STATS_INTERNAL.DQ(EXTN_NAME),\r\n> NULL, NULL, NULL, NULL, NULL, TRUE, TRUE, NULL, FALSE, FALSE, \r\n> DSC_NON_FXT, TRUE, 'ALL', FALSE, NULL, TRUE);\r\n<\/pre>\n
64c64,65\r\n< 'where (PARENT_DBUN not in ' ||\r\n---\r\n> 'where (DEST_ROLE != ''LOGICAL STANDBY'') ' ||\r\n> 'and (PARENT_DBUN not in ' ||\r\n<\/pre>\n
32,34c32\r\n< NOTIF_OWNER DBMS_ID := '';\r\n< NOTIF_OWNER_ID PLS_INTEGER;\r\n< HAS_SYS_PRVLG VARCHAR2(1) := 'N';\r\n---\r\n> CURRENT_USER DBMS_ID := SYS_CONTEXT('USERENV','CURRENT_USER');\r\n38,43d35\r\n< \r\n< \r\n< \r\n< \r\n< \r\n< \r\n49,52c41,46\r\n< SYS.DBMS_ISCHED.TRACE_EMAIL('Current user: '||\r\n< SYS_CONTEXT('USERENV','CURRENT_USER'));\r\n< SYS.DBMS_ISCHED.TRACE_EMAIL('Consumer name: '||\r\n< DESCR.CONSUMER_NAME);\r\n---\r\n> SYS.DBMS_ISCHED.TRACE_EMAIL('Consumer name: ' || DESCR.CONSUMER_NAME);\r\n> SYS.DBMS_ISCHED.TRACE_EMAIL('Current user: ' || CURRENT_USER);\r\n> SYS.DBMS_ISCHED.TRACE_EMAIL('Session user: ' ||\r\n> SYS_CONTEXT('USERENV','SESSION_USER') );\r\n> SYS.DBMS_ISCHED.TRACE_EMAIL('Current schema: ' ||\r\n> SYS_CONTEXT('USERENV','CURRENT_SCHEMA') );\r\n55a50,52\r\n> SYS_PRIVS := SYS.DBMS_SCHEDULER.CHECK_SYS_PRIVS();\r\n> \r\n> \r\n75,117d71\r\n< \r\n< \r\n< BEGIN\r\n< NOTIF_OWNER_ID := TO_NUMBER(REGEXP_SUBSTR(DESCR.CONSUMER_NAME, '[0-9]+$')); \r\n< SELECT NAME INTO NOTIF_OWNER FROM SYS.USER$ \r\n< WHERE USER#=NOTIF_OWNER_ID;\r\n< IF DO_TRC THEN\r\n< SYS.DBMS_ISCHED.TRACE_EMAIL('Notification owner: '||\r\n< NOTIF_OWNER);\r\n< END IF;\r\n< EXCEPTION WHEN NO_DATA_FOUND THEN\r\n< SYS.DBMS_ISCHED.TRACE_EMAIL(\r\n< 'No data found: notif_owner_id: ' || NOTIF_OWNER_ID);\r\n< WHEN OTHERS THEN RAISE;\r\n< END;\r\n< \r\n< \r\n< SELECT DECODE(SIGN(COUNT(UNIQUE UP)),1, 'Y', 'N') \r\n< INTO HAS_SYS_PRVLG\r\n< FROM (\r\n< SELECT GRANTED_ROLE UP\r\n< FROM (\r\n< SELECT NULL GRANTEE, USERNAME GRANTED_ROLE\r\n< FROM SYS.DBA_USERS\r\n< WHERE USERNAME = NOTIF_OWNER\r\n< UNION\r\n< SELECT GRANTEE, GRANTED_ROLE\r\n< FROM SYS.DBA_ROLE_PRIVS\r\n< UNION\r\n< SELECT GRANTEE, PRIVILEGE\r\n< FROM SYS.DBA_SYS_PRIVS\r\n< )\r\n< START WITH GRANTEE IS NULL\r\n< CONNECT BY GRANTEE = PRIOR GRANTED_ROLE\r\n< )\r\n< WHERE UP IN ('CREATE ANY JOB', \r\n< 'MANAGE SCHEDULER', \r\n< 'SCHEDULER_ADMIN');\r\n< \r\n< IF DO_TRC THEN\r\n< SYS.DBMS_ISCHED.TRACE_EMAIL('has_sys_prvlg: '||\r\n< HAS_SYS_PRVLG);\r\n< END IF;\r\n124,125d77\r\n< \r\n< \r\n127,129c79,81\r\n< IF NOTIF_OWNER != MESSAGE.OBJECT_OWNER AND\r\n< NOTIF_OWNER != 'SYS' AND\r\n< HAS_SYS_PRVLG != 'Y' \r\n---\r\n> IF CURRENT_USER != MESSAGE.OBJECT_OWNER AND\r\n> CURRENT_USER != 'SYS' AND\r\n> BITAND(SYS_PRIVS,2) = 0 \r\n131,133c83,86\r\n< \r\n< SYS.DBMS_ISCHED_UTL.CHECK_OBJECT_PRIVS(MESSAGE.OBJECT_NAME , MESSAGE.OBJECT_OWNER, \r\n< 'JOB', NOTIF_OWNER, 'ALTER', TRUE, 0);\r\n---\r\n> \r\n> SYS.DBMS_ISCHED_UTL.CHECK_OBJECT_PRIVS(MESSAGE.OBJECT_NAME,\r\n> MESSAGE.OBJECT_OWNER, 'JOB', CURRENT_USER,\r\n> 'ALTER', TRUE, SYS_PRIVS);\r\n145,146d97\r\n< \r\n< \r\n149c100\r\n< NOTIF_OWNER, EVT_FLAG, SENDER_ARR, BODY_ARR, \r\n---\r\n> CURRENT_USER, EVT_FLAG, SENDER_ARR, BODY_ARR, \r\n353a305,308\r\n> \r\n> IF DO_TRC THEN\r\n> SYS.DBMS_ISCHED.TRACE_EMAIL('Exiting job event handler.');\r\n> END IF;\r\n<\/pre>\n
\n
