JS.OracleDatabase v0.2.2.3 is out of the oven!

Hello fellow technocrats, automation lovers and PowerShell enthusiasts! Only a few days go I uploaded to the PowerShell Gallery Site the new alpha version of my Oracle Database Client-based Module. Here's a summary of the functions you can find in it. PS > Get-Command -Module JS.OracleDatabase CommandType Name Version Source ----------- ---- ------- ------ Function …

Continue reading JS.OracleDatabase v0.2.2.3 is out of the oven!

JS.OracleDatabase: I got it, now how do I use it?

Welcome my much appreciated readers! I want to tell you that if you have made it here so far, you are on my team. The unsettled ones that always look for improvement. I'll be posting some scripts and samples on my PowerShell GitHub Repo. I'm quite sure you'll find some interesting ideas there. Feel free …

Continue reading JS.OracleDatabase: I got it, now how do I use it?

PowerShell + Oracle Client = Awesome Module

Hello everyone! At first I was reluctant to try PowerShell, you know, being a Oracle on Linux DBA gets you fully used to the Linux ecosystem and going for PowerShell meant relying on Windows and .Net to do what I was comfortable doing by leveraging Linux, Korn Shell and the Oracle Client on Linux. But …

Continue reading PowerShell + Oracle Client = Awesome Module

How to avoid plain-text passwords in shell scripts

Hello fellow DBAs and readers, today I want to share with you a good option to avoid having plain-text password on storage as part of scripts or automation efforts. A few months ago, I discovered an issue with a plain-text password sitting there in a script. Most of the people I talked about it disregarded …

Continue reading How to avoid plain-text passwords in shell scripts

AWR: Same SNAP ID, Different Dates

Hello everyone, Recently I ran into an interesting issue. I created a script to automatically generate AWR + ADDM reports by asking only for the start and end timestamps. Basically the script looks for the minimum and maximum SNAP_IDs between the start and end times in order to get comprehensive information out of the AWR. Everything …

Continue reading AWR: Same SNAP ID, Different Dates