I can only answer this question from the perspective of VERITAS Cluster Server - which is the enterprise clustering technology I know and most often use. Clustering at this level relies on a number of "resource management" concepts. At the VCS level you would be looking at "resources" (monitored by agents), and "Service Groups". Resources have 'dependencies' within Service Groups and Service Groups can have dependencies between each other. The behavior of each resource depends entirely on the way it has been configured within VCS.
Where Oracle is concerned, you would have single service group with two major components - the Oracle DAtabase itself and the Oracle Listener. The database would depend on a number of resources - mostly storage related, however the Oracle Listener would be dependent on the Oracle Database. Without the Oracle Database present, the Oracle Listener would not come online.
I cannot speak for the clustering technology you are currently using, as you have provided no configuration information, however VERITAS Cluster Server has a specific "Agent" for Oracle which knows about all the processes that need to be monitored on a SID by SID basis in order that service group high availability can be achieved.
Hope this helps in some way