Home Forums SQL Server 2008 Working with Oracle is it possible to have Single instance(name or SID) on multiple database? RE: is it possible to have Single instance(name or SID) on multiple database?

  • July 2, 2013 at 6:32 am

    #1629031

    nikunj_lodhi (7/2/2013)

    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...!!!

    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 http://docs.oracle.com/cd/E11882_01/server.112/e10713/startup.htm). That is contrary to Microsoft SQL Server where there is one instance that can contain one or more user-databases.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **