PostgreSQL PostgreSQL on Cygwin 01.08.2017 by Oracle Team By Franck Pachot . I run my laptop with Windows 10 for office programs, and VirtualBox machines with Linux for the big stuff (Oracle databases). I have also Cygwin installed on Windows for GNU programs. I wanted to quickly install(…)
Oracle, PostgreSQL Postgres vs. Oracle access paths VII – Bitmap Index Scan 31.07.2017 by Oracle Team By Franck Pachot . In the previous post we have seen the Index Scan, where a where clause condition uses the index structure to find rows and then fetches remaining columns from the table. The case(…)
Database Administration & Monitoring OUD 11.1.2.3 – What are the minimum privileges for administering connect strings in OUD? 20.07.2017 by Oracle Team By William Sescu [vc_row][vc_column width=”1/1″][vc_column_text]Security in OUD plays a very important role. Keeping your patch level up to date is just one of those topics, like explained in my recent blog. https://www.dbi-services.com/blog/oud-11-1-2-3-patch-25840309-oud-bundle-patch-11-1-2-3-170718/ Another one are privileges. You don’t need(…)
Database Administration & Monitoring OUD 11.1.2.3 – Patch 25840309: OUD BUNDLE PATCH 11.1.2.3.170718 19.07.2017 by Oracle Team By William Sescu A new OUD bundle patch was release at the 18th of July 2017, and this gives me the opportunity to show how fast an OUD can be patched, if configured correctly. In case you have an OUD(…)
Database Administration & Monitoring Grid Infrastructure 11.2.0.3 PSU: My Opatch version check is failing 08.07.2017 by Oracle Team Mouhamadou Diaw Last day I was configuring grid infrastructure 11.2.0.3 for a standlone server. After the installation, I decided to apply the Patch Set Update 11.2.0.3.7 (Includes Database PSU 11.2.0.3.7) – 16742216 In the documentation it is marked(…)
Database Administration & Monitoring Grid Infrastructure 12.2: Are all Redhat 7 kernels compatible? 08.07.2017 by Oracle Team By Mouhamadou Diaw In this blog I am going to share an issue I had when installing grid infrastructure 12.2 on Redhat 7.3. I was configuring grid infrastructure 12.2 for a standlone server. Below the release and the version of(…)
Cloud, Database management Oracle Database to SQL Server 2016 TCO Analyzer 08.07.2017 by Oracle Team Today, many enterprises are striving to transform their IT organization from a cost center into a strategic asset and looking for ways to get more value from their application and data platform investments. To deliver on(…)
Oracle ODA X6 installation: re-image 28.06.2017 by Oracle Team By Franck Pachot . The Oracle Database Appliance is shipped with a bare-metal installation which may not be the latest version. You may want to have it virtualized, or get the latest version to avoid further upgrade, or install an(…)
Database management, Oracle 12c Multitenant Internals: VPD for V$ views 27.06.2017 by Oracle Team By Franck Pachot . I described in an earlier post on AWR views how the dictionary views were using metadata and object links to show information from other containers. But this mechanism cannot work for fixed(…)
Application integration & Middleware, Database Administration & Monitoring OUD 11.1.2.3 – ODSM Session Timeout 27.06.2017 by Oracle Team By William Sescu The ODSM is a quite powerful tool for managing the Oracle Unified Directory, and quite a lot of default settings are very reasonable. But there is one that disturbed me from the beginning. It is the ODSM(…)