Solved

connectivity of oracle from client(Nt) to server(linux)

Posted on 2001-06-06
4
265 Views
Last Modified: 2010-04-21
Well I have
oracle client(NT) IP :: 93.83.18.192
oracle server(LInux) IP :: 93.83.18.253
ok !! since for connectivity from client to server I changed the Tnsnames.ora in client side ip address of server ..

Then I ran the sqlplus .. I got the below error

ERROR:
ORA-12545: Connect failed because target host or object does not exist
..PLs tell me ..
0
Comment
Question by:tony111400
[X]
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
4 Comments
 
LVL 3

Accepted Solution

by:
superschlonz earned 100 total points
ID: 6197227
It should look something like this: (replace MYDATABASE and MYSID by the
name you like for the connection and the SID of the database)

MYDATABASE.WORLD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 93.83.18.253)(PORT = 1521))
    (CONNECT_DATA = (SID = MYSID))
  )

You should also find theSID informations in listener.ora on the server.
0
 

Expert Comment

by:skullface
ID: 6199692
i think this should help a bit.. apart form what super has already given..

http://www.is.mcgill.ca/banner/pst/helpdesk/errors/ora12545.htm
0
 
LVL 20

Expert Comment

by:jmcg
ID: 9868842
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: superschlonz {http:#6197227}

Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

jmcg
EE Cleanup Volunteer
0

Featured Post

Want Experts Exchange at your fingertips?

With Experts Exchange’s latest app release, you can now experience our most recent features, updates, and the same community interface while on-the-go. Download our latest app release at the Android or Apple stores today!

Question has a verified solution.

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

The purpose of this article is to fix the unknown display problem in Linux Mint operating system. After installing the OS if you see Display monitor is not recognized then we can install "MESA" utilities to fix this problem or we can install additio…
The purpose of this article is to demonstrate how we can upgrade Python from version 2.7.6 to Python 2.7.10 on the Linux Mint operating system. I am using an Oracle Virtual Box where I have installed Linux Mint operating system version 17.2. Once yo…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

626 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