1.Connection to Oracle Autonomous Database
In this blog, Selvakumar Nagulan explains how to connect to an Oracle Autonomous database using SQL developer, SQL plus or other tools. He refers to this document in his blog.
2. Reading a LOB in another session
Martin Berger begins by saying, “Reading a LOB in Oracle is often quite easy: it’s just a column in the query and all the libraries available today are doing the work necessary to make the LOBs content appear in the desired variable.”
Erman Arslan starts by saying, “Forms 12C customers should know this. The jar files/the standard code delivered by Oracle is signed with the Digicert certificates and these certificates, which are there for the code signing, are used ensure the security on the client side. I won’t go into the details of how code signing works, and I suppose most of my followers already know this.
Here, I want to share something interesting.. This is based on a true story, on an issue escalated to me…”
4. Analytical SQL – Running Total – Order by without Partition By
This is the 3rd post in the series.
The first two posts were:
Analytical Function without Window Clause
Analytical Function Partition By
5. Oracle Analytic Server 2024 is Available
This blog begins with, “Oracle Analytic Server new release is available. The internal name is OAS 7.6 and the formal is OAS 2024.
If you are OBIEE or OAS owner, allow me to recommend you one thing (accept the Sunscreen part); Consider upgrading to this version. I didn’t recommend anything of the kind in previous releases. This release is expected to have a mature version data visualization, beyond the classic BI.
It is available on https://edelivery.oracle.com/ as OAS 7.6 for Linux and Windows.”
6. How To Discover ExaCC/ExaCS in Enterprise Manager
Alfredo Kriegdba writes, “In this post I want to share the required steps to discover ExaCC or ExaCS in Oracle Enterprise Manager (EM). I’ll provide as much detail as possible.”
7. Troubleshooting IPSec VPN Connections using IKEv2 in OCI
Raffi Shahabazian begins his blog with, “In this blog, we will discuss the common troubleshooting methods to diagnose and resolve an IPSec VPN connection issue dealing with IKE (phase 1). Below is an example of common IKE (phase 1) issues we generally see, the methods we can use in OCI to identify the issue, and the methods used to resolve these issues.”
8. SelectAI – Doing something useful
Brendan Tierney says, “In a previous post, I introduced Select AI and gave examples of how to do some simple things. These included asking it using some natural language questions, to query some data in the Database. That post used both Cohere and OpenAI to process the requests. There were mixed results and some gave a different, somewhat disappointing, outcome. But with using OpenAI the overall outcome was a bit more positive. To build upon the previous post, this post will explore some of the additional features of Select AI, which can give more options for incorporating Select AI into your applications/solutions.”
9. All you need to know about Oracle Real Application Testing (RAT) Part2
This blog begins with, “In this post, I’ll delve into the process of capturing RAT workloads. This post will provide insights into key considerations, best practices, implementation strategies, and essential MOS notes for RAT capture.”
10. Announcing the general availability of Oracle Analytics Server 2024
This blog starts with, “We are proud to announce the general availability of Oracle Analytics Server 2024. This release introduces over one hundred new capabilities that enhance the analytics experience across all users within an organization. New innovations enable customers to gain deeper insights from their data and take actions that result in better business outcomes.”