1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

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

What is informatica worklet?

606

What is mapplet in informatica?

588

What do you understand by term role-playing dimension?

566

What are the different clients of powercenter?

592

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

624




Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

548

What is informatica?

675

Explain the types of lookup transformation?

560

Explain what are the different versions of informatica?

651

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1530

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

707

How to join three sources using joiner? Explain though mapping flow.

689

Is there any target staging area in informatica not staging area

2120

What is meant by target load plan?

550

what is size of u r database?

1844