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..
how will I find the diskgroup..
if not how can I configure...
in order to create a tablespace..
check following link
http://gjilevski.wordpress.com/2010/07/06/creating-disk-group-in-oracle-11g-r2/
http://gjilevski.wordpress.com/2010/07/06/creating-disk-group-in-oracle-11g-r2/
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
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.
ASKER
yes i did tablespace is created successfully..
how will I know this diskgroup is exisiting..
is there any query.. for that.
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
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
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
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?
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...
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
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
windows xp pro
Then use the following syntax:
CREATE TABLESPACE my_ts DATAFILE '+disk_group_1' SIZE 100M AUTOEXTEND ON;