when i try to connect to the repository server i am getting
this message can someone help me..

Starting Repository [infa_rep]
(6016|1292) Informatica Repository Agent, version [7.1.1],
build [0811], 32-bit.
(6016|1292) Copyright (c) 2000-2004 Informatica Corporation.
All Rights Reserved. This Software is protected by U.S.
Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158;
5,794,246; 6,339,775 and other U.S. Patents Pending.
(6016|1292) Informatica Repository Agent starting up.
(6016|1292) Security audit trail has been turned off.
(6016|1292) infa_rep: Repository runtime manager initialized.
(6016|1292) infa_rep: Initialized configuration information.
(6016|1292) infa_rep: Initialized request dispatcher.
(6016|1292) Database Connection Error : Failed to logon to
Database server
ORA-12154: TNS:could not resolve service name

Database driver error...
Function Name : Connect
Database Error: Failed to connect to database using user []
and connection string [].
(6016|1292) Service stopped.



when i try to connect to the repository server i am getting this message can someone help me.. S..

Answer / dheeraj

check the oracle connection string, if you have given the
service name check the entry in your TNSname.ora file in
oracle installation dir.
Try connecting using sqlplus and if success use the same
details in the repo to connect.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

4 Answers   Polaris,


What is the difference between bitmap and btree index?

2 Answers   CTS, TCS,


111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 Answers   IBM,


Difference between task flow and linear task flow

0 Answers  


suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,






What is the difference between Active and Passive transformation?

0 Answers   Informatica,


what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 Answers  


What you know about transaction control transformation?

0 Answers  


hi all, Can anyone please tell me the relationship between informatica and business objects

1 Answers  


We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?

3 Answers  


I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  


when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?

3 Answers  


Categories