5 Replies Latest reply: Dec 1, 2012 1:09 AM by qazianeel RSS

    Creation of separate database

    qazianeel
      Hello friends,

      I've to create a new database like production but don't know how do I proceed!

      The server detail is as under:
      EBS 12.1.1
      Redhat Linux 64bit
      Vision database

      The partition detail is as under :

      Filesystem     -     Size      -     Used      -     Avail      -     Use% -     Mounted on
      /dev/sda5     -     15G      -     2.5G -      12G      -     18%      -     /
      /dev/sda7     -     107G -      40G -     62G      -     39%      -     /PROD
      /dev/sda3     -     54G -     47G      -     3.6G -     93%      -     /stage
      /dev/sda2     -     262G -     232G -      17G      -     94%      -     /VISION
      /dev/sda1     -     99M -     12M -     83M      -     13%      -     /boot
      tmpfs          -     3.9G -     2.8M -     3.9G -      1%      -     /dev/shm

      Memory details:

      Total Memory : 7974
      Used Memory : 7893
      -/+ buffers/cache: 1773 / 6200
      Swap: 16386, used: 0

      SGA size:
      sga_max_size: 4G
      sga_target: 4G

      It seems I don't have much space. Further I can't delete vision as we use it for demo purpose.

      Please help.

      Regards


      Aneel