(savvinov) Every upgrade is a bit of a lottery. But for a long running, well established system with a lot of legacy code, it can be more of a Russian roulette.
Tag: Oracle
Apache Traffic Server (ATS) Returning 403 For DELETE HTTP Requests
(James Coyle) Here is a quick snippet which solves an issue I ran into today. I’ve recently set up Apache Traffic Server to reverse proxy requests to various Docker containers. It all works great and runs itself in Docker.
Dataguard and LOG_ARCHIVE_MAX_PROCESSES
(Bryan Grenn) Any DBA who has set up Dataguard has seen this diagram of how the sending of logs to standby database works.
A refreshing look at PIVOT
(Connor McDonald) We had an AskTOM question come in recently where our customer was very excited about the PIVOT operator in SQL which lets you transpose rows to columns.
Java Development with Autonomous Transaction Processing Dedicated (ATP-D)
(Kuassi Mensah) The Oracle Autonomous Transaction Processing Dedicated (ATP-D) is a database Cloud service which allows implementing a private database Cloud service running on dedicated Exadata Infrastructure within the Oracle Public Cloud.
Permanent URLs for the Latest Instant Client Packages
(Christopher Jones) Permanent URLs that download the latest Oracle Instant Client packages are now live on OTN. Instant Client packages give you free, light-weight, and easily installed Oracle Database tools, libraries and SDKs.
Using Oracle Gold Images
(Liron Amitzi) After OOW19 I looked into using GI gold images to upgrade a few databases at a client’s site. The client has 11 data guard environments (and they both use ASM), so using gold images would really help.
Oracle Forms 12.2.1.4.0 – New Security Handling for userid
(Dirk Nachbar) In the latest Oracle Forms 12.2.1.4.0 Release, Oracle has implemented a new cool feature for security handling of the userid parameter.
CVE-2019-2638, CVE-2019-2633, Oracle Payday Vulnerabilities – AppDefend Protection
Two Oracle E-Business Suite security vulnerabilities (CVE-2019-2638, CVE-2019-2633) fixed in April 2019 Oracle Critical Patch Update (CPU) have been recently publicized.
Simple getTracefile
(Martin Berger) Tracefiles are a very valuable source of information in Oracle databases.