- Article Type: General
- Product: Aleph
- Product Version: 20
I ran p_manage_01. It seemed to run OK, but after, OPAC/keyword searching are not working: the user gets no response; the www_server log shows "network connection timeout".
I did the SQL from KB 8192-6423 to check for missing Oracle indexes:
abc01@ALEPH20> select index_name from all_indexes where owner = 'USM01' and index_name like 'Z%' minus select index_name from all_indexes where owner = 'ABC01' and index_name like 'Z%' and status = 'VALID';
**** Hit return to continue ****
The Z97_ID1, Z97_ID2, Z97_ID3, and Z98_ID are all indexes on Keyword tables which should have been generated as part of p_manage_01.
Looking at the p_manage_01 logs in abc01 $data_scratch, we see that the cycles files show success and the last data load step log (p_manage_01_e.log) is also successful, but the next step (create_ora_tables_z97_id1.log
) and all of the following Oracle index build steps -- fail like this:
aleph_admin@ALEPH20> 02:40:45 aleph_admin@ALEPH20> CREATE INDEX ABC01.Z97_ID1 ON
ABC01.Z97 (Z97_WORD_R ASC)
ERROR at line 1:
ORA-01187: cannot read from file 201 because it failed verification tests
ORA-01110: data file 201: '/ora01/oradata/aleph20/aleph20_temp01.dbf'
I tried to build the z97_id1 using util a/17/2, but it got the same error.
util o/14/1 and o/17/2 also show the error.
This error indicates that the Oracle TEMP tablespace files are corrupted. This is a temporary tablespace and can be dropped and recreated at will; there's no data in it which Aleph needs. It should be recreated with new tablespace files.
Once this problem is resolved you should use util a/17/2 to build all 6 of these Oracle indexes.
- Article last edited: 10/8/2013