Oracle composition Environment

 

The basic environment after Oracle Installation involves the installed program group, the physical files contained in the DBMS, the services related to the database server, the default account/password for Oracle, and. Understanding and understanding these basic environments is very important for correct use and in-depth understanding of Oracle technology.

1.4.1 program group after installation

Oracle Database 10g installed program group Oracle-OraDb10g _ home1 includes:

· Oracle Installation Products

· Integrated management tools

· Configure and port tools

· Application Development

(1) Oracle Installation products mainly includes:

· Universal Installer: Universal Installer

· General Installer concept Guide

(2) Integrated management tools include:

· Oracle Directory Manager: a Java-based management tool used to manage Oracle Internet directory.

· Wallet MANAGER: the wallet manager can create an encrypted Oracle wallet to enhance its security.

(3) configure and transplant tools

· Administration assistant for Windows: it can be used to manage database instances and administrator roles.

· Database Configuration ASSISTANT: Database Configuration assistant. It can create databases, configure Database options in existing databases, delete databases, and manage database templates.

· Database Upgrade ASSISTANT: database update Assistant, which helps you upgrade your local database.

· Locale builder: Oracle locale builder is a convenient tool for customizing local data definitions. You can use this tool to view the creation language, Character Set, and so on. Main functions include: Language settings, Region settings, Character Set settings, and syntax settings.

· Microsoft ODBC administrato 558 R: the ODBC data source Manager. ·

Net configuration ASSISTANT: network configuration assistant. You can use this assistant to configure listeners, naming methods, and local net service names. It is a required connection Configuration tool for Oracle network connection.

· Net manager: this tool can be used for network configuration, such as database identification service configuration, naming method configuration, and listener creation and configuration. This tool and net configuration assistant are the main tools for network connection configuration.

(4) Application Development SQL * Plus: it provides an environment for editing, running SQL and PL/SQL and interacting with the database.

1.4.2oracle Database Service

Unlike other platforms, Oracle on Windows is presented as a service, while Oracle runs as a process in UNIX. All oracle.exe servers and their subsequent processes run as clues in the oracle.exe process.

After the Oracle Database 10g system is installed, many database services are automatically added in Windows 2000/XP/2003. In "Administrative Tools"> "services", you can see multiple services starting with Oracle. These services are related to Oracle database servers.

Oracle Database Operation Management is closely related to its services. Therefore, we should fully understand the role of the Oracle service.

1. Oracle service

The Oracle service is crucial for database operation and system management. In Windows, Oracle starts each instance as a service. A service is an executable process registered in the Windows registry and managed by windows ). The registry automatically tracks and records the security information of each created service. Oracle also uses services to support database operations, similar to Windows Services. Oracle is a service that establishes and associates with Oracle databases during database creation. The Oracle service is used to create, connect to, and use an Oracle database instance. In the registry, you can use the "Search" option in the "edit" menu to search for "oracle" information for each service. One of the advantages of the service is that it simplifies the process of starting the database. When the computer restarts, the system automatically starts and configures the database without the user's participation. This is done by the Service. Another advantage of services is that they must be started by users with specified permissions. For example, Oracle

The service starts background processes, which are similar to the daemon process in UNIX. When the Oracle Database Service is started, no typical Oracle process is running in the system. On the contrary, the service process waits for the initial connection from SQL * Plus, which causes a foreground process to start and create the background process of SGA in the global region of the system. When the Oracle database is closed, all created processes are terminated. However, the process is still running, waiting for the next connection request and start command. This means that when the database instance is started through Oracle service <Sid> in windows, but the database instance is disabled in SQL * Plus or Oracle Enterprise Manager, however, the oracleservice <Sid> in Windows is still in the "started" status. The database cannot be started only when the Oracle service <Sid> Service (process) in Windows is stopped. Of course, when the Oracle service <Sid> service is stopped, you can start the database instance in other ways. There are multiple ways to manage Oracle services in windows. For details, see the relevant sections below.

Oracle network listener (Net Listener) is another important service. This service must be started before the user can connect to the Oracle database. Whether the process is closed or not does not affect the connection established between the client and the database and the user's usage of the database. Take SQL * Plus as an example, when Oracle network listener service Oracle