Sunday, February 27, 2011

Error: Cannot connect to the integration service [Integration_Service] No gateway connectivity is provided for the domain [Domain_Name]

Error: Cannot connect to the integration service [Integration_Service] No gateway connectivity is provided for the domain [Domain_Name]

Reason: The workflow is not assigned to the correct integration service.

Solution: Assign the workflow to the integration service that is connected or associated to the informatica repository where you are executing the workflow.

Steps: Once you have identified the associated integration service, follow these steps to assign integration service.

Steps

Step 1 – Disconnect from all open folders and Click on Service -> Assign Integration Service

Step2: Choose the Integration Service - Integration_service from the drop down list.

Step 3 – Choose the folder which contains the workflow.

Step 4 – Select the Workflow and click on Assign.

Tuesday, February 15, 2011

Connecting to Oracle DB via command prompt using ldap

How do I connect to the Oracle db through command prompt via ldap?
Once we have the sqlnet.ora and ldap.ora files in place as explained in blog 'Sql developer connection to oracle db', we just have to use the below syntax to connect.

Syntax - sqlplus username/password@dbservice

Here dbservice is the same service name in sqldeveloper that we select as the last step in creating a connection.