Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8i and JDBC
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