SQLServerCentral.com / SQL Server 2008 / Working with Oracle / is it possible to have Single instance(name or SID) on multiple database? / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 02 Aug 2015 16:48:59 GMT20RE: is it possible to have Single instance(name or SID) on multiple database?http://www.sqlservercentral.com/Forums/Topic1469415-1044-1.aspx[quote][b]nikunj_lodhi (7/3/2013)[/b][hr]@Paul: I want to use the same instance number for ten different servers so dats y i was looking for it[/quote]Oracle instances are identified by the SID defined by ORACLE_SIDAnswering your question, yes... you can have the same SID in multiple servers, they are independent and do not care about each other.Wed, 03 Jul 2013 09:38:00 GMTPaulB-TheOneAndOnlyRE: is it possible to have Single instance(name or SID) on multiple database?http://www.sqlservercentral.com/Forums/Topic1469415-1044-1.aspxHi All,Thanks for the reply.@steve, that was what i was looking for.....can we do this with Oracle too......???@Paul: I want to use the same instance number for ten different servers so dats y i was looking for it.....Still thanks......:)Wed, 03 Jul 2013 09:30:07 GMTnikunj_lodhiRE: is it possible to have Single instance(name or SID) on multiple database?http://www.sqlservercentral.com/Forums/Topic1469415-1044-1.aspxIn SQL Server, you have an instance that contains control information, scheduling, logins, etc. and then you can have multiple databases inside the instance. The instance is at a higher level, and acts as a container for the databases.You can have multiple instances on a Windows host, but each of those has it's own databases.Wed, 03 Jul 2013 09:23:17 GMTSteve Jones - SSC EditorRE: is it possible to have Single instance(name or SID) on multiple database?http://www.sqlservercentral.com/Forums/Topic1469415-1044-1.aspx[quote][b]nikunj_lodhi (7/2/2013)[/b][hr]I wanted to know that can we have a single instance on two different databases?[/quote]Since this was posted on the Oracle section of the forum, please allow me to answer from the Oracle point of view.An Oracle Instance and an Oracle Database are one and the same. It refers to the set of code - either Unix daemos or Windows services - plus data files, control files, etc.Hope this helps.Wed, 03 Jul 2013 08:50:20 GMTPaulB-TheOneAndOnlyRE: is it possible to have Single instance(name or SID) on multiple database?http://www.sqlservercentral.com/Forums/Topic1469415-1044-1.aspx[quote][b]nikunj_lodhi (7/2/2013)[/b][hr]Hi Folks,I wanted to know that can we have a single instance on two different databases?I am till now aware that it is a one to one relation(correct me if i'm wrong)If yes,then how?Thanks in advance...!!![/quote]If I read your post I think you are mixing up Oracle and Microsoft SQL Server. I have almost no knowledge of Oracle DBMS but AFAIK a database can relate to multiple Oracle instances (see [url]http://docs.oracle.com/cd/E11882_01/server.112/e10713/startup.htm[/url]). That is contrary to Microsoft SQL Server where there is one instance that can contain one or more user-databases.Tue, 02 Jul 2013 06:32:03 GMTHanShiRE: is it possible to have Single instance(name or SID) on multiple database?http://www.sqlservercentral.com/Forums/Topic1469415-1044-1.aspx[quote][b]nikunj_lodhi (7/2/2013)[/b][hr]Hi Folks,I wanted to know that can we have a single instance on two different databases?I am till now aware that it is a one to one relation(correct me if i'm wrong)If yes,then how?Thanks in advance...!!![/quote]your question is not exactly clear, because "instance" has a special meaning to SQl server, whcih referneces a complete , independant installation potentiallycontaining one or more user databases.By the title of the post, i think you mean" is it possible to have one specific user in two different databases?If that is the quesiton, then the answer is yes, because each user points to a specific login, and that login is unique.Code Examples would be something like this, where I'm assuming you have two databases named "SandBox" and "Development"[code]USE master;create login ClarkKent with password = 'NotTheRealPassword';USE [SandBox]Create USER [ClarkKent] FOR LOGIN [ClarkKent] USE [Development]Create USER [ClarkKent] FOR LOGIN [ClarkKent] [/code]with that, the user ClarkKent would be able to connect to the Server, and use either of those two databases, but as it sits, they could only see a few rows in sys.objects; i didn't grant access to anything specific, other than what the public role can see in any database by default.Tue, 02 Jul 2013 06:19:35 GMTLowellis it possible to have Single instance(name or SID) on multiple database?http://www.sqlservercentral.com/Forums/Topic1469415-1044-1.aspxHi Folks,I wanted to know that can we have a single instance on two different databases?I am till now aware that it is a one to one relation(correct me if i'm wrong)If yes,then how?Thanks in advance...!!!Tue, 02 Jul 2013 05:43:00 GMTnikunj_lodhi