Oracle 11gR2 - ASM tablespace creation
Posted on 2012-03-12
Im trying to set up Oracle using ASM. Installed it like this:
Oracle was installed using 11GR2 patterns.
Two users created: grid for infrastructure and Oracle for the DB
- Instance ASM: (Infrastructure).
- Instance DPDB:
- Mount Points created in ASM:
Visible through the user GRID and the ASM tool.
NOTE: not usual UNIX filesystems
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 25557 25505 0 25505 0 N ARCH/
MOUNTED EXTERN N 512 4096 1048576 66519 64931 0 64931 0 N DATA/
MOUNTED EXTERN N 512 4096 1048576 10197 10145 0 10145 0 N REDO/
So now the problem:
I will run a script that will create a bunch of tablespaces - among other things - for DPDB (script wasnt set for ASM use).
So I have to run these TS manually.
Basically a appl will have to access the tables inside these tablespaces using the DPDB.. but Im not sure how to create then for ASM...
I read this:
'You need to create your diskgroups in ASM, then create your tablespaces in the ASM diskgroup.
If you setup the instance with db_create_file_dest = ‘+<DISKGROUP>’ then you can simply do “create tablespace <TBLSPACE_NAME>;” '
Would it be the right way to do it? How could I create these diskgroups in ASM? This variable is necessary?