• Article Type: General
• Product: Aleph
• Product Version: 18.01

Description:
Our OPAC is not working correctly. The Browse works OK, but the Find gives a list of words on the left instead of actual results for the word searched. If you click on a word, you get a list of bases with the message "The requested base/library is not accessible now".

Resolution:
[This is similar to KB 8192-7896 ]

I found this in vir01 util a/17/14:

Enter Table Name : z05

Defined in file_list:


IND z05_id 1M 0K ts1
IND z05_id1 1M 0K ts1
IND z05_id2 1M 0K ts1
IND z05_id3 1M 0K ts1
IND z05_id4 1M 0K ts1
__________________________________________________________


Exist in the Database:

INDEX_NAME STATUS INDEX_TYPE UNIQUENESS COLUMN_NAME
--------------- ------- ---------- ----------- --------------------
Z05_ID3 VALID NORMAL NONUNIQUE Z05_ID
Z05_ID4 VALID NORMAL NONUNIQUE Z05_FIND_GROUP

[The z05_id, z05_id1, and z05_id2 are missing.]

I tried doing util a/17/2 to build the absent z05 Oracle indexes, but got some "resource busy" messages. I brought down the www_server, but that didn't help.

So we did:

Stop/restart ALEPH
Stop all servers
Drop vir01 z05 and vir01 z110 (util A/17/1)
Restart web server and checked: No luck.

So, then I did:

Stop all servers
Stop ALEPH
Stop/restart Oracle
Start ALEPH
Drop/create vir01 z05 and vir01 z110 (util A/17/1)
Restart web server and all okay
Restart other servers

• Article last edited: 10/8/2013