Hot answers tagged

8

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


7

In this case, should I use TAF or FCF? TAF- Transparent Application Failover is a database session-level connection failover mechanism and works only for OCI clients. FCF- Fast Connection Failover is a application-level failover mechanism. It depends on the implicit connection cache feature and implicit connection caching must be enabled. TAF would be ...


6

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

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


4

Yes, it is possible. https://docs.oracle.com/database/121/NTDBI/intro.htm#NTDBI2648 Oracle Database supports multiple Oracle homes. You can install this release or previous releases of the software more than once on the same system, in different Oracle home directories. This allows flexibility in deployment and maintenance of the database software. ...


4

Two transactions won't share an SCN barring a bug in Oracle. Exactly how Oracle ensures this varies by version, platform, and configuration settings. For example, back in the Oracle 9.2 days, there was by default a non-zero max_commit_propagation_delay which meant that a row that was inserted on one node and committed might not be immediately visible to a ...


3

I tried the above suggestions, but did not work, such as select SQL did not get results and I still cannot drop the undo table space. The fundamental issue is that the old undo table space is still registered in Oracle as its undo, therefore we need to change it to the new undo table space. Here are what I did and it worked: create a new UNDO table space: ...


3

i've found the definitive answer from the oracle docs http://docs.oracle.com/cd/E11882_01/license.112/e47877/editions.htm#DBLIC109 in the Oracle Database Standard Edition and Oracle Real Application Clusters (Oracle RAC) section, it specifies "Oracle Automatic Storage Management is required for creating and managing all Oracle database file types. Raw ...


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

What is node eviction? Word Meaning(Merriam Webster Disctionary): to force(someone) to leave the place. The process of removing the failed(due to various reasons) node from the cluster is known as eviction. Prior to 11gR2 Oracle tries to prevent from split brain situation by quickly rebooting the failed node . After 11gr2 Clusterware will attempt to ...


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: database|instance|service|nodeapps|vip|asm|diskgroup|...


2

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


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

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


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

First of all, I checked that there were no extents on DISK1. $ . oraenv ORACLE_SID = [+ASM1] ? SQL> select PXN_KFFXP, -- physical extent number XNUM_KFFXP, -- virtual extent number DISK_KFFXP, -- disk number AU_KFFXP -- allocation unit number from X$KFFXP where DISK_KFFXP=1; no rows selected I cleared the ...


2

You can check the value of the CLUSTER_DATABASE parameter: SQL> select name, value from v$parameter where name = 'cluster_database'; NAME VALUE --------------------- --------------------- cluster_database TRUE According to the Oracle Database Reference: CLUSTER_DATABASE is an Oracle RAC parameter that specifies whether or not ...


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


2

Oracle RAC requires a clustered file system: ASM comes with the database ASM provides a clustered file system ASM was built specifically to do this Anything else would be an additional cost 3rd party product that you would have to integrate and get working with your Oracle RAC.


2

Let me start with another question. Is catproc.sql/catalog.sql really required? Try creating a new database manually: create database; And stop here, don't run any scripts. You have a "functioning" database, you can create tablespaces, users, query v$ views, create tables, indexes, insert and query data. You can even create user-managed backups. Now try ...


2

Listener is a process running in the Oracle Server machine. The responsibility of the listener is to listen for the incoming database connection request and spawning server process to handle the request(in Dedicated Server mode) or handing over to dispatcher process(in Shared-Server mode). In RAC architecture we have SCAN listener to redirect connection ...


2

Connect to third instance and issue SQL> alter database open; then to fourth instance and do the same. But if you want to open all instances at once, you need to use srvctl utility: srvctl start database -db db_name https://docs.oracle.com/database/121/RACAD/GUID-C9DB4DCB-34B9-42F0-8AB4-33199087CE98.htm#RACAD900


2

I've created a new temp file using command: ALTER TABLESPACE temp ADD TEMPFILE '+DATA/ORCL/DATAFILE/temp02.dbf' SIZE 2048M REUSE; After that SELECT * FROM dba_temp_free_space; command showed me much more space available. However I don't know where old temp file is located and what is its name. I've found old tempfile name and resized it: SQL> SELECT * ...


2

I've supported One Node installs for something like 8 years now: Make sure all databases are running on node 1. Patch the GI and DB homes (GI, DB, OJVM, Java JDK, etc.) on node 2. Relocate the databases from the unpatched node 1 to the patched node 2. Run the post-install SQL scripts for each patch on each database on node 2. Patch the GI and DB homes on ...


2

Clients connect to the scan listener(s) listening on the scan vip(s). The scan listener forwards the request to the appropriate local listener listening on the node vip. So the node vip is still used for connecting. The listener must run on the node you end up connecting to spawn your server process. The scan listener running on rac1 can not spawn a process ...


1

I had similar issue and local listener was null, fixed it when enetered proper values I'm no expert in RAC but here is how they could look show parameter listener NAME TYPE VALUE -------------------------- -------------------- ------------------------------ listener_networks string ((NAME=...


1

What the SIDs on all the nodes? Is this really the same DATABASE. For example you can have 3 node cluster having a single ASM on all the nodes, but database A is clustered on node1/node2. But database B runs only on the node 3. The database B then is still started and stopped by the Clusterware, but is not clustered. You can also check output from: ps -ef |...


Only top voted, non community-wiki answers of a minimum length are eligible