Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8i and JDBC

Re: Oracle 8i and JDBC

From: DriftWood <drift_wood_at_my-deja.com>
Date: Fri, 15 Dec 2000 14:53:04 GMT
Message-ID: <91db8d$ufh$1@nnrp1.deja.com>

If you are using the OCI driver, then create a TNSNAMES entry for the local RDBMS :

MYALIAS =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = MyMachineName)(PORT = 1521))     )
(CONNECT_DATA =

      (SERVICE_NAME = MyGlobalDBName)
    )
  )
and use that where needed.

The service name entry is quite often the same as the Global DB Name, but if you installed the Net 8 Service name to be different, then you substitute the Net 8 service name you used when you did the install.

If you would rather use the THIN driver, you must first start a TCP/IP listener on the RDBMS.

--
-cheers
  DW
--------------------------------------------------------------------
"It is a kind of good deed to say well; and yet words are not deeds.
  -William Shakespeare"


Sent via Deja.com
http://www.deja.com/
Received on Fri Dec 15 2000 - 08:53:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US