IBM Support

PI55946: THE CONFIGURATION OF THE DATABASES FAILS WHEN NO ORACLE DATABASENAME IS SET IN ANT FILE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • During an installation of the MFP Server with Ant tasks and
    Oracle as DBMS, if no database name is set, the execution of the
    database configuration scripts fail with error "ORA-12504,
    TNS:listener was not given the SID in CONNECT_DATA".
    

Local fix

  • Edit the Ant task configuration file and set a value for the
    Oracle database name.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Administrators of a MobileFirst Server who use Oracle as a   *
    * repository.                                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * In the Ant files used to create and configure the MFP Server *
    * administration and runtime databases (e.g.                   *
    * create-database-oracle.xml and configure-liberty-oracle.xml) *
    * , if the oracle child element has no database attribute      *
    * (<oracle database=...>), the default database name is an     *
    * empty string (??) and the script execution leads to error    *
    * "ORA-12504, TNS:listener was not given the SID in            *
    * CONNECT_DATA".                                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * -                                                            *
    ****************************************************************
    

Problem conclusion

  • The code was fixed by setting the default value ?ORCL? when no
    Oracle database name is provided.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI55946

  • Reported component name

    MFPF/WORKLIGHT

  • Reported component ID

    5725I4301

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-01-22

  • Closed date

    2016-01-27

  • Last modified date

    2016-01-27

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    MFPF/WORKLIGHT

  • Fixed component ID

    5725I4301

Applicable component levels

  • R700 PSY

       UP

  • R710 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSZH4A","label":"IBM Worklight"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"700","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
14 October 2021