How SID is different from Service name in Oracle tnsnames.ora

Quote by @DAC

In short: SID = the unique name of your DB, ServiceName = the alias used when connecting

Not strictly true. SID = unique name of the INSTANCE (eg the oracle process running on the machine). Oracle considers the “Database” to be the files.

Service Name = alias to an INSTANCE (or many instances). The main purpose of this is if you are running a cluster, the client can say “connect me to SALES.acme.com“, the DBA can on the fly change the number of instances which are available to SALES.acme.com requests, or even move SALES.acme.com to a completely different database without the client needing to change any settings.

Related Posts:

  1. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  2. Oracle SQL query for Date format
  3. Difference between partition key, composite key and clustering key in Cassandra?
  4. How do I reset a sequence in Oracle?
  5. Will it break my site if I delete all transient records in wp_options table?
  6. Safest way to bulk delete post revisions
  7. Please explain how WordPress works with MySQL character set and collation at a low level
  8. Two WordPress sites sharing the same content
  9. Automate WordPress Database Upgrade
  10. Why does $wpdb return strings for mysql integer values?
  11. How can I migrate from another platform to WordPress (using the same domain) and launch when ready?
  12. Where are image paths to product category images stored in WordPress database
  13. Sharing database for collaborative development
  14. Inserting data into custom tables
  15. Can I use MariaDB instead of MySQL in wordpress?
  16. What’s the database relationship between a post and its attachments
  17. Saving Metadata from the Gutenberg Editor Sidebar to the Database
  18. Prevent changing the length of post_name column on WordPress Update
  19. Migrate a Non WordPress database to wordpress [closed]
  20. Moving an entire wordpress site from one domain to a new domain and database
  21. how to transfer wordpress sql/database from local to live
  22. Custom DB_COLLATE (collation) value not working on fresh install?
  23. What causes the “max_user_connections” warning on WordPress frontend?
  24. Get Database Credentials from within the themes file
  25. what to do when your WordPress database is too large?
  26. How does WordPress create its database during installation?
  27. How to use user table of a different database for WordPress users?
  28. Subscribers to posts
  29. $wpdb->update has finished saving trigger?
  30. WordPress site uses MyISAM, should I switch to InnoDB necessary?
  31. WP Database Table to CSV file
  32. For WordPress is there content in the database which I can safely ignore?
  33. How can I UN-orphan media files?
  34. Does WordPress always create unique passwords?
  35. Uppercase to sentence case for post titles
  36. Merge two WordPress installations into one, and keep posts separated?
  37. Moving online website to MAMP or dumb idea?
  38. WordPress database import: Row size too large
  39. Advanced SELECT query with condtional statements
  40. Export / import WordPress database
  41. WordPress choose wrong database
  42. How can I (semi) automate a database export and import to a different location?
  43. Is it safe to delete unnecessary user metadata?
  44. Improve performance by removing unnecessary database queries
  45. Redirecting to old domain after migration website
  46. WordPress Relational Database
  47. Switching Databases in LocalHost
  48. How to update the values when the featured image has changed?
  49. Does WordPress $wpdb functions wait when table is locked?
  50. Unable to set a default serialized array using dbdelta()
  51. Importing 10 Years of Media into the WP Database
  52. 2 WordPress sites with 2 databases but sharing the same users
  53. How to get nav_menu_item_id and slug from wp database
  54. connecting to DB from custom php file
  55. Is there a way to execute a php script outside WordPress?
  56. Make changes of wp-db.php file persistent against updates
  57. How can I restrict php mail() to only send me one email after a db error
  58. Change the default data installed when setting up WordPress
  59. How to delete post comments from the database via SQL statement?
  60. Clear Terms from Taxonomy for Specific Post IDs?
  61. Why does changing Database Table Prefixes result in loss of content?
  62. How to split the WordPress database?
  63. $wpdb->get_var – What value is returned when zero records are found?
  64. SymmetricDS in dev + prod workflow?
  65. Fixing YARPP plugin FULLTEXT MySQL indexing
  66. What is wrong here? Issue with post_id and meta_value
  67. Only allow user to access a link once a year, based on their joining date
  68. Error establishing a database connection in wordpress site , website not opening
  69. Counting post and changing roles in mysql database. Query not code
  70. wpdb Insert unknown post data dynamic foreach loop
  71. How do I use a database in a custom theme?
  72. Deleting empty meta key values
  73. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  74. WP 5.5, child themes, customizer and a weird cache issue
  75. Migrating meta_key and meta_value from old theme to new one
  76. How do you enable scripts on a WordPress installation in Softaculous?
  77. How to rerieve comments and their replies from DB
  78. Inserting data with Geometry field
  79. Export only a part of the database for migration
  80. Why am I being prompted to reinstall wordpress?
  81. What’s the easiest way to connect external database and display data on wordpress?
  82. database error WordPress move from one hosting to other
  83. Select data from foreach loop and send it to wordpress database
  84. Error establishing database connection error during first WordPress run
  85. Same DB for live and dev versions
  86. update multiple user meta field based on another meta field
  87. After renaming MySQL database, I can no longer access my Blog page
  88. execute custom function on database connection error
  89. Call to a member function insert()
  90. Create a new table on the database and save parameters from a contact form
  91. not saving post in wp_post wordpress database table
  92. How to have WP Search widget index dynamically generated content?
  93. How to add data from wordpress tables to new database tables you have created
  94. Creating Tables in WordPress Database
  95. Calling update_user_meta inside of another function doesn’t work
  96. Install WordPress with SQL database
  97. How to back-up a database on IIS
  98. $wpdb->prepare returns empty array
  99. Where are database files of a WordPress website?
  100. WordPress database connection failed, while mysql client is working [closed]

Leave a Comment