Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to get SERVICE_NAME

 
Arun raghvan
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How to get service_name of oracle (not manually from tnsname.ora) ..through Query
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you have already connected to Oracle to run said query, why do you need to know the service name (if there is one).
 
Tom Reilly
Rancher
Posts: 618
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't have access to an Oracle instance so I have not tried it but this link looks promising: http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/functions165.htm#i1038176. Can you reply back if successful?
 
Tom Reilly
Rancher
Posts: 618
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
That URL didn't work for me. Here's the raw text:

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/functions165.htm#i1038176
 
Rene Larsen
Ranch Hand
Posts: 1179
Eclipse IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
AFAIK you can not get a list of all available service_names (or SIDs if service_names are not used) without connecting to a DB first with a user with SYSDB roll.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic