3 Replies Latest reply: Feb 20, 2010 8:59 AM by oradebug RSS

    how to prepare new instance of existing AMI installed with oracle

    646883
      Hi All

      I have created one centos instance from existing aws ami's and attached 2 ebs volumes each of 50gb, created raid 0 in between the both ebs volumes and attached the raid volume as /raidvol, installed entire oracle software on /raidvol partition, started the databse and everything is working fine.

      i prepared the existing instance as AMI.

      now i have taken snapshot of the above 2 ebs volumes and made them as volumes

      now when i create an instance of the above ami i generally get the old instance settings wrt oracle, how do i change the settings to new instance so that i can attach the existing volumes and start oracle.

      kindly suggest any procedure.

      Anil
        • 1. Re: how to prepare new instance of existing AMI installed with oracle
          oradebug
          What do you mean by 'instance settings'? Are you referring to initialization parameters, kernel parameters, or the database state?

          Anything that you want to persist has to be on the EBS volumes. If you have /etc/oratab, /etc/oraInst.loc, oraInventory, etc. on the ephemeral storage, it will revert to AMI state on termination and restart. You should make all those things symbolic links to files in your EBS filesystem and rebundle the AMI.

          Or you could use "boot from EBS".

          Jeremiah Wilton
          Blue Gecko, Inc.
          [http://www.bluegecko.net|http://www.bluegecko.net]
          • 2. Re: how to prepare new instance of existing AMI installed with oracle
            749190
            To store AMI, S3 storage is needed which is extra charge.

            May be, you can do following
            - Create AMI using pubic image
            - Create new volume using EBS
            - Move Oracle binaries (ORACLE_BASE) to EBS
            - Create database with all files on EBS (e.g. admin files, db files, ..)
            - Backup .profile on EBS (which has ORACLE_HOME, ORACLE_SID etc.)
            - Terminate and recreate AMI
            - Attach your EBS volume
            - Delete pre-configured binaries and restore your .profile

            HTH,
            nilesh
            • 3. Re: how to prepare new instance of existing AMI installed with oracle
              oradebug
              nilesh_patel wrote:
              To store AMI, S3 storage is needed which is extra charge.
              For a 1GB AMI, it is $0.15 / month.
              - Create AMI using pubic image
              - Create new volume using EBS
              - Move Oracle binaries (ORACLE_BASE) to EBS
              - Create database with all files on EBS (e.g. admin files, db files, ..)
              - Backup .profile on EBS (which has ORACLE_HOME, ORACLE_SID etc.)
              - Terminate and recreate AMI
              - Attach your EBS volume
              - Delete pre-configured binaries and restore your .profile
              The pieces that you need to persist are the /etc/oratab, the (s)pfile and the passwordfile. You don't need to copy the whole ORACLE_HOME. You just have to fix up symbolic links on those two places in the OEL community AMI to point to your persistent copies on EBS.

              Jeremiah Wilton
              Blue Gecko, Inc.
              [http://www.bluegecko.net|http://www.bluegecko.net]