Link to home
Create AccountLog in
Avatar of nobleit
nobleit

asked on

diskgroup

I want to create a tablespace in a diskgroup in 11g
how will I find the diskgroup..
if not how can I configure...
in order to create a tablespace..
Avatar of cheers4beers
cheers4beers
Flag of United States of America image

Start with the ASMCA utility (ASM Configuration Assistant), or you can use ASMCMD from the command line.  This will allow you to see and administer existing diskgroups, as well as create new ones.

Then use the following syntax:

CREATE TABLESPACE my_ts DATAFILE '+disk_group_1' SIZE 100M AUTOEXTEND ON;
Avatar of devind
devind

Avatar of nobleit

ASKER

mine is R1..
ALSO I tried this shows error

SQL> create tablespace myts datafile '+disk_group_1' size 100M AUTOEXTEND ON;
create tablespace myts datafile '+disk_group_1' size 100M AUTOEXTEND ON
*
ERROR at line 1:
ORA-01119: error in creating database file '+disk_group_1'
ORA-17502: ksfdcre:4 Failed to create file +disk_group_1
ORA-15001: diskgroup "DISK_GROUP_1" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
The statement above is just an example.  Replace "disk_group_1" with the name of the disk group you want to create the tablespace in.
Avatar of nobleit

ASKER

yes i did tablespace is created successfully..
how will I know this diskgroup is exisiting..
is there any query.. for that.
Yes:

select name from v$asm_diskgroup order by 1;

(the 'order by 1' clause tells it to order the results alphabetically by the first column chosen, in this case it's name)

This will list all of your diskgroups.

http://download.oracle.com/docs/cd/B12037_01/server.101/b10755/dynviews_1019.htm

Avatar of nobleit

ASKER

when I queried it says no row selected..
is there any chance to create a new asm diskgroup in 11gR1
I know i asked this question
asmca and asmcmd is not working for me
asmcmd
I could see a asmcmd file in my oracle home
I am trying to configure..
I am stucked with configuration,
can you please help
when I
Do you already have an ASM instance created?  If so, are you running the query against the ASM instance?  If you haven't, you can use dbca to set up ASM.  What happens when you run ASMCA?
Avatar of nobleit

ASKER

This the issue I am facing...
when I user dbca to create asm..it asking for 2 groups I cannot create the second one..
could you help with the second one...
ASKER CERTIFIED SOLUTION
Avatar of cheers4beers
cheers4beers
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of nobleit

ASKER

windows xp pro