Changing an expired database account password using SQL Developer is very easy. Just follow these simple steps.
While creating a script to send an email alert when a linux accounts password is about to expire, we needed to determine the number of days remaining before expiry. A quick search of Google surprisingly returned only methods that access /etc/shadow, which is not possible for standard users. However, we did manage to come up with a solution.
After applying the October 2015 Critical Patchset Update to our databases, we discovered a number of invalid objects within the XDB and GSMADMIN_INTERNAL schemas. This article provides the steps needed to ensure these objects compile successfully.
Around 14 years ago, I switched from using Reflection to PuTTY because it was free and my employer at the time wouldn’t pay for such extravagance software purchases such as a simple terminal emulator! Since then I’ve become rather accustomed to the way PuTTY behaves, and find Reflections particularly annoying to use on the occasion that I visit a client who insists on using it.
However, it is possible to solve most of the biggest annoyances…
I have been running Windows 10 for a while now and every other day or so, I get the Security and Maintenance notification show regarding "disable apps to help improve performance". After a bit of hunting around, I have finally discovered how to disable this notification from appearing any more.
A number of older ScanSnap scanners released by Fujitsu are no longer supported and the official line from Fujitsu is to buy new hardware. However, the ScanSnap range isn't cheap and you can avoid spending a large sum by utilizing Compatibility Mode built into Windows to get your older scanner working with the latest versions of Windows.
This guide will show you how.
Over the years I have seen and maintained many kornshell scripts written by DBAs, and there are a number of programming styles that provoke strong reactions on who is doing it the "right" way.
In this article, I will explain the different ways in which functions can be defined in Kornshell and explain why I personally prefer one method over another.