013tips&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
2 MIN READRead the field notes ↗
BROWSE THE FIELD NOTES
2015
22 field notes / page 2 of 2
014tips&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. 1 select * 2 from v$option 3* where lower(parameter) like ‘%real
8 MIN READRead the field notes ↗
015tips&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
15 MIN READRead the field notes ↗
016tips&tricks
RAC: change the voting disk and ocr location
Change VOTE and OCR location First we have to create new ASMLib binding
2 MIN READRead the field notes ↗
017tips&tricks
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
14 MIN READRead the field notes ↗
018tips&tricks
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 netwo
4 MIN READRead the field notes ↗
019tips&tricks
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",
5 MIN READRead the field notes ↗
020Oracle
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 DBC
1 MIN READRead the field notes ↗
021security
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: oracle@kokos:~$ fin
1 MIN READRead the field notes ↗
022Oracle
Slow TRUNCATE TABLE due to operations on MON_MODS$
One of my customers had a problem with a very slow TRUNCATE TABLE operation on a partitioned table having 22 000 partitions. The problem has raised after a test migration to database 12c. I’ve prepared a little
5 MIN READRead the field notes ↗