This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

problem with getting connection to oracle database installed on linux.

 
Arun Boraiah
Ranch Hand
Posts: 233
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,
I am trying to access the oracle database installed on linux platform using jdbc call. And I am not able to access. The same database I am able to access through the UI tool such has TOAD and also through sqlPlus.
I checked the url supplied to DriverManager.getConnection() method by accessing for database installed on windows, which is working well.
url supplied is jdbcracle:thin:@IP:1521atabase name
I even tried replacing the database name with SID but did not work.
So what would be error? If you want more details of the problem, please let me know what type of detail you require to shout out my problem
Thanx
Regards
arun
 
martin samm
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
given the url jdbcracle:thin:@IP:1521B
1. Can you ping the specified IP from the linux machine?
2. tyr using a different port, sometimes the listener is installed on 1525
3. the DB when using thin must be the database SID. I fyou use OCI, then use the TNS alias you set up on the Linux machine
Hope that works
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic