Duke Wiki  logo

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

VIR01 Troubleshooting

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.****

VIR01 Troubleshooting

 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 9.2.0.5.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 9.2.0.5.0 - 64bit Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.5.0 - Production



SQL-VIR01> select z52_rec_key from z52;

Z52_REC_KEY

--------------------

change-file-name

find-group

last-acc-number

last-doc-number

last-file-number

last-word-number

last-z34-sequence

library-lock-status

max-z02-count

session-id

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



...