Which Oracle Release are you using?

Post Date: August 2018!

Recently an awesome Oracle Guru friend of mine questioned someone who was installing 11.2.0.4 with the word “seriously”, which is think shows that Oracle staff sometimes don’t live in the same technological world as the rest of business.

My response was:

11.2.0.4 is normal. In the real world:

– large corps mostly use old versions
– consultants look at current versions
– Oracle staff look (more...)

Oracle Database 18c – Install On-Premises for Linux

Oracle Database 18c was available on Oracle Cloud. Now everybody can download Oracle Database 18c On-Premises for Linux (LINUX.X64_180000_db_home.zip)

Oracle change a little on installation file.
  • OUI does not copy files to Oracle Home
You just extract the zip file to Oracle Home directly and OUI only linking binaries.

I installed Oracle Database 18c on Linux 7.1. Before installation, I set Oracle environments such as (ORACLE_HOME, ORACLE_BASE). You can add these settings in oracle user .bash_profile.

Running RAC in a Virtual Environment

I was in a discussion at an Oracle Meetup this week, and the subject of RAC in a virtualized environment – specifically Oracle Virtual Machine (OVM) – came up.
Here’s a couple of points which were discussed.

pingtarget

There was a lack of awareness of a common problem, which has a solution built-in to Oracle 12.1.0.2 Grid Infrastructure and later. In a virtualized environment, the network components are also virtualized. Sometimes, network (more...)

A week of PostgreSQL

One of the attractive things of my job is this… Just a bit more often than every now and then, you get the opportunity to get out and meet people to talk about Postgres. I don’t mean the kind of talk I do every day, which has more of a commercial touch to it. – Don’t get me wrong, that is very important too! – But I mean, really talk about PostgreSQL, be part of (more...)

UKOUG Member Advocate: sorted!

I received an email from the UKOUG last week.

winners-picture

 

It turns out that I have won the vote to become the next Member Advocate for the UKOUG. I will (eventually) be joined on the board by Martin Widlake – who won the vote for the position of President Elect – a position whereby Martin will shadow the current UKOUG President before taking office on the Board. He has written about it here.

I would (more...)

Changing Security Role Password in Oracle GoldenGate 12.3 Microservices

One of the nice things about Oracle GoldenGate 12.3 Microserivces, is the flexibility we now have to interact with Oracle GoldenGate. Additionally, what comes with Oracle GoldenGate 12.3 Microservices is a new role based security frame work.

When you first setup Oracle GoldenGate 12.3 Microservices, you setup your ServiceManager and initial deployment. Upon setting this up, you will assign a new administrator to the frame work. This is a different user than (more...)

UKOUG M.A. Voting Hots Up!

It’s getting hotter!

After so many years volunteering at the UKOUG, are you going to vote me for Member Advocate?

Do you think I will represent the membership well? Yes. VOTE FOR ME!

Oh, you must be the main UKOUG membership contact, or know who is, to vote.

giphy

One thing that has happened is that Steve Davis has withdrawn from the vote due to business commitments, leaving a straightforward race between myself and Andy Nellis. (more...)

I want your vote!

Are you a member of the UKOUG? Read on…

ukoug_logo

I’m currently standing for the role of Member Advocate. But why?

I’ve been volunteering at the UKOUG for over 10 years, and speaking at the conferences and SIGs for the last 5 years or so.  I’ve been deputy chairing or chairing a SIG for all of this time and I’m currently the RAC SIG Chairperson. I’m also involved with our main conference, having helped on (more...)

Why I picked Postgres over Oracle, part III

This is the final episode of this short series of blog posts on some of my drivers for moving to Postgres from Oracle.
Please do read Part I and Part II of the series if you have not done so. It discussed the topics “History”, “More recently”, “The switch to Postgres”, “Realization”, “Pricing”, “Support” and “Extensibility”.

In summary:

  • Part one focused on “why not Oracle anymore, so much”
  • Part two discussed on the comparison (more...)

ORA-19963 ORA-27041 OSD-04002

While doing restore controlfile to new host in windows server, getting below issue

ORA-19963: error getting logical block size of file F:\BACKUP\O1_MF_S_966071800_
F6C0G8CF_.BKP
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.

Solution :

Windows, you need to give full permission of directory to users which contents of backup files.

ORA-27102 OSD-00026 O/S-Error: (OS 1455)

I am trying to restore the database to new host, While doing the first step, I try to start the database,

SQL> startup nomount pfile=’F:\backup\init.ORA’;
ORA-32006: SEC_CASE_SENSITIVE_LOGON initialization parameter has been deprecated

ORA-00600: internal error code, arguments: [kmgs_component_init_5], [15], [], []
, [], [], [], [], [], [], [], []

 

Solution :

The below error message appeared in the alert log file.

ORA-27102: out of memory
OSD-00026: additional error information
O/S-Error: (OS 1455) (more...)

Oracle 12c SE2 installation guide on OEL 7.4

Please find the document here

Oracle 12c SE2 installation guide on OEL 7

12c SQL loader express mode

In Oracle Database12c, SQL*Loader has a new feature called express mode that makes loading CSV files faster and easier. With express mode, there is no need to write a control file for most CSV files you load. Instead, you can load the CSV file with just a few parameters on the SQL*Loader command line.

Example :

SQL> create table dept(deptno number,deptname varchar2(20),deptlocation varchar2(20));

Table created.

SQL> desc dept;
Name Null? Type
—————————————– ——– —————————-
DEPTNO NUMBER
(more...)

Why I picked Postgres over Oracle, part II

Continuing this short series of blog posts on some of my drivers for moving to Postgres from Oracle.
Please do read Part I of the series if you have not done so. It discussed the topics “History”, “More recently” and “The switch to Postgres”.

Realization

In the last months, discussing Postgres with my Oracle peers, playing with the software and the tooling, I actually quite quickly realized Postgres is a lot cooler, at least to (more...)

KILL! KILL! KILL! (of Unix processes)

The start of this isn’t my post – I got it from here: but I wanted to reblog/repost and enhance it because as far as I can tell, 99% of all known DBA’s only use kill -9 to remove unhappy processes.


Original Post:

Useless Use of Kill -9 form letter

No no no.  Don't use kill -9.

It doesn't give the process a chance to cleanly:

1) shut down socket connections

2) clean up temp  (more...)

Why I picked Postgres over Oracle, part I

As with many stories, if you have something to tell, it quickly takes up a lot of space. Therefor this will be a series of blog posts on Postgres and a bit of Oracle. It will be a short series, though…

Let’s begin

History

 I have started with databases quite early on in my career. RMS by Datapoint… was it really a database? Well, at least sort of. It held data in a central (more...)

EnterpriseDB Summerschool 2017

I have been meaning to write a lot of posts, meanwhile. With the new challenges, and all, it just hasn’t happened.

But!!

although I don’t tend to do much advertising here, I really do need to share this (unique) opportunity,

I (and my other colleagues across EMEA) really want to meet you and share some of the knowledge on EDB Postgres with you. Especially targeted at Oracle DBA’s!
It will cost you one day and (more...)

Oracle Database 12c Release 2 – Long Identifiers

Prior to Oracle Database 12c Release 2 have a problem with long identifier name, for example, in 11.2 version you cannot create long name (max 30 Bytes) tables.  As you see, from screenshots length of table name column is maximum 30.

Creating table with long name

Table Name Column size 30

In Oracle Database 12c Release 2 changed the length of identifier names, and this change depends on the COMPATIBLE initialization parameter. Documentation says:

If (more...)

Oracle Database 12c Release 2 – SQL*Plus History Command


As you know that we can repeat our previous SQL*Plus commands in Windows CMD. But in UNIX based systems not supported command line history of SQL*PLus.  For this reason in UNIX and Linux, we used rlwrap utility to see the SQL*Plus command line history and quickly recall previous SQL*Plus commands.

With seconds release of Oracle Database 12c coming SQL*Plus history command for the history of the command line in Linux.

I want to share some example for this (more...)

OTN EMEA Tour 2017 Baku

OTN EMEA Tour 2017 took place.

Our city Baku also included this tour this year also. We (board of Azerbaijan Oracle User Group) organized the biggest event at Baku  (Park in Hotel) by sponsored Azercell Telecommunication Company. This year 3 Oracle ACE Director  Bjorn Rost (Germany), Gurcan Orhan (Turkey), Heli Helskyaho (Finland) and an Oracle ACE Rene Antunez (Mexica)  are our guests. Attendees of our event listened very interesting Oracle technical topics at the event.

Here is (more...)