4 Replies Latest reply: May 17, 2014 12:09 PM by Jyoti Verma -Oracle RSS

    single instance database installation on clustered system

    Saurabh Gupta-OC

      Dear Folks,

       

      We have a clustered database server (11gR2 on Linux), in which 2 node RAC DB is installed. We have a requirement to install few single instance databases on these servers.

       

      Kindly suggest:

      • Oracle & Grid software owner should be same or different
      • Oracle Home should be same or different (Oracle version is same here)
      • What are the best practices in such installation cases
      • Do we require to install another ASM & GRID home or it can be managed in the same installed & running cluster system?
      • How ASM would be connecting, suppose we install db on db node1 then ASM sid would be +ASM1 or just +ASM?
      • Other things to take care in such case

       

      Kindly share if you have a detail design & implementation document.

       

      Thanks & Rgrds

      Vineet

        • 1. Re: single instance database installation on clustered system
          oscrub
          Oracle & Grid software owner should be same or different

          What do you already have currently? I see no reason to change the current ownership configuration just because you are going to add single instances. Unless there is a specific need for separate users, eg. auditing purposes, or a different DBA team is to manage the single instances.

           

          Oracle Home should be same or different (Oracle version is same here)

          If the version is the same, the Oracle Database Home can be the same.

           

          What are the best practices in such installation cases

          Generally there isn't much difference from installing on a standalone server. One consideration would maybe creating a separate listener for the single instance DBs

           

          Do we require to install another ASM & GRID home or it can be managed in the same installed & running cluster system?

          You can use the current Grid home to manage the ASM instance for the single instance databases.

           

          How ASM would be connecting, suppose we install db on db node1 then ASM sid would be +ASM1 or just +ASM?

          +ASM1

           

          Other things to take care in such case

          Are the new databases for production use as well? Performance, capacity, etc. Be aware that if all your databases are running from the same Oracle Home. What if you need to upgrade the DB version, and one of your apps running on the single instance isn't certified on that version? Then you might want to consider using different Oracle Homes.

           

          HTH,

          Oscar

          • 2. Re: single instance database installation on clustered system
            Top.Gun

            I don't see a reason for different software owner, or Oracle home.

            The rule is keep it as simple as you can.

            • 3. Re: single instance database installation on clustered system
              J.A.

              Use the same GRID and DB user. Just use DBCA to create a Stand Alone Database, that´s all.

               

              If you use DBCA, you can choose all the configurations and you choose there ASM to create your database.

               

              The reason to use another OS user, or another Oracle_Home, for example: if you have an EBS environment on one node of your RAC (Stand Alone Database), then yes use another S.O. User, another Listener and another Oracle_Home, so you can patch, restart services without affecting the RACs Databases.

               

               

              Regards

              • 4. Re: single instance database installation on clustered system
                Jyoti Verma -Oracle

                In addition to the above, you cant have multiple ASM and GRID installations on the same node. I meant you can have only a single ASM instance on a node. Also, you can have only one working clusterware installation on a node.