Do I have to install Oracle Client to connect a database?

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.