CODEWITHSUNDEEP
oracle-databaseoracle10g
karikari
karikari

Reputation: 6797

Where to get Oracle SERVICE_NAME?

I just installed Oracle database 10g free version for students on my Windows XP. I am confused how to know the SERVICE_NAME? Am running it at my localhost 127.0.0.1, with username SYSTEM. May I know where can I get to know the SERVICE_NAME?

Upvotes: 6

Views: 29345

Answers (2)

Gary Myers
Gary Myers

Reputation: 35401

It is normally XE for the free version. ORCL is another typical value.

Once logged in, it can be determined from 

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

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

Upvotes: 13

billygoat
billygoat

Reputation: 21984

Since its windows, you can go to control panel - administrative tools - services : (switch to classic mode in control panel if you do not see admin tools). Once there you will have a service by the name "Oracle service_". The is your service name.

Upvotes: 4

Related Questions