Tag Info

Hot answers tagged

7

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 ...


6

SCAN is supposed to give you connect-time failover, but not run-time failover (like TAF). Where did you get the (mis-)information that SCAN also means TAF?


5

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 ...


5

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

We just did the same thing. install software in new machines and configure different cluster copy tnsnames.ora, orapwSID files to new machines and prepare pfile you may need to add SID to /etc/oratab file on new machines shutdown database on old machines dismount ASM diskgroups on old machines present LUNs to new machines mount diskgroups on new machines ...


3

The recommendation is to have log switches occur a few times an hour. If you have a 100 log switches an hour with 50MB redo logs, you need e.g 1GB redo logs for 5 log switches/hour. 100*50 MB redo/hour for a 6.5GB database is unusually much though. You can add the new logs, e.g: ALTER DATABASE ADD LOGFILE THREAD 1 SIZE 1G; ALTER DATABASE ADD LOGFILE THREAD ...


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 ...


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.


2

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 ...


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

We solved this at my previous company by scheduling a cron job for out of trading hours to grow the tablespace when it fell to within a couple of standard deviations of average daily growth free. I researched it extensively at the time, and there is no way to tune the threshold for when Oracle does it (and you probably wouldn't want to anyway, since you ...


2

30min for 1TB is quite normal. That all writing stops is also normal if your tablespace completely run out of space. When writes has nowhere to go they have to wait for the RESIZE operation to complete. If one extends datafile while there is still space in it database I/O does not stop. Just why you extended for such huge amount? Now those +1TB will add to ...


2

They are Oracle Resource Manager waits. Resource Manager is a set of Oracle functionality that lets you prioritise work. See the list of possible waits in the documentation.


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: ...


2

Yes, Oracle RAC is built using multiple servers sharing their memory - Cache Fusion - and they all access the same shared storage where the database resides. In Oracle an Instance is just the collection of processes that acts as an interface between client connections and the actual database. Since all storage is shared, when a server crashes, a surviving ...


1

When you drop user on primary then this will be also reflected on secondary site. Also impdp will work as expected. But when you are about to import large amount of data MAA might slow down the whole procedure significantly. If you have enough experience with RMAN you might try: shutdown and disconnect the secondary import data into master backup master ...


1

It looks like resource manager is in action. Your dba configured this most likely to give certain processes priority over other processes. Oracle Scheduler is fuly integrated with Resource Manager but the way this is presented is a bit misleading. Often it has nothing to do with Scheduled Jobs at all. You can find which sessions are waiting for resource ...


1

Investigate v$session view about what particular event is causing those cluster waits. E.g.: select s.event, s.* from v$session s order by s.event; event column will get you offending event event name. Then you can google the event or add information to you question. Also "Blocking Sessions" screen in Performance menu in Enterprise Manager in such cases ...


1

Try using these 3 options : oracle.install.option=INSTALL_DB_SWONLY \ oracle.install.db.InstallEdition=EE \ oracle.install.db.isCustomInstall=true


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

This is a bug which is fixed in 11.2.0.3. Have a look at bug# 9897335. If you have a support contract, you can request a backport if it is feasible. In addition the error tell you which client it is waiting on. Further information can be retrieved from v$asm_client.


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

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

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