Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle d.b URL explanation please

 
m.indira mandapati
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Driver class name
oracle:jdbc river racleDriver
Connection
URL is jdbc racle ci8@connect_string active1ORCL

active1ORCL is {host=active1;port=1521; service=ORCL}
Please explain each part of URL.
As per my understanding
jdbc is the protocol
oracle is the database driver
oci8@connect_string active1ORCL represents how to connect to database server.where oci8 is oracle calling interface library inside the client machine. active1ORCL is the address of database server.
In that host = active1 '?' how do we find this (is it a server name)
port=1521 for oracle server port is always this ( am i right)
service =ORCL '?' is this an instance of server ,where can we find it?
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How to Connect to Oracle. Just choose the OCI or thin driver for the URL explanation.
Jamie
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic