orac值是什么_orac值是什么
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 110
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.169.72.117)(PORT=52726))
Thu Mar 02 18:44:45 2017
Errors in file /u01/app/oracle/diag/rdbms/cpwsjc/cpwsjc1/trace/cpwsjc1_ora_68146.trc (incident=):
ORA-00600: internal error code, arguments: [6856], [0], [0], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/cpwsjc/cpwsjc1/incident/incdir_/cpwsjc1_ora_68146_i.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1
at My Oracle Support for error and packaging details.
Thu Mar 02 18:44:46 2017
Dumping diagnostic data in directory=[cdmp_446], requested by (instance=1, osid=68146), summary=[incident=].
Thu Mar 02 18:44:47 2017
Sweep [inc][]: completed
Sweep [inc2][]: completed
Thu Mar 02 18:44:49 2017
Corrupt Block Found
TSN = 15, TSNAME = TBS_TEMP_HARMONYHIS
RFN = 1, BLK = , RDBA =
OBJN = -1, OBJD = , OBJECT = , SUBOBJECT =
SEGMENT OWNER = , SEGMENT TYPE =
Errors in file /u01/app/oracle/diag/rdbms/cpwsjc/cpwsjc1/trace/cpwsjc1_ora_68146.trc (incident=):
ORA-00603: ORACLE server session terminated by fatal error
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [6856], [0], [0], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/cpwsjc/cpwsjc1/incident/incdir_/cpwsjc1_ora_68146_i.trc
opiodr aborting process unknown ospid (68146) as a result of ORA-603
Dumping diagnostic data in directory=[cdmp_449], requested by (instance=1, osid=68146), summary=[incident=].
Thu Mar 02 18:45:47 2017
Sweep [inc][]: completed
Sweep [inc2][]: completed
Thu Mar 02 18:47:16 2017
Dumping diagnostic data in directory=[cdmp_716], requested by (instance=2, osid=79290 (GTX0)), summary=[incident=].
Thu Mar 02 18:48:46 2017
Errors in file /u01/app/oracle/diag/rdbms/cpwsjc/cpwsjc1/trace/cpwsjc1_ora_69787.trc (incident=):
ORA-00600: internal error code, arguments: [6856], [0], [0], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/cpwsjc/cpwsjc1/incident/incdir_/cpwsjc1_ora_69787_i.trc
Thu Mar 02 18:48:46 2017
Dumping diagnostic data in directory=[cdmp_846], requested by (instance=1, osid=69787), summary=[incident=].
Use ADRCI or Support Workbench to package the incident.
See Note 411.1
at My Oracle Support for error and packaging details.
Thu Mar 02 18:48:47 2017
Sweep [inc][]: completed
Sweep [inc2][]: completed
Thu Mar 02 18:48:49 2017
Corrupt Block Found
TSN = 15, TSNAME = TBS_TEMP_HARMONYHIS
RFN = 1, BLK = , RDBA =
OBJN = -1, OBJD = , OBJECT = , SUBOBJECT =
SEGMENT OWNER = , SEGMENT TYPE =
For more detailed info:
Bug
- ORA-1578 or ORA-600 [6856] transient in-memory corruption on TEMP segment during transaction recovery / ROLLBACK (eg: after Ctrl-C) - superseded ( Doc ID .8
)
The following justifies how the issue is related to this specific customer:
1.the error info"ORA-00600: internal error code, arguments: [6856], [0], [0], [], [], [], [], [], [], [], [], []" have been found in alertlog
2.the error info "ORA-01578: ORACLE data block corrupted (file # 207, block # 10369)" have been found in alertlog
3. the database server version is 11.2.0.4 and the bug is fixed by version 12.1.0.2 (Server Patch Set)
4.ORA-1578 have been reported during ROLLBACK in a TEMP segment after a user cancel operation.
5. it is similar between the symptom in dumpfile and description in bug
option1: to upgrade the database version to 12.1.0.2 :
To implement the solution, please execute the following steps:
1. Download and review the readme and pre-requisites for Patch. via the link below
https://updates.oracle.com/download/21419221.html
2. Ensure that you have taken a backup of your system before applying
the recommended patch.
3. Apply the patch in a test environment.
4. Retest the issue.
5. Migrate the solution as appropriate to other environments.
~~~~~~~~~~~~~~~~~~~~~~~~~~OR~~~~~~~~~~~~~~~~~~~~~~~~~~
option2: to apply one-off patch :
To implement the solution, please execute the following steps:
1. Download and review the readme and pre-requisites for Patch. via the link below
https://updates.oracle.com/download/17767676.html
2.opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./,
3. Ensure that you have taken a backup of your system before applying
the recommended patch.
4. Apply the patch in a test environment.
5. Retest the issue.
6. Migrate the solution as appropriate to other environments.
Note that this fix has been superseded by the fix in Bug:
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net//viewspace-/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net//viewspace-/
