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.
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
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is informatica powercenter repository?
What is meant by lookup transformation?
Clarify the utilization of aggregator cache record?
In informatics server which files are created during the session rums?
What do you understand by term role-playing dimension?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Mention a few design and development best practices for informatica?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Can informatica load heterogeneous targets from heterogeneous sources?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Can we create two repositories on same database instance in oracle?
Explain the features of connected and unconnected lookup.
Explian the Process of deployment groups in informatica
Explain the informatica workflow?