connection is only possible using the TCP/IP network protocol .
following data types are not available: OBJECT, ARRAY, REF, XML,
When connecting via OCI, you need to enter the TNS name of the database, together with the user name and password.
When connecting directly via TCP/IP, you need to enter the host name, port number and database SID separated by colons e.g.
where ORAPROD01 is the host name, 1521 is the port number that the Oracle service is listening on, and FINANCE is the database SID.