11gR1 datbase files path on Linux OS


$Oracle base = /11g/oracle/
$ORACLE_HOME = /11g/oracle/product/11.1.0/db_1

CRD-file = /11g/oracle/oradata/orcl

C = control file <.ctl>
control01.ctl  control03.ctl     
control02.ctl 

R = redo file <.log>
redo01.log redo02.log  redo03.log

D = data file <.dbf>
example01.dbf    sysaux01.dbf  temp01.dbf    users01.dbf system01.dbf  undotbs01.dbf

P_file = /11g/oracle/admin/orcl/pfile  <init.ora.5212012161047>
            /11g/oracle/product/11.1.0/db_1/dbs/init.ora

Sp_file = /11g/oracle/product/11.1.0/db_1/dbs  <spfileorcl.ora>

Audit_file_dest(adump) = /11g/oracle/admin/orcl/adump <ora_17508.aud>

Datapump_dump(dpdump) = /11g/oracle/admin/orcl/dpdump <dp.log>

diagnostic_dest= /11g/oracle

db_recovery_file_dest= /11g/oracle/flash_recovery_area

Bin = /11g/oracle/product/11.1.0/db_1/bin

Network Configuration File<tnsnames.ora> = /11g/oracle/product/11.1.0/db_1/network/admin/

Tace file location :-
/11g/oracle/diag/rdbms/orcl/orcl/trace

Alert file location :-
/11g/oracle/diag/rdbms/orcl/orcl/alert

No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf...