1

I am getting this error message while creating the MRS (Model Repository Service) in Informatica Powercenter 10.4:

[PERSISTENCEAPI_0307][PERSISTENCECOMMON_0001] Internal error. The request processing failed.
This was caused by [PERSISTENCEAPI_0307][DBPERSISTER_2002] The Repository Service failed to create the repository content.
This was caused by A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@6f24bed2 -- timeout at awaitAvailable()**.

My Informatica and Oracle Database are installed on a Linux server.

I have created a <MRS_User> and granted these permissions:

GRANT CREATE ANY SEQUENCE, ALTER ANY SEQUENCE, DROP ANY SEQUENCE, SELECT ANY SEQUENCE TO <MRS User>;
GRANT CREATE SESSION TO <MRS_User>;
GRANT CREATE ANY SYNONYM TO <MRS User>;   
GRANT CREATE TABLE TO <MRS User>;
GRANT CREATE VIEW TO <MRS User>;
GRANT CREATE ANY VIEW TO <MRS User>;

I am getting this error message MRS error msg and not able to understand where I am doing it wrong and what I am missing.

Could anyone help me resolve this issue?

Thanks, BiraKishore

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
BiraKishore
  • 11
  • 2
  • have you checked if you can connect to oracle DB from infa server. login to infa srver and use sqlplus to see if you can connect. This looks like hostname unreachable issue – Koushik Roy Sep 02 '22 at 09:51

0 Answers0