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

GeekInterview.com > Tech FAQs > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 60 of 304

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.

Total Answers and Comments: 4

Last Update: May 26, 2008 Asked by: Raju007

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

August 28, 2006 04:34:23

Bala

RE: when i try to connect to the repository server i a...

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.

Is this answer useful? Yes | No

August 28, 2006 05:33:23

Vikas

RE: when i try to connect to the repository server i a...

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

Is this answer useful? Yes | No

November 07, 2006 18:16:06

sathishkumar_sundaram

RE: when i try to connect to the repository server i a...

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

Is this answer useful? Yes | No

May 26, 2008 04:11:04

anupama2000

Member Since: May 2008 Contribution: 13

RE: 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

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.

Is this answer useful? Yes | No

0 1

Overall Rating: -1

Go To Top