check the oracle connection string, if you have given the service name che

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.

Question Posted / dheeraj

1 Answers
5998 Views
I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

Quickly characterize reusable change?

1089

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4709

What is rank transformation?

966

Write the advantages of partitioning a session?

1257

What do you mean by enterprise data warehousing?

1036

What are roles and groups and benefits of using them?

1037

What is Data Caches size?

1068

What are the databases that informatica can connect to windows?

1032

How can you differentiate between powercenter and power map?

1067

What is session task and command task?

1257

How can you define user defied event?

1008

Why union transformation is an active transformation?

1031

What does cheating measurement mean?

1028

What is lookup transformation?

1021

What is a code page?

1156