Oracle8
Enterprise Edition Getting Started
Release 8.0.5 for Windows NT A64416-01 |
|
This chapter describes the contents of the Oracle8 Enterprise
Edition starter database.
Specific topics discussed are:
Oracle8 Enterprise Edition is installed when you select the:
Note: Oracle8 Enterprise Edition cannot be installed through the Oracle8 Client option. |
Both these installation processes prompt you to install either of three types of database configurations:
This table describes some of the features available with
each configuration:
Database Feature | Typical Configuration | Custom Configuration |
---|---|---|
Type of Database Created |
Automatically creates a fully preconfigured and ready-to-use starter database with default INITSID.ORA file parameter settings. |
Enables you to create your own database with customized INITSID.ORA parameter settings. This option is only for Oracle database administrators (DBAs) experienced with advanced database creation procedures. |
Database Name |
Automatically named ORCx1. |
Your choice. |
System Identifier (SID) Name |
Automatically named ORCx1. |
Your choice. |
Cartridges and Options |
Both configuration types allow you to select the following cartridges and options for installation: |
|
Advanced replication (updatable snapshots) |
Automatically installed. |
|
User names, database files, and tablespaces |
Automatically creates the user names, database files, and tablespaces described in section, "Starter Database Contents". |
Automatically creates the SYS, SYSTEM, SCOTT, DEMO, and DBSNMP user names and INTERNAL alias described in section, "Starter Database Contents", but enables you to customize tablespace and database file settings and create an extra control file and extra tablespace named INDEX. An Oracle8 Cartridge user name is only created if you select that specific cartridge for installation when running Oracle Database Assistant. |
Initial archiving mode |
Set to NOARCHIVELOG |
Your choice. |
Additional
Information:
You can still create a custom database manually. See Chapter 9, "Creating a Database" for additional information. |
The starter database you receive if you select the Typical Configuration database option contains the following features:
Your starter database contains these user names:
User Name | Passwords | Description |
---|---|---|
INTERNAL |
ORACLE is automatically the password if you installed your Oracle8 database using the Oracle8 Enterprise Edition option. If you installed your Oracle8 database using the Custom option, the password is whatever you entered when prompted during installation. |
DBA user name with which to perform database administration tasks, including starting up and shutting down a database. Note: INTERNAL is not a true user name; it is an alias for the SYS user name and SYSDBA privilege. Note: INTERNAL uses the SYS schema, listed below, with additional SYSDBA privileges. See the chapter "The Oracle Database Administrator" in Oracle8 Administrator's Guide for more information. |
SYS |
CHANGE_ON_INSTALL |
DBA user name with the following database roles: |
SYSTEM |
MANAGER |
DBA user name with DBA database role. |
SCOTT |
TIGER |
User name with CONNECT and RESOURCE database roles. |
DEMO |
DEMO |
User name with CONNECT and RESOURCE database roles. Oracle Corporation recommends that you drop this account if it is not needed. |
DBSNMP |
DBSNMP |
User name with CONNECT, RESOURCE, and SNMPAGENT database roles. If you want to drop this role and user, run CATNSNMP.SQL. |
MDSYS1 |
MDSYS |
Oracle8 Spatial Cartridge administrator user name. |
ORDSYS1 |
ORDSYS |
Oracle8 Image, Time Series, and Visual Information Retrieval Cartridges administrator user name with CONNECT and RESOURCE database roles. |
1 If you install the starter database through the Oracle8 Enterprise Edition option, MDSYS and ORDSYS are automatically created even if you do not select their Oracle8 Cartridges for installation. |
Note: Change the passwords for the SYS, SYSTEM, MDSYS, and ORDSYS user names immediately after installation with the following SQL statement at the Server Manager prompt: SVRMGR> ALTER USER USERNAME IDENTIFIED BY PASSWORD; See Chapter 3, "Database Tools Overview" for information on starting Server Manager. |
Each Oracle8 database has a SID. A SID is a unique name for
an Oracle database instance that can be up to four alphanumeric characters
in length.
For example, if the SID for an Oracle8 database is ORCL,
each database file in the ORACLE_HOME\DATABASE directory has ORCL
as part of its name (for example, CTL1ORCL.ORA, LOG1ORCL.ORA, and INITORCL.ORA).
The multiple Oracle homes feature enables you to have multiple, active
Oracle8 databases installed on a single computer. Each database requires
a unique SID. To ensure that each SID is unique, the last letter of ORCL
is automatically replaced by a number and incremented each time you install
Oracle products into a different home (that is, for a second Oracle8 database
installation, the SID is ORC1, for a third Oracle8 database installation,
the SID is ORC2, etc.). See Chapter 6, "Using
Multiple Oracle Homes" for further information. Because of this, the
data files, initialization files, redo log files, and control files described
below use a variable of SID in their names. When you see SID,
substitute it with the SID for your Oracle8 database.
An Oracle8 database is subdivided into smaller logical areas
of space known as tablespaces. Each tablespace corresponds to one or more
physical data files. The four tablespaces in the Oracle8 database contain
the following types of data:
Additional
Information:
See the chapter "Tablespaces and Datafiles" of Oracle8 Concepts and the chapter "Managing Tablespaces" in Oracle8 Administrator's Guide |
Data files contain the contents of logical database structures
such as tables and indexes. One or more data files form a logical unit
of storage called a tablespace. A data file can be associated with only
one tablespace, and only one database. The starter database contains the
following four data files located in the ORACLE_HOME\DATABASE directory:
This Data File... | Is Contained in the Tablespace... |
---|---|
SYS1SID.ORA |
SYSTEM |
USR1SID.ORA |
USER_DATA |
TMP1SID.ORA |
TEMPORARY_DATA |
RBS1SID.ORA |
ROLLBACK_DATA |
Additional
Information:
See the chapter "Tablespaces and Datafiles" of Oracle8 Concepts and the chapter "Managing Datafiles" in Oracle8 Administrator's Guide |
The starter database contains one initialization parameter
file located in the ORACLE_HOME\DATABASE directory:
Additional
Information:
See Appendix B, "Oracle8 Database Specifications for Windows NT" of this guide. This appendix lists the Oracle8 database-specific initialization parameters for Windows NT and their default values. See Oracle8 Reference for further information on initialization parameters. |
The starter database contains four redo log files located in the ORACLE_HOME\DATABASE directory, each 1 MB in size:
Additional
Information:
See the chapters "Managing the Online Redo Log" in Oracle8 Administrator's Guide and "Recovering a Database" of Oracle8 Backup and Recovery. |
The starter database contains one control file located in
the ORACLE_HOME\ DATABASE directory:
Note: Oracle Corporation recommends that you keep at least two control files (on separate physical drives) for each database and set the CONTROL_FILES initialization parameter to list each control file. See the chapter "Managing Control Files" of the Oracle8 Administrator's Guide for information on setting this initialization parameter value. |
The data dictionary is a protected collection of tables and views containing reference information about the database, its structures, and its users. The data stored in the dictionary includes:
Additional
Information:
See the chapter "The Data Dictionary" of Oracle8 Concepts and "Static Data Dictionary Views" in Oracle8 Reference. |
Rollback segments record the old values of data that was changed by each transaction (whether or not committed). Every database contains one or more rollback segments, which are portions of the database that record the actions of transactions in the event that a transaction is rolled back. Rollback segments are used to provide read consistency, to roll back transactions, and to recover the database. The starter database contains the following rollback segments:
Additional
Information:
See the chapter "Managing Rollback Segments" of the Oracle8 Administrator's Guide. |