Infrastructure at your Service

dbi services BLOG

Welcome to the dbi services Blog! This IT blog focuses on database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, EMC Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on our blog postings.

Franck Pachot

SQLcl on Bash on Ubuntu on Windows

By | Database management | No Comments
 

 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 screen (I want to share on the beamer only the slides or demo screen, not my whole desktop). However, I have 3 ways to enjoy GNU/Linux: Cygwin to operate on my laptop, VirtualBox to run Linux hosts, and Cloud…

Read More
Daniel Westermann

In-core logical replication will hit PostgreSQL 10

By | Database Administration & Monitoring | No Comments
 

 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 will be a major help in upgrading PostgreSQL instances from one version to another with no (or almost no) downtime. In addition this can be used to consolidate data from various instances into one instance…

Read More
Daniel Westermann

8 + 1 = 9, yes, true, but …

By | Database Administration & Monitoring | 2 Comments
 

  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> select banner from v$version; BANNER ——————————————————————————– Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production PL/SQL Release 12.1.0.2.0 – Production CORE 12.1.0.2.0 Production TNS for Linux: Version 12.1.0.2.0 – Production NLSRTL Version 12.1.0.2.0 – Production…

Read More
William Sescu

Oracle 12c – Why you shouldn’t do a crosscheck archivelog all in your regular RMAN backup scripts

By | Database Administration & Monitoring | 3 Comments
 

 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 archived logs from disk with an operating system command, the repository (RMAN controlfile or RMAN catalog) still indicates that the logs are on disk, when in fact they are not. It is important to know, that the RMAN…

Read More
Pascal Brand

Using WebLogic 12C RESTful interface to query a WebLogic Domain configuration

By | Application integration & Middleware | No Comments
 

 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 explains how the RESTful interface can be used to determine a WebLogic Domain configuration and display it’s the principals attributes. For this purpose, a Search RESTful call will be used. The RESTful URL to point to the…

Read More
Saïd Mendi
m17bannernew

Welcome to M|17

By | Database Administration & Monitoring | No Comments
 

  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 received a full bag of goodies (mobilephone lens,Jolt charger, cap,note block,…) we could choose between 3 workshops. – Scaling and Securing MariaDB for High Availability – MariaDB ColumnStore for High Performance Analytics – Building Modern Applications with…

Read More
Daniel Westermann

Failed to set logmining server parameter MAX_SGA_SIZE to value XX

By | Database Administration & Monitoring | No Comments
 

 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 ERROR OGG-02042 Oracle GoldenGate Capture for Oracle, extxxx.prm: OCI Error 23605. 2017-04-12 14:51:38 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, extxxx.prm: PROCESS ABENDING. … then you should increase the streams_pool_size (maybe you need to increase…

Read More
Morgan Patou

Documentum – Deactivation of a docbase without uninstallation

By | Entreprise content management | No Comments
 

 At some of our customers, we often install new docbases for development purposes which are used only for a short time to avoid cross-team interactions/interferences and this kind of things. Creating new docbases is quite easy with Documentum but it still takes some time (unless you use silent installations or Docker components). Therefore installing/removing docbases over and over can be a pain. For this purpose, we often install new docbases but then we don’t uninstall it,…

Read More
Franck Pachot

Service “696c6f76656d756c746974656e616e74″ has 1 instance(s).

By | Database management | One Comment
 

 Weird title, isn’t it? That was my reaction when I did my first ‘lsnrctl status’ in 12.2: weird service name… If you have installed 12.2 multitenant, then you have probably seen this strange service name registered in your listener. One per PDB. It is not a bug. It is an internal service used to connect to the remote PDB for features like Proxy PDB. This name is the GUID of the PDB which makes this…

Read More
Clemens Bleile

Trace files segmented in multiple parts as a workaround for bug 23300142

By | Database Administration & Monitoring | No Comments
 

 Today I visited a customer, who deleted a Data Guard configuration (i.e. a temporary Data Guard setup through the broker was deleted). The LOG_ARCHIVE_DEST_STATE_2 on the primary database was set to DEFER temporarily. That resulted in trace-files with name *tt*.trc to become huge (GBytes after a couple of days). Analysis showed that this was caused by bug 23300142 in 12.1.0.2. See My Oracle Support Note Bug 23300142 – TT background process trace file message: async…

Read More