PLS-00201: identifier 'F1_Z11' must be declared

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

Description:
I've been running p_manage_05 for abc01. We see the following in the log:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

abc01@ALEPH20> > > > > 2 begin f1_Z11; end;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'F1_Z11' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

util f/4 doc in abc01 shows this:

ENTER DOC NUMBER : 1
get_ora_passwd: open: Permission denied
Error: io_z00 - table doesn't exist in database or tab_io_remote for library: ABC01
Error reading doc : 000000001
Load:
/app_tmp/aleph_tmp//utf_files/exlibris/aleph/u20_1/alephe/tab/tab_io_remote

util o/1/4 ("Show Oracle Server Status") shows this:

ERROR:
ORA-01005: null password given; logon denied

SP2-0640: Not connected
SP2-0640: Not connected

Enter CR to continue...

util o/14/1:

ERROR:
ORA-01005: null password given; logon denied


exlibris@ALEPH(a20_1) ABC01> s+ abc01
get_ora_passwd: open: Permission denied

Resolution:
Note the double slash: "... aleph_tmp//utf_files ..."
>
I believe this is the result of these lines in aleph_start:

setenv TMPDIR /app_tmp/aleph_tmp/
setenv aleph_utf /app_tmp/aleph_tmp/

I think that the terminal slash should be eliminated from these lines
-- and any other setenv's in aleph_start which have terminal slashes.

Then do "source aleph_start".

In regard to the "get_ora_passwd: open: Permission denied", that is like KB 6518.
The permissions on your /exlibris/aleph/ora_aleph/ora_passwd_xxxxx files need to be changed in a similar fashion.

• Article last edited: 10/8/2013