GeekInterview.com
Series: Subject: Topic:
Question: 745 of 1134

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.

Asked by: Raju007 | Member Since Aug-2006 | Asked on: Aug 23rd, 2006

View all questions by Raju007

Showing Answers 1 - 4 of 4 Answers
Bala

Answered On : 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.

  
Login to rate this answer.
Vikas

Answered On : 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

  
Login to rate this answer.
sathishkumar_sundaram

Answered On : Nov 7th, 2006

Hi,If you look at the last few lines of the error message,ORA-12154: TNS:could not resolve service nameDatabase driver error...Function Name : ConnectDatabase 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

  
Login to rate this answer.
anupama2000

Answered On : May 26th, 2008

View all answers by anupama2000

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.

  
Login to rate this answer.

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.