Oracle 8.1.6 for Win2000 System file interpretation

Source: Internet
Author: User
Tags add time log
Oracle Author: Anonymous Source: InterNet Add Time: 2003-7-20 system Environment: 1, operating system: Windows 2000
2. Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition
3, Installation path: C:\ORACLE
Explain:
Oracle 8i R2 (8.1.6) for NT Enterprise Edition The default installation will create the following three directory admin: Log Oracle instance configuration, run log files, and each instance a directory Ora81: Oracle System files oradata:oracle all the specific files (data files, log files, control files) required for the instance to run, one directory for each instance in general, Oracle files are divided into the following types: Data files: Real data redo log files: Online logs, Archive Log Control File: Mapping initialization parameter file containing physical file to logical table space in data dictionary: Control memory Warning and trace log file: Backup file: C:\Oracle\admin\oradb\pfile\init.ora--Initialization parameter file C:\Oracle\admin\oradb\bdump\oradbALRT.LOG--Warning log file C:\Oracle\admin\oradb\udump\ORA00960. TRCC:\ORACLE\ORADATA\ORADB YSTEM01. DBF-Table space data file C:\Oracle\oradata\oradb\USERS01. dbfc:\oracle\oradata\oradb\indx01. Dbfc:\oracle\oradata\oradb\rbs01. Dbfc:\oracle\oradata\oradb\temp01. Dbfc:\oracle\oradata\oradb\tools01. Dbfc:\oracle\oradata\oradb\dr01. Dbfc:\oracle\oradata\oradb\oem_repository. Orac:\oracle\oradata\oradb\control01. CTL-Control file C:\Oracle\oradata\oradb\CONTROL02. Ctlc:\oracle\oradata\oradb\control03. Ctlc:\oracle\oradata\oradb\redo01. Log--Online log file C:\Oracle\oradata\oradb\REDO02. Logc:\oracle\oradata\oradb\redo03. Logc:\oracle\oradata\oradb\archIve\oradb2t001s01100. ARC--Archive log file ... C:\Oracle\oradata\oradb\archive\ORADB2T001S01199. Arcc:\oracle\ora81\bin\afiedt.buf--sql*plus Default Edit 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--Startup parameter file C:\Oracle\Or A81\database\oradim.log--SVRMGRL Manager error Log C:\Oracle\Ora81\network\log\listener.log--listener log file C:\Oracle\Ora81\networ K\log qlnet.log--sql*net log file C:\Oracle\Ora81\network\ADMIN\tnsnames.ora--tns connection file (database alias) C:\Oracle\Ora81\network\A DMIN Qlnet.ora--sql*net Environment File C:\Oracle\Ora81\network\ADMIN\listener.ora--listener parameter file C:\Oracle\Ora81 qlplus\admin\ Glogin.sql--sql*plus Login Automatic script C:\Oracle\Ora81 qlplus\admin qlplus.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 Tandard.sql--a package C:\Oracle\Ora81\RDBMS\ADMIN\catalog.sql to build the basic structure of a database--Establish a number According to the Dictionary view script, the SYS, INternal Connection C:\Oracle\Ora81\RDBMS\ADMIN\catexp.sql--establishing exp/imp with data dictionary view C:\Oracle\Ora81\RDBMS\ADMIN\catexp7.sql-- Enable V7 version of the exp file to be imported into V8 C:\Oracle\Ora81\RDBMS\ADMIN\catdbsyn.sql--Establish DBA Private data dictionary view C:\Oracle\Ora81\RDBMS\ADMIN\ Cataudit.sql--establishing audit with data dictionary view C:\Oracle\Ora81\RDBMS\ADMIN\catsnap.sql--Set up a snapshot data dictionary view, with SYS, internal connection C:\Oracle\Ora81\ Rdbms\admin Cott. SQL--Generate Scott users and their user data C:\Oracle\Ora81\dbs\pupbld.sql--scripts to be executed after a new 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.