How to add one more SID for Database instance? Oracle

oracle sid
Artem Zubkov picture Artem Zubkov · Aug 23, 2012 · Viewed 8.9k times · Source

I want to add one more SID for database? How to do it?

Answer

Justin Cave picture Justin Cave · Aug 23, 2012

You can't. An Oracle database has a single SID. You can create multiple service names for a database. I'm not sure why you would want to have multiple SIDs but I suspect that whatever you want to do you can do by using service names.

Related questions

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

Why do I need two of them? When I have to use one or another?

Read More
How can I change the SID of an Oracle XE instance

I needed to change the SID of an Oracle XE database (not the Service Name) to match a production database. When I tried searching online, most of the pages were describing changing or adding a service name through tnsnames.ora; …

Read More
what differences SID and Service Name when use Oracle SQLDeveloper?

English is not my native please understand When I try to login like system/password as sysdba to oracle(linux) by sqldeveloper(window) It fail when through Service Name and return ORA-0131 :insufficient privileges but SID? successfully passed what differences? …

Read More