IBM Support

PH26948: OP INSTALLER MAY BE PUTTING THE WRONG ORACLE DB IDENTIFIER IN BOOTSTRAP.PROPERTIES

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • The client is asking what to put in the 'alias' field for
    deployment?
    
    When I look at the tnsnames.ora file I see this:
    <some
    name>=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<server>)(PORT=1
    521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=<something
    here>)))
    
    When they use <some name> they run into the following issue:
    I tried that before, and Installation server will allow me to go
    through validation step and most of configuration steps if I
    enter <some name> as database alias. However, during
    configuration Installation server will write this value into
    bootstrap.properties file as op.ora.databaseName parameter and
    OpenPages will not be able to connect to the database server
    since it will use TNS Alias name as database name
    When they try to use <something here> they run into the original
    issue they reported:
    06-22-2020 15:42:57 - info: Execute command
    "E:\app\oracle\product\19.0.0\bin\sqlplus.exe -s -l
    "sys/\"******\"@<something here>" as sysdba
    @E:\app\IBM\OPInstall82\src\assets\scripts\Database\exit.sql"
    06-22-2020 15:42:57 - info: ERROR: ORA-12154: TNS:could not
    resolve the connect identifier specified
    
    
    Follow up:
    The problem is, that after install it uses alias value from
    properties file as value for op.ora.databaseName in
    bootstrap.properties file, and oracle_identifier as value to
    build jdbc connection string in aurora.properties files. So
    after installation is complete, OpenPages application uses two
    different parameters to connect to database
    bootstrap.properties jdbc connection string (alias is used as
    SID): [host]:[port]/[alias]
    aurora.properties jdbc connection string:
    [host]:[port]/[oracle_identifier]
    Workaround I used was to create second entry in TNS names file
    the same way as you used during your set up, which is not the
    way I prefer to have my system configured. Can IBM fix
    discrepancy with Oracle connection usage between bootstrap and
    aurora properties file and preferably consolidate this
    information in single file?
    Basically the installer is putting the Oracle db alias (as
    defined in tnsnames.ora for the client) into WLP's
    bootstrap.properties instead of the actual name of the database
    (which is referred to in the installer as the "Identifier"). In
    other places where the installer defines JDBC connection info
    (aurora.properties, Cognos data source, search) it is using the
    "identifier" instead of the alias.
    On our internal systems this has been working because the alias
    and identifier are always set the same, but on environments
    where they aren't this likely will cause an issue with the JDBC
    connection from OP to Oracle.
    

Local fix

  • Possible Workarounds:
    
    1. Change the alias name in the client tnsnames.ora to be the
    same as the identifier before installing.
    2. After installing, update bootstrap.properties and change the
    value of op.ora.databaseName to the identifier and restart the
    servers. If any steps failed (ex. Object Manager load), rerun
    them.
    3. [Unverified] Prior to installing, create an override XML for
    the JDBC connections that references a hardcoded value for the
    database name (instead of the op.ora.databaseName property), and
    place it in the directory where the overrides will exist,
    creating whatever directories are necessary.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * OpenPages Users                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * OP INSTALLER MAY BE PUTTING THE WRONG ORACLE DB IDENTIFIER   *
    * IN BOOTSTRAP.PROPERTIES                                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Customers should download OpenPages 8.2.0.0 Interim Fix 1    *
    * from Passport Advantage. See the following document for      *
    * details on obtaining OpenPages 8.2.0.0 Interim Fix 1:        *
    * https://www.ibm.com/support/pages/openpages-watson-8200-inte *
    * rim-fix-1                                                    *
    ****************************************************************
    

Problem conclusion

  • The installer is putting the Oracle db alias (as defined in
    tnsnames.ora for the client) into WLP's bootstrap.properties
    instead of the actual name of the database.  This is now
    corrected in the OpenPages 8.2.0.0 Interim Fix 1 and will also
    be fixed in our next fixpack.
    
    Customers should download OpenPages 8.2.0.0 Interim Fix 1 from
    Passport Advantage. See the following document for details on
    obtaining OpenPages 8.2.0.0 Interim Fix 1:
    https://www.ibm.com/support/pages/openpages-watson-8200-interim-
    fix-1
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH26948

  • Reported component name

    OPENPAGES GRC

  • Reported component ID

    5725D5100

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-06-29

  • Closed date

    2020-08-12

  • Last modified date

    2020-08-12

  • 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

    OPENPAGES GRC

  • Fixed component ID

    5725D5100

Applicable component levels

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFUEU","label":"IBM OpenPages with Watson"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"810","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
13 August 2020