Blogs
This blog begins with:
“Today when checking a recently installed server with Oracle Linux 7.9 and ASM 19.17 with ASMLib, we found that when performing any reboot on the server, ASM could not mount the disks.”
Read how the fix was applied!
Nikhil shares the script used to perform the healthcheck of a database.
3. Analytical SQL – Running Total – Order by without Partition By
This is the third post of a series on Analytical SQL.
The first two posts can be found:
Analytical Function without Window Clause
Analytical Function Partition By
4. Oracle Transparent Application Continuity (TAC) – Part 1 (TAF)
This is Part 1 after a question was asked whether DMLs will be failed over to surviving instance if one of the instance in a Oracle RAC is crashed.
In the next post, they will cover:
“Now, what if a batch job runs in the database performing millions of DML and then the node is crashed? This could happen and mostly it’s not by software error but sometimes due to patching window where applications are not appraised of the schedule, issues with underlying OS or storage causing DB node to crash, etc,. What would be the condition of the database sessions? Will the DMLs continue to run on the other surviving node? Do we have any automated mechanism to take care of this situation for us? “
5. How to unlock an account in the Oracle database
This article explains how we can unlock a user account in an Oracle database. As a database administrator, managing the security of the database is a crucial task. The DBAs must keep track of all successful and failed authentication in an Oracle database.
6. Fluid Page Naming Conventions
Jim Marion recommends the following name pattern:
7. How To Connect With HR User In Oracle Database 21c
This blog begins with:
“The first thing that comes to the mind of a developer after installing the database is “How to connect with it?” In the Oracle Database ecosystem we connect with the database through Schemas also called Users. This could be a user-created schema or a sample schema. I will use the sample schema for the demonstration and show you how to connect with it.”
This blog begins by saying:
“Each of the following video clips were recorded by me, Mark Daynes, and are designed to show ‘something interesting’ using Oracle Analytics Cloud (OAC) in a very short time period, typically around a minute. Most examples are focused on visualizations elements. Whilst these were created using OAC, a lot will also apply to Oracle Analytics Desktop“
9. Oracle Cloud Infrastructure Quick Tip – Unlock the Windows OPC User Account
Martin Berger says, “Today, after testing some Oracle Cloud Infrastructure firewall changes and login tests into a running Windows 2019 Server, the account of the administration user opc was locked. The referenced account is currently locked out and may not be logged on. And now? There was no other user available with administrator privileges to unlock this account. We have basically two methods to solve the issue.”
10. How To Trace GoldenGate To Find Bad Code
Find out how to trace bad code in this short blog.
Paper.li
Stories from: databasesecurityninja.wordpress.com, obieeil.blogspot.com and andrejusb.blogspot.com
Videos such as:
Redefining talent retention: trends in employee experience I Oracle Trending Topics–Episode 3
Donut ML Model Fine-Tuning with Hugging Face API