Resolution:
Set-up the drivers (TIbase.jar, TIutil.jar & TIoracle.jar) in your class path by :
c:\tibco5\tpcl\5.2\jdbc&gtset CLASSPATH=TIoracle.jar;TIbase.jar;TIutil.jar;%CLASSPATH%


And run the following java command to return the version string:
c:\tibco5\tpcl\5.2\jdbc> java tibcosoftwareinc.jdbc.oracle.OracleDriver

A typical output should be:
C:\tibco5\tpcl\5.1\jdbc&gtjava tibcosoftwareinc.jdbc.oracle.OracleDriver
[tibcosoftwareinc][Oracle JDBC Driver]Driver Version: 3.3.008802005002004203