"Error 6 initializing SQL*Plus ... SP2-0667: Message file sp1.msb not found" and Primavera Data Warehouse Schema Upgrade Fails
(Doc ID 2162640.1)
Last updated on MAY 12, 2021
Applies to:Primavera Analytics - Version 188.8.131.52 and later
Information in this document applies to any platform.
When attempting to upgrade the Data Warehouse schema from 3.4 to 15.2 using the upgradeschema34.sh/.bat script, it fails with the following error:
schemaUpgrade [INFO] (Progress) - Step 4/13 Part 1/2 - [07/11/2016 08:53:42] DropStagingAndViews -- Drop existing staging tables and views (upgrade/drop_staging_tables.sql)
schemaUpgrade [INFO] (Message) - === Step 4, Part 1 ====================================================
schemaUpgrade [INFO] (Message) - === Drop existing staging tables and views (upgrade/drop_staging_tables.sql)
schemaUpgrade [WARN] (Message) - Error 6 initializing SQL*Plus
schemaUpgrade [WARN] (Message) - SP2-0667: Message file sp1.msb not found
schemaUpgrade [WARN] (Message) - SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
The issue can be reproduced at will with the following steps:
- Run upgradeschema34.sh/.bat
- View log file
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document