Problem with freespace Ora-11g
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Problem with freespace Ora-11g

  1. #1
    Join Date
    Feb 2008
    Posts
    5

    Problem with freespace Ora-11g

    Hi, i've a problem with the oracle partition, i've only 3MB of free space(on a partition of 6GB) but i've very little database with 16 table... its size is 250Mb maybe are there obsolete file that i can delete?
    i'm using oracle 11g under solaris
    I've seen in the directory app/bin file such as: emagtm0,dgmgrO ...
    Files that end with 0 or O
    what are these files? a backup copy of emagtm and dgmgr?
    can i delete them?
    On this partition there is only the oracle installation...

    This is a print of df -k /app/oracle
    File system kbyte used free capacity Actived on
    /dev/dsk/c0t0d0s7 6050742 5986834 3401 100% /export/home

    As you can see all the space has taken by oracle application directory.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you need to find the big files that you dont need and remove them - only you know.

    And your database will be more than 250Mb

  3. #3
    Join Date
    Feb 2008
    Posts
    5
    in this partition there is only the oracle installation, the OS is in another partition.

    These are file more than 100 MB
    What's the first ?ASMQueries.jar?

    -bash-3.00$ find . -size +10024
    ./app/oracle/product/11.1.0/db_1/inventory/Queries21/ASMQueries/11.1.0.6.0/ASMQueries.jar
    ./app/oracle/product/11.1.0/db_1/apex/builder/de/f4000_de.sql
    ./app/oracle/product/11.1.0/db_1/apex/builder/de/f4500_de.sql
    ./app/oracle/product/11.1.0/db_1/apex/builder/es/f4000_es.sql
    ./app/oracle/product/11.1.0/db_1/apex/builder/es/f4500_es.sql
    ./app/oracle/product/11.1.0/db_1/apex/builder/fr/f4000_fr.sql
    ./app/oracle/product/11.1.0/db_1/apex/builder/fr/f4500_fr.sql
    ./app/oracle/product/11.1.0/db_1/apex/builder/it/f4000_it.sql
    ./app/oracle/product/11.1.0/db_1/apex/builder/it/f4500_it.sql
    ./app/oracle/product/11.1.0/db_1/apex/builder/ja/f4000_ja.sql
    ./app/oracle/product/11.1.0/db_1/apex/builder/ja/f4500_ja.sql
    ./app/oracle/product/11.1.0/db_1/apex/builder/ko/f4000_ko.sql
    ./app/oracle/product/11.1.0/db_1/apex/builder/ko/f4500_ko.sql
    ./app/oracle/product/11.1.0/db_1/apex/builder/pt-br/f4000_pt-br.sql
    ./app/oracle/product/11.1.0/db_1/apex/builder/pt-br/f4500_pt-br.sql
    ./app/oracle/product/11.1.0/db_1/apex/builder/zh-cn/f4000_zh-cn.sql
    ./app/oracle/product/11.1.0/db_1/apex/builder/zh-cn/f4500_zh-cn.sql
    ./app/oracle/product/11.1.0/db_1/apex/builder/zh-tw/f4000_zh-tw.sql
    ./app/oracle/product/11.1.0/db_1/apex/builder/zh-tw/f4500_zh-tw.sql
    ./app/oracle/product/11.1.0/db_1/apex/builder/f4000.sql
    ./app/oracle/product/11.1.0/db_1/apex/builder/f4500.sql
    ./app/oracle/product/11.1.0/db_1/apex/utilities/fop/fop.war
    ./app/oracle/product/11.1.0/db_1/assistants/dbca/templates/Seed_Database.dfb
    ./app/oracle/product/11.1.0/db_1/assistants/dbca/templates/Seed_Database.ctl
    ./app/oracle/product/11.1.0/db_1/assistants/dbca/templates/example01.dfb
    ./app/oracle/product/11.1.0/db_1/bin/amdu
    ./app/oracle/product/11.1.0/db_1/bin/oracle
    ./app/oracle/product/11.1.0/db_1/bin/wrap
    ./app/oracle/product/11.1.0/db_1/bin/oratclsh
    ./app/oracle/product/11.1.0/db_1/bin/plshprof
    ./app/oracle/product/11.1.0/db_1/bin/rman
    ./app/oracle/product/11.1.0/db_1/bin/proc
    ./app/oracle/product/11.1.0/db_1/bin/procob32
    ./app/oracle/product/11.1.0/db_1/bin/profor
    ./app/oracle/product/11.1.0/db_1/bin/rmanO
    ./app/oracle/product/11.1.0/db_1/bin/oratclsh0
    ./app/oracle/product/11.1.0/db_1/ctx/data/inxight/lang/dutch-expanded.stemmer
    ./app/oracle/product/11.1.0/db_1/ctx/data/inxight/lang/dutch-std.stemmer
    ./app/oracle/product/11.1.0/db_1/ctx/data/inxight/lang/dutch-std.tagged-stemmer
    ./app/oracle/product/11.1.0/db_1/ctx/data/inxight/lang/dutch-std.tagger-lexicon
    ./app/oracle/product/11.1.0/db_1/ctx/data/inxight/lang/german-nosplit.stemmer
    ./app/oracle/product/11.1.0/db_1/ctx/data/inxight/lang/german-nosplit.tagged-stemmer
    ./app/oracle/product/11.1.0/db_1/ctx/data/inxight/lang/hungarian-expanded.stemmer
    ./app/oracle/product/11.1.0/db_1/ctx/data/inxight/lang/japanese-expanded.index
    ./app/oracle/product/11.1.0/db_1/ctx/data/inxight/lang/japanese-std.index
    ./app/oracle/product/11.1.0/db_1/ctx/data/inxight/lang/korean-std.stemmer
    ./app/oracle/product/11.1.0/db_1/ctx/data/jalx/droldJA.dat
    ./app/oracle/product/11.1.0/db_1/ctx/lib/kpodardr.so
    ./app/oracle/product/11.1.0/db_1/instantclient32/libociei.so
    ./app/oracle/product/11.1.0/db_1/javavm/admin/classes.bin
    ./app/oracle/product/11.1.0/db_1/jdk/jre/lib/fonts/ALBANWTJ.TTF
    ./app/oracle/product/11.1.0/db_1/jdk/jre/lib/sparc/client/classes.jsa
    ./app/oracle/product/11.1.0/db_1/jdk/jre/lib/sparc/client/libjvm.so
    ./app/oracle/product/11.1.0/db_1/jdk/jre/lib/sparc/server/libjvm.so
    ./app/oracle/product/11.1.0/db_1/jdk/jre/lib/sparcv9/server/libjvm.so
    ./app/oracle/product/11.1.0/db_1/jdk/jre/lib/charsets.jar
    ./app/oracle/product/11.1.0/db_1/jdk/jre/lib/rt.jar
    ./app/oracle/product/11.1.0/db_1/jdk/lib/tools.jar
    ./app/oracle/product/11.1.0/db_1/jlib/oemlt.jar
    ./app/oracle/product/11.1.0/db_1/lib/libserver11.a
    ./app/oracle/product/11.1.0/db_1/lib/libinlxs11.so
    ./app/oracle/product/11.1.0/db_1/lib/libjavavm11.a
    ./app/oracle/product/11.1.0/db_1/lib/libordsdo11.a
    ./app/oracle/product/11.1.0/db_1/lib/libagtsh.so.1.0
    ./app/oracle/product/11.1.0/db_1/lib/libcore11.a
    ./app/oracle/product/11.1.0/db_1/lib/libclient11.a
    ./app/oracle/product/11.1.0/db_1/lib/libgeneric11.a
    ./app/oracle/product/11.1.0/db_1/lib/libplp11.a
    ./app/oracle/product/11.1.0/db_1/lib/libpls11.a
    ./app/oracle/product/11.1.0/db_1/lib/libxml11.a
    ./app/oracle/product/11.1.0/db_1/lib/libn11.a
    ./app/oracle/product/11.1.0/db_1/lib/libnnz11.so
    ./app/oracle/product/11.1.0/db_1/lib/libldapjclnt11.so
    ./app/oracle/product/11.1.0/db_1/lib/libnnz11.a
    ./app/oracle/product/11.1.0/db_1/lib/libclntsh.so.11.1
    ./app/oracle/product/11.1.0/db_1/lib/liborasdkbase.so.11.1
    ./app/oracle/product/11.1.0/db_1/lib/liborasdk.so.11.1
    ./app/oracle/product/11.1.0/db_1/lib32/libnnz11.a
    ./app/oracle/product/11.1.0/db_1/lib32/libnnz11.so
    ./app/oracle/product/11.1.0/db_1/lib32/libn11.a
    ./app/oracle/product/11.1.0/db_1/lib32/libclient11.a
    ./app/oracle/product/11.1.0/db_1/lib32/libgeneric11.a
    ./app/oracle/product/11.1.0/db_1/lib32/libpls11.a
    ./app/oracle/product/11.1.0/db_1/lib32/libplp11.a
    ./app/oracle/product/11.1.0/db_1/lib32/libxml11.a
    ./app/oracle/product/11.1.0/db_1/lib32/liborasdk.so.11.1
    ./app/oracle/product/11.1.0/db_1/lib32/liborasdkbase.so.11.1
    ./app/oracle/product/11.1.0/db_1/lib32/libclntsh.so.11.1
    ./app/oracle/product/11.1.0/db_1/lib32/libagtsh.so.1.0
    ./app/oracle/product/11.1.0/db_1/md/admin/sdoepsgl.plb
    ./app/oracle/product/11.1.0/db_1/oc4j/j2ee/home/applications/ascontrol.ear
    ./app/oracle/product/11.1.0/db_1/oc4j/j2ee/home/lib/oc4j-internal.jar
    ./app/oracle/product/11.1.0/db_1/oc4j/j2ee/oc4j_applications/applications/WFMGRApp.ear
    ./app/oracle/product/11.1.0/db_1/oc4j/j2ee/oc4j_applications/applications/WFMGRApp/WFMGRWebApp.war
    ./app/oracle/product/11.1.0/db_1/oc4j/toplink/jlib/toplink.jar
    ./app/oracle/product/11.1.0/db_1/owb/bridges/lib/vek10.jar
    ./app/oracle/product/11.1.0/db_1/owb/external/oc4j_applications/applications/WFMGRApp.ear
    ./app/oracle/product/11.1.0/db_1/owb/home/applications/ascontrol.ear
    ./app/oracle/product/11.1.0/db_1/owb/j2ee/owbb.war
    ./app/oracle/product/11.1.0/db_1/owb/lib/ext/jdev.jar
    ./app/oracle/product/11.1.0/db_1/owb/lib/ext/oembase-10_1_0.jar
    ./app/oracle/product/11.1.0/db_1/owb/lib/ext/oemtools-10_1_0.jar
    ./app/oracle/product/11.1.0/db_1/owb/lib/int/helpdoc.jar
    ./app/oracle/product/11.1.0/db_1/owb/lib/int/rts.jar
    ./app/oracle/product/11.1.0/db_1/owb/lib/int/OMBPlusHelp.jar
    ./app/oracle/product/11.1.0/db_1/owb/lib/int/nlsrts.jar
    ./app/oracle/product/11.1.0/db_1/owb/lib/int/reposimpl.jar
    ./app/oracle/product/11.1.0/db_1/owb/lib/int/ui.jar
    ./app/oracle/product/11.1.0/db_1/owb/lib/int/helpdoc_it.jar
    ./app/oracle/product/11.1.0/db_1/perl/lib/5.8.3/sun4-solaris-thread-multi-64/CORE/libperl.a
    ./app/oracle/product/11.1.0/db_1/rdbms/lib/libdbtools11.a
    ./app/oracle/product/11.1.0/db_1/rdbms/lib32/libdbtools11.a
    ./app/oracle/product/11.1.0/db_1/sqldeveloper/jdev/extensions/oracle.javacore.jar
    ./app/oracle/product/11.1.0/db_1/sysman/install/ccr.zip
    ./app/oracle/product/11.1.0/db_1/sysman/jlib/emCORE.jar
    ./app/oracle/product/11.1.0/db_1/sysman/jlib/emcoreALL.jar
    ./app/oracle/product/11.1.0/db_1/sysman/jlib/emcore_emjsp.jar
    ./app/oracle/product/11.1.0/db_1/sysman/jlib/jviewsall.jar
    ./app/oracle/product/11.1.0/db_1/sysman/jlib/emDB.jar
    ./app/oracle/product/11.1.0/db_1/sysman/jlib/emdb_emjsp.jar
    ./app/oracle/product/11.1.0/db_1/sysman/prov/paf/pa.par
    ./app/oracle/product/11.1.0/db_1/sysman/prov/paf/patchAdvisor.par
    ./app/oracle/product/11.1.0/db_1/ccr/inventory/pending/engines.jar
    ./app/oracle/product/11.1.0/db_1/EMStagePatches_oracledb/10/3F849311CCCF04CBE0440003BA03CFE3
    ./app/oracle/product/11.1.0/db_1/EMStagePatches_oracledb/6/3F849311CCCB04CBE0440003BA03CFE3
    ./app/oracle/product/11.1.0/db_1/EMStagePatches_oracledb/36/3F9819FA457D0533E0440003BA03CFE3
    ./app/oracle/product/11.1.0/db_1/EMStagePatches_oracledb/8/3F9819FA45810533E0440003BA03CFE3
    ./app/oracle/diag/rdbms/oracledb/oracle/ir/offline_dictionary.ir
    ./app/oracle/oradata/oracledb/system01.dbf
    ./app/oracle/oradata/oracledb/sysaux01.dbf
    ./app/oracle/oradata/oracledb/undotbs01.dbf
    ./app/oracle/oradata/oracledb/users01.dbf
    ./app/oracle/oradata/oracledb/control01.ctl
    ./app/oracle/oradata/oracledb/control02.ctl
    ./app/oracle/oradata/oracledb/control03.ctl
    ./app/oracle/oradata/oracledb/redo01.log
    ./app/oracle/oradata/oracledb/redo02.log
    ./app/oracle/oradata/oracledb/redo03.log
    ./app/oracle/oradata/oracledb/temp01.dbf

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you have a database and all its datafiles in there, what do you expect?

  5. #5
    Join Date
    Feb 2008
    Posts
    5
    yes but my database is very little only 16 tables...
    isn't there nothing to do?

  6. #6
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Add more space to the partition or mountpoint.

    Did the person who installed oracel software read about the minimum hard disk space requirements for installing oracle11g ?

    regards
    Hrishy

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    doesnt matter how many tables you have the DATABASE has a minimum space requirement.

    Either give it more disk or move things about.

    You need a dba to help you

  8. #8
    Join Date
    Feb 2008
    Posts
    2
    these datafiles, indexes and system datafiles are important for your database, so if you delete them, it will cause an error......

  9. #9
    Join Date
    Feb 2008
    Posts
    5
    isn't there a log file that i can delete? also 1 mb for me is very important

  10. #10
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you tell us, are there any log files? did you look for them?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width