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