-
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.
-
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
-
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
-
you have a database and all its datafiles in there, what do you expect?
-
yes but my database is very little only 16 tables...
isn't there nothing to do?
-
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
-
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
-
these datafiles, indexes and system datafiles are important for your database, so if you delete them, it will cause an error......
-
isn't there a log file that i can delete? also 1 mb for me is very important
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|