Oracle 11gR2 - ASM tablespace creation

Hi,

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).
ORACLE_SID=+ASM
ORACLE_BASE=/u01/app/grid
ORACLE_HOME=/u01/app/grid/product/11.2.0/grid

-      Instance DPDB:
ORACLE_SID=DPDB
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1

-      Mount Points created in ASM:
Visible through the user GRID and the ASM tool.
NOTE: not usual UNIX filesystems
Eg.:
$ asmcmd
ASMCMD> lsdg
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?

Any suggestion?

Tks,
Joao
joaotellesAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

BajwaCommented:
You can do that from ASMCMD or from sqlplus or from asmca (gui utility) as grid user.
for asmcmd check
http://docs.oracle.com/cd/B19306_01/server.102/b14215/asm_util.htm

for sqlplus
1. logon as GRID user
2. set the environment for your ASM instance
3. sqlplus "/ as sysasm"
and then for external redundancy (meaning that SAN is taking care of striping and mirroring)

create diskgroup DG_NAME external redundnacy disk 'ORCL:DISK' attribute 'au_size' = '4m';

another good website
http://www.oracle-base.com/articles/11g/AsmEnhancements_11gR1.php

then you can create a tablespace as

1.  logon as oracle
2. set the environment and run
3. create tablespace my_ts_name datafile '+DG_NAME' size 4096m
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
joaotellesAuthor Commented:
So let me see if I get it:

the DG's are already created:
ASMCMD> lsdg
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 I can login here:
-      Instance DPDB:
ORACLE_SID=DPDB
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1

And create the tablespaces as this:
create tablespace my_ts_name datafile '+DG_NAME' size 4096m,
using the Oracle user.

Is this correct?
0
BajwaCommented:
Sure!! You have three  Disk Groups

ARCH
DATA
REDO

you can use any of the with
create tablespace my_ts_name datafile '+DATA' size 4096m;

This will create the tablespace.
0
BajwaCommented:
This is exactly how it should work.  If you are getting error from inside the database (DPDB) which creating the tablespace then you need to put oracle user (database os owner) in appropriate OS groups.
0
joaotellesAuthor Commented:
Tks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.