|
check ur tnsnames.ora file.. there has to be an entry in it.
host_name:ip address of the pc or server ur connecting sid=oracle instance name
for eg
test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = host_name)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = host_name)
(Port = 1526)
)
)
(CONNECT_DATA = (SID = instance_name)
)
)
|