Here is the small post which describes the potential placed where log files and trace files are present and can be cleaned up. This is requied when you want to free up space on the system.
Cleaning up R12 instance:
Following are the locations in applmgr side which you can check and clean up. Be careful while cleaning up the log files, because some might be needed for analysis or might contan errors for some reproducible test case. So if you delete some log file which is needed, you might have to redo that work. Usually its a good idea to leave the logs which are 1-2 days old and delete the other older logs
Main location for logs and other not useful files on applmgr side:
Forms dump files : $INST_TOP/logs/ora/10.1.2/forms
Reports Cache : $INST_TOP/logs/ora/10.1.2/reports/cache
Apache logs : $INST_TOP/logs/ora/10.1.3/Apache
OPMN Logs : $INST_TOP/logs/ora/10.1.3/opmn
Its advisable not to remove any logs under $INST_TOP/logs/ora/10.1.3/j2ee directory since these are very important logs and are required frequently for debugging.
Logs for service management : $INST_TOP/logs/appl/admin/log
Concurrent Manager logs : $INST_TOP/logs/appl/conc/log
Concurrent Manager out files : $INST_TOP/logs/appl/conc/out
Other then these directories if you have some patch downloaded at some location, it is advisable to remove those patches once applied.
Main location for logs and other not useful files on oracle side:
Cleanup background_dump_dest, user_dump_dest and core_dump_dest directories on database side. These locations usually have huge trace files.
Check the location of ORACLE_HOME using du -sh command. Usually the size of ORACLE_HOME should be aounr 3-4G. If size of ORACLE_HOME (other then datafiles) is abnormally large like 7-8G or more then you need to investigate which directory is consuming more space and accordingly clean up that directory if appropriate.
In some situation if it becomes impossible to clean up the space (because there are no trace files to cleanup) and you desperately want the space to be available on the file system, then you can connect to database as sysdba and try to reduce the size of temp files using “alter database tempfile .. resize” comamnd. This will release some space and prevent database from crashing in case file system is reaching 100% full.
Again if some patches are downloaded for application, make sure to remove the patches zip files once they are applied.
Some times we upgrade the database to a major release, like from 9i to 10g or from 10g to 11g. In that case its advicable to remove the old ORACLE_HOME. This will not only save space but also will avoid confusion.
Cleaning up 11i instance:
Main location for logs and other not useful files on applmgr side:
Logs for Concurrent manager, forms and reports: $COMMON_TOP/admin/log/$CONTEXT_NAME
Out files for Concurrent managers: $COMMON_TOP/admin/out/$CONTEXT_NAME
Apache Log files: $IAS_ORACLE_HOME/Apache/Apache/logs
Jserv Log files: $IAS_ORACLE_HOME/Apache/Jserv/logs
There are some log files in $APPL_TOP/admin/$TWO_TASK/log and $AD_TOP/log, but its advisable not to delete these logs as they are very important for debugging.
Main location for logs and other not useful files on oracle side:
Cleanup background_dump_dest, user_dump_dest and core_dump_dest directories on database side. These locations usually have huge trace files.
Hope this helps !!
I am Amane Matsumoto. I am from Japan.
I am makie-shi (Japanese lacquer artist) and shoka(Japanese calligrapher).
I have spent my life working on traditional Japanese lacquer(urushi).
I am the Kyoto style artist and I have samurai soul.
I can make samurai maetate of Japanese helmets ,inro ,saya of Japanese sword ,gold Japanese lacquer boxes and so on.I have the highest skill in Japan.
Japanese lacquer art is made with gold ,silver ,platinum and so on.
The subjects I pick are very often nature.
I admire Mr.Lawrence Joseph Ellison in every way.
I am very happy that he research and learn
about Japanese culture and arts like Zen.I think he is a true samurai.
I’d like to ask him to become my patron.
He must have been extra busy , but if he would not mind helping me get through this tough competition, that would be tremendously appreciated.
I sent my work(sho) and the photograph of my work(urushi)to Oracle head office. But I hardly ever get back his reply.
It may be that he doesn’t get my photos and works.
Could you help me?
I’m at a loss. But I can not want to give up.
I would like to contact him.
I would like to go to America to meet him.
I’d like to ask him to become my patron.
I wish I could contact him somehow or other.
Could you help me? My Email Address is spkv9xz9@yahoo.co.jp .
Thank you so much for your kind reply.
Interesting topic and excellent sharing. Thanks for same.