Solved

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

Posted on 2001-06-06
4
263 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
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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
IPtables not running - RHEL7 64bit 5 246
Shell script / command to generate IO / IOPS load 22 430
Use Powershell script to ftp 10 119
Why  my code (program) build with old compiler? 11 78
Have you ever been frustrated by having to click seven times in order to retrieve a small bit of information from the web, always the same seven clicks, scrolling down and down until you reach your target? When you know the benefits of the command l…
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…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

828 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