NULL Password error when installing the iProcess Technology Plug-in into the iProcess Engine

NULL Password error when installing the iProcess Technology Plug-in into the iProcess Engine

book

Article ID: KB0081977

calendar_today

Updated On:

Products Versions
TIBCO iProcess Technology Plug-ins 11.4.1

Description

Exception generated when installing the iProcess Technology Plug-in:

java.lang.Exception: Unable to connect to the database. ORA-01005: null password given; logon denied

The correct database user and password was provided to the installer.

Issue/Introduction

Exception generated when installing the iProcess Technology Plug-in: java.lang.Exception: Unable to connect to the database. ORA-01005: null password given; logon denied

Environment

TIBCO iProcess Engine (Oracle) 11.4.1 Linux TIBCO iProcess Technology Plug-ins 11.4.1 Linux

Resolution

The installer used JDBC to connect to the iProcess database to create the objects (e.g. tables, stored procedures and sequences) for the plug-ins.

The correct database user name and password was supplied, however the installer was unable to connect to the database due to:
ORA-01005: null password given; logon denied

Test login to the database using the same user credentials using sqlplus
Check that the database user can logon without any of the following message generated:
    ORA-28002: the password will expire within 7 days
    ORA-28001: the password has expired

e.g.

ORA-28002: the password will expire within 7 days
$ sqlplus swpro/staffpro1
SQL*Plus: Release 11.2.0.3.0 Production on Mon Feb 5 08:50:55 2018
Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ERROR:
ORA-28002: the password will expire within 7 days
SQL>


ORA-28001: the password has expired
$ sqlplus swpro/staffpro1
SQL*Plus: Release 11.2.0.3.0 Production on Mon Feb 5 08:07:57 2018
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
ERROR:
ORA-28001: the password has expired

Changing password for swpro
New password:



Resolve the above issue and re-run the installer.

 

Additional Information

TIBCO iProcess Technology Plug-in Installation Guide