How to find out an Oracle DB Service Name.

Simply run the following query :

show parameter service_name;