Friday, July 29, 2022

using python-oracledb to connect rds for Oracle in thin mode

 The Oracle python driver cx_Oracle only works with Oracle thick client (including Oracle instant client) to connect to Oracle database. With the release of python-oracledb, the new name for the Python Oracle driver, the default mode is thin mode, which means no thick/instant client installation required. The feature parity differences between Thin mode, Thick Mode and original cx_Oracle could be found here.

Here are quick references with code samples to connect RDS for Oracle with/without SSL.


Connect to Oracle without TLS/SSL


  1. Check the Python environment. Refer to the actual Python version required in the installation guide.
which python3
/usr/bin/python3 -V
[ec2-user@ip-10-1-1-110 ~]$ which python3
/usr/bin/python3

[ec2-user@ip-10-1-1-110 ~]$ /usr/bin/python3 -V
Python 3.7.10
  1. Install python-oracledb package. It's optionally run using user root for the installation to share the package with other users.
python3 -m pip install oracledb --upgrade
  1. Execute following sample code the test the Oracle connectivity
#!/usr/bin/python3
import oracledb
import os

un = 'admin'
pw = 'yourComPlexPassword'
cs = 'oracle-instance1.fakeramdonid.us-east-1.rds.amazonaws.com:1521/MYTEST'

with oracledb.connect(user=un, password=pw, dsn=cs) as connection:
    with connection.cursor() as cursor:
        sql = """select '['||systimestamp||'] Connectivity OK' from dual"""
        for r in cursor.execute(sql):
            print(r[0])

Sample output:

[ec2-user@ip-10-1-1-110 ~]$ chmod +x non-tls.py

[ec2-user@ip-10-1-1-110 ~]$ ./non-tls.py
[30-JUL-22 08.18.53.670773 AM +00:00] Connectivity OK


Connect to Amazon RDS for Oracle with TLS/SSL


  1. Enable Oracle SSL Option following the official documentation.

Make sure you have selected TLS 1.2 instead of default TLS 1.0.

  1. Install additional Linux packages and Python modules using root user
yum install libcurl-devel python3-devel openssl-devel gcc ca-certificates

python3 -m pip install pyca
  1. Download the Amazon RDS certificate bundle from the official documentation. Here we will use the global bundle as example, which contains intermediate and root certificates for all AWS regions.

  2. Append the cert to Linux default cert.pem.

cp global-bundle.pem /etc/pki/ca-trust/source/anchors/
update-ca-trust force-enable
update-ca-trust extract

To verify the certificates installed successfully, below grep command shall have list of certs from Amazon.

grep -i "Amazon RDS" /etc/pki/tls/cert.pem
  1. Execute following sample code the test the Oracle connectivity
#!/usr/bin/python3
import oracledb
import os

un = 'admin'
pw = 'yourComPlexPassword'
cs = '''(description = (retry_count=20)(retry_delay=3)(address=(protocol=tcps)
           (port=2484)(host=oracle-instance1.fakeramdonid.us-east-1.rds.amazonaws.com))(connect_data=(SERVICE_NAME=MYTEST))
           (security=(ssl_server_dn_match=yes)
           (ssl_server_cert_dn="C=US,ST=Washington,L=Seattle,O=Amazon.com,OU=RDS,CN=oracle-instance1.fakeramdonid.us-east-1.rds.amazonaws.com")))
           '''

with oracledb.connect(user=un, password=pw, dsn=cs) as connection:
    with connection.cursor() as cursor:
        sql = """select '['||systimestamp||'] Connectivity OK' from dual"""
        for r in cursor.execute(sql):
            print(r[0])

Sample output:

[root@ip-10-1-1-110 ec2-user]# ./tls.py
[30-JUL-22 09.10.56.125153 AM +00:00] Connectivity OK

if you only needs tls/ssl encryption without verifying the server certificates, you can use below simplified connection string:

cs1 = '''(description = (retry_count=20)(retry_delay=3)(address=(protocol=tcps)
           (port=2484)(host=oracle-instance1.fakeramdonid.us-east-1.rds.amazonaws.com))(connect_data=(SERVICE_NAME=MYTEST))
           )
           '''


Common errors and possible solutions


Error message:

oracledb.exceptions.OperationalError: DPY-6005: cannot connect to database. Connection failed with "[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1091)

Solution: Make sure you have downloaded the certificates bundle and added to cert.pem.


Error message:

oracledb.exceptions.DatabaseError: DPY-4011: the database or network closed the connection
[Errno 104] Connection reset by peer

Solution: Make sure have opened necessary firewall ports, and your TLS version is 1.2.


Error message:

oracledb.exceptions.OperationalError: DPY-6002: cannot connect to database. The distinguished name (DN) on the server certificate does not match the expected val

Solution: If you have ssl_server_dn_match=yes included in your connection string, make sure your ssl_server_cert_dn is correct. Part of your DN is your database endpoint.


Reference: Python packages used with version details


[root@ip-10-1-1-110 ec2-user]# pip3 list -v
Package            Version Location                                 Installer
------------------ ------- ---------------------------------------- ---------
aws-cfn-bootstrap  2.0     /usr/lib/python3.7/site-packages
cffi               1.15.1  /usr/local/lib64/python3.7/site-packages pip
click              8.1.3   /usr/local/lib/python3.7/site-packages   pip
configobj          5.0.6   /usr/local/lib/python3.7/site-packages
cryptography       37.0.4  /usr/local/lib64/python3.7/site-packages pip
docutils           0.14    /usr/lib/python3.7/site-packages
Flask              2.1.3   /usr/local/lib/python3.7/site-packages   pip
greenlet           1.1.2   /usr/local/lib64/python3.7/site-packages pip
importlib-metadata 4.12.0  /usr/local/lib/python3.7/site-packages   pip
itsdangerous       2.1.2   /usr/local/lib/python3.7/site-packages   pip
Jinja2             3.1.2   /usr/local/lib/python3.7/site-packages   pip
lockfile           0.11.0  /usr/lib/python3.7/site-packages
MarkupSafe         2.1.1   /usr/local/lib64/python3.7/site-packages pip
oracledb           1.0.2   /usr/local/lib64/python3.7/site-packages pip
pip                20.2.2  /usr/lib/python3.7/site-packages         rpm
prometheus-client  0.14.1  /usr/local/lib/python3.7/site-packages   pip
psutil             5.9.1   /usr/local/lib64/python3.7/site-packages pip
pyca               4.4     /usr/local/lib/python3.7/site-packages
pycparser          2.21    /usr/local/lib/python3.7/site-packages   pip
pycurl             7.45.1  /usr/local/lib64/python3.7/site-packages
pystache           0.5.4   /usr/lib/python3.7/site-packages
python-daemon      2.2.3   /usr/lib/python3.7/site-packages
python-dateutil    2.8.2   /usr/local/lib/python3.7/site-packages   pip
sdnotify           0.3.2   /usr/local/lib/python3.7/site-packages
setuptools         49.1.3  /usr/lib/python3.7/site-packages         pip
simplejson         3.2.0   /usr/lib64/python3.7/site-packages
six                1.16.0  /usr/local/lib/python3.7/site-packages   pip
SQLAlchemy         1.4.39  /usr/local/lib64/python3.7/site-packages pip
typing-extensions  4.3.0   /usr/local/lib/python3.7/site-packages   pip
Werkzeug           2.2.1   /usr/local/lib/python3.7/site-packages   pip
zipp               3.8.1   /usr/local/lib/python3.7/site-packages   pip

Friday, July 22, 2022

Total 276 bugs fixed in Jul-2022 Oracle 21c updates (21.7RU)

 

Total 276 bugs fixed in Jul-2022 Oracle 21c updates (21.7RU)

BUG_ID
DESCRIPTION
25655012UNABLE TO MONITOR PARALLEL QUERY (MARKED INACTIVE AFTER 30MINS) IN SQL MONITOR
28044739FTS PLAN FOR REMOTE WHEN SQL CONTAINS NESTED TABLES AND REMOTE TABLES
28089112ALTERNATIVE QUOTING Q[LITERALS] GENERATES WRONG RESULT THROUGH JDBC
28513129VERY LARGE SQL GENERATED FROM GRAPH QUERY NEVER GETS A QUERY PLAN
29413205SELECT QUERY FAILS WITH ORA-07445 EXCEPTION ENCOUNTERED CORE DUMP [EVAPLS]
29811720DATAPATCH PRECHECK ENHANCEMENT
29927360UPDATING PROXY USER PASSWORD VIA GETCONNECTION() UPDATES WRONG PASSWORD
29948154ORA-01403 USING TEXT INDEX IN ADG
30706073ORDER_SUBQ HINT IS USUSED
30771009PSR PERF SUPPORTING ACS FOR AUTO-SPM
31192261CORRECT ERROR HANDLING IN PRESENCE OF MULTIPLE ODCI*CLOSE CALLS
31487775ADB-CC BB UI PDB RMAN-06813 COULD NOT TRANSLATE PLUGGABLE DATABASE
31504723SELECT QUERY FAILED WITH ORA-00979 AFTER UPGRADE TO 19C
31531079AQ RESPONSYS ON-PREM EFFICIENT SPACE MANAGEMENT NEEDED FOR TEQ INTERNAL SEGMENTS
31676324GOLDENGATE CAPTURE STARTED BY REGISTER EXTRACT SHOULD STOP AFTER FINISH DICTIONARY LOADING
31768866CDB_RAC_AUDIT ORA-7445 [__INTEL_AVX_REP_MEMCPY] WAS ENCOUNTER WHILE RUNNING THE WORKLOAD CONCURRENTLY
31834611SR21.1CHAOS_V2 - TRC - QERTBRANGEMAP - ORA-600 [12701]
31960603PRO*COBOL COMPILATION IS GENERATING SEGMENTATION FAULT AFTER APPLYING PATCH 28704412 ON 18C ORACLE CLIENT
31974187ORA-07445 [MDCGPP()+83]
32012400ACCESS ADVISOR IS FAILING WITH ERROR ORA-13602 FROM OEM PARAMETER RETAIN_UNIQUE_INDEX
32017570INTERMITTENT ORA-03106 ERROR FROM OCI APPLICATION
32104578IMPROVE DIAGNOSTICS FOR HSM CONNECTIONS
32122804PET ORA-7445 [ATBFMEXDOMETADATA] WHILE EXCHANGE PARTITION
32166950CORRECT VALUE OF REQUIRED_MIRROR_FREE_MB AND USABLE_FILE_MB FOR EXADATA SYSTEMS
32196943XF21.3ADBD_FLASHBACK_TABLE - TRC - KSLILCR - ORA-7445 [KGHCLN_INT()]
32224140CONVERT ASSERT TO PDB SPECIFIC IN KPDBAOPENCLOSERECOVERCBK
32233406INCORPORATE DIAGNOSTICS FROM SRDC FOR ORA-4023 INTO THE PRODUCT
32234148BETTER DIAGS ON AN ORA-60 (DEADLOCK)
32240272CALL KZSRCRL CONDITIONALLY ONLY FOR OGG AND XSTREAMS
32255529ASMCMD CREDVERIFY DOES NOT DETECT CREDENTIAL PROBLEM WHEN ASM IS RUNNING
32255762PERF_ENH ENHANCEMENTS TO HINT USAGE REPORT IN 19C
32258388LOGMINER SESSION ACTION MISSING DATA FOR CDB SUPPORT
32294031JSON_VALUE FAILS WITH ORA-29903, ORA-20000, DRG-00100 [50600],[DRED.C],[1927],[]
32338919PERFORMANCE ISSUES WITH NFV4.
32371828DUP REARCH FOR DUPLICATED, DEFAULT VALUES OF A COLUMN DOESNT GET PROPAGATED TO SHARDS
32449909TPCDS BLOCKCHAIN COMMIT TIME PERFORMANCE NEED TO BE IMPROVED AFTER THE LOAD
32506166PIPE FILE DESCRIPTOR LEAK EACH TIME USING EXTERNAL JOB
32514516STRESS FA MEM FMW12C MEMORY LEAK IN AQJMSDESTINATION CLASSES
32535156INSERTS INTO BLOCKCHAIN TABLE HAVE UNCESSARY OVERHEAD
32550894HEAVY WAITS ON LIBRARY CACHE MUTEX X WHEN INSERTING INTO A BLOCKCHAIN TABLE
32556311ADD WARNING IF GCS_SERVER_PROCESSES PARAMETER SET VALUE IS LOWER FROM DEFAULT
32593877BLOOM FILTER IS NOT CHOSEN DUE TO MISSING PARTITION LEVEL STATISTICS
3260609319.9 ORA-07445 EXCEPTION ENCOUNTERED CORE DUMP [KKQTUTLGETFIRSTCOL()+20]
32609512CRASH ON KOXSS2GPAGE ON CROSS-CONTAINER VIEW WITH XMLTYPE
32625160WRONG RESULTS WITH WHERE WITH AN IN WITH MULTIPLE VALUES AND JSON_VALUE INDEX
32649737SELECT * FROM DBA_DIRECTORIES IN PDB RETURNS ORA-12801,ORA-48189
32682586DBA_TABLESPACE_USAGE_METRICS DOES NOT SHOW UNDO TABLESPACE WHEN UNDO_TABLESPACE VALUE IS LOWER CASE
32705734XF23.1MFSR_VERSIONS_QRY - TRC - KJBDOM_ENABLE_PDBISOLATION_CHKS - ORA-700 [KJBDOM_ENABLE_PDBISOLATION_CHKS ENQS]
32712791ADD TRACING IN KKQCTTCALO()
32726772LMS PROCESS HUNG IN KJCSSBA_PREALLOC() WAITING FOR GES MESSAGE BUFFER ALLOCATION
32732179TXTCDB ORA-14552 CANNOT PERFORM A DDL, COMMIT OR ROLLBACK INSIDE A QUERY OR DML
32737827IMPROVE THE DIAGNOSIS IN METHOD KZEKMRTK FOR THE ERROR ZTERR_KEY_NOT_FOUND
32802926QUERY ON V$DATAGUARD_STAT TAKES A VERY LONG TIME AFTER UPGRADING TO 19C FROM 11.2.0.4
32804609ATP DG REINSTATE OPERATION TERMINATES W/ CDG-50301 - FAILED TO REINSTATE ONE OR MORE INSTANCES
32848060LNX-21.3-RDBMS ORA-29770 GLOBAL ENQUEUE PROCESS IS HUNG AND INSTANCE TERMINATED.
32852484EMIT INFO MESSAGES IN THE ASM ALERT.LOG WHEN DISKGROUP SPACE USAGE EXCEEDS EXADATAS RESERVED SPACE REQUIREMENTS
32856640COLUMN_AUTH_INDICATOR WITH LEFT JOIN RETURNING NULL INSTEAD OF 1/0
32868344AIM ORA-600 [QKAINITGRPFNS.3] - QKAINITGRPFNS
32874225EXASCALE WHEN IN CLOUD MODE, SKIP VAULT OPERATIONS
3291361019C OLS SESSION LABEL FOR USER THROUGH A TRUSTED PACKAGE WITH FULL PRIVILEGES SHOWS NO ROWS
32920489ORA 7445 [KJDR_PRM_SCAN] WHILE RUNNING CUSTOMER WORKLOAD WITH ASO
32926653ORA-47306 ERROR WHEN TRYING TO ALTER USERS PASSWORD SINCE UPGRADE FROM 12.2 TO
32936537SIGNIFICANT CONTENTION ON LIBRARY CACHE MUTEX X WHEN FIRST INSERTING INTO A TABLE
32940440ORA-12154 SHOULD GIVE MORE DETAIL
32943694TT23.1ASAN GLOBAL-BUFFER-OVERFLOW IN PGA AT KJXBSTATREQ+3773
32947268ERROR ORA-16625 GENERATED AFTER SWITCHOVER
32958616OPTIMIZE CONTROL FILE I/O UNDER KCCREC_RBL<-KCCREC_READ_WRITE<-KCCUGG?KCCGTS?KRTCKTT?KPDBASWITCHOPENCLOSE
32961142POSSIBLE SEGVS IN KDZK* ON SSE4/AVX/AVX2/AVX512 PLATFORMS
33001615CN DEADLOCK LIBRARY CACHE LOCK=LIBRARY CACHE LOCK? (CYCLE) AFTER UPGRADED TO 19.10.
3300524119CCUSTOMERUPGRADE ORA-00600 [KDSGRP1]
33022926AIM ORA-600 [16607] - QMXTKISNONPUSHABLELOBCOL
33025005LATCH CACHE BUFFERS CHAINS AFTER UPGRADE FROM 12.1.0.2 TO 19C
33034846VSS BACKUP THROWS ORA-959 IN CDB MODE - BACKUP CODE WAS NOT HANDLING PDB NAMES CORRECTLY
33038120LARGE NUMBER OF PDB DOMAIN REQUEST QUEUES LATCH GETS DURING PDB FAILOVER
33047645ORA-600 [KCSGSSN8_2]
33048074GDSCTL PRCR-1207 THERE ARE NO RUNNING RESOURCES TO STOP, SAME AS BUG 31532308
33061595SQL TUNING ADVISOR FAILED WITH ORA-56900 FOR SQL WITH HIGH NUMBER OF BINDS
33065343SOME ORA ERRORS IN 0 TO 65535 RANGE ARE MISSING CAUSE OR ACTION
33065526ORA-00600 [KTCRAB CALLER PASSED INVALID XCB] DBMS_SQLCONTROL_INTERNAL
33069889GETTING ORA-28113 POLICY PREDICATE HAS ERROR IN RESYNC WHEN DATA VAULT IS ENABLED.
33075093HEAP MEMORY ISSUE WHEN USING THE JDBC 21C DRIVER DUE TO LRUSTATEMENTCACHE
33080651OCI PROD - LAUNCH ISSUE - WHEN AQ IS FAILOVER TO SECONDARY NODE
33088863AIM ORA-600 [KSFDFIDS2] - KSFD_ODMFIDS
33089096AFTER UPGRADE TO 19C , SEVERE PERFORMANCE DEGRADATION FOR QUERIES.
33090127Fix for Bug 33090127
33116481FSFO RESULTED TWO PRIMARY DATABASES, DATA LOSS AFTER RECREATING THE OLD PRIMARY FROM NEW PRIMARY.
33120920AIM ORA-600 [KOKLGETLOCANDFLAG BNDPOS] - KOKLGETLOCANDFLAG
33121934IAD E23POD LIBRARY CACHE LOCK / LOAD LOCK / MUTEX X DURING CONNECTION STORM
33132050DATABASE IO ERROR WHEN ENABLING DNFS WITH NFSV4.1
33135374RS-700 [OFFLOAD SERVER TERMINATED DUE TO HIGH MEMORY CONSUMPTION]
33136601ENABLE RESET OF FORCED INDIRECT SENDS AFTER TIMEOUT OF DLM MESSAGE SEND.
33142479OPTIMIZE RS PRIORITY BUMP DURING RECONFIG BUMP AFTER ACKING FREEZE, INITIATE BUMP VERY EARLY
33146001TRANSIENT ORA-00604 IN DRC LOG DURING STANDBY STARTUP
33147065XSTREAM LOSES PRECISON FOR INTERVAL AND TIMESTAMP DATA TYPES
33161424ENHANCE ORACLE HIVE METADATA TO DETECT HIVE TRANSACTIONAL TABLES FOR DD VIEWS
33179718A WAY TO ADD OPCODE IN HANG ANALYZE DUMP WHEN CROSS INSTANCE CALL RELATED WAIT EVENTS ARE INVOLVED
33181349SESSION POOL FOR LOCAL SERVICE FAILS WHEN MULTIPLE TABLE FAMILIES ARE PRESENT
33186650REGRESSION TRACKING BUG FILED FROM MERGEREQ
33189199ERROR 16198 FOR LAD2 AFTER STANDBY DATABASE RESTART [HUNG I/O]
33190761AH IMPROVE SPIN CHECK DIAGNOSTICS AND HANDLE SAGEASM-E HIT ORA 600 [KCBBPIBR_WAITALL_2]
33195897ADD RETURN CHARACTER WHEN PRINTING BEFORE IMAGE SCN
33201415AQ Notification not Working when DMLs Replicated with Goldengate
33203951AIM ORA-7445 [RI_RESMNGR_ADD] - RI_RESMNGR_ADD
33205229PHX E7POD QSUEFF3YZUQPQE7_CELL1OCNSDB GOLDENGATE EXTRACT IS WAITING FOR ARCHIVE LOG FROM AUG 1ST
33216590SELECT GROUP BY FAILS WITH ORA-7445 [EXPCHECKEXPREQUIV()+342] [SIGSEGV]
33241118JED E1POD RMAN IS NOT RESTORING THE RIGHT FILES WHEN PITR BELONGS TO ORPHAN INCARNATION
33241692LOTS OF CHECKING SER BIT VECTOR MESSAGES IN ALERT LOG
33245879JSON_VALUE INDEX NOT PICKEDUP BY JSON_EXISTS WHEN THERES AN ARRAY ELEMENT IN THE PATH
33254019PREREQ CHECK FAILS IF A PDB HAS AN EXTRA PATCH TO BE INSTALLED (IN COMPARISON TO ROOT IN RU)
33261707ORA-600 [KGHSTACK_FREE1] KFKBESTEFFOFFLN RTI 24514376
33278440IMPROVE DIAGNOSTICS IN DBMS_AUDIT_MGMT.SET_LAST_ARCHIVE_TIMESTAMP PROCEDURE
33282502ADD TESTS TO LRG OF SANITY_CHECKS
33282504ADD TESTS TO LRG OF SANITY_CHECKS (SECOND BUG)
33289734UNIFIED_AUDIT_POLICIES COLUMN IS EMPTY FOR CERTAIN AUDIT RECORDS FOR PRIVILEGE AUDITING(CREATE VIEW PRIVILEGE)
33292429WRONG STATS (NUMBER OF DISTINCT KEYS) ON COMPRESSED SECONDARY INDEXES
33294123KZTDE IS THE DIAGNOSTIC TAG WHICH SHALL BE PREFIXED TO IMPROVEMENTS DONE AS PART OF 33115438 AND 33023671
33305175ORA-00600 INTERNAL ERROR CODE, ARGUMENTS [KGHSSC_GETBUF]
33308736DATAPATCH HANGS AS CATCON TRIES TO START MANY PROCESSES IN EXA ENVIRONMENTS
33309324NEED ASMCMD CREDFIX TO HANDLE FAILURES WHEN IMPORTING CREDENTIALS INTO OLR
33312932DISABLE RDMA REGISTRATION ON STORAGE DEVICES IF RDMA REGISTRAION WERE TO FAIL
33315230INMEMORY 1MB POOL SPACE LEAKS
33316815AIM ORA-7445 [KKOIOP] - KKOIOP
33317740AH DB23 PROJECT 84763 CONSIDER CONVERTING ORA-600 [KCBZPBUF_3] SEEN IN DBWN TO PDB-SPECIFIC ASSERT OR SOFT ASSERT
33317752AH DB23 PROJECT 84763 CONSIDER CONVERTING ORA-600 [KCBZIB_6] SEEN IN SMON TO PDB-SPECIFIC ASSERT OR SOFT ASSERT
33319065EJAM GSI- PERFORMANCE ENTIRE POD-ORA-04036 PGA_AGGREGATE_LIMIT ISSUE
3332045519.10 ENQ DX - CONTENTION WHEN AUTONOMOUS PROCEDURE OVER DBLINK HANGS
33329192DDL REPLICATION ERROR AFTER CHANGING AN EXPIRED PASSWORD IF PASSWORD VERIFY FUNCTION EXISTS
33334957SUBQUERY IN CURSOR REFERENCES MATERIALIZED SUBQUERY IN WITH GIVING WRONG RESULTS
33339444NO PERMISSION TO ACCESS PMEM FILESTORE USING FUSE WHEN ORACLE SERVER BINARY IS SETGID TO A DIFFERENT GROUP
33339868AQ 10852 TRACES DUMPS NULL MSG ID ALWAYS FOR DEQUEUED MESSAGES
33345269DUPLICATE ALERT.LOG IF ORACLE_PATH IS SET
33352740VERY HIGH WAITS WAITING FOR RMAN BACKUP & RECOVERY IO AFTER UPGRADE TO 19.11
33367076MAKE KGI ASSERTS USEFUL FOR MITIGATION.
33370332SKIP PDBS THAT DO NOT HAVE FDA ENABLED TABLES
33376694IN 19C ANALYTICAL FUNCTION LAG RETURNS A VALUE FOR THE FIRST ROW WHEN NORMALLY A NULL IS EXPECTED
33380058LOGMINER BUILDER PROCESSES SHOW HIGH CPU EVEN THE EXTRACT IS IDLE
33381839ADB-D - EXPDP FAILED WITH ORA-62612 OPERATION DISALLOWED; COLUMN WITH ROWID TYPE CANNOT BE CREATED IN ORACLEAUTONOMOUS DATABASE CLOUD
33389651AV QUERIES CREATE NEW CHILD CURSOR DUE TO BIND_EQUIV_FAILURE (BIND MISMATCH)
33390717AH DB23 PROJECT 84763 CONSIDER CONVERTING ORA-600 [KTFTDROPEXT-1] SEEN IN SMON TO PDB-SPECIFIC ASSERT OR SOFT ASSERT
33390917AH DB23 PROJECT 84763 CONSIDER CONVERTING ORA-600 [KCBTSE_POPULATE_TBSKEY_1] SEEN IN DBWN TO PDB-SPECIFIC ASSERT OR SOFT ASSERT
33390925AH DB23 PROJECT 84763 CONSIDER CONVERTING ORA-600 [KCBBXSV_NWP] SEEN IN DBWN TO PDB-SPECIFIC ASSERT OR SOFT ASSERT
33392926INSERTING JSON DATA INTO A TABLE WITH MV FAILS WITH ORA-29913, ORA-04091
33397605AIM ORA-600 [QSMOPREPLOCKNAME 1] - QSMOPREPLOCKNAME
33402361LNX64-21C ORA-7445 COREDUMP AT KSS_GET_TYPE()+6
33402456STANDBY EXPERIENCING HIGH STANDBY QUERY SCN ADVANCE WAITS.
33410321CN?ORA-06553 FROM NAMED ARG TYPE CALL FROM SQL
33418112TRACKING BUG FOR LRG 24619245 - CELL HANDLE LEAK
33418443ORA-06553 PLS-801 ORA-06544 ORA-00600 [15419] [78405]
33420096NO WAY TO DISABLE IO MONITORING IN DRF
33421440AWR IO STATS AND V$IOFUNCMETRIC AND SHOWING WRONG VALUE AFTER 19.10
33422877GSM SEND MALFORMED ONS FAN MESSAGE FOR SERVICEMEMBER EVENTS WHEN IT HAS ORPHANED BUDDY REGIONS
33424192XMLFOREST IN 19C CAUSING ORA-07445 [QCTCPQBL()+68]
33427991ORA-600 [KJRBKTHK MASK], [.JWH], [0] CRASH ASM INSTANCE AFTER LINUX LIVE MIGRATION ENDED
33440899PRINT MORE INFO FOR ORA-600 [KTSPFMTHWM] TSN, RDBA AND DUMP THE SEGMENT HEADER BLOCK
33441073Fix for Bug 33441073
33447015ORA-372 SHOULD PROVIDE THE ABSOLUTE FILE NUMBER INSTEAD OF RELATIVE FILE NUMBER
33447957HIGH LIBRARY CACHE LOCK AND LIBRARY CACHE MUTEX X WAITS AFTER APPLYING 19.11 DB RU WHICH HAS BUG 30220932 FIXED
33460870RHP DELETEHOME STOPS LISTENER RUNNING FROM DIFFERENT DBHOME
33464061TT23.1ASAN HEAP-BUFFER-OVERFLOW IN PGA AT KKZPMARKFC+405
33467715REGRESSION TRACKING BUG FILED FROM MERGEREQ
33470254UPDATE FAILS WITH ORA-00600 [13030], [20]
33480765DISABLING CURSORTRACE DOESNT SEEM TO WORK FULLY UNDER SHARED SERVER USE
33485134AFTER SHUTDOWN AND STARTUP GSM, THE GSM IS REJECTING REGISTRATION FROM ALL OF THE DATABASES
33486067KSFD_ODMCRT() IMPLEMENTATION DOES NOT RESULT IN CONTENTS OF EXISTING FILE TO BE DISCARDED WHEN KSFD_REUSE/KSFD_RESIZE FLAGS ARE SPECIFIED
33491676IMPROVE TRACE MESSAGE WHEN WALLET FAILS TO OPEN DURING MIGRATION IS IN PROGRESS
33492066DBMS_AQADM.PURGE_QUEUE_TABLE SKIPS DELETING ENTRIES FROM TIME MANAGER IOT
33492136IMPORT OF SOME TABLES WTIHOUT ACCESS_METHOD=EXTERNAL_TABLE PARAMETER ARE FAILIG
33503732ADD GCS DRM FREEZE IN ENTER SERVER MODE AS A TRUSTED WAIT EVENT IN HANG MANAGER
33504158LOW CONTROL FILE RDMA% DURING PDB OPEN DUE TO MGA BUFFER ALLOCATION SLOWNESS
33504626DBMS_SPACE_ADMIN.TABLESPACE_DUMP_BITMAPS DUMPS FFB AS CORRUPT
33505158TEST HANG. CKP INCOMPLETE DUE TO CAN NOT ENTER DLM
33513906EVEN WITH 32730701 QUERY REGRESSION ON V$DIAG_ALERT_EXT AFTER UPGRADE FROM 12.1 TO 19C
33514440SYS_REMAP_XMLTYPE OPERATOR IS CAUSING PERFORMANCE ISSUES WHEN IT COMES TO LARGE DATASETS
33516571GI PATCHING FRA EFRA2A007-FXHMR5 CRS POST PATCH FAILED WITH CLSRSC-205 FAILED TO UNINSTALL ADVM/ACFS
33517703DB WIDE HANG, SMON WAITING ON DBW
33520658SELECT TO_NUMBER CAUSING ORA-03113 END-OF-FILE ON COMMUNICATION CHANNEL
33523982BLOCK CHECKING MEDIUM DOES NOT CHECK SELF REFERENCING CHAINED CU PIECES
33525448LNX64-19.13-RAC,DB HANG AT CPU OR WAIT CPU<=LOG FILE SWITCH (CHECKPOINT INCOMPLETE)...
33527630SCRUB STOP COMMAND ISNT STOPPING SCRUB OPERATION
33527663AMDU FAILS TO DUMP METADATA FROM STRIDES > 4
33532517PRINT TSN, RDBA IN THE ORA-600 [KTUGCT CORRUPTION DETECTED] ARGUMENTS
33533269PRINT OBJN OBJD TSN BLOCK IN ARGS OF ORA-600 [6006]
33545633HOSTNAME BASED DN MATCHING DOES NOT WORK WITH HTTPS_PROXY
33553452LNX64-1913-CMT ODAVM REMOVE FILE GROUP CASCADE AS ORACLE USER FAILS WITH ORA-15260
33555482AIM ORA-600 [KJBRMNOT WN] - KJBRWREQ
33558087CBTREE CREATE FUNCTION BASED INDEX FAILS - WHEN FUNCTION RETURNS NULL
33568355TXTCDB ORA-7445 [DREDFO()+792] DURING RSI BASED TEXT QUERY EXECUTION.
33580595DD AND VAL BLOCKS SHOULD BE DUMPED TO AMDU EVEN IF BLOCKS ARE ZEROED OUT
33581395SATURN BRANCH GENERATED A DIF ON DELETE FILE OP
33584585NLSN QUERY HANG AND ASM HIT ORA-600 [KFK_IODONE_INVALID_BUFFER]
3358463719C UNIFIED AUDITING GIVING WRONG RESULT IF POLICY CONDITION IS LONG
33596056ORA-00600 INTERNAL ERROR CODE, ARGUMENTS [KSFDODM_LIBGETATTR]
33596361ORADEBUG SUBHEAP_GC SHOULD FORCE GARBAGE COLLECTION EVEN IF THE THRESHOLD IS NOT MET
33598703HIGH WAITS ON ENQ TX - INDEX CONTENTION MORE SEVERLY THAN 19.4
33601673ADD A SUMMARY JSON REPORT TO SANITY_CHECKS
33607613INCORRECT TRACING IN KRSG_TEST_GAP() ROUTINE
33617587SAGEASM-E QUERY INDIRECT EXTENT RETURNS NO ROW AFTER MIRROR SPLIT COPY IS DROPPED
33624052XF23.1IMC_FORCE_QH_SR - TRC - KJBCLOSEIMC - ORA-7445 [KJBCLOSEIMC()]
33647716ASM HIT ORA-600 [KFFBADDBLK04]
33651993ORA-15064 AND ORA-15078 WITH THE FAILGROUP TESTING FOR THE DB USING NORMAL REDUNDANCY
33663444ALTER DATABASE SWITCHOVER VERIFY GETS ORA-16467 ERROR
33664959AIM ORA-7445 [KDDLRC] - KDDLRC
33664976DIAGNOSTIC TRACING IMPROVEMENT IN SHARED CURSORS AREA UID 581
33666803ENCOUNTERS CHECKPOINT HANG WHEN DIFFERENT NUMBER OF LMS IS SET
33676296UNCONDITIONALLY SETTING SA_CACHETHIS IN NFS4.1 SEQUENCE OP CAUSES IO ERRORS WITH ONTAP
33677163Adding columns to ACDR Column Resolution enable table receives error ORA-01400 on insert
33679665DBMS_HADOOP NEEDS TO SUPPORT HIVE 3.0
33704431SHARDING DEPLOYMENT FAILS DUE TO REGRESSION IN VNCR REGISTRATION OF LONG FQDN HOSTNAME
33708958IN RAC DEQUEUES AT NON-OWNER INSTANCE SEARCH DEQUEUE LOG FOR EVERY DEQUEUE PERMANENTLY POST BOUNCE DEGRADING PERFORMANCE
3371056819.14 DBVM PROVISION DCS-10001 FAILED TO CREATE THE DATABASE PRCZ-4001 PRCZ-2103 [FATAL] ERROR IN PROCESS ?/BIN/ORAPWD
33714000FADBRWT STRESS FA ORA-07445 [KSKENFORCERUNAWAYGENCB] DURING FA BATS WORKLOAD
33727390BRING DOWN RDMA PATHS ON TCP DOWN
33727922Logminer Builder ORA-600 [krvuatla20] and Capture ORA-600 [600]
33729569PROTOCOL VIOLATION CAUSED BY ISVALID(SOCKET) RIGHT AFTER PROXY AUTHENTICATION
33729692ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FAILED IN OCI DBSYSTEM
33746114INCORRECT GAP ANALYSIS WHEN THERE ARE DISABLED REDO THREADS
33749984ADD DATABASE RESULTS IN ORA-45540 CALL TO SRVCTL FAILED WITH STATUS 1, ERRORS PRCR-1001
33751080DBMS_OUTPUT IS LEAKING PGA MEMORY 19C
3375516119.15 DBRU DROP GETTING DATAPATCH ERROR ON PDB DUE TO BUG 30910255, 32914978 (LABEL RDBMS_19.0.0.0.0_LINUX.X64_220106)
33757064OKV JOBS INTERMITTELY FAILING WITH ORA-01031 BEING RAISED BY DV CODE
33761538ORA-13200 INTERNAL ERROR [MDMRTBUILDGEODRAY 1] IN SPATIAL INDEXING
33763570AIM ORA-600 [QJSNPLSSETINT NEWNODE,!OK] - QJSNPLSSETINT
33764761SYS_CONTEXT WITH NAMESPACE RETURNS EMPTY AFER EXECUTION OF DBMS_SCHEDULER
33767425OUTPUT ADDITIONAL INFORMATION RIGHT AFTER THE MESSAGE POSSIBLE NETWORK DISCONNECT WITH PRIMARY DATABASE
33770883USERS WITH SCHEDULER AUTHORIZATION CANNOT ENABLE/DISABLE JOBS WHEN JOBS ARE PROTECTED BY A REALM
33774856IAD ORA 600 [ORA-00600 INTERNAL ERROR CODE, ARGUMENTS [KKDOILSN1], [0], [16961889]
33777176DUPLICATE DATABASE USING DNFS RESULTS ORA-16032 ORA-01264 ORA-19800
33780001BDSQL4.1.2 21C AND OSS20 BASED CELLS OBSERVE QUERY HANG WITH DOP16
33786208ORA-7445 [KKBORTC()+111] ON CREATING VIEW KU$_ATTR_DIM_JOIN_PATH_VIEW WITH TYPE
33796040ORA-600 [KJBLCWSCN !WR]
33798328SCHED HUGE NO. OF SCHEDULER JOB SLAVE TRACE FILE GENERATED IN SCHEDULER/OTHER STRESS TESTS - KGHUPR_FLG
33809062TRACKING BUG FOR REGRESSION RTI 24544369 CAUSED BY PKNAGGS_BUG-32472737 APPROVED/INCLUDED IN 21.0.0.0 ADBSBP
33810360Fix for Bug 33810360
33813849ORA-00600 WHILE TRUNCATING TABLE
33845824ENABLE EVENT BASED STACK DUMP IN KSVKILLSLAVES
33848294ORA-00600 [KQRPRE1-KQRDSTRU]
33863183EXASCALE CLIENT SIDE AGGREGATE FIXES POST 21.3
33865116REPLACE OBJ FILES IN LIBKNLOPT.A WITH FILES IN RDBMS/LIB WHILE LINKING ORACLE
33865495AH FOR DIA0, START RECONFIGURATION OR RESTART MASTER PROCESS IF DIA0 LEVEL COMMUNICATION FAILS
33867208AGGREGATE BUG FIXES FOR EXASCALE IN DB
33870373SHUTDOWN IMMEDIATE TAKES TOO LONG
33871591ORA-00600 [QCSRWAE1], JSON WITH OBJECT TYPES
33871761ENABLE DIRECT RETURN OF DLM MESSAGE BUFFERS TO LGWR PROCESS
33875167ORA-13199 WK BUFFER MERGE FAILURE
33897055TRACKING BUG FOR RTI 25101314
33902235ADD MORE DIAGNOSTICS WITH SRSNEXT ASSERTS
33909838SSS_XCPT_SAFESUSPEND TO SUSPEND THREAD IF NO LOCKS HELD
33916081Fix for Bug 33916081
33921410ORA-00600 [KCL_SND_CUR_2]/CORRUPT BLOCK DURING PREPARING FOR TRANSFER
33932721APPLYING DATAPATCH TO 19C RAC CDB DATABASE WITH DBSHAPES AS ODB1 ALWAYS FAIL
33933784Fix for Bug 33933784
33937333JDBCSTRESS UCP FCF NON-AC HA MODE JDBC CLIENT HANG WITH CORE DRIVER AND FCF ENABLED
33947516DBID NOT SET IN FLASHCACHE IOCTLS TO CELLS (REGRESSION FROM 19C)
33957025ORA-7445 IN KDST_COMPILE() OR QEESRINITOPNMUTRSET() IN 19.13 AND ABOVE WITH MULTI-BYTE CHARSET
33960647TRACKING BUG FOR RTI 25201958
33970659DBWX HANG WAITING FOR WRITE PERMISSION
33973695SPARQL QUERIES WITH GROUP BY + ORDER BY ADD REDUNDANT VALUE$ JOINS
33987170CHECKPOINT INCOMPLETE HANG PLUS ORA-00700 [KCBBXSV_NOWRITESBUF]
33987636EXPOSE HELP TEXT FOR DGPDB COMMANDS
33988974HIT ORA-00600 [KCLCHKBLKDMA_3] FOLLOWED BY [KCLALC_1]
3399098521.6 DBRU PATCH MISMATCH IN VERSION IN BUILD LABEL INFO IN TRACE LOG
34001406MVIEW CREATION WITH ON PREBUILT TABLE WITH REDUCED PRECISION CLAUSE FAILS WITH ORA-03113
34003643ORADEBUG LKDEBUG -M RECONFIG SHOULD REMASTER ALL PDBS
34023644SA_CACHETHIS IN NFS4.1 SEQUENCE OP IS SET INCORRECTLY IN BUG 33676296
34053514ADB-CC RESTORE CLONE PDB FROM BACKUP FAILED -- BACKUP PIECE ALREADY INCLUDED
34066251TRACKING BUG TO BACKPORT TXN RAMISRA_RTI-25249075 ON 21
34094291Fix for Bug 34094291
34110342TRACKING BUG FOR MERGING AZURE OAUTH SUPPORT (93576)
34113643JDK BUNDLE PATCH 21.0.0.0.220719
34139217TRACKING BUG TO UPDATE BUNDLEFCP.XML IN JUL 2022 RELEASE
34149263Fix for Bug 34149263
34164828ADD SQLPATCH_SANITY_CHECKS.PM TO COPY_SQLPATCH_FILES.PL
34183461LINUX.X64 - 19.16RU - UPGRADE PDB UNPLUG-PLUG UPGRADE FROM 12.2.0.1 AND 18.1 TO 19.16 COMPLETES WITH ERRORS DUE TO ISSUE IN BUG_32583355_APPLY.SQL
34220943REMOVE EXTRA WAIT IN KGHFRUNP ADDED IN BUG 33225584
34240339FOLLOW ON FROM 33182407
34261947LMS HIT ORA-00600[KJBLPCM !CLOCKP]
Fix Control
SQL Feature
Description
31988833:1QKSFM_CBO_31988833Enable global caching of IMC stats per original qb
32856375:1QKSFM_CBO_32856375convert simple CASE to IS NOT NULL where apropriate
32913527:0QKSFM_CBO_32913527do not populate log costs if not already populated on inspection
33323903:1QKSFM_CBO_33323903no redundant visits of query blocks for virtual column processin
32800137:0QKSFM_DDL_32800137allow sharded table reference duplicated table
32408640:1QKSFM_FIRST_ROWS_32408640correct settings when switching between Kmode and Amode
31912834:1QKSFM_JPPD_31912834skip filter push predicate into outer join subquery view for MER
32754044:1QKSFM_JPPD_32754044allow JPPD with LOB column when max_string_size = EXTENDED
33297275:1QKSFM_JPPD_33297275avoid double costing e.g. of pushed views under OJPPD
29738374:1QKSFM_MVIEWS_29738374delete orphan rows in sys.snap_logdep$ during mview refresh
32212062:0QKSFM_MVIEWS_32212062Rebuild index online with redef online
28044739:1QKSFM_OBJ_EXT_28044739allow collection iterator predicates to be pushed
32302470:1QKSFM_OR_EXPAND_32302470Try LORE after ORE rejected for subquery correlated to non-paren
32851615:1QKSFM_OR_EXPAND_32851615allow Legacy ORE correction to more cost-based ORE cases
31545400:1QKSFM_PQ_31545400Delay in setting QERTBTEMPCSH when kxttIsIMCDTEnabled is safe to
31843716:0QKSFM_QUERY_REWRITE_31843716remove expression col from frocol if NOT referenced in the query
30771009:1QKSFM_SQL_PLAN_MANAGEMENT_30771009enable adaptive cursor sharing for SPM
29413205:1QKSFM_TRANSFORMATION_29413205fix the traversal of view columns in an operator tree
33145153:1QKSFM_TRANSFORMATION_33145153allow CBQT in presense of pseudo-column
33325981:1QKSFM_UNNEST_33325981allow unnesting in some cases previously restricted
31880080:0QKSFM_XML_REWRITE_31880080disable rewrite for XMLTABLE and OUTER JOINS
32766397:0QKSFM_XML_REWRITE_32766397handle invalid characters by replacing or removing them
-- create view my_patch_view
-- as
with a as (select dbms_qopatch.get_opatch_bugs patch_output from dual)
  select x.*
    from a,
         xmltable('bugInfo/bugs/*'
            passing a.patch_output
            columns
               bug_id number path '@id',
               description varchar2(160) path 'description'
         ) x
;

execute dbms_optim_bundle.enable_optim_fixes('ON','BOTH', 'YES');

select p.value, f.sql_feature, f.description
from v$spparameter p join v$system_fix_control f
on substr(p.value,1,length(p.value)-2)=f.bugno
where p.name='_fix_control'
order by f.sql_feature;