Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

DLP's Oracle VM size issue

Created: 04 Oct 2012 | 8 comments
jawad1987's picture

I am creating a test enviornment on Virtual Machines. I am going for three tier installation. This setup is just for my own learning and testing. I was installing Oracle on Windows 7 VM. I was following steps in "Symantec_DLP_Oracle_11g_Installation_Upgrade_Guide" . I copied .dbt template file and was running DBCA wizard. When i click finish it gave me an error that the setup need 133 GB of Disk Space where as i have only 11 GB. This is test enviornment and my VM has only 20 GB of size. I don't need 133 GB database size. What should i do to overcome this error?

Comments 8 CommentsJump to latest comment

AMyers6671's picture

The template has defaults to create ~ 3 30GB db files (more or less). There are two ways to overcome this.

  1. Size up your VM to ~ 150 GB
  2. Edit the template file to create smaller database files.

If you go with #2, there is a good chance you could break something or have it not work correctly. If you can allocate the space, I would recommend you just make a bigger VM.

Aaron

If this post has helped you, please vote up or mark as solution to help others looking for the same data.

jawad1987's picture

Thanks Aaron

I found the solution at below mentioned thread and decreased db template tabsizes from 32767 MB to 1024 MB and it worked

https://www-secure.symantec.com/connect/forums/symantec-dlp-oracle-11g-r2-database-template-size

AMyers6671's picture

Great! Glad that worked for you. I've never actually tried it but may have to just to see how it works.

Aaron

If this post has helped you, please vote up or mark as solution to help others looking for the same data.

stumunro's picture

jawad amayers

i use the same method for my lab and i actually just finished a video on this, i had a client who wanted a larger DB and we used this method to expand it in the initial setup.

Glad to see it works it is failry easy to do you just have to know where to do it..

UFO's picture

What I was doing to solve the size for Oracle database was editing template .dbt file. I have changed all parameters "size unit" like this (e.g.)
<size unit="MB">20</size>
 

STS: DLP

stumunro's picture

UFO,

in the setup you can edit it. i do this so i can fit all the virtuals in my lab.

i make the whole DB inder 10 gigs

UFO's picture

stumunro, do you mean that you are setting up the Oracle DB using manual settings, not template, provided by Symantec?

This is very interesting, because, yes, this option is available during setup, but I am, for example, not aware of Oracle DB setting so good to be able to set the DB using this alternative wizard.

Could you please share step by step what do you do with manual Oracle DB setup? 

STS: DLP

stumunro's picture

i still use the template but i just tweak them going thru the setup so i can fit this is my test and demo enviroment so it does not take up a t on of space...