Posts by Andrey Goryunov

EM CLI with Scripting Option in EM12cR3

The new release of #EM12c came with advanced EM CLI, providing interactive and script modes to enhance the standard command line functionality. EM CLI includes Jython interpreter and all verbs presented as functions, which allows the use of verb arguments as parameters. Managing several thousand targets in one of Pythian’s client environments and having different…

Silent Installation of EM Cloud Control 12c

Silent installation always attracts by its simplicity and power, the new release 2 of EM 12c proves it, making installation
smooth and straightforward. Before we start the installation, it is very important to make sure all prerequisites are satisfied
to avoid any unpredictable errors during the process. Let’s have a look.

RMAN Duplicate in Details

I took debug of duplication and figured out that RMAN internally executes procedure dbms_tts.transport_set_check preventing any further copy operations if tablespaces do not satisfy TTS requirements. Now the plot thickens and considering RMAN shows everything that it does in log file I decided to repeat the same steps but one by one and manually. Let’s get into it.

RDBMS Online Patching

If you support Oracle RDBMS 11.2.0.2 and want to zero downtime applying patches to databases then it is time to have a look at new possibility of Online Patching delivered with 11.2.0.2 version and described here.

Data Pump Monitoring

If there is no much useful information in v$session_longops and space for the segment is already allocated how to get the same “rows completed” value of worker status as in intercative mode but using sql script? With small modification of example from the documentation I came with the PL/SQL block to get value of one Data Pump Import worker status attributes…

Installer 11.2.0.2 Download Updates Option

The new functionality to download latest patches or either apply saved ones came with installer of Oracle 11.2.0.2 (Software Updates Option) It can be used not only through OUI but with silent installation too. There are several options and variables available to get patches from MOS: oracle.installer.autoupdates… MYORACLESUPPORT_… AUTOUPDATES_MYORACLESUPPORT_… Putting it all together I got…

Chopt Utility

There is a new tool came with Oracle 11g Rel.2 that helps to modify options in installed oracle home (Enabling and Disabling Database Options) It is very simple and straightforward utility that recompiles database kernel with different flags.

Oraenv in 11.2.0.2

Oraenv is great utility that helps to control environment and to avoid exact use of ORACLE_… variables in scripts. With invention of ORACLE_BASE it was enhanced to change the variable and to print the value in the output. More interesting that behaviour of oraenv in 11.2.0.2 has been changed
and now it is able to switch oracle base variables but it does not show oracle home path in the output, only oracle base

Page 2 of 3123