This discussion is archived
3 Replies Latest reply: Feb 20, 2010 6:59 AM by oradebug RSS

how to prepare new instance of existing AMI installed with oracle

646883 Newbie
Currently Being Moderated
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 Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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]

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points