|
If you were logged in you would be able to see more operations.
|
|
|
| Product Version: |
Oracle 10g 10.2.0.3
|
| Operating System: |
Linux
|
| Operating System Version: |
RHEL 4
|
The one of RAC Nodes encounters the following error codes while no problem occurs on the other node:
From ALERT LOG:
From dmsdb2_j000_21660.trc:
|
|
Description
|
The one of RAC Nodes encounters the following error codes while no problem occurs on the other node:
From ALERT LOG:
From dmsdb2_j000_21660.trc:
|
Show » |
|
Change by ubTools Support - 08/May/08 12:52 PM
|
| Field |
Original Value |
New Value |
|
Status
|
Open
[ 1
]
|
Closed
[ 6
]
|
|
Resolution
|
|
Answered
[ 10
]
|
|
Change by ubTools Support - 11/May/08 08:22 AM
|
|
Resolution
|
Answered
[ 10
]
|
|
|
Status
|
Closed
[ 6
]
|
Reopened
[ 4
]
|
|
Change by ubTools Support - 11/May/08 08:23 AM
|
|
Status
|
Reopened
[ 4
]
|
Closed
[ 6
]
|
|
Resolution
|
|
Answered
[ 10
]
|
|
Change by ubTools Support - 12/May/08 12:36 PM
|
|
Resolution
|
Answered
[ 10
]
|
|
|
Status
|
Closed
[ 6
]
|
Reopened
[ 4
]
|
|
Change by ubTools Support - 12/May/08 12:37 PM
|
|
Description
|
The one of RAC Node encounters the following error codes while no problem occurs on the other node:
From ALERT LOG:
{noformat}
Generic Alert Log Error May 2, 2008 11:21:30 PM ORA-12012: error on auto execute of job 8913
ORA-01187: cannot read from file ORA-01187: cannot read from file 96 because it failed verification tests
ORA-01110: data file 96: '/u64/oradata/DMSDB/LBPRD_IDX_SKU_005DMSDB.dbf'
ORA-06512: at "SYS.PRVT_ADVISOR", line 1624
ORA-06512: at "SYS.DBMS_ADVISOR", line 186
ORA-06512: at "SYS.DBMS_SPACE", line 1347
ORA-06512: at "SYS.DBMS_SPACE", line 1566
because it failed verification tests
Trace File: /u00/app/oracle/oracle/admin/DMSDB/bdump/dmsdb2_j000_21660.trc
{noformat}
From dmsdb2_j000_21660.trc:
{noformat}
*** 2008-04-07 23:03:34.750
GATHER_STATS_JOB: GATHER_TABLE_STATS('"LOADOWNER"','"MARKEDPRODUCT"','"MARKEDPRODUCT_20080406"', ...)
ORA-01187: cannot read from file 88 because it failed verification tests
ORA-01110: data file 88: '/u64/oradata/DMSDB/MRK_IDX_004DMSDB.dbf'
{noformat}
|
The one of RAC Nodes encounters the following error codes while no problem occurs on the other node:
From ALERT LOG:
{noformat}
Generic Alert Log Error May 2, 2008 11:21:30 PM ORA-12012: error on auto execute of job 8913
ORA-01187: cannot read from file ORA-01187: cannot read from file 96 because it failed verification tests
ORA-01110: data file 96: '/u64/oradata/DMSDB/LBPRD_IDX_SKU_005DMSDB.dbf'
ORA-06512: at "SYS.PRVT_ADVISOR", line 1624
ORA-06512: at "SYS.DBMS_ADVISOR", line 186
ORA-06512: at "SYS.DBMS_SPACE", line 1347
ORA-06512: at "SYS.DBMS_SPACE", line 1566
because it failed verification tests
Trace File: /u00/app/oracle/oracle/admin/DMSDB/bdump/dmsdb2_j000_21660.trc
{noformat}
From dmsdb2_j000_21660.trc:
{noformat}
*** 2008-04-07 23:03:34.750
GATHER_STATS_JOB: GATHER_TABLE_STATS('"LOADOWNER"','"MARKEDPRODUCT"','"MARKEDPRODUCT_20080406"', ...)
ORA-01187: cannot read from file 88 because it failed verification tests
ORA-01110: data file 88: '/u64/oradata/DMSDB/MRK_IDX_004DMSDB.dbf'
{noformat}
|
|
Change by ubTools Support - 12/May/08 12:37 PM
|
|
Status
|
Reopened
[ 4
]
|
Closed
[ 6
]
|
|
Resolution
|
|
Answered
[ 10
]
|
|
Oracle - Administration
Closed
Major
"ORA-01187: cannot read from file" in one of the RAC Node.