Oracle 8.1.6 for win2000 system file explanation

Source: Internet
Author: User
Oracle 8.1.6 for win2000 system file explanation
    • 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:
     
     
      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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.