12cR4 configureBIP Script Fails is SYSMAN Password had been Changed: ORA-01741: illegal zero-length identifier

(Doc ID 1912155.1)

Last updated on APRIL 17, 2015

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.4.0 to 12.1.0.4.0 [Release 12.1]
Information in this document applies to any platform.

Symptoms

BI Publisher Software was integrated with Cloud Control R4. Nevertheless is should be configured by running configureBIP script.

In case SYSMAN password is changed since the software was installed (or contains special charactes), the first attempt to run configureBIP fails with error:

BIP Schema is not created

The second/third attempts to run configureBIP partially succed (assuming that schema exist) , but BI will not fully work as there is no BIP Repository.

Changes

 BI Configuration fails in any of the following situations:
1. If SYSMAN user contains special characters (e.g $)
2. If SYSMAN pwd had been changed since the Cloud Control was installed until first run of configureBIP script

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms