After running p_manage_01: “The requested base/library is not accessible now.”

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

Description:
It looks like the parallel p_manage_01 in abc03 ended around 3AM today. I wanted to test it, so made sure it’s in tab_base.eng and base-list-abc01. The library is unlocked according to util c/4 (and I deliberately did util c/6 to ensure that), but when I select it from base-list , I get the message “The requested base/library is not accessible now.” Other bases are fine.

Later, the message "Internet Explorer cannot display the webpage" was being displayed rather than the one shown above.

Resolution:
The “The requested base/library is not accessible now” may have been due to the abc03 library being locked(?)

The following message occurs in the $alephe_scratch/p_manage_01 log, in the index-build at the end:

Enter user-name: ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

The $data_scratch/p_manage_01_e.err file has the message:

b_manage_01_g3: z98 build failure

The $data_scratch/p_manage_01_e1_1.log has these messages:

start building /exlibris/aleph/u18_1/abc03/files/z98.seq.1
Sun Sep 28 02:51:27 EDT 2008

Oracle error: handle_connection
ORA-12514: TNS:listener does not currently know of service requested i
0 START READING AT 02:51:37

Execution error : file '/exlibris/aleph/a18_1/aleph/exe/b_manage_01_g3.gnt'
error code: 114, pc=0, call=1, seg=0
114 Attempt to access item beyond bounds of memory (Signal 11)

Sun Sep 28 02:51:38 EDT 2008

FAILURE Sun Sep 28 02:51:38 EDT 2008 ==================
step 1
Cycle: 1
b_manage_01_g3: z98 build failure

Job Suspended !!!

p_manage_01 needs be started over from the beginning, making sure that the Oracle server and Listener are available for the entire time.

Note 1: It may not be relevant, but this is a "two-task" set-up, with Oracle on a separate server.

Note 2: In another case, nightly clean-up of the f_symbol *- tmp files in the $TMPDIR directory caused the problem. Such cleanup should be suspended when batch jobs are running.

• Article last edited: 10/8/2013