Hello,
I just installed a fresh new 11.2.0.2 Database on Solaris 10.
Everything straightforward on the parameter side!!! I tried custom install as well as general purpose template. When installing with DBCA, I set every parameters around DB Name in lowercase name.
With this, questions are popping in my mind regarding some parameters after installation.
First, %dump_dest parameters contains in path, two times the db name (ocpdb in my case):
background_dump_dest /u01/app/oracle/diag/rdbms/ocpdb/ocpdb/trace
user_dump_dest /u01/app/oracle/diag/rdbms/ocpdb/ocpdb/trace
core_dump_dest /u01/app/oracle/diag/rdbms/ocpdb/ocpdb/cdump
Is it normal to have ..../rdbms/dbname/dbname/..... as path, with dbname/dbname ??? Why?
Second, the question regarding the directory structure under fast_recovery_area (new term for flash_recovery_area). The directory structure:
oracle@enalab13:/u01/app/oracle/fast_recovery_area$ ls -l
total 2
drwxr-x--- 2 oracle oinstall 512 2010-10-28 19:53 ocpdb
drwxr----- 5 oracle oinstall 512 2010-10-29 07:44 OCPDB
oracle@enalab13:/u01/app/oracle/fast_recovery_area$ ls -l ocpdb
total 9528
-rw-r----- 1 oracle oinstall 9748480 2010-10-31 21:09 control02.ctl
oracle@enalab13:/u01/app/oracle/fast_recovery_area$ ls -l OCPDB/
total 3
drwxr----- 5 oracle oinstall 512 2010-10-31 03:48 archivelog
drwxr----- 3 oracle oinstall 512 2010-10-29 07:44 autobackup
drwxr----- 3 oracle oinstall 512 2010-10-29 07:43 backupset
Why am I having a subdir with dbname in uppercase AND in lowercase? Should I specify dbname in uppercase at db creation to have all files under the same directory, or in lowercase? Or, is it normal?
I want to know how to do it well before reinstalling a fresh database.
Thanks
Bruno
Edited by: blavoie on Oct 31, 2010 6:18 PM
Edited by: blavoie on Oct 31, 2010 6:20 PM