Home » SQL & PL/SQL » SQL & PL/SQL » Re: connecting oracle 8i with d2k
Re: connecting oracle 8i with d2k [message #19658] Wed, 03 April 2002 01:12
hanu
Messages: 21
Registered: March 2002
Junior Member
You can connect oracle either using net8 or by inserting an entry physically into tnsnames.ora
as follows:

ORACLE_SID =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle_server)(PORT = 1521)))
(CONNECT_DATA =
(SERVICE_NAME = ORACLE_SID))
)

But, there are some other parameters which will have effect on this physical entry. So, it's better to use NET8.
Previous Topic: Re: connecting oracle 8i with d2k
Next Topic: Urgent :to Copy data between users
Goto Forum:
  


Current Time: Thu Mar 28 10:52:43 CDT 2024