i'm stuck with a problem of connenction string
The scenario is i have installed informatica 8.6.0 and have managed to start the repository services in admin tool .
But now i wanted to change my operating mode from Exclusive to normal for my integration service to run and other tasks , and as i change my mode and click ok, am getting an error saying my connection string is longer that 79 characters
I have tried some other connection strings instead of the earlier one but the services are starting only in the earlier longer string that i used .
So which Connection string should i use ???
And if possible plz mention the syntax or the format for it.
The point to note here is that OBI Apps , informatica client -server ,and database 11g all are installed on one system only.
Am using oracle database 11 g
Plz help me with this.
Thanks in advance
Edited by: Nikhil.S on Jun 9, 2011 4:52 AM
Edited by: Nikhil.S on Jun 9, 2011 4:53 AM
Edited by: Nikhil.S on Jun 9, 2011 4:57 AM
I assume that you talk about the repository service.
Check here a picture:
Gerard is correct. If your machine has a tns entry for that database, type in your database name as defined in the tns entry. That should be good enough. You need not have the whole connect string
use DOUG in that field if tns entry for your database is like below:
DOUG =(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ISP4400.localdomain)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = TEST92) ))
I did get stumped on this but finally worked.
Award points if its helpful. Close the thread if its answered and correct.