I/O
17.07.2015

db file scattered read – MBRC and ASYNC IO on linux

Recently one of my students asked me if there is any correlation between the AU size in ASM diskgroup and parameter db_file_multiblock_read_count. I made some tests but results are very strange. I have 4 same tables, located in 4 different diskgroups: All tables are smaller then a hidden parameter "_small_table_threshold" so table access full on […]


Czytaj
12c
25.05.2015

12c: duplicate pluggable database without READ ONLY mode

At the beginning we have to prepare parameter file for the new instance Start the instance in nomount Since I want to duplicate the database in active mode I will register it in LISTENER. To achieve this I have to add the following lines to the listener.ora Now we can perform active database duplication with […]


Czytaj
ASM
14.05.2015

DBA: migrate database to ASM

Let’s try to migrate database to ASM diskgroup without big maintenance window. I have database and ASM (11.2.0.4) – the database is prepared to migration: We will use recoverable copy of database to migrate to ASM. The first run of this script will create copy of datafile on ASM: Subsequent executions of this script will […]


Czytaj
ASM
14.05.2015

Install ASM manually using response file

I have configured two devices for ASM – one with ASMLib and one with UDEV: I have downloaded 11.2.0.4 grid infrastructure binaries and prepared response file: Of course in production environment you have set different groups for security reasons. If you think that you can ignore security, read my articles regarding privilege escalations: http://blog.ora-600.pl/category/oracle/security/ With […]


Czytaj
RAC: tips&tricks
17.04.2015

RAC: CHANGE IP OF CLUSTER INTERCONNECT

In this article I will show how to change IP address of cluster interconnect. First we have to define new address of the cluster interconnect before we change network settings. And now stop all cluster resources on both nodes Now we can change cluster interconnect ips Now we can start init cluster resources on both […]


Czytaj
RAC: tips&tricks
17.04.2015

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: […]


Czytaj
RAC: tpis&tricks
16.04.2015

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. […]


Czytaj
RAC tpis&tricks
15.04.2015

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 :)) […]


Czytaj
RAC tips&tricks
15.04.2015

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


Czytaj
12c & ENDIAN
09.04.2015

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 […]


Czytaj
SOLARIS
12.03.2015

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: […]


Czytaj
ASM
24.02.2015

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 […]


Czytaj
1 2 3 4

Kontakt

Database Whisperers sp. z o. o. sp. k.
Al. Jerozolimskie 200
Wejście B, III piętro/ pokój 342
02-486 Warszawa
NIP: 5272744987
REGON:362524978
+48 508 943 051
+48 661 966 009
info@ora-600.pl

Newsletter zapisz się żeby być na bieżąco