System environment:
1, operating system: Windows 2000
2, Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition
3, installation path: c: / oracle
Explanation:
Oracle 8i R2 (8.1.6) For NT Enterprise Edition defaults, create the following three directories after the drive letter
Admin: Record the configuration of the Oracle instance, run the log, etc., each instance is a directory
ORA81: Oracle System File
ORADATA: Oracle instances run all specific files (data files, log files, control files), one directory for each instance
Generally speaking, Oracle files are divided into the following types:
Data file: real data
Heavy log file: online log, archive log
Control file: Map between logic tablespaces containing physical files into data dictionary
Initialization parameter file: Control memory
Warning and tracking log files:
backup file:
C: /oracle/admin/oradb/pfile/init.ora - Initialization Parameters
C: /oracle/admin/oradb/bdump/oradbalrt.log - Warning Log File
C: /oracle/admin/oradb/udump/ora00960.trc
C: /oracle/oradata/oradb/system01.dbf - Table Space 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 - Archive log file
...
C: /oracle/oradata/oradb/archive/oradb2t001s01199.arc
C: /oracle/ora81/bin/afiedt.buf --sql * Plus default editing file
C: /oracle/ora81/bin/oradc.ocx - Oracle ActiveX control (available 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/Ordim.log - SvRMGRL Manager Error Log
C: /oracle/ora81/neetwork/log/listener.log - listener log file
C: /oracle/ora81/neetwork/log/sqlnet.log --sql * net log file C: /oracle/ora81/neetwork/admin/tnsnames.ora - TNS connection file (database alias)
C: /oracle/ora81/neetwork/admin/sqlnet.ora --sql * net environment file
C: /oracle/ora81/neetwork/admin/listener.ora - listener parameter file
C: /oracle/ora81/sqlplus/admin/gLogin.sql --sql * plus login automatic execution 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 package of basic structure of a database
C: /oracle/ora81/rdbms/admin/catalog.sql - Create a data dictionary view script, connected in SYS, Internal
C: /oracle/ora81/rdbms/admin/catexp.sql - Establish an EXP / IMP Data Dictionary View
C: /oracle/ora81/rdbms/admin/catexp7.sql - enables V7 version of the EXP file to import to V8
C: /oracle/ora81/rdbms/admin/catdbsyn.sql - Create DBA Private Data Dictionary View
C: /oracle/ora81/rdbms/admin/cataudit.sql - Create an audit data dictionary view
C: /oracle/ora81/rdbms/admin/catsnap.sql - Create a snapshot data dictionary view, connect with SYS, Internal
C: /oracle/ora81/rdbms/admin/scott.sql - Generate Scott User and Its User Data
C: /oracle/ora81/dbs/pupbld.sql - Script that needs to be executed after the new database
