Hi, OLT group,<div><br></div><div>I met with strange problem when doing the tput and power test of OLT, when I first setup the test and run, the tput and power test failed, error message from<b> tput/power.log</b> is :</div>
<div><br></div><div><i><font color="#3366ff">ERROR: 10:27:58: Failed to create materlized_view</font></i></div><div><i><font color="#3366ff">ERROR: 10:27:58: Failed to Build database,no other test can be run</font></i></div>
<div><i><font color="#3366ff">ERROR: 10:27:58: Error in database load test: test cant be continue </font></i></div><div><i><br></i></div><div><b>alert.log :</b></div><div><i><br></i></div><div><i><font color="#3366ff"><div>
CREATE UNDO TABLESPACE UNDO DATAFILE '/olt-storage/local/nas/11.2.0.2-8192-16G/oltdbt3/undo.dbf' size 512 M reuse autoextend on</div><div><br></div><div>Sat Feb 11 10:27:32 2012</div><div>ORA-19502 signalled during: CREATE UNDO TABLESPACE UNDO DATAFILE '/olt-storage/local/nas/11.2.0.2-8192-16G/oltdbt3/undo.dbf' size 512 M reuse autoextend on</div>
<div><br></div><div>...</div><div>Errors in file .../dblogs/dbcreate_dump/diag/rdbms/dbt3db/dbt3db/trace/dbt3db_ora_11756.trc:</div><div>ORA-00604: error occurred at recursive SQL level 1</div><div>ORA-19502: write error on file "/olt-storage/local/nas/11.2.0.2-8192-16G/oltdbt3/undo.dbf", block number 59520 (block size=8192)</div>
<div>ORA-27063: number of bytes read/written is incorrect</div><div>Additional information: 393216</div><div>Additional information: 1048576</div><div>ORA-19502: write error on file "/olt-storage/local/nas/11.2.0.2-8192-16G/oltdbt3/undo.dbf", block number 59648 (block size=8192)</div>
<div>ORA-27063: number of bytes read/written is incorrect</div><div>Additional information: 655360</div><div>Additional information: 1048576</div><div>Errors in file /home/oracle/work/st-tput-dss_Feb11_12-10-22-36/st-tput-dss_Feb-11-10-22-36-9963/work/dblogs/dbcreate_dump/diag/rdbms/dbt3db/dbt3db/trace/dbt3db_ora_11756.trc:</div>
<div>ORA-01501: CREATE DATABASE failed</div><div>ORA-01519: error while processing file '?/rdbms/admin/dtxnspc.bsq' near line 5</div><div>ORA-00604: error occurred at recursive SQL level 1</div><div>ORA-19502: write error on file "/olt-storage/local/nas/11.2.0.2-8192-16G/oltdbt3/undo.dbf", block number 59520 (block size=8192)</div>
<div>ORA-27063: number of bytes read/written is incorrect</div><div>Additional information: 393216</div><div>Additional information: 1048576</div><div>ORA-19502: write error on file "/olt-storage/local/nas/11.2.0.3-8192-16G/oltdbt3/undo.dbf", block number 59648 (block size=8192)</div>
<div>ORA-27063: number of bytes read/written is incorrect</div><div>Additional information: 655360</div><div>Additional information: 1048576</div><div>Error 1519 happened during database creation, shutting down database</div>
<div>USER (ospid: 11756): terminating the instance due to error 1519</div><div>Instance terminated by USER, pid = 11756</div><div>ORA-1092 signalled during: CREATE DATABASE dbt3db</div></font></i></div><div><i><br></i></div>
<div>then I restart the test again with nothing change, they all can pass. This happened on several machines, I do not know where I am wrong, hope you could give some clue about this. Thanks.</div><div><br></div><div>regards,</div>
<div>derek</div>