Upgrade Express: "sqlplus: Command not found" and "Undefined variable" errors
- Article Type: General
- Product: Aleph
- Product Version: 21
Problem Symptoms:
* After importing/upgrading the v20 data and u-tree in Upgrade Express, all of the Oracle steps (1000-up) fail with "sqlplus: Command not found" and "Undefined variable" errors.
* The SQL query "select * from all_users;" shows that the install_utree proc failed to create any of the XXXnn Oracle users.
Cause:
Failure of Upgrade Express install_utree process.
Resolution:
1. Correct $alephe_root/aleph_start as described in KB 5148 ("Undefined variable" message trying to connect to server")
2. Resubmit "Install customer data"
3. Check the ./upgrade_express_2001_2101/logs/log/install_utree.log, for messages indicating successful processing of Oracle tables. See "Additional Information" below.
Additional Information
Errors for each library in the ./upgrade_express_2001_2101/logs/log.20120918.154622/install_utree.log:
Found ./data/a20_1/abc01/files/dpdir - Processing...
Creating Oracle schema: abc01 ...
create_ora_user_b abc01
sqlplus: Command not found. <-----
data_scratch: Undefined variable.
Importing to abc01 ...
sqlplus: Command not found. <-----
Importing the following files:
/exlibris/aleph/upgrade_express_2001_2101/data/a20_1/abc01/files/dpdir/abc0101.dmp
/exlibris/aleph/upgrade_express_2001_2101/data/a20_1/abc01/files/dpdir/abc0102.dmp
Dropping user abc01 ...
impdp: Command not found. <-----
Import (dp) abc01 ended
Sample messages indicating successful install_utree processing:
Starting "ALEPH_ADMIN"."SYS_IMPORT_SCHEMA_01": ALEPH_ADMIN/******** SCHEMAS=ABC01 DIRECTORY=ABC01_DIR_UE DUMPFILE=abc01%U.dmp NOLOGFILE=Y PARALLEL=4
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "ABC01"."Z00" 197.0 MB 224092 rows
. . imported "ABC01"."Z01" 378.0 MB 1560526 rows
. . imported "ABC01"."Z95" 354.9 MB 224092 rows
. . imported "ABC01"."Z11" 161.6 MB 1331089 rows
<etc.>
Category: Installation & Upgrades (500)
Subject: Upgrade Express (500)
- Article last edited: 10/8/2013