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…Read More >
The new functionality to download latest patches or either apply saved ones came with installer of Oracle 126.96.36.199 (Software Updates Option) It can be used not only through OUI but with silent installation too. There are several options and variables…Read More >
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.Read More >
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 188.8.131.52 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
I was co-presenting recently at Sydney Oracle Meetup about Data Guard Compression and in preparation I did
some tests to see how it works for 184.108.40.206 (Linux x86-64). Here are my results.
One of the first questions that I asked myself when EM GC 11g came out is how would a silent installation go especially taking into account the use of WebLogic server as the http server. But before any attempt of silent installation I started the GC 11g GUI installation to local VM machine
(Oracle Enterprise Linux 5.4 64-bit) with an allocated 2Gb of memory and got errors since WebLogic server was not installed there.
When Oracle announced Oracle 11.2 for Solaris (x86-64), I decided to try a silent installation of Oracle on OpenSolaris, even though it is not certified. I downloaded the Solaris ISO and installed it as 64-bit on one of my virtual machines without a problem, I was soon enjoying OpenSolaris. I eventually stopped admiring the good-looking interface and connected through a plain old black-and-white ssh terminal to execute the silent installation. Based on the silent installation that I had earlier executed on Linux for 11.2, I started the following…Read More >
I had had some experience with silent (and not always successful) installation of Oracle versions 8 and 9, but thanks to an excellent post, Oracle Silent Mode, Part 1: Installation Of 10.2 And 11.1 Databases by Grégory Guillou, I got a new splash of joy using silent installations. RDBMS, Oracle Grid Control, agents, scheduler agents, collaboration software, etc., can be installed using the silent installation in latest versions. This post is about silent installation of one of the new Oracle 11g Rel.2 options called Oracle Restart.Read More >