oracle rac issues and solutions

Common causes and solutions for Oracle deadlocks 1. deadlock caused by deletion and update The reason for the deadlock is that multiple threads or processes compete for or depend on the same resource. Here is an example of a deadlock caused by competition for the same resource. CREATE TABLE testLock( ID NUMBER, test VARCHAR(100) ) COMMIT INSERT INTO testLock VALUES(1,'test1'); INSERT INTO testLock VALUE

Because 111 of the group companies, there is such a business: 222 of the business after receiving the sales order, from 333 of the company delivery to the customer, but from the customer's receipt is 222 of the business. For such a business, we have the following three solutions. solution 1 using the integration relationship between Oracle Applications, the company invoicing function of the inv

Handle the Oracle SQL statement in clause (where ID in (1, 2, ..., 1000, 1001)), and if more than 1000 items in the clause will be an error. This is primarily a limitation that Oracle considers performance issues. If you want to solve the minor problem, you can use the where ID (1, 2, ..., +) or ID (1001, ...) PackageWindy.learn;Importjava.util.Collection;Importo

Tags: tor full user experience RAC latest IT architecture personalised ERP definitionFirst, demand analysis both SAP and Oracle EBS are the world's top ERP products and are favored by many customers. However, due to the large system, high price and different positioning, customers often face the following confusion in the implementation process: 1, how to achieve "online + offline" closed-loop process SAP U

On-site solutions to Oracle customers I. OverviewOracle Database Service has a huge market demand. There are a lot of vendors working on Oracle third-party services in China. In the face of so many seller choices, there are dazzling service providers, it can be said that both love and hate. What I love is that sometimes it can help me solve problems, relieve pre

, least recently applicable) list, you should try to store smaller tables to avoid repeating them again and again.==================================================The p1text=file#,p1 of this type of event is File_id,p2 is block_id, and the Hotspot object (table or index) can be determined by dba_extentsSelect Owner,segment_name,segment_typeFrom Dba_extentswhere file_id = file_idand block_id between block_id and block_id + blocks-1;================================================== This event

an attempt to find changes in Web. config, added under system.webThe webservice can be accessed normally. The reason is that IIS does not allow access to WebService by default (what is the rule?).Well, the website can finally open all the pages. The mood is joyful. Oh,man.what is going on? Why is there garbled characters? Isn't the database character set wrong? Hurry Plsql Compare the next two databases what's the difference? As a result, shit. The same. Continue Baidu, and wen.lu. After being

Tags:. SQL Union operation having the use of RAC SQL collection optimization1. When querying, use the name of the column as much as possible;2. When the sub-query and multi-table query can achieve the goal, try to use multi-table query;3. In a set operation, if the collection contains null, it cannot be in, but can be used in (which can be understood as null contains all);Parsing principles for 4.SQL statements: parsing from right to left (SQL executi

Issues with CDB User Creation and tablespace allocation in Oracle 12c Database In Oracle12c, the concept of database plug-in is added, that is, PDB, which allows a database container (CDB) to host multiple pluggable databases (PDB ). CDB is called ContainerDatabase, and the Chinese translation is a database container. PDB is called PluggableDatabase, which can be used to plug and unplug the database. Before

recently) list, we recommend that you store small tables as much as possible, to avoid reading them again and again.========================================================== ============P1text = file # for this type of event, P1 is file_id, P2 is block_id, and dba_extents can be used to determine the hotspot object (table or index)Select owner, segment_name, segment_typeFrom dba_extentsWhere file_id = file_idAnd block_id between block_id and block_id + blocks-1;=============================

502 05-may 17:08 2,137 8,464 349 273 05-may 16:58 2,874 27,562 0 6 05-may 16:48 2,625 25,278 0 7 05-may 16:38 2,496 23,711 1,006 8 05-may 16:28 2,194 21,037 404 6 05-may 16:18 1,877 17,981 0 5 05-may 16:08 1,883 17,215 0 5 The only doubt is that the problem is fixed in 10.2.0.4.4, 10.2.0.5, 11.2.0.1, and the current database patch is 10.2.0.4.7, so the current problem is that the bug is still in doubt. In addition to bug:7291739, Oracle Bug

, why these dictionaries are locked, probably because there is no configuration to tell the server user, so the system needs to go to each PDB to query the system fields, just In Pdb_sa, there are some reasons for being stuck (guessing, because of a lack of conditions, so querying these fields is time consuming) WORKAROUND: Provide the complete statement Create User by "123456" defaulttemporarytemp Default on Users container=all Result: Create nowIn the CDB mode

problem resolution.Next choose the data source service, I choose Oracle, then need to load OJDBC, there are two buttons below, usually choose to load from the hard disk,If add failsThen copy the jar package directly to the \java\lib in the tool root directory and restart the tool to take effect.Error when connecting to an Oracle server, such asThere are two kinds of reasons: 1. Database connection paramete

client if you are using Plsql.2. Oracle_home directory (i.e. ORACLE home directory)Looking for Oracle_home to find Tnsnames.ora. Tnsnames.ora Stores database connection information. Tnsnames.ora can be configured with the "Net configuration Assistant" or directly from another computer to be placed in the Oracle client home directory \network\admin.The Oracle_home home directory can be configured in an envi

Tags: inux alter ble ARC job x86 error instance proc Environment Description: Source database environment:Operating system: Windows SERVER 2008R2 Database version: single Instance ORACLE 11.2.0.1target-side database environment:Operating system: Redhat Linux 6.5 x86 64bit database version: ORACLE 11g RAC 11.2.0.4Fault Description:Export the data from the source d

Tags: share picture client TPS IMG SYS version password RAC developerAn error occurred before connecting Oracle with Sqldeveloper: System.Data.OracleClient requires Oracle client software 8.1.7 or laterOn the internet for a long time did not find the last installed a "oracle11g client Lite" Installation problem solved, now share to everyone ha hope to help everyo

can be accessed normally. The reason is that IIS does not allow access to WebService by default (what is the rule?).Well, the website can finally open all the pages. The mood is joyful. Oh,man.what is going on? Why is there garbled characters? Isn't the database character set wrong? Hurry Plsql Compare the next two databases what's the difference? As a result, shit. The same. Continue Baidu, and wen.lu. After being bombarded by various solutions on t