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 serverORA-12154: TNS:could not resolve service nameDatabase driver error...Function Name : ConnectDatabase Error: Failed to connect to database using user [] and connection string [].(6016|1292) Service stopped.

Questions by Raju007

Showing Answers 1 - 4 of 4 Answers

Bala

  • Aug 28th, 2006
 

It is not a Informatica problem, it is database problem. May be the database services has been stopped. Once you check services of oracle and use oracle 8.1.7 or higher version if you are using the operating system XP then it will work properly.

  Was this answer useful?  Yes

Vikas

  • Aug 28th, 2006
 

Hi,

generally this problem arises when the informatica repository services are not started. please check that informatica repository services are started & running on your machine. Also check the connection string specified while creating the repository, this should be your database name.

Hope this will solve your problem.

Regards,

vikas

  Was this answer useful?  Yes

sathishkumar_sundaram

  • Nov 7th, 2006
 

Hi,

If you look at the last few lines of the error message,

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 [].

The connection string does not specify a user name and a connection string.

It shows as []. Please check your repository server configuration.

It is an issue with the connection string.

Good Luck,

Sathish

  Was this answer useful?  Yes

anupama2000

  • May 26th, 2008
 

Go to the mapping designer check the source username, after that go to session task double click on it go to mapping tab, check the source connection if the name that is mentioned in this tab is not same as the user name what you have used as source change it to that.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions