Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2008-06-16
3
2,422 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
3 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 250 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

856 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