Hello fellow Oracleans!
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 then again, I don't like to be too comfortable so I decided to dive in and see what I could achieve with PowerShell. As usual, with Microsoft, expectations were high according to what the makers of PowerShell claimed that could be done. And this time, they were just right. If you want to go a little deeper on PowerShell, visit my previous post about it on my Wordpress blog.
So, today I'm here to make both an announcement and a request.
If you want to give it a test drive, just run the following commands in PowerShell and feel free to install it and use it to your best convenience.
Find-Module JS.OracleDatabase Install-Module JS.OracleDatabase
No Admin rights? No Problem, just add -Scope CurrentUser to the Install-Module command and you'll be set.
The module is currently under development and I'm adding functions as they come handy for me. I can use your suggestions to further add more functionality and options to existing functions.
Remember that this module is based on the Oracle Client programs, so it's required to have the Oracle Client installed with SQL*Plus and TNS Ping at least.
Make sure to set your environment variables and add the bin directory to the path in powershell as well.
$env:ORACLE_HOME = /path/to/your/oracle/installation $env:PATH = "$env:PATH ; $env:ORACLE_HOME/bin"
This module can be used under Windows or, if your using PowerShell Core, on Linux.