How to find Oracle Service Name

Question

I have an Oracle database on my network which I am able to connect to with Oracle SQL Developer  using hostname  port  username  password and the SID   I need to connect another application  Quantum Gis   however it uses the Service Name instead of the SID   Is there any way for me to determine the SERVICE NAME of the database when I am connected in SQL Developer via the SID   I do not have access to the server and have no local tnsnames ora or similar

User · Answer

Connect to the database with the  system  user  and execute the following command   show parameter service name

User · Answer

Overview of the services used by all sessions  provides the distionary view v session or gv session for RAC databases  in the column SERVICE NAME   To limit the information to the connected session use the SID from the view V MYSTAT   select SERVICE NAME from gv session where sid in   select sid from V MYSTAT    If the name is SYS USERS the session is connected to a default service  i e  in the connection string no explicit service name was specified   To see what services are available in the database use following queries   select name from V SERVICES  select name from V ACTIVE SERVICES

User · Answer

Thanks to this thread  https   community oracle com thread 473276   select sys context  userenv   service name   from dual   It can be executed with a regular user account  no need for sysdba rights

User · Answer

Found here  no DBA   Checking oracle sid and database name  select   from global name

User · Answer

TO FIND ORACLE SID USE    oraenv

User · Answer

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

User · Answer

Check the service name of a database by  sql  show parameter service

User · Answer

With SQL Developer you should also find it without writing any query  Right click on your Connection Propriety   You should see the name on the left under something like  connection details  and should look like  Connectionname servicename   or on the right  under the connection s details

[oracle] How to find Oracle Service Name

Examples related to oracle