No, you can use “Basic Type” option in the Connection Mode when you are creating a connection in Connection Manager. Only Host name/IP, port id and SID/Service name are required for “Basic Type” option.
Oracle client is required only if you are using “TNS” option as the Connection Mode.