oracle11g - Connect to Oracle server from local network client -


i want connect oracle on ip 192.168.1.18 client ip 192.168.1.200 through sql developer

i setup oracle server on server

what must set on client except sql developer?

please patient me beginner using oracle

  • if use thin jdbc driver, no need install oracle on client machine (jdbc driver need).
  • check server running , have listener running ("lsnrctl status" on server side).
  • in sql developper add new connection , choose connect
  • if can't access it, verify url syntax, host/port , instance name (or service in dba_services) , sure no firewall blocks connection
  • use "tnsping yourdbserver" verify (part of oracle client install if available)
    luck


  • Comments