Oracle A423961 Manual Do Utilizador

Página de 202
3 – 2
Oracle7 Server Getting Started for Windows NT 
Overview of Database Administration Tasks
This section introduces you to the starter database installed during the
Oracle7 Server for Windows NT installation. It shows you how to
modify the starter database or create a new database of your own.
Note:
 
 
Database creation is an advanced function; Oracle
recommends that you use the starter database and modify it to
suit your needs.
What is an Instance?
An Oracle instance is a logical term that refers to an Oracle service and a
database server.
Oracle services are similar to Windows NT services. In order to connect
to and use an Oracle server, an Oracle service must be created and
associated with the Oracle database. Each Oracle instance must have a
unique SID. With Oracle7 Server for Windows NT, you can run multiple
Oracle instances simultaneously on one machine.
During the installation, a default instance is installed. This instance is
identified by the sid ORCL. This Guide refers to the database of this
default instance as the starter database. You can expand the starter
database if necessary to better suit your needs.
The installation process creates an Oracle service and a listener service
for the default instance. Both services are created as automatic Windows
NT services. This means that they start automatically when the machine
powers up. To use the starter database, start the database with Server
Manager or Database Manager.
The Starter Database
The starter database ORACLE is the core of the Oracle7 Server for
Windows NT database system. The starter database contains:
four tablespaces
four database files
two log files
a preloaded data dictionary
usernames
The data dictionary (SYSTEM tablespace) contains tables and views
commonly used by many Oracle tools and sample programs.