It is possible in theory, as Temporal has a well-defined API that a specific DB binding can implement. It already supports MySQL, PostgreSQL, SQLite, and Cassandra. So Oracle can be added by implementing this interface.
AFAIK no one has implemented the Oracle binding yet.