5 Replies Latest reply on Dec 8, 2016 4:51 AM by inuser450494

    OBJM_54538 - Unable to connect to the repository pc_repo on database

    New Member

      We have

      • Informatica 9.6.1 HF3 64bit on Windows 2012 64bit,
      • Oracle 12c 64bit on Windows for repositories and
      • Oracle 12c 64bit Client on Informatica box.


      The domain repository has been created successfully, but when create the PowerCenter Repository, it shows the following error:

       

      OBJM_54538 - Unable to connect to the repository pc_repo on database ...

       

      and

       

      "The PowerCenter Repository Service was created, but the service could not be enabled. You must enable the service before you can create content. The following error occurred while attempting to create the content. Error - [DOM_10079] Cannot start service [pc_repo] on any node specified for the service. Check the service log and resolve any error listed for the service. Then restart the service."

       

      The following connect string values have been tested, all failed with similar errors:

       

      • jdbc:informatica:oracle://192.168.208.1; SID=pdborcl
      • jdbc:informatica:oracle://192.168.208.1; ServiceName=pdborcl
      • pdborcl


      The odd thing is, among these three,

      • jdbc:informatica:oracle://192.168.208.1; ServiceName=pdborcl

      is the same as the connection string value for Informatica domain repository, which works.


      SQLPLUS tested, tnsping tested, all worked fine. Also enable

       

      USE_SID_AS_SERVICE_LISTENER=ON

       

      in the oracle database service LISTENER.ORA.

      As shown in the TNSNAMES.ora in the Informatica service, both TNSNAMEs worked fine (With service_name or with SID)

       

       

       

      PDBORCL =

        (DESCRIPTION =

          (ADDRESS_LIST =

            (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.208.1)(PORT = 1521))

          )

          (CONNECT_DATA =

            (SERVICE_NAME = pdborcl)

          )

        )

       

       

      PDBORCL_SID =

        (DESCRIPTION =

          (ADDRESS_LIST =

            (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.208.1)(PORT = 1521))

          )

          (CONNECT_DATA =

            (SID = pdborcl)

          )

        )

       

       

       

       


      Please kindly help if possible. Many thanks in advance,