aspose file tools*
The moose likes Oracle/OAS and the fly likes Connecting to Oracle Server From a Linux Client Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Connecting to Oracle Server From a Linux Client" Watch "Connecting to Oracle Server From a Linux Client" New topic
Author

Connecting to Oracle Server From a Linux Client

Joe Harry
Ranch Hand

Joined: Sep 26, 2006
Posts: 9383
    
    2

Guys,

I have an Oracle 11.x DB server installed on Windows. I have a Linux Box running Ubuntu on which I have the instant client installed. But when I try to connect to the oracle database server, I get the following error:



And my tnsnames.ora looks like:



I later even tried to change the HOST in my tnsnames.ora to the ip address. But that resulted in the following error:




Any suggestions on what has gone wrong?


SCJP 1.4, SCWCD 1.4 - Hints for you, Certified Scrum Master
Did a rm -R / to find out that I lost my entire Linux installation!
Joe Harry
Ranch Hand

Joined: Sep 26, 2006
Posts: 9383
    
    2

Got ahead with the problem. There was a firewall blocking on the machine that runs the Oracle server. Made some firewall changes and then everything started working.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connecting to Oracle Server From a Linux Client