Oracle Configuration for generic applications

Oracle| Program Oracle Configuration Instructions
Lixin (University of Petroleum, East China) School of Computer and communication engineering, Dongying 257061, Shandong;
1. Objective
After the Oracle installation is successful, some basic configuration is required for the application to run normally. This article provides a detailed explanation of how to make Basic configuration of Oracle. All the explanations in this article are based on Oracle 8i
2. Local Oracle Configuration 2. 1 Creating a Database
Typically, after the server side of Oracle is installed, a database is created by default. If this database is already established, you can skip this step. You can detect if a database exists by using the following methods.

Open the Database configuration Assistant, as shown below


Figure 2.1.1 Start the database configuration Assistant




The window appears (Figure 2.2):

If changes to the Database Settings option and the Delete database option are not available, no database is established on behalf of the current host.

When you need to set up a native database, select Create DATABASE, click Next button, select Typical in the newly emerged window, click Next button. Appears in Figure 2.1.3

If you are an Oracle installed from your hard disk or oracle that you installed from the CD and the installation disk of Oracle is still in the optical drive, select "Copy existing database files from CD", or select "Create New Database File", which is slower than the creation of the former. Click the Next button. Appears in Figure 2.1.4

In the text box, fill in the SID of your database. This is the same as your Oracle SID (established when Oracle is installed).

By clicking on the "Finish" button, a new database will be created.




Figure 2.1.2 Database Configuration Assistant







Figure 2.1.3 Database Configuration Assistant







Figure 2.1.4 Database Configuration Assistant

2. 2 Creating table spaces and users
⑴ Open DBA Studio



Select Lannch DBA Studio Standalone Login

⑵ See if the database you created is in the list on the left. If not, in the Select File menu, add Database to tree appears 2.2.1




Figure 2.2.1 Adding a database to a tree




In general, the database you have created is already in the list below, select it to make sure it exits. If you are not in the list below, you can add it manually. Fill in the host name or host IP in the Host Name dialog box. The port number is typically configured to 1521. Sid dialog box, fill in the corresponding database ID. The Network service name is installed by default and can be modified by itself.

⑶ Login

At this point, if you are doing the right thing, the database has been added to the left database tree. Select your database, click on the left sidebar in the connection, the Login dialog box appears. A database is installed with a default system administrator user that can be used to log in. The user name is system and the password is manager. Click on the "OK" button to sign in. Log in as shown in Figure 2.2.2.




Figure 2.2.2 Login Successful




⑷ Create a table space

Select the table space under the storage node, then click the right mouse button to select Create, appear 2.2.3


Figure 2.2.3 Creating a table space






Enter the name of the table space in the name. In our application, the name defaults to TXK. Then modify the file size in the table below. Our application requires a 50M of tablespace. Then, by clicking the "Create" button, Oracle begins to create the table space. The general need to wait a little while, Oracle will prompt you to create success. If you do not succeed, it is generally because your table space settings are too large or insufficient disk space, modify your configuration and recreate, you can generally create success.

⑸ Create a user

Select the user under the Security node, then click the right mouse button to select Create, appear 2.2.4




Figure 2.2.4 Creating a user


Enter your username and password, and change the default value of the tablespace to the name of the table space you just created.

Then select the Role tab above, which appears in Figure 2.2.5


Figure 2.2.5 Add permissions




Select resource in the list above to add to the following. Then the Connect and resource management options are drawn on the check, click Create. Configuration complete, when the application is logged in or logged in with SQL Plus, the host string is not filled in
















Figure 2.2.6 Application Login

3. Online Oracle Configuration
In an online Oracle configuration, the server-side configuration is described above. The client must install at least Oracle clients. Then configure the following.

⑴ Start Net8 Configuration Assistant


Figure 3.1 Start Menu




⑵ Select Local Network service name configuration


Figure 3.1 Net8 Welcome interface




Next.

⑶ Select Work and Oracle version

In the Select Work interface, select the work you want to do, we choose to add.

In Oracle's version selection, select the Oracle version you installed, we select Oracle 8i

⑷ Enter Global database name

The name you need to enter is the SID of the database server you are going to connect to. In my lab, the server's database SID is lab.



⑸ Select Network protocol and port number

The network protocol generally chooses TCP, and the port number is 1521. In the host name, fill in the server's hostname or the IP address of the server. The IP of my database server is 10.66.66.1.



⑹ Test



Generally choose to test to ensure that your configuration is successful. If the test does not succeed, go back to the first step and start the configuration anew. After the configuration succeeds, configure the host string.

⑺ Configuration Host String



This name can be entered arbitrarily, but in order to remind you of what database you are connected to, it is recommended that this name be related to the database name. After the above steps, a network service name is configured to complete. When an application logs in or logs on with SQL Plus, the host string is populated with the name of the network service you just created.


4. Summary
In the above documentation, a brief description of the Oracle configuration required by the general application is presented. Of course, Oracle is quite complex, and if you need additional configuration, you must refer to Oracle's user reference manual.