| ORA-01406: fetched column value was truncated when trying to startup the database [message #150758] |
Fri, 09 December 2005 08:52  |
kumarjs
Messages: 2
Registered: December 2005
|
Junior Member |
|
|
I tried to restart a database and get the following error
ORA-01092: ORACLE instance terminated. Disconnection forced
The following errors are reported in the alert log.
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-01406: fetched column value was truncated
Can anybody help me in sorting this one out, please.
Kind Regards
|
|
|
|
|
|
| Re: ORA-01406: fetched column value was truncated when trying to startup the database [message #150802 is a reply to message #150758] |
Fri, 09 December 2005 16:09  |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
Error: ORA 704
Text: bootstrap process failure
Cause: Failure in processing bootstrap data - see accompaning error.
Action: Contact your customer support representative.
*** Important: The notes below are for experienced users - See Note 22080.1
Explanation:
This is a general error reported at startup when there is some
problem during processing of bootstrap information.
There should be an accompanying error/s.
Diagnosis:
- See the accompanying error/s for more information.
- Shutdown abort the instance and clean up any OS structures
used by the instance. Eg: Ensure there is no shared memory,
semaphores etc.. left lying around
- Retry the startup.
- If the error persists follow up on the accompanying errors
(Eg: block corruption etc.. could cause this.)
***
Note:179951.1
Subject: Database crahes with ORA-604 ORA-02051 ORA-7445 [10] pmon dies
Type: PROBLEM
Status: PUBLISHED
Content Type: TEXT/X-HTML
Creation Date: 14-MAR-2002
Last Revision Date: 08-AUG-2004
Problem Description
-------------------
The application includes the following components:
- Tuxedo
- The instance is one node in a multimaster replication configuration or the
instance is a snapshot master site.
The instance crashes frequently and the alert log shows the following error
stream:
(1)
Error 604 trapped in 2PC on transaction 26.24.13218. Cleaning up.
Error stack returned to user:
ORA-00604: error occurred at recursive SQL level 1
ORA-02051: another session in same transaction failed
---> This is the first error
(2) 3-5 minutes later
Errors in file /bd/bback/A/trc/ora_13425_bback.trc:
ORA-07445: exception encountered: core dump [10] [4160811208] [111404864] [0] [] []
---> Above error indicates that shadow process has dumped core
(3) shortly after error message (2)
Errors in file /bd/bback/A/trc/pmon_27252_bback.trc:
ORA-07445: exception encountered: core dump [10] [4160700856] [2644007196] [0] [] []
---> Pmon tries to clean up the abended shadow process but fails; because it fails to
clean up the abended process, Pmon itself fails.
(4) - shortly after error message (3)
SNP3: terminating instance due to error 472
Instance terminated by SNP3, pid = 27295
Wed Feb 27 10:20:27 2002
---> When Pmon abends, by definition the instance will also abend.
In the trace files identified in the alert log the following stacks are observed:
sc_onstack: 000000009d98591c, sc_mask 0000000000000000
ORA-07445: exception encountered: core dump [10] [4160700856] [2644007196] [0] [] []
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
Solution Description
The first error is due to Bug 1984822:
BugTag: Support notes on Bug 1984822 - DDR info <BugDesc:1984822>
Affects: RDBMS (80-92)
Abstract: Concurrent execution on tightly coupled transaction branches
can cause logical corruption
Fixed-Releases: 8173 9013 9200
Tags: CORR XA
Details:
The branches in a tightly-coupled distributed transaction can erase
each other's work if executing in parallel leading to logical
corruption.
Workaround:
1. Serialize access to the branches.
or 2. Use loosely-coupled transactions.
Explanation
The errors ORA-604 ORA-02051, introduce a dynamic memory corruption into the SGA
which causes the shadow process to abend and generate the ORA-7445 error and
dump core.
Pmon wakes up and sees that there is a process that had crashed, and tries to
clean up after the abended process. In rolling back the failed transactons,
Pmon also encounters the memory corruption and is also unable to handle the
corruption causing Pmon to abend. Pmon failure then results in instance failure.
*****
Note:3404500.8
Subject: Bug 3404500 - ORA-604/ORA-1406 with QUERY_REWRITE_ENABLE=TRUE
Type: PATCH
Status: PUBLISHED
Content Type: TEXT/X-HTML
Creation Date: 29-APR-2004
Last Revision Date: 10-AUG-2005
Click here for details of sections in this note.
Bug 3404500 ORA-604/ORA-1406 with QUERY_REWRITE_ENABLE=TRUE
This note gives a brief overview of bug 3404500.
Affects:
Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected Versions < 10.2
Versions confirmed as being affected 9.2.0.4
9.2.0.5
10.1.0.2
Platforms affected Generic (all / most platforms affected)
Fixed:
This issue is fixed in 9.2.0.6 (Server Patch Set)
10.1.0.3 (Server Patch Set)
10.2.0.1 (Base Release)
Symptoms: Related To:
Error May Occur
ORA-1406
Query Rewrite (Including Materialized Views)
QUERY_REWRITE_ENABLE
Description
An ORA-604 / ORA-1406 error can occur when QUERY_REWRITE_ENABLE=TRUE
from a recursive select statement in qsmqswhetr().
Workaround: Set query_rewrite_enabled to FALSE.
|
|
|
|
| Re: ORA-01406: fetched column value was truncated when trying to startup the database [message #150995 is a reply to message #150760] |
Mon, 12 December 2005 09:20 |
kumarjs
Messages: 2
Registered: December 2005
|
Junior Member |
|
|
This is what is in the alert log.
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-01406: fetched column value was truncated
Fri Dec 9 14:25:31 2005
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 11499
ORA-1092 signalled during: alter database open read write...
Also the trace file has the same information
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-01406: fetched column value was truncated
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
