by Job | Feb 7, 2021 | SQLserver
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:
- Running ssms.exe with logging (C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe” -log C:\drop\log.txt)
- C:\Users(user)\AppData\Roaming\Microsoft\AppEnv\15.0\ActivityLog.xml .
Solutions mentioned (first one worked for me):
- “I just overlaid the Microsoft.VisualStudio.Shell.Interop.8.0.dll in
C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\PublicAssemblies
with the copy from ..\PrivateAssemblies\Interop
and the IDE opens”
- Another solution: “For me there was an additional
Microsoft.VisualStudio.Shell.Interop.8.0
“
This is known issue and there is new official workaround which published by the SSMS developers team.
You can view the open ticket at the Microsoft feedback system .
Resources:
DBA stack exchange: https://dba.stackexchange.com/questions/237086/sql-server-management-studio-18-wont-open-only-splash-screen-pops-up
Microsoft feedback system: https://feedback.azure.com/forums/908035-sql-server/suggestions/37502512-ssms2018-installed-but-will-not-run
by Job | Jul 19, 2020 | grid control, Oracle Enterprise Manager
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 bit more confidence during patching of OEM : Always On Monitoring (AOM). Maybe a bit underrated functionality – within Oracle .
When Oracle Management Server (OMS) is down for patching, AOM is capable of mailing you when a critical target is down. It’s a limited functionality, but can be quite useful in some cases. Some details has changed since the start in 2016, when DBIservices wrote about it. At the end of the blogpost my findings. (more…)
by Job | Jul 8, 2020 | Sqldeveloper
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 simple and scripting for Citrix is is not that hard too. Scripter tested it, I tested it, and it was all fine during the day. But… it turned out that the saved connections and other preferences were gone the next morning. A very short post to overcome this annoyance.
(more…)
by Job | May 12, 2020 | Database
What has Oracle to do with motorcycles? At first sight: nothing at all! Except I’m a motor rider myself and I’m doing something with databases. But, inspired by a motorcycle-vlogger I made a mental connection between those area’s, where motorcycles can be replaced by cars or any other luxury goods we are using. Just a small reflection about overlooking the hidden costs or savings.
(and by the way, the photo of Itchy Boots I used, has her permission).
Motorcycles
To explain the relation, and relevant for this short blogpost, I first need to tell you what bike I own at the moment.
My motorcycle is a Yamaha XT1200Z Super Tenere Worldcrosser with 112 BHP, 1200cc, an impressive machine with massive power, especially designed for people like me, a wannabee world-traveller with little or no experience in off-road riding. The motor has been equipped with all kind of fancy electronics avoiding me falling off, be involved in an accident or get lost. But… you don’t see a lot of dirt-road travellers choose this bike for their adventures. (more…)
by Job | Apr 29, 2020 | Database
As most of us know, Oracle Database 19c now supports up to 3 pluggable databases (PDBs) per container database (CDB) without requiring additional multitenant license—applicable for both Standard Edition (SE2) and Enterprise Edition (EE). This documentation clearly states: “For all offerings, if you are not licensed for Oracle Multitenant, then you may have up to 3 user-created PDBs in a given container database at any time.” Meaning it’s about user-created PDBS.
But is a Proxy PDB (in fact a kind of symbolic link in Linux terms) considered user-created, or are you allowed to have 4 PDBs in theory? Once, I attended a presentation of Carajandb (Johannes Ahrends) in Germany, who stated that a Proxy PDB is free to use, based on the 18c documentation.
(more…)