Life of an IT Infrastructure Designer

Jobacle

SQL Server Management Studio 18 won’t open

by Job | February 7, 2021 | SQLserver | 0 Comments

Yes, no Oracle today. A very short blogpost about opening SQL Server Management Studio. It didn't open, only a splash screen pops up. Found the solution at DBA Stack Exchange, but thought it would be nice to summarize this in a blog-post. Logging gave no clue:...

Oracle Enterprise Manager 13c and Always On Monitoring

by Job | July 19, 2020 | grid control, Oracle Enterprise Manager | 0 Comments

In this cloud-era it’s almost weird to explore stuff on-premises, but I did…. In this case a slightly Higher Availibility configuration of Oracle Enterprise Manager (OEM) that doesn’t cost anything, is not disruptive to the existing configuration and gives a tiny...

SQLDeveloper user preferences in a Citrix environment

by Job | July 8, 2020 | Sqldeveloper | 0 Comments

Installing software in a Citrix-environment is sometimes a hassle. You have to handover the software, installation- and test-documentation to the scripters and hope for the best. In this case I handed over SQLDeveloper 19.4 as a pretty default installation, very...

Should a standby database be considered in the cloud?

by Job | Sep 3, 2019 | Database, Standby, Uncategorized

To answer this question for your company, the criticalness of your application and database must be clear. In a High Availability Environment, a standby-database can be part of the technical solution to ensure minimum downtime for your database. But when moving...

Webinar “Oracle migration to Postgres in the Cloud”

by Job | Aug 1, 2019 | Cloud

Recently I attended a webinar “Oracle migration to Postgres in the Cloud”. It felt a bit like cheating, as I'm more an Oracle guy and my company is Oracle Platinum partner…. But very curious how easy it is to migrate (it depends…) and what hurdles to expect. The...

Oracle disaster recovery without licensing the DR site

by Job | May 12, 2019 | Database, licensing

Recently I got a question of a customer regarding a failover configuration. They wanted to install a second server acting as a failover server, switched off until the primary experiences an outage, and they don't want to pay licenses for it. By bringing the...

No more RAC in SE2 19c

by Job | Apr 9, 2019 | Database, licensing, RAC, Uncategorized

A short post after a tweet of Johannes Ahrends (@carajandb on twitter). He brought to our attention that he was worried: SE2 doesn't include RAC anymore in 19c. Is it a documentation bug? Unfortunately not... his worries appeared to be ligitimate. He made a...

Oracle licenses needed while monitoring your (non-)Oracle environment with OEM

by Job | Mar 6, 2019 | licensing, Oracle Enterprise Manager

With Oracle Enterprise Manager (OEM) you are able to monitor an Oracle environment as well as a non-Oracle environment, like Microsoft’s SQL Server. You are also able to exchange notifications between Oracle Enterprise Manager and e.g. Microsoft’s SCOM. How to monitor...

expdp, ora-1555, Query Duration = 0

by Job | Mar 2, 2019 | Database

During a migration of a database, a remote export/import procedure (through database-link) fails intermittently. Some tables are skipped during export, with the familiair 'ORA-0155' error. Snapshot too old. Procedure hasn't changed. What's going on, besides the...