After Oracle 8i R2 (8.1.6) for NT Enterprise Edition is installed by default, the following three directories are created on the drive letter.
Admin: records the configuration and running logs of Oracle instances. Each instance has a directory.
Ora81: Oracle System File
Oradata: all the specific files (data files, log files, and control files) required for running Oracle instances. Each instance has a directory.
Generally, Oracle files are classified into the following types:
Data File: Real Data
Redo log files: Online logs and archived logs
Control File: contains the ing between physical files and logical tablespace in the data dictionary.
Initialize parameter file: Control Memory
Warning and tracing log files:
Backup file:
C: \ oracle \ admin \ oradb \ pfile \ init. ora -- initialize the parameter file
C: \ oracle \ admin \ oradb \ bdump \ oradbalrt. log -- warning Log File
C: \ oracle \ admin \ oradb \ udump \ ora00960.trc
C: \ oracle \ oradata \ oradb \ system01.dbf -- tablespace Data File
C: \ oracle \ oradata \ oradb \ users01.dbf
C: \ oracle \ oradata \ oradb \ indx01.dbf
C: \ oracle \ oradata \ oradb \ rbs01.dbf
C: \ oracle \ oradata \ oradb \ temp01.dbf
C: \ oracle \ oradata \ oradb \ tools01.dbf
C: \ oracle \ oradata \ oradb \ dr01.dbf
C: \ oracle \ oradata \ oradb \ oem_repository.ora
C: \ oracle \ oradata \ oradb \ control01.ctl -- Control File
C: \ oracle \ oradata \ oradb \ control02.ctl
C: \ oracle \ oradata \ oradb \ control03.ctl
C: \ oracle \ oradata \ oradb \ redo01.log -- online Log File
C: \ oracle \ oradata \ oradb \ redo02.log
C: \ oracle \ oradata \ oradb \ redo03.log
C: \ oracle \ oradata \ oradb \ archive \ oradb2t001s01100. arc -- archiving log files
...
C: \ oracle \ oradata \ oradb \ archive \ oradb2t001s01199. Arc
C: \ oracle \ ora81 \ bin \ afiedt. Buf -- SQL * Plus default file editing
C: \ oracle \ ora81 \ bin \ ORADC. ocx -- Oracle ActiveX Control (which can be used in VB)
C: \ oracle \ ora81 \ database \ pwdoradb. ora -- Internal Password File
C: \ oracle \ ora81 \ database \ initoradb. ora -- start the parameter file
C: \ oracle \ ora81 \ database \ oradim. log -- svrmgrl manager Error Log
C: \ oracle \ ora81 \ Network \ log \ listener. log -- listener Log File
C: \ oracle \ ora81 \ Network \ log \ sqlnet. log -- SQL * Net Log File
C: \ oracle \ ora81 \ Network \ admin \ tnsnames. ora -- TNS connection file (Database alias)
C: \ oracle \ ora81 \ Network \ admin \ sqlnet. ora -- SQL * Net Environment File
C: \ oracle \ ora81 \ Network \ admin \ listener. ora -- listener parameter file
C: \ oracle \ ora81 \ sqlplus \ admin \ glogin. SQL -- SQL * Plus log on and automatically execute the script
C: \ oracle \ ora81 \ sqlplus \ admin \ sqlplus. ini -- SQL * Plus environment Initialization File
C: \ oracle \ ora81 \ precomp \ demo \ proc -- Pro * C directory
C: \ oracle \ ora81 \ RDBMS \ admin \ buildall. SQL -- generate all object scripts
C: \ oracle \ ora81 \ RDBMS \ admin \ Standard. SQL -- create a database basic structure package
C: \ oracle \ ora81 \ RDBMS \ admin \ catalog. SQL -- create a data dictionary View Script to connect to sys and internal
C: \ oracle \ ora81 \ RDBMS \ admin \ catexp. SQL -- create a data dictionary view for exp/imp
C: \ oracle \ ora81 \ RDBMS \ admin \ catexp7. SQL -- enables V7 exp files to be imported to V8
C: \ oracle \ ora81 \ RDBMS \ admin \ catdbsyn. SQL -- create a DBA private data dictionary View
C: \ oracle \ ora81 \ RDBMS \ admin \ cataudit. SQL -- create a data dictionary view for Auditing
C: \ oracle \ ora81 \ RDBMS \ admin \ catsnap. SQL -- creates a snapshot data dictionary view and connects to sys and internal
C: \ oracle \ ora81 \ RDBMS \ admin \ Scott. SQL -- generate Scott user and user data
C: \ oracle \ ora81 \ DBS \ pupbld. SQL-script to be executed after a database is created