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