I haven’t written anything in my blog for a few months now, and if you have been following me for a long time you know that’s quite unusual. However, there
Tag: database
Database for Developers: Connection PoolsDatabase for Developers: Connection Pools
When you develop an application that uses a database, one of the topics you need to consider is how to connect to the database. Some application use a one-to-one connection,
All You Need to Know About Oracle Database ReleasesAll You Need to Know About Oracle Database Releases
When Oracle moved to the new Oracle database release model in 2018, some changes were introduced with it. I just realized that I haven’t blogged about it (even though I
Oracle 21c New FeaturesOracle 21c New Features
Even though it’s not listed in the main documentation page, Oracle 21c documentation exists. I went to the New Features Guide and here is a compilation of some of the
Patching Oracle Standard Edition High Availability (SEHA)Patching Oracle Standard Edition High Availability (SEHA)
SEHA is a new Oracle Database 19c (>=19.7) feature to allow Standard Edition to integrate with Grid Infrastructure (GI) and allow a simple fail-over cluster option (after Oracle has removed
Thoughts about Oracle Version ChangeThoughts about Oracle Version Change
It’s been about a year since Oracle decided to change their database version schema, from version with a couple of releases (e.g. 12.1 is 12cR1 and 12.2 is 12cR2) to
Oracle Challenge #3 – SolutionOracle Challenge #3 – Solution
This is the solution for Oracle Challenge #3. If you haven’t read the challenge, go and check it before you read the solution here.
Using DBCA in Silent ModeUsing DBCA in Silent Mode
One of my customers is a software company and they use Oracle database for their product. One of the things we need to do when they certify an Oracle version
Bug When Patching ProductionBug When Patching Production
I had a bad night last Thursday.After patching two test RAC databases and one production RAC with 180417 DB Bundle Patch (and some one-offs), I got to the point where
One-off Patch FrustrationOne-off Patch Frustration
Lately I started patching a client’s database (12.1.0.2) to the latest PSU (180417). This is a RAC environment with streams and all kind of other features, so over the time