Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
Showing results for 
Search instead for 
Did you mean: 

Oracle installation doubts

Go to solution
Trenta Angelo

Oracle installation doubts

Hi all

I have some problems about our Oracle installation, which was made in past, and you can find details in attachement.

Regards, Angelo
I will work harder, HP-UX is always right
Santosh Nair_1
Honored Contributor

Re: Oracle installation doubts

Its typical to have an admin directory with subdirectories for each instance. Within those directories, you have pfiles, bdump, udump, cdump. The pfiles directory contains the parameter files for the instance (similar to ini files for Windows). The *dump directory contains trace and log files for the instance. The alert log is typically in bdump which also contains traces relating to the instance as a whole. The udump contains trace files for user processes. I forget what the cdump is used for, but it also contains trace files. The alter log records all startup/shutdown and major database changes. The trace files are usually generated in the event of an error/warning. Hope this helps.

Life is what's happening while you're busy making other plans
Alexander M. Ermes
Honored Contributor

Re: Oracle installation doubts

Hi there.
This is suggested by Oracle support.
You should separate the files for the different instances. If you try to fix errors
and you cannot find, which file is really meant, you are in a bit of trouble.
Your admin dir is ok so far.
The directories ending on dump contain logfiles. Most important is bdump for alert_${ORACLE_SID}.log, where you can find everything going on in the database ( log changes, errors, shutdown, startup etc. ).
pdump is containg trace files from process dumps ( dbwriter, smon ( system monitor ), pmon ( process monitor ) and so on.
Pfile should contain init_xy.ora for the instance and the config.ora file.
create is the place for the scripts, which you use to create a database. udump is for user trace files. If you find FIRENZE within genesys it is possible, that this is a second instance for the same database. If not, you should separate FIRENZE from GENESYS.
For more questions contact me at

Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
Roger Baptiste
Honored Contributor

Re: Oracle installation doubts


The basic thing needed for the oracle install is a filesystem with enough space under it. For eg: if we have more than
one version of oracle to support on the box:
it would /opt/oracle/8.1.6

Each having different sizes and preferably
filesystems. As far as instances are concerned, the structure under these filesystems automatically get created during install and subsequent tuning by the DBA.

Take it easy.