Database-Oracle [installation of ORACLE Server]

Preface:

In the age of network coverage, databases are nothing new to modern society and industry. They have been applied to all fields of social production and life. As a high-performance and high-productivity database management application platform, Oracle9i has powerful functions in database management, data integrity check, database query performance, and data security, moreover, it provides different methods and methods in terms of confidentiality mechanisms, backup and recovery, space management, open links, and development tools. In short, Oracle9i has become a powerful tool for modern enterprises to operate efficiently, become a rare software tool for different users, developers, and managers. This article briefly introduces the implementation process of Oracle9i's network database application. Due to the huge functionality of Oracle9i, this article strives to be concise, hoping to bring some valuable results to beginners.

Resource preparation:

To do a good job, you must first sharpen the tool. Oracle9i has high requirements on system resources. If it lacks high hardware and software configuration support, its operation efficiency will be greatly reduced.

Hardware configuration:

Application:

This article mainly introduces the application and implementation of Oracle Database in the network, taking into account the knowledge structure andArticleAccording to the different access methods in database setup and operation, the author divides the application of network databases into two general modes: one is based on the server-client mode, the other is based on the server-browser mode. Readers only need to understand that Oracle9i uses the Oracle Net mechanism, so it is easy to use the existing network for data communication.

I. Server-client Mode

Article 1: Installation

Server installation:

The so-called server is the computer used for database servers. The first thing we need to do is to install the Oracle9i server. The installation steps are as follows:

Place the first installation CD of Oracle into the optical drive, and the CD will automatically start. 1. Click [start installation] To Go To The Oracle general installer, as shown in Figure 2. Click [next].

Select the installation path and name of Oracle:

In the dialog box shown in 3, select the source installation path and target name and path of oracle. Generally, the names of installation products are named products and jar. The system will identify the source installation path by default. Click [next] to continue the installation. If the option is correct, you will see the progress indicator of the product to be loaded.

Choose to install the Oracle9i Database Server:

Select the installation type you need. Generally, use the [Enterprise Edition] with complete functions, as shown in Figure 5.

For different installation purposes, select the required database:

If you are not familiar with Oracle9i installation, we recommend that you select the [common] Single-choice button. The installation type shown in 6 will help you automatically configure network connections and create databases.

* Option Description: "General"-preconfiguration database for general purpose installation. Common types are suitable for simple transaction processing or complex queries, and support quick access to data by a large number of concurrent users. It can be used for typical applications in the transaction processing environment, Decision Support System (DSS) query, and historical data scanning. "Transaction processing"-install the pre-configured database for optimizing transaction processing. The transaction processing type supports a large number of concurrent users to execute simple transaction processing. It can provide high availability and service rationality, provide the ability of a large number of users to access the same data in parallel, and have high recovery performance. Typical applications of transaction processing include bank transaction processing or Internet Business Database Transaction processing. "Data Warehouse"-install and optimize the pre-configured database of the data warehouse. The data warehouse type is suitable for complex queries on topics. It supports fast access to a large amount of data and uses applications such as Online Analytical Processing (OLAP ).Program. Data Warehouse has a wide range of typical applications, including customer order research, support for call, sales forecasting, shopping and purchasing models, and history databases for other strategic business issues. "Custom" -- create a custom database. Select this option, which takes a long time to install, but you can select the required installation type and component. You must select Custom installation only when you have experience installing Oracle, prepare complex system and product configuration information, or install a specific oracle91 component. "Install software only" -- select this type, only install software, do not create a database, and do not start the configuration assistant after installation, which may cause some difficulties in configuring the database later.

In the dialog box for the database ID shown in Figure 7, determine the name of the global database you want to create. In this example, enter "CMDL" in the [Global Database Name] and Sid ", click [next] to continue the installation.

Select the database file location:

To optimize the database performance, we recommend that you install the database files and software on different disks, as shown in figure 8.

Select the database character set:

Character Set setting in Oracle databases is a key issue for installation. If the character set is improperly used, it may appear in the database as "???" So that the user cannot correctly identify the information, but also may cause loss of important information.

First, we should explain that when installing the database server, we should select the General Chinese Character Set of the database. There are three main Chinese character sets of the database: zhs16gbk, us7ascii, and we8iso8859p1. Here, we select the character set zhs16gbk, as shown in 9.

Second, when installing the client to be explained later, in order to make the client display the server information normally, when installing the client, the character set of the client must be consistent with that of the server. Therefore, in the subsequent Client installation steps, the character set of the client must also be zhs16gbk.

Click [install] To start installation. In the dialog box shown in figure 10, you can view the installation process and add the second and third installation disks to the optical drive as prompted.

Create a database:

After the Oracle software is successfully installed, create a database. The dialog box shown in Figure 11 shows the process of creating a database.

Change the default password:

After a database with the SID of CMDL is created, the Database Configuration assistant displays the database details, including the default sys and system passwords, as shown in Figure 12, click the [Password Management] button to change the default password, and click the [exit] button to complete the database configuration. The installer configures some other tool services, as shown in Figure 13, these operations are automatically performed. Do not worry, please be patient.

When the installation end screen shown in figure 14 is displayed, it is proved that the installation of our database server has basically completed.

Check the status after installation:

After installing the database server according to the previous steps, how can I know how the database works? What services are provided? Therefore, we need to perform necessary checks to confirm.

1. Check in the [Program] menu

After the database server is installed, check the project in the [Program] menu and select [start] | [all programs]. There are two items in total.

Oracle-OraHome90 oracle tools

Oracle instaalation products Oracle Installation Product

2. Check in "service"

Select the [start] | [set] | [Control Panel] command, double-click [Administrative Tools icon], and select the [SERVICE] Option to open the screen shown in Figure 15. This figure lists all the services that Oracle needs to start after the server is installed. At this time, it should be:

Check the connected database:

After completing the first two steps, it indicates that the database and listener services are working properly. Next, let's try using SQL * Plus on the server to check the connection to the database.

After running SQL * Plus, enter the user name and password, as shown in Figure 16. If the connection is unsuccessful or successful, the connection is successful, as shown in figure 17.

Client installation:

Place the first system installation disk of Oracle9i into the optical drive, automatically guide the installation of the system, and display the Oracle9i installation system cover window. Click the [start installation] button to display the installation homepage, the "welcome" window shown in 18 is displayed. Click [next] to go to the "file positioning" window. In the target text box of this window, enter the name of the main directory. Generally, press the default value, for example, orahome90. In the path text box, enter the path of the main directory, for example, D: \ oracle \ ora90, click the [next] button to display the "file positioning window" with the "loading product list" progress bar, as shown in Figure 19.

The "available products" window shown in 20 is displayed. Click the second option, that is, the single-choice button of the Oracle9i client.

Click [next] to display the "installation type window" shown in Figure 21 ". Select "Administrator" and click the [next] button to display the "installation type" window with the "execution prerequisites" progress bar.

* Window Description: "Administrator" -- indicates that the Administrator installs the SDK. The installation content includes the management console, enterprise management tools, network services, user programs, and basic client software. It requires a disk space of 6 47mb. "RunTime"-indicates that the database application support provides network connection services and support files that connect to the Oracle9i database and interact with each other, and requires a disk space of 48 6 MB. "Custom" -- indicates that you can install it on your own. Some additional components can only be installed using the "Custom" installation type.

The summary window shown in 22 is displayed.

Click the [install] button to display the "Install" window, as shown in Figure 23.

The "configuration tool" window is displayed, as shown in Figure 24. What we need to do now is the key operation for establishing the server/client mode !!

During configuration, the "Network Configuration Wizard" window shown in "25" appears, asking whether to use the directory service.

"Yes, I want to use directory service": includes two service types: Oracle Internet Directory and Microsoft activity directory.

"No, I want to create my own network service name"

In this example, use "No, I want to create a network service name". After selecting this option, the Oracle9i Network Configuration Wizard will help you complete the network service creation.