RAC: tips&tricks

RAC: change IPs on public network

In this article I will show how to reconfigure IP addresses in public network for RAC. ` First we have to close all cluster resources This command can hang on stopping ASM. It’s normal, because the resource CRSD is using OCR, which is located on ASM diskgroup. In ASM alertlog you will see errors like: […]

Read more
RAC: tpis&tricks

RAC: migrate standalone database to RAC

Procedure to convert a standalone database to RAC 11gR2 I have a single-instance database and I want to convert it to RAC with minimum downtime. The first step is to enable RAC option by recompiling the binaries (YOU HAVE TO STOP THE DATABASE FIRST!!!) After this operation I can startup instance and proceed to migration. […]

Read more
RAC tpis&tricks

RAC: add new node to cluster

Add a new node to RAC Check the network configuration for both nodes On the with active cluster, check the network configuration Configure appropriate network devices on the node, which I want to add Create appropriate user on the new node: Configure shared storage – first install ASMLib drivers (if you are using ASMLib :)) […]

Read more
RAC tips&tricks

RAC: change the voting disk and ocr location

Change VOTE and OCR location First we have to create new ASMLib binding Then we have to create new ASM diskgroup and set the appropriate attributes (at least ‘compatible.asm’) Then we can add a new location for OCR. And remove the old location Now we can replace the voting disk location

Read more
12c & ENDIAN

12c RMAN: convert between endian formats

There is a great new feature related to the 12c database. The feature that will resolve a lot of problems with migrating databases between endian formats. And thanks to our new partner – Omnitec, who agreed to share with their SPARC resources – I will be able to demonstrate you this powerful solution. Oracle has […]

Read more

Oracle on Solaris (SPARC)

Since the documentation to install Oracle Database on the Solaris SPARC 64bit is so lame, I wrote the short step-by-step instruction on how to install the database, using response file. I assume, that the network is configured and all appropriate packages are installed, so let’s start with configuring project and kernel parameter for user oracle: […]

Read more

Oracle ASM

There is some kind of wrong understanding, regarding what Oracle ASM really is. A lot of people thinks, that this is some kind of file system, provided by Oracle and that Oracle Database reads data "from ASM", while the truth is, that the database reads data directly from the physical raw device with assistance of […]

Read more

12c: New "small" features: DBCA

There are a lot of new powerful features in the 12c database but don’t forget about the little features that can make a DBA happier on the day to day basis 🙂 One of my favourites is a new approach to use a DBCA command line interface to create a database in silent mode: Nice, […]

Read more

Oralce uses gethostbyname in "*skgxp*" libraries [CVE-2015-0235]

Recently there was a new vulnerability introduced in glibc library: http://www.openwall.com/lists/oss-security/2015/01/27/9 Oracle is using the gethostbyname function in "*skgxp*" libraries: So this can be an issue – a specially in RAC environments. RedHat recommends to upgrade the glibc libraries: https://access.redhat.com/articles/1332213 And I do agree 😉

Read more
1 5 6 7 8 9 11

Contact us

Database Whisperers sp. z o. o. sp. k.
al. Jerozolimskie 200, 3rd floor, room 342
02-486 Warszawa
NIP: 5272744987
+48 508 943 051
+48 661 966 009

Newsletter Sign up to be updated