FIELD NOTESTHE ORA-600 BLOGSearch /BROWSE THE FIELD NOTES
59 field notes / page 5 of 5
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
Add a new node to RAC Check the network configuration for both nodes On the with active cluster, check the network configuration
Change VOTE and OCR location First we have to create new ASMLib binding
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
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
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",
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
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
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
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
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