049tips&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 ↗
BROWSE THE FIELD NOTES
tips&tricks
58 field notes / page 5 of 5
050tips&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 ↗
051tips&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 ↗
052tips&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 ↗
053tips&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 ↗
054tuning
Oracle 11g & 12c: tunning the sort and hash operations
Hash and sort operations are perfomed in PGA. Quoting after the documentation: A sort operator uses a work area (the sort area) to perform the in-memory sorting of a set of rows. Similarly, a hash-join operator
2 MIN READRead the field notes ↗
055tips&tricks
Script for metadata export in SQL*Plus
Sometimes you have to export all metadata for a schema but you have no access to data pump or other tools. SQL Developer can cause a lot of problems with referential constraints. But there is always a good old
1 MIN READRead the field notes ↗
056tips&tricks
Oracle RAC 11.2.0.4 – add another ethernet to interconnect
Instead of bonding you can use Oracle cluster interconnect HAIP for using multiple ethernets. And here is how its done 🙂 At the begining I have one interconnect – eth1: SQL> select * from GV$CLUSTER_INTERCONNE
1 MIN READRead the field notes ↗
057tips&tricks
Exadata – skgxpinfo returns UDP after reconfiguration
We had to change the hostnames on Exadata with one of the customers. It is a well known fact that RAC doesn’t like such changes – we had to reconfigure the cluster and after the whole process I found the funny
4 MIN READRead the field notes ↗
058tips&tricks
SQL For Modeling
Do you realy know SQL? I mean Oracle SQL…. Maybe you should take a closer look: http://ora-600.pl/art/sql-for-modeling.pdf
1 MIN READRead the field notes ↗