Database Administration & Monitoring OGG: Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 18.04.2017 by Daniel Westermann Another GoldenGate 12.2 one: Some days ago I had this in the GoldenGate error log: 2017-04-12 14:56:08 WARNING OGG-02901 Oracle GoldenGate Capture for Oracle, extimch.prm: Replication of UDT and ANYDATA from redo logs is not supported with the(…)
Database Administration & Monitoring Welcome to M|17, part 2 17.04.2017 by Open source Team Welcome to the second day of the MariaDB’s first user conference On the 12th, at 09:00, started the first-ever experimental MariaDB Associate certification exam and I was glad to be among the first and participate(…)
Application integration & Middleware Listing the extensions available in PostgreSQL 17.04.2017 by Daniel Westermann When you follow this blog regularly you probably already now that PostgreSQL is highly extensible. There are quite a couple of extension which ship by default and are ready to use. How can you know what is(…)
Database management SQLcl on Bash on Ubuntu on Windows 16.04.2017 by Oracle Team By Franck Pachot . I'm running my laptop on Windows, which may sound weird, but Linux is unfortunately not an option when you exchange Microsoft Word documents, manage your e-mails and calendar with Outlook and present with Powerpoint using dual(…)
Database Administration & Monitoring In-core logical replication will hit PostgreSQL 10 13.04.2017 by Daniel Westermann Finally in PostgreSQL 10 (expected to be released this September) a long awaited feature will probably appear: In-core logical replication. PostgreSQL supports physical replication since version 9.0 and now the next step happened with the implementation of logical replication. This(…)
Database Administration & Monitoring 8 + 1 = 9, yes, true, but … 13.04.2017 by Daniel Westermann Btw: If you really would do that (the screen shot is from 12.1.0.2): SQL> alter system set sga_target=210m scope=spfile; System altered. SQL> alter system set sga_max_size=210m scope=spfile; System altered. SQL> alter system set pga_aggregate_target=16m scope=spfile; System altered. SQL>(…)
Database Administration & Monitoring Oracle 12c – Why you shouldn’t do a crosscheck archivelog all in your regular RMAN backup scripts 13.04.2017 by Oracle Team By William Sescu Crosschecking in RMAN is quite cool stuff. With the RMAN crosscheck you can update an outdated RMAN repository about backups or archivelogs whose repository records do not match their physical status. For example, if a user removes(…)
Application integration & Middleware Using WebLogic 12C RESTful interface to query a WebLogic Domain configuration 13.04.2017 by Middleware Team WebLogic 12.2.1 provides a new REST management interface with full accesses to all WebLogic Server resources. This new interface provides an alternative to the WLST scripting or JMX developments for management and monitoring of WebLogic Domains. This blog(…)
Database Administration & Monitoring Welcome to M|17 13.04.2017 by Open source Team Welcome to the MariaDB’s first user conference On the 11th, started at 09:00 this big event at the Conrad Hotel in New York, closed to the One World Trade Center After the short registration process where we(…)
Database Administration & Monitoring Failed to set logmining server parameter MAX_SGA_SIZE to value XX 12.04.2017 by Daniel Westermann When you see something like this in your GoldenGate error log when you try to start an extract: 2017-04-12 14:51:38 ERROR OGG-02039 Oracle GoldenGate Capture for Oracle, extxxx.prm: Failed to set logmining server parameter MAX_SGA_SIZE to value 24. 2017-04-12 14:51:38(…)