VIR01 Background Information
What's in VIR01?
There are a number of tables defined, but the ones that seem to actually have data are:
The daily routine to clear VIR01 basically empties out all the files except Z52, which it reloads from a file which has all the parameters listed with values of zero. In an emergency, you could retype Z52 using one of the UTIL G utilities.
What to do with VIR01 problems. Case 1: Z52 problems - manifests as problems with the number of sessions (usually GUI sessions). Case 2: OPAC simply stops working; lots of "Oracle errors" in the www_server log for z05 and z63 (for example). Case 3: License Limit Exceeded for GUI users. ****See end of file for V18 ExLibris KB # 5711 that helped on 5/26/2009.****
Cases detailed below:
1. Z52 problems - manifests as problems with the number of sessions (usually GUI sessions).
First, look at the most recent clear_vir01 log:
hornaleph@aleph-16(2app-01(a21_1) VIR01-ALEPH>>cdDUK50 >>cd $alephe_scratch horn-16(2) VIR01-ALEPH>>ls
aleph@aleph-app-01(a21_1) DUK50 >>ls -lt vir01_clear_vir01.* | more
-rw-rw-r-- 1 aleph exlibris 13001 Jul 21 06:00 vir01_clear_vir01.00833 -rw-rw-r-- 1 aleph exlibris 12650 Jul 20 06:00 vir01_clear_vir01.00832 ... horn-16(2) VIR01-ALEPH>>more
aleph@aleph-app-01(a21_1) DUK50 >>more vir01_clear_vir01.00833
You may want to compare to an older log to see what a normal run looks like.
Subcase 1a: The Z52 file is okay, but the index is unusable. First, check if the Z52 file has good data in it. Try this:
hornaleph@aleph-16(2) VIR01-ALEPH>>app-01(a21_1) DUK50 >>s+ vir01
SQL*Plus: Release 220.127.116.11.0 - Production on Fri Jul 21 14:36:20 2006 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 18.104.22.168.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 22.214.171.124.0 - Production SQL-VIR01> select z52_rec_key from z52;
10 rows selected.
Enter Table Name : z52 make_library_file_list: env file_list_size does not exists. Using data_root/file_list as is Defined in file_list: __________________________________________________________ IND z52_id 10K 10K ts1 __________________________________________________________ Exist in the Database: INDEX_NAME STATUS INDEX_TYPE UNIQUENESS COLUMN_NAME --------------- ------- ---------- ----------- -------------------- Z52_ID VALID NORMAL UNIQUE Z52_REC_KEY