Where to get Oracle SERVICE_NAME?

Question

I just installed a free version of the Oracle 10g student database on my Windows XP. I'm confused how to find out SERVICE_NAME? I run it on my localhost 127.0.0.1 with the username SYSTEM. Can I find out where I can find SERVICE_NAME?

Answer 1

This is usually XE for the free version. ORCL is another typical value.

After logging in, it can be determined from

select sys_context('USERENV','SERVICE_NAME') from dual 

If you need to know this so that you can log in, find the file called TNSNAMES.ORA in $ ORACLE_HOME / rdbms / network / admin and the service name will probably be in the connection string.

Answer 2

From its windows you can go to the control panel - administrative tools - services: (switch to classic mode on the control panel if you do not see administrator tools). After that, you will receive a service called "Oracle Service". This is your service name.