if you are familiar with the command line, then just create a new check command.

After that simply create a service with the command you created.

Share of to us and we will guide you to define the macros

here is the command that I execute but when I create a new command in the web interface with the same command it marks me (Execute Command failed)

--sql-statement should be between double quotes

--sql-statement=”select count(*)...;”

I use oracle as database even after double quotes it still says table or view does not exists

​@ganesh have you used the oracle specific connector?

https://docs.centreon.com/pp/integrations/plugin-packs/procedures/applications-databases-oracle/

https://docs.centreon.com/pp/integrations/plugin-packs/procedures/applications-databases-oracle/#prerequisites

/usr/lib/centreon/plugins/centreon_oracle.pl \
	--plugin=database::oracle::plugin \
	--hostname='10.0.0.1' \
	--help