2 Replies Latest reply: May 12, 2011 2:17 PM by 100525 RSS

    Oracle 11.2 default instance volume is 50 GiB - How can I increase size?

    100525
      Hi,

      I created an ebs Oracle 11.2 instance that defaulted to a volume size of 50GiB.

      Does anyone know how to increase the volume size to 300GiB?

      This didn't work:

      I created another volume (300Gib), attached it to the instance, mounted the drive, but when I ran the Oracle install script - that drive didn't show up:
      Select a disk device to store your datafiles and redo logs on:

      ID DEVICE_NAME
      --- -----------
      [0] Refresh List
      [1] Use Default
      [2] /dev/sdc1

      Thanks.
        • 1. Re: Oracle 11.2 default instance volume is 50 GiB - How can I increase size?
          vxwo0owxv
          I didnt have any luck with the scripts it comes with the AMI so I just cut and paste of what I need heres the script I use.
          You can mount the 300G to /u02 or whatever you want
          and change the ORACLE_SID to <YOUR_SID_NAME>
          Also you have to run it as user oracle instead of Root
          and make sure that the ORACLE_HOME is correct
          ORACLE_SID=<YOUR_SID_NAME>
          SID=${ORACLE_SID}
          GLOBAL_NAME=${SID}
          SYS_PWD=s
          SYSTEM_PWD=s
          DBSNMP_PWD=s
          SYSMAN_PWD=s
          DBF_MOUNT=/u02
          FRA_MOUNT=/u02
          ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
          DBCA_TEMPLATE_DIR=${ORACLE_HOME}/assistants/dbca/templates
          DBCA_TEMPLATE_NAME=${DBCA_TEMPLATE_DIR}/General_Purpose.dbc
          ORACLE_OWNER=oracle
          DBCA=${ORACLE_HOME}/bin/dbca
          SQLPLUS=${ORACLE_HOME}/bin/sqlplus
          EMCTL=${ORACLE_HOME}/bin/emctl
          DB_FILE_DIR=${DBF_MOUNT}/oradata
          RECO_AREA=${FRA_MOUNT}/flash_recovery_area
          CHARSET=AL32UTF8
          
          export ORACLE_SID=${SID}
          
          mkdir -p ${DBF_MOUNT}/admin/${ORACLE_SID}
          mkdir -p ${DBF_MOUNT}/admin/${ORACLE_SID}/dbs
          mkdir -p ${DBF_MOUNT}/admin/${ORACLE_SID}/adump
          
          export EMKEY_LOCATION=${DBF_MOUNT}/admin/${ORACLE_SID}/dbs
          
          echo
          echo "Please wait while your database is created..."
          echo
          
          ${DBCA} -silent -createDatabase -templateName ${DBCA_TEMPLATE_NAME} -gdbName ${GLOBAL_NAME} -sid ${SID} -sysPassword ${SYS_PWD} -systemPassword ${SYSTEM_PWD} -dbsnmpPassword ${DBSNMP_PWD} -sysmanPassword ${SYSMAN_PWD} -emConfiguration LOCAL -storageType FS -datafileJarLocation ${DBCA_TEMPLATE_DIR} -sampleSchema true -datafileDestination ${DB_FILE_DIR} -recoveryAreaDestination ${RECO_AREA} -characterSet AL32UTF8
          RV=$?
          if [ $RV -ne 0 ]
          then
          echo
          echo "There was a problem creating your database.  Please review the log file shown above."
          else
          
          ${EMCTL} stop dbconsole
          
          ${SQLPLUS} /nolog << EOF
          ${SQLPLUS} /nolog << EOF
          connect / as sysdba
          alter system set audit_file_dest='${DBF_MOUNT}/admin/${ORACLE_SID}/adump' scope=spfile;
          EXEC DBMS_XDB.SETHTTPPORT(8080);
          ALTER USER anonymous ACCOUNT UNLOCK
          /
          @${ORACLE_HOME}/apex/.apxxepwd_custom.sql ${APEX_PWD}
          shutdown immediate
          exit
          EOF
          
          mv $ORACLE_HOME/dbs/spfile${ORACLE_SID}.ora ${DBF_MOUNT}/admin/${ORACLE_SID}/dbs/.
          mv $ORACLE_HOME/dbs/orapw${ORACLE_SID} ${DBF_MOUNT}/admin/${ORACLE_SID}/dbs/.
          ln -s ${DBF_MOUNT}/admin/${ORACLE_SID}/dbs/spfile${ORACLE_SID}.ora ${ORACLE_HOME}/dbs/.
          ln -s ${DBF_MOUNT}/admin/${ORACLE_SID}/dbs/orapw${ORACLE_SID} ${ORACLE_HOME}/dbs/.
          
          ${SQLPLUS} /nolog << EOF
          connect / as sysdba
          startup mount
          alter database archivelog;
          alter database open;
          exit
          EOF
          
          ${SQLPLUS} /nolog << EOF
          connect sysman/${SYSMAN_PWD}
          @/home/oracle/scripts/osbws/submit_osb_cloud_backup.pls
          exit
          EOF
          
          
          ${EMCTL} start dbconsole
          
          echo
          grep ORACLE_SID /home/oracle/.bash_profile > /dev/null 2>&1
          if [ $? -eq 0 ]
          then
          echo "Not adding ORACLE_SID=${SID} to /home/oracle/.bash_profile"
          echo "because ORACLE_SID is already set in that file."
          else
          echo "Adding ORACLE_SID=${SID} to /home/oracle/.bash_profile"
          echo "export ORACLE_SID=${SID}" >> /home/oracle/.bash_profile
          fi
          
          OH="\/u01\/app\/oracle\/product\/11.2.0\/db_1"
          cp /etc/oratab /tmp/oratab.bak
          sed "s/${ORACLE_SID}:${OH}:N/${ORACLE_SID}:${OH}:Y/" /tmp/oratab.bak > /etc/oratab
          
          echo
          echo "The database was created successfully."
          fi
          echo
          echo
          /home/oracle/scripts/setup_osbws.sh
          
          echo
          echo "You can connect to your database as follows:"
          echo
          echo "Command Line: sqlplus sys/<your-password> as sysdba"
          echo "Enterprise Manager Database Console: https://${ORACLE_HOSTNAME}:<port number>/em e.g. https://${ORACLE_HOSTNAME}:1158/em"
          echo "Oracle Application Express (APEX): http://${ORACLE_HOSTNAME}:<port number>/apex e.g. http://${ORACLE_HOSTNAME}:8080/apex"
          echo "Actual ports numbers can be found in ${ORACLE_HOME}/install/portlist.ini file. If this is the first database being created on this machine, the above example URLs should work."
          echo
          echo "Thank You for choosing Oracle Database on EC2."
          Edited by: vxwo0owxv on May 11, 2011 1:01 PM
          • 2. Re: Oracle 11.2 default instance volume is 50 GiB - How can I increase size?
            100525
            Thank you very much - I'll take a look.