Q
Problem solve Get help with specific problems with your technologies, process and projects.

Difference between service_name and database_name?

What is the diference between service_name and database_name for Oracle 9i?

The database name is exactly as it implies, the name of your database. The database name is the same as your ORACLE_SID for that database.

A service name is a logical representation of your database for users connecting to the database through Oracle Net software. A database can be presented as multiple services, and a service can be implemented as multiple instances. For instance, you can have one service name that connects to multiple instances in a Real Application Clusters environment.

Most people configure their networking software to have the service name be the same as their database name. When this happens, the distinction between the two is not quite clear.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close