Oracle configuration instructions
Li Wei (University of Petroleum (East China) Computer and Communication Engineering, Dongying 257061, China;
1. Foreword
After the Oracle installation is successful, some basic configurations must be made to run the application. This article explains how to make basic configurations for Oracle. All explanations of this article are based on Oracle 8i
2. Local Oracle configuration
2.1 Creating a database
Generally, a database will be created by default after installing Oracle's server-side. If this database has been established, you can skip this step. It is possible to detect if there is a data inventory.
Open Database Configuration Assistant, as shown below
Figure 2.1.1 Starting the Database Configuration Assistant
Window appears (Figure 2.2):
If you change the database settings option and delete database options are not available, you do not have any databases that are not established in the current host.
When you need to create a native database, select Create a database, click the "Next" button, select the typical window in the new window, click the "Next" button. Figure 2.1.3 appears
If you are an Oracle installed from the hard disk or the Oracle installed on the CD and the Oracle installation disk is still in the CD-ROM drive, please select "Copy the existing database file from the CD", otherwise select "Creating a new database file", The latter is slower than the former's creation. Click the "Next" button. Figure 2.1.4 appears
Fill in the SID of your database in the text box. This is the same as your Oracle's SID (established when installing Oracle).
Click the "Finish" button to create a new database.
Figure 2.1.2 Database configuration assistant
Figure 2.1.3 Database configuration assistant
Figure 2.1.4 Database Configuration Assistant
2.2 Creating tablespaces and users
(1) Open DBA Studio
Choose LANNCH DBA Studio Standalone login
(2) View whether the database you established is in the list on the left. If not, select "Add Database to Tree" in the File menu. Figure 2.2.1
Figure 2.2.1 Add the database to the tree
Generally, the database you have established has appeared in the list below, select it to determine exit. If you are not in the list below, you can use it manually. Fill in the host name or host IP in the Host Name dialog box. The port number is generally configured to 1521. The corresponding database ID is filled in the SID dialog. The network service name can be modified by the default installation.
(3)
At this point, if you operate correctly, the database has been added to the left database tree. Select your database, click on the connection in the left toolbar, and the login dialog appears. A default system administrator user is established when a database is installed, which can be used to log in. The user name is System, the password is Manager. Click the "OK" button to log in. After logging in, as shown in Figure 2.2.2.
Figure 2.2.2 Login success
⑷ Create a table space
Select the table space under the storage node, then click the right mouse button, select the creation, Figure 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 is default to TXK. Then modify the file size in the table below. Our application requires a 50m table space. Then click the "Create" button, and Oracle starts to create a table space. Generally I need to wait a little, Oracle will prompt you to create success. If it is unsuccessful, it is generally because your table space is set too large or the disk space is insufficient, and you will be recreated after you have configured it, it is generally created.
⑸ Creating users
Select the user under the security node, then click the right mouse button, select the creation, Figure 2.2.4 Figure 2.2.4 Create a user
Enter your username and password and change the default value of the table space to the table space you just created.
Then select the above role tab, appears Figure 2.2.5
Figure 2.2.5 Add Permissions
Select Resource in the above list to add it below. Then draw the Connect and Resource management options on the check, click Create. The configuration is complete, when the application is logged in or logged in with SQL Plus, it can be filled with the host string.
Figure 2.2.6 Application Login
3. Online Oracle Configuration
In the online Oracle configuration, the configuration of the server is as described above. The client must install at least the Oracle client. Then make the following configuration.
(1) Start Net8 Configuration Assistant
Figure 3.1 Start menu
(2) Select the local network service name configuration
Figure 3.1 Net8 welcome interface
Next step.
(3) Select the work and Oracle version
In the selection work interface, select the job you want to do, we choose to add.
In Oracle's version selection, select Oracle Versions you installed, we choose Oracle 8i
⑷ Enter the global database name
This name that needs to be entered refers to the SID of the database server you will connect. In my laboratory, the server's database SID is LAB.
⑸ Select the network protocol and port number
The network protocol generally selects TCP, the port number is 1521. Fill in the host name or server's IP address of the server in the host name. My database server's IP is 10.66.66.1.
⑹ test
Generally choose to test, make sure your configuration is successful. If the test is not successful, return to the first step from the new start configuration. After the configuration is successful, the host string is configured.
⑺ Configure the host string
This name can be set any, but in order to let you think of what the database you connect, it is recommended that this name is related to the database name. After the above steps, a network service name is complete. When logging in to the application or logged in with SQL Plus, a host string is filled in the network service name you just established.
4. summary
In the above documents, the Oracle configuration required by the general application is briefly illustrated. Of course, Oracle is quite complicated. If you need other configurations, you must refer to Oracle's user reference manual.
