UxOra - Unix and Oracle tech notes
Welcome to UxOra,
This website publishes technical notes on Unix and Oracle (=UxOra) especially as a DBA point of view.
Please read the writing conventions here first.
I hope it may help you.
Michel V.
RMAN Best Practice
- Details
- Written by Michel VONGVILAY
- Category: DBA
User Rating: 1 / 5
This article will gives some advices for making a RMAN backup in the right way based on my experience.
Silent database 12c creation with dbca
- Details
- Written by Michel VONGVILAY
- Category: DBA
User Rating: 1 / 5
This article will show how to create a Oracle 12c container database (CDB), with one pluggable database (PDB), in command line with dbca and silent option.
DBCA is for DataBase Configuration Assistant, this is a tool to create/delete Oracle databases.
It can be used as GUI or as command line.
Silent install of OEM Cloud Control 12c
- Details
- Written by Michel VONGVILAY
- Category: DBA
User Rating: 3 / 5
This article will show an installation of Oracle Enterprise Manager Cloud Control 12c in silent mode (no GUI, command line only).
OEM Cloud Control 12c is a centralised management software for administrating and monitoring all oracle's products, especially oracle database.
It is quite powerful and it becomes very handy when you manage many databases, and its base features are free of charge to use.
Silent install of Oracle Grid Infrastructure 12cR1
- Details
- Written by Michel VONGVILAY
- Category: DBA
User Rating: 1 / 5
This article will show an installation of Oracle Grid Infrastructure 12cR1 in silent mode.
The Oracle Grid Infrastructure is the Oracle software that provides system support for Oracle Automatic Storage Management (Oracle ASM), Oracle Restart (for Standalone server only) and Clusterware (for Cluster only). You must install Oracle Grid Infrastructure before installing your database.
Using UDEV instead of ASMlib
- Details
- Written by Michel VONGVILAY
- Category: DBA
User Rating: 1 / 5
This article will show to use UDEV instead of ASMLib on Oracle Linux 7.
If for any reason you cannot or don't want to use ASMLib, then you can use UDEV instead. This is an alternative in order to present disks to ASM and this does not required to install an extra layer.
Oracle installation errors and fixes
- Details
- Written by Michel VONGVILAY
- Category: DBA
User Rating: 4 / 5
This article will list all errors/issues I encounter during Oracle installation with their fix.
It will be updated with all new errors I will encounter.
Handle long options with any getopts
- Details
- Written by Michel VONGVILAY
- Category: Shell Script
User Rating: 5 / 5
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)
Getopts with man page and long options
- Details
- Written by Michel VONGVILAY
- Category: Shell Script
User Rating: 5 / 5
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)
