"_ gby_hash_aggregation_enabled" = false2: Fundamental Solution2. 1. Optimize SQL statements to avoid bugs;2. Upgrade(1) update the database psu to 10.2.0.5.4 and 11.2 to correct this problem.(2) For versions 10.2.0.5.0 to 10.2.0.5.3, PATCH 7612454 should be used to avoid errors (this PATCH replaces the kcbl. o file in lib ).
Example of a temporary solution:
Trace the trace file in the alarm log and find the SQL statement that causes this error.
ORA-
[Oracle] OPatch upgrade, oracleopatch
During the PSU upgrade, opatch prereq CheckConflictAgainstOHWithDetail-phBaseDir./12419378
Detection Error:
Invoking prereq "checkconflictagainstohwithdetail"
The location "./9352164/README.html" is not a directory or a valid patch zip file.
Prereq "checkConflictAgainstOHWithDetail" not executed
PrereqSession failed: Invalid patch location.
OPatch failed with error code 73
This is because the OPatch version is to
/rdbms/bd/BD2/trace/PVBD2_lmon_29938.trc (incident=90153):ORA-29740: evicted by member 0, group incarnation 10Incident details in: /u01/app/oracle/diag/rdbms/bd/BD2/incident/incdir_90153/BD2_lmon_29938_i90153.trc
In the preceding example, instance 2 LMD0 (pid 29940) is the proceser in IPC Send timeout. There cocould be various reasons causing IPC Send timeout. For example:
A. Network problemB. Process hangC. Bug etc
Please see Top 5 issues for Instance Eviction Document 1374110.1 for more infor
Today, I received a phone call from the leader saying that an important email was sent out in a group. I want to withdraw it as soon as possible to avoid causing major losses. Could you help me.
This problem will still occur. I have long considered it and did not expect it to come so quickly.
After five hours of efforts, the solution was finally solved. We will record the issue here for memo.
-- ===-------------------------------------------- = ---
First, two software are required:
1.
the following three situations: AC power failure, power failure, failure to output the desired DC, DC in the poweroff status, or PSU firmware problems. These situations must be taken into account.
CPU frequency doubling factor: the CPU frequency doubling factor, which refers to the ratio of the actual CPU running frequency to the CPU baseline clock frequency. Any chip has the highest design frequency and minimum frequency. If the frequency is too hi
Original environment: AIX6.1 and Oracle CRS 11g R2 without DB soft.
You need to install a new database and INSTANCE, and prepare to test, upgrade, and install PSU 11.2.0.3.2. During the DBCA process, the ASM disk cannot be identified. The solution is as follows:
Two nodes are analyzed and executed:
Su-grid
Cd $ GRID_HOME/bin
Chmod + s oracle
Chmod + s meaning:
To facilitate normal users to execute some privileged commands, the SUID/SGID program
-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
Additional information: 2
RMAN>
Then ask the database administrator to upgrade the database PSU, which should be caused by a problem in the direct link between the master and slave databases.
In the backup, nbu needs to call the oracle lib library file. The symantec bin directory provides a script to create a link and execute it on
A read example provided by an open source projectusingSystem;usingSystem.Collections.Generic;usingSystem.IO;usingSystem.Linq;usingSystem.Text;namespacenewtonsoft.json.tests.documentation.samples.json{ Public classReadjsonwithjsontextreader { Public voidExample () {#regionUsagestringJSON =@"{' CPU ': ' Intel ', ' PSU ': ' 500W ', ' Drives ': [' DVD read/writer '/* * (broken) * /, ' gigabyte hard drive ', ' $ gigabype hard drive '}"; JsonTextReader Read
Practices for backup and recoveryDocument 1577628.1 How to install Patchset, PSU, or CPU on the data Guard physical standby environmentDocument 1577382.1 configuring Rman Purge archive logs that have been applied to the standby repositoryDocument 1602424.1 Maximum performance/maximum availability RMAN backup in the Data Guard environmentDocument 1602082.1 Common RMAN 11.2 issuesDocument 1602437.1 support for heterogeneous master and standby systems i
theLaninterfaces,IPMBuse of the interface, users can directly use theOpenIPMIThe library has been developed two times, focusing on andBMCIPMIThe modules and implementations of the relevant business, without additional consideration of the design of the lock, synchronization and event-driven models themselves, greatly improve the development efficiency. OPENIPMThe following six basic concepts are involved in understanding these concepts to quickly graspOpenIPMIthe key:
Connection: gener
PSU and have a ground differential slightly different from your de Bug PC. Please don't rely on your debug probe to ground your PC to the same potential as your target.PowerEven when you had designed your debug circuit according to the above considerations, you should also check that Sufficien T power is being supplied to your target with order to obtain a reliable debug connection. If you were using a USB port on your PC to power your target, make s
been running-if patch set update (PSU) has been applied, which is fi NE, and cluster parameters is not changed since original configuration, EG:OCR/VD on same location, network Configurati On have not been changed etc, and grid_home is intact. Deconfig and reconfig on each problematic node can used (as root, execute "$GRID _home/crs/install/rootcrs . Pl-deconfig-force "Then" $GRID _home/root.sh ").Parallel execution of Root script:When establishing o
node, the State_details column of some resources on other nodes may display an error and do not match the State column, or the missing status:-------------------------------------------------------------NAME TARGET State SERVER state_details--------------- ----------------------------------------------Local Resources-------------------------------------------------------------ora.asmonline online oranode1 Started Online ONLINE oranode2 Reason:Case 1This was caused by partially published bug:BUG
Document 1549189.1 10 best practices for backup and recovery
Document 1577628.1 how to install Patchset, PSU, or CPU in the Data Guard Physical Standby environment
Document 1577382.1 configure RMAN to clear Archived logs that have been applied to the standby database
Document 1602424.1 maximum performance/maximum availability RMAN backup in the Data Guard environment
Document 1602082.1 common RMAN 11.2 problems
Document 1602437.1 supports heterogeneo
Ogg 12.2 Installation mode and 11 is slightly different, before the decompression on OK, now is OGG provide OUI installation way, can also be silent way, before the upgrade is decompression coverage, now a choice can be used as a DB Opatch installation, Here the simple record installs and gives the Ogg installs the PSU the process.
The basic software can be downloaded from Oracle's official website (OTN), and patches are loaded from MOS. My environme
use flashback to return to the time point before resetlogs.
Add a recovery experiment for a forced checkpoint. It can be used to refresh the data dictionary during PSU.
SQL> startup mount;ORACLE instance started.Total System Global Area 536870912 bytesFixed Size 1220432 bytesVariable Size 125829296 bytesDatabase Buffers 406847488 bytesRedo Buffers 2973696 bytesDatabase mounted.SQL> create restore point p1 guarantee flashback database;Restore point cr
audit tool
Document 1602035.1 top five common CRS Cluster patching Problems
Document 1602076.1 five most common database and/or instance performance problems in the RAC Environment
Document 1602417.1 10g and 11gR1 ASM Best Practices
Document 1602450.1 ASM 11gR2: how to upgrade the ASM instance to version 11gR2 (11.2.0.X )?
Document 1602048.1 common 11gR2 Grid Infrastructure upgrade ProblemsHigh Availability
Document 1526160.1 step-by-step guide for using rman duplicate... from active database t
.
ExperimentsExperiments were carried out on the Psu,tud and ETHMS databases, and the results of the experiments were described in this paper.Conclusion1. The model uses higher-order information relative to the general network flow algorithm2. But the higher order here is only a 3-order message, and now there are some ways to use higher-order information than a multi-target tracking based on the approximation of tensor rank.3. The model can be ef
IntroductionThe shopt command allows you to set optional parameters for the shell.shopt [-PSU] [optname ...]-S turns on an option.-U turns off an option.-p lists all the options that can be set.Extglob OptionsIf the EXTGLOB option is turned on, the shell will enable pattern matching. Reference to Shell pattern matchingSee if the EXTGLOB option is on (default is OFF)$ shopt Extglobextglob offTurn on the EXTGLOB option$ shopt-s ExtglobCheck whether the
At the time of 11.2.0.4 in Aix, you may encounter a failure of the TFA service that caused some Lib not to be released with the CRS shutdown, resulting in a failure of the upgrade upgrade, in which case either auto or manual patch will fail and the TFA must be shut down. and use Slibclean to release the Lib object and then hit patch againPlay 11.2.0.4.3 PSU 18522515 Patch failedXifenf01:/home/grid> cle/app/grid-local/oradata/sys/soft/18706472/18522515
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.