Recently came across a situation number of times and thought to share it here.
To give you brief idea, I am working on Hyperion EPM System V11.1.2.2 and the relational DB is Oracle 11.
The DB schema "hyp_hss" is used for Hyperion V11.1.2.2 Foundation services configuration. The password of DB schema got expired after some days.
As a normal solution, changed password for DB schema and did reconfiguration of Hyperion EPM System V11.1.2.2
After giving new credentials, got the error about DB Connection.
Though was able to connect to DB via sqlplus using same credentials, I was getting above error during EPM System V11.1.2.2 configuration.
This is due to previous credentials saved in "reg.properties" file at following location.
MIDDLEWARE_HOME\user_projects\epmsystem1\config\foundation\11.1.2.0
Delete "reg.properties" at above location and rerun the configuration. The file "reg.properties" is created with new credentials and the configuration is successful.
To give you brief idea, I am working on Hyperion EPM System V11.1.2.2 and the relational DB is Oracle 11.
The DB schema "hyp_hss" is used for Hyperion V11.1.2.2 Foundation services configuration. The password of DB schema got expired after some days.
As a normal solution, changed password for DB schema and did reconfiguration of Hyperion EPM System V11.1.2.2
This is due to previous credentials saved in "reg.properties" file at following location.
MIDDLEWARE_HOME\user_projects\epmsystem1\config\foundation\11.1.2.0
Delete "reg.properties" at above location and rerun the configuration. The file "reg.properties" is created with new credentials and the configuration is successful.
Thanks for sharing this wonderful stuff plz visit for more info DbSchema 8.2.10
ReplyDelete