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.

Raju007
Profile Answers by Raju007 Questions by Raju007
Aug 24th, 2006
8
10173

Showing Answers 1 - 8 of 8 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.

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

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

anupama2000
Profile Answers by 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.