0

what is the service name of oracle10g xe database

Improve this question
1
  • Please choose tags carefully. JavaScript != Java and .NET != Java. I removed the irrelevant tags. Commented Jul 8, 2010 at 12:19

3 Answers 3

Reset to default
1

It varies ragarding the network. In our local system it'll be 'localhost'

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

... localhost is the IP (127.0.0.1) if you have a local install of the oracle database. The service name is a different part of the connect string.
1

The jdbc url for a locally installed xe databse would look like this: jdbc:oracle:thin:@127.0.0.1:1521:XE, note that XE is the SID, a service name does not seem to be needed for jdbc.

Improve this answer

1 Comment

You can assign different services to the same SID (eg for resource management purposes) using listener.ora. But by default you'll get a service with the same name as the sid, which is XE.
0

Service name is ambigious. But as you asked about jdbc I guess you need advice on the service name that is used on the jdbc url.

Here is a good article with a link to oracle sources.

Basically it says that the format is

jdbc:oracle:thin:scott/tiger@//myhost:1521/myservicename

and myservicename can be found in TNSNAMES.ORA.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.