Profile cover photo
Profile photo
Martin Berger (berx)
716 followers -
of course I do not look busy, I did it right the first time
of course I do not look busy, I did it right the first time

716 followers
About
Posts

Post has attachment
SQL Real Time Monitoring pure HTML report (thanks to SQLDeveloper 18.3)
Yesterday (from the writing of this post perspective) SQLDeveloper 18.3 came out. (it seems SQL Developer does not strict follow Oracle Database Release Number schema, otherwise it must be 18.4 already as it's released in 4th quarter of 2018) There are many...
Add a comment...

Post has attachment
seing your DB as it was some minutes ago
Last week during a discussion with a colleague we thought if it would make sense to have in SQLDeveloper the possibility to see the system "as it was some minutes ago". Small errors can happen and also resource control isn't always perfect in every company....
Add a comment...

Post has attachment
TFA reports full dba_feature_usage_statistics to MyOracleSupport
Those who deal with MyOracleSupport (MOS) regularly will have noticed their demand for Trace File Analyzer ( TFA ) diagnostic collections. Few will know they are also providing a full content of their DBs DBA_FEATURE_USAGE_STATISTICS view; at least when run...
Add a comment...

Post has attachment
RBAL process needs to release FORMER disk
Oracles Automatic Storage Management ( ASM ) has many nice advantages against other volume managers. One of my favorite is to add and remove or rebalance disks without any interruption for the database. Unfortunately the remove of devices after the rebalanc...
Add a comment...

Post has attachment
unwanted cleanup in /var/tmp/.oracle
In my previous blog missing oraagent.bin process I raised a question: why does files in  /var/tmp/.oracle disappear?  At least this question I am now able to answer. By the help of Linux kernel's audit system and a proper rule: -a always,exit -F arch=b64 -S...
Add a comment...

Post has attachment
missing oraagent.bin process
It all started with a small error when I tried to stop/start a service: srvctl start service -d cmpp01_site1 -s cmpp01 PRCD-1084 : Failed to start service CMPP01
PRCR-1079 : Failed to start resource ora.cmpp01_site1.cmpp01.svc
CRS-2680: Clean of 'ora.cmpp...
Add a comment...

Post has attachment
enabling Database Vault on e-business RAC database
Right now I'm in a process to setup Database Vault for an E-Business suite database. This is a 2 node RAC cluster. The DB is 12.1.0.2 with April 17 BP. As the DB exists already, I followed How To Enable Database Vault in a 12c database ? (Doc ID 2112167.1) ...
Add a comment...

Post has attachment
OUD - no operational route
Oracle Universal Directory is by far not my preferred tool. Probably it's me, I'm just not used to it. The latest joy was an error when I tried to run eusm addDatabase and I got javax.naming.AuthenticationException: [LDAP: error code 49 - Invalid Credential...
OUD - no operational route
OUD - no operational route
berxblog.blogspot.com
Add a comment...

Post has attachment
when it runs on your computer ...
... please don't see it ready for customers. I try to enable Database Vault on an existing 12.2 database. A proper document to follow is How To Enable Database Vault in a 12c database ? (Doc ID 2112167.1) At some point it tells to run @$ORACLE_HOME/rdbms/ad...
Add a comment...

Post has attachment
preupgrade.jar version number
Mike Dietrich is very motivated to convince everyone who wants to take Oracle database upgrades serious to use always the latest version of preupgrade.jar . Some parts of Note:884522.1 - How to Download and Run Oracle's Database Pre-Upgrade Utility  are mis...
Add a comment...
Wait while more posts are being loaded