How to find Oracle Service Name
Found here, no DBA : Checking oracle sid and database name
select * from global_name;
Connect to the server as "system" using SID. Execute this query:
select value from v$parameter where name like '%service_name%';
It worked for me.