Today, I checked the alter _ . log of the ERP DB server and found an error.
Sat Sep 14 14:49:42 CST 2013Error 2068 trapped in 2 PC on transaction 47.12.104933. Cleaning up.Error stack returned to user:ORA-02068ORA-03135
ERPSALES indicates that
ORA-03135 connections lost contact Process ID: 0
Scenario Description:The leader callme said that the remote logon to pslql reports an error and the error message is:ORA-03135 connections lost contact Process ID: 01. Hurry to the vpn and log on to
A friend came to me and said they couldn't start the database, the database started Ora-600[k2vcbk_2] Error, the database version is 11.2.0.2 RAC, the operating system is AIX 6.1sql> Recover database;Media recovery complete.sql> ALTER DATABASE
In Oracle Database deadlock, the database will report the ORA-00060 error code, this deadlock phenomenon is usually caused by application logic design errors, and o
In Oracle Database deadlock, the database will report the ORA-00060 error code, this
Prerequisites:
The RMAN backup was performed before the loss, and the full database
The control file, archiving, and online log files are intact.
SYS @ PROD> conn amy/amy
Connected.
AMY @ PROD> create table t_amy02 (B int );
Table created.
AMY
? Describes locking mechanisms and how Oracle manages data concurrency processing? Using SQL to manage Data? identify and manage PL/SQL Objects? Describe triggers and trigger events? Monitoring and resolving locking conflicts
Working with
The archive mode switching in the RAC environment is slightly different from that in a single instance, mainly because of the differences in shared storage. In this case, we can switch the RAC database to a non-cluster state and switch the archive
Some time ago the customer called to say that since the database was moved after the database is always prompt session is not available, and customer communication to know that their connection to the database program is from the morning after the
After the Oracle11GR2RAC archive mode is modified, the default archive mode is non-archive mode. For more information, see Oracle11GRACOCR and db_unique_name.
After Oracle 11G R2 RAC modifies the archive mode, the default archive mode is non-archive
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.