?
Solved

Unable to connect to oracle database repository from informatica repo server admin console

Posted on 2008-06-16
3
Medium Priority
?
2,494 Views
Last Modified: 2013-12-19
I have oracle 9.2 on my windows machine..I installed informatica 7.1 on the same machine and have been using and running that for 2 years...
Now I have installed oracle 10g standard edition also and installed oracle warehouse builder(OWB) tool and a repository is created in 10g.I can run OWB workflows and access 10g repository.
I can use both databases from the sql client.but when I'm starting my info repo server , it says TNS could not resolve connection identifier specified. So i removed oracle 10g totally and trying to connect to informatica thru repository server admin console..Now it throws another error, ORA-12557: TNS:protocol adapter not loadable

Can you plz tell me the solution for this??

Thanks


please let me know whats going wrong..
0
Comment
Question by:mpaladugu
1 Comment
 
LVL 74

Accepted Solution

by:
sdstuber earned 1000 total points
ID: 21805874
reinstall 10g then

copy  sqlnet.ora, tnsnames.ora  and ldap.ora (if used) from your 9i home $ORACLE_HOME_9i/network/admin to your $ORACLE_HOME_10g/network/admin

0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to recover a database from a user managed backup
Suggested Courses
Course of the Month8 days, 19 hours left to enroll

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question