Home » RDBMS Server » Server Administration » ASM problem (oracle 10.1.0.2.0/Win XP Professional)
ASM problem [message #306942] Mon, 17 March 2008 06:04 Go to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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
Re: ASM problem [message #306970 is a reply to message #306942] Mon, 17 March 2008 06:54 Go to previous messageGo to next message
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.
Re: ASM problem [message #306971 is a reply to message #306970] Mon, 17 March 2008 07:02 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: ASM problem [message #306977 is a reply to message #306942] Mon, 17 March 2008 07:16 Go to previous message
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?
Previous Topic: NO import !
Next Topic: Unable to drop user after upgrade
Goto Forum:
  


Current Time: Sun Dec 04 18:36:59 CST 2016

Total time taken to generate the page: 0.17958 seconds