OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ASM problem (oracle 10.1.0.2.0/Win XP Professional)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ASM problem [message #306942]

Mon, 17 March 2008 06:04

joeguo101@163.com
Messages: 3
Registered: March 2008

Junior Member

All tablespaces in my test database only occupy 1G. The ASM disk group has 2.4G. Why free disk space in ASM group is 0?

orcl@DIDI>select tablespace_name, bytes/1024/1024 from dba_data_files;

TABLESPACE_NAME                BYTES/1024/1024
------------------------------ ---------------
USERS                                      135
SYSAUX                                     260
UNDOTBS1                                    30
SYSTEM                                     450
EXAMPLE                                    150

orcl@DIDI>select NAME,STATE,TOTAL_MB,FREE_MB from  v$asm_diskgroup;

NAME                           STATE         TOTAL_MB    FREE_MB
------------------------------ ----------- ---------- ----------
ORCL_DATA1                     CONNECTED         2900          0
RECOVERYDEST                   MOUNTED

Could any oracle experts tell me why?

[Updated on: Mon, 17 March 2008 06:24] by Moderator

Report message to a moderator

Re: ASM problem [message #306959 is a reply to message #306942]

Mon, 17 March 2008 06:35

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Is this the only diskgroup?
Is this the only database using the diskgroup?

I would check from ASMCMD.

post the output of lsdg and lsct from ASMCMD

Report message to a moderator

Re: ASM problem [message #306970 is a reply to message #306942]

Mon, 17 March 2008 06:54

joeguo101@163.com
Messages: 3
Registered: March 2008

Junior Member

There is only one disk group in my test DB and only one DB is using it.

I can't find asmcmd in ORACLE_HOME/bin. Why can't I find it there?

Many thinks.

Report message to a moderator

Re: ASM problem [message #306971 is a reply to message #306970]

Mon, 17 March 2008 07:02

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You tell me. It is your installation. Smile

It is supposed to be a bat file. Had you set your ORACLE_HOME , ORACLE_SID to ASM instance, there should be no problem.

Report message to a moderator

Re: ASM problem [message #306977 is a reply to message #306942]

Mon, 17 March 2008 07:16

joeguo101@163.com
Messages: 3
Registered: March 2008

Junior Member

Thanks Mahesh Rajendran!

I've searched all disks and I can't find asmcmd.bat. I have set ORACLEHOME and SID to ASM and windows still can't find that command.
It doesn't matter to find this command.

orcl@DIDI>create tablespace test datafile '+ORCL_DATA1' size 1m;
create tablespace test datafile '+ORCL_DATA1' size 1m
*
ERROR at line 1:
ORA-01119: error in creating database file '+ORCL_DATA1'
ORA-17502: ksfdcre:4 Failed to create file +ORCL_DATA1
ORA-15041: diskgroup space exhausted

Could you explain it for me?

Report message to a moderator

Previous Topic:	NO import !
Next Topic:	Unable to drop user after upgrade

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 03:44:30 CST 2024