UxOra - Unix and Oracle tech notes
Welcome to UxOra (=Unix+Oracle),
This website publishes technical notes on Unix and Oracle especially as a DBA point of view.
Please read the article writing conventions first.
I hope it may help you.
This article will show to configure a simple lightweight local DNS with DNSMASQ in Oracle Linux 7.
This is handy for a small private network and quite useful for a oracle homelab, especially to resolv hostname and domain name.
After installing Oracle Enterprise Linux 7 (OEL7) virtual machine on VirtualBox (as explained here), I would recommend to install the VirtualBox Guest Additions.
For any serious and interactive use, the VirtualBox Guest Additions will make your life much easier by providing closer integration between host and guest and improving the interactive performance of guest systems.Virtualbox
This article will show step by step how to configure a virtual machine on VirtualBox in order to install Oracle Enterprise Linux 7 (OEL7).
Before going through those steps, you will need to have:
- Oracle VM VirtualBox installed, it can be downloaded from virtualbox.org
- OEL7 (V46135-01) iso image, it can be downloaded from edelivery.oracle.com with a free oracle account
(warning: images-intensive article)
In older ksh or bash, the builtin command
getopts can usually only handle short option.
But newer Korn shell may be able to handle long options as show in an other article.
If you don't have the chance to get a recent shell, or if you want to write more portable script, this article will show how to handle GNU-style long options (
-- double hyphen) using getopts with few extra lines of scripting.
(foobar_any_getopts.sh zip file attachement in this article)
In recent Korn Shell ksh93,
getopts can be more powerful than you think, it can :
- naturally parse short and long options with error management
- manage option value as optional, as mandatory or as numeric
- auto generate man page alike
This article will show how to use
getopts in recent ksh93. If you have older ksh, read this other article instead.
(foobar_getopts.ksh zip file attachement in this article)
It's sometimes painful to create a shell script from scratch ...
So here is a script template that can help to start any good shell script.
This template contains header which is use for usage info as well, useful predefined functions and predefined variables, and manage short and long options.
(template.sh zip file is attached in this article)
This article will gives some advices for making a RMAN backup in the right way based on my experience.
This article will present a custom shell script to install oracle software : grid infrastructure and rdbms 11g/12c.
This is a korn shell script I created for educational purpose, you are free to use and change it at your convenience.
(ora_install_software.sh.zip file attachement in this article)