Hot answers tagged rac
6
Virtualizing an Oracle RAC isn't necessarily a stupid idea, but it should only be done with a full understanding of the benefits and risks. You are asking questions, so that is a good step in the right direction.
Your question doesn't say which virtualization technology, the Oracle version, or the edition. For now I will assume this is for production on ...
4
I'm a DBA supporting both SQL 2000-2012, Oracle 11g, and Oracle 11g RAC.
IMO, Always On Availability Groups in SQL 2012 comes very close to the availability and scalability of RAC at much less cost in both dollars and complexity. You can scale out reads by querying against the mirrors, but you'd want to direct all DML to the primary server (SQL Server ...
4
No, nothing in SQL Server can give you the same thing out of the box.
Currently, the only SQL Server technology that allows simultaneous writes at multiple nodes is Peer-to-Peer replication. Note that I did not to say "write scale-out," because it works in a way such that the entire system has the write capacity of only a single node. The introductory ...
3
The straight answer to your question is no, SQL Server does not have equivalent functionality. There are aspects of SQL Server that give you the kind of failure tolerance that you want (even as far back as SQL Server 2005 when using DB mirroring and a mirror-aware application), but there is not a 1:1 with Oracle RAC.
3
As it turns out, the ODA is factory configured with active-backup bonds. I've tested this to work well without any switch-side LACP/EtherChannel configuration, and each bonded connection may be split across two switches. In my tests, no simulated failure or network reconfiguration caused more than a a few hundred milliseconds worth of network outage.
This ...
2
I found the solution.
--------------------------------------To shutdown
----------shutdown database instance first
$. oraenv
>mydb1
>/u01/app/oracle/product/11.2.0/db_1
$sqlplus / as sysdba
SQL> shutdown immediate;
---------stopping Oracle Clusterware, It will shutdown ASM instance itself
$ su -
# cd /u01/app/11.2.0/grid/bin/
# ./crsctl stop ...
2
DISCLAIMER : Not an Oracle DBA
Use srvctl, the grid control program that allows you to manipulate parts of the RAC Cluster
Usage: srvctl <command> <object> [<options>]
commands: enable|disable|start|stop|relocate|status|add|remove|modify|getenv|setenv|unsetenv|config
objects: ...
1
The 11.2 manual says you should also check plain LOG_ARCHIVE_DEST. Although it comes from Standard Edition, it is still valid in case none of numbered Enterprise Edition destinations LOG_ARCHIVE_DEST_n are defined. I haven't tested that personally.
In case all are unset, the another 11.2 manual says
If you configure a Fast Recovery Area (by setting the
...
1
Changing the order of the SET seemed to make a difference, as it is working now.
create or replace
TRIGGER schema.django_nls_tr
AFTER logon ON DATABASE
BEGIN
execute immediate 'ALTER SESSION SET NLS_TERRITORY = ''AMERICA'' NLS_DATE_FORMAT = ''YYYY-MM-DD HH24:MI:SS'' NLS_TIMESTAMP_FORMAT = ''YYYY-MM-DD HH24:MI:SS.FF''';
END;
I don't really like this ...
1
A search of 'My Oracle Support' (MOS) showed that this is a bug reported in at least versions 11.1.0.6 and 11.1.0.7. One of the bug reports, #6747927, seems to indicate it was fixed in 11.2 although judging by one of your tags, [oracle-11g-r2], that may not be the case. I suggest you open a ticket with MOS.
1
I would go "CRS / ASM / RDBMS 10.2.0.1 and then patch to 10.2.0.5 in the same order" just to be sure I follow the most typical way that others went before 10.2.0.5 became available. But it's just me, your first proposition will work as well.
Both alternatives guarantee that at all times:
CRS version >= DB version
CRS version >= ASM version
1
In addition to the suggestions already posted, I highly recommend the Apress edition for 11gR2. I used it extensively to implement our development and production RAC environments after having no previous experience on RAC. Hope this helps!
Here's a link to the book on Amazon
1
As always, I would start with the Oracle documentation. You'll also need a virtual test environment, check Tim Hall's articles, they are really helpful.
1
Check ronr.blogspot.com for a plug of and link to a book by Ben Prusinsky and Syed Jaffar Hussain that is very practical. It explains lots of things, and how to do them in great detail. There is lots of hands on experience in it. Very - VERY - nice.
Only top voted, non community-wiki answers of a minimum length are eligible
