1. Oracle10g Installation

1.1 download the installation package

We can go to the Oracle official website to download its installation package, but have to see the relevant software declaration, nonsense, the following is the Oracle10g URL and site http://www.oracle.com/technology/global/cn/software/products/database/oracle10g/index.html

 

 

1. 2. Installation
1.2.1.run setup.exe and the "10 Gb installation of Oracle Database" image is displayed in Figure 1.

Figure 1 Oracle Database 10 Gb Installation

Select "Advanced installation" to set different passwords for sys and system and perform selective configuration.

1.2.2. "Next" to go to "Oracle universal Installer: Specify the file location", as shown in figure 2.

Figure 2 Specify the file location

• Set the source "path", "name", and target "path", as shown in figure 3.
  1. "Name" corresponds to the oracle_home_name environment variable
  2. The path corresponds to the ORACLE_HOME environment variable.

Figure 3 set the source "path", "name", and target "path"

1.2.3. Click "Next" to go to "Oracle universal Installer: select the installation type", as shown in figure 4.

Figure 4 select an installation type

1.2.4. Keep the default value. Next, go to "Oracle universal Installer: select database configuration", as shown in Figure 5.

Figure 5 select Database Configuration

1.2.5. Keep the default value. Next, go to "Oracle universal Installer: Specify Database Configuration Options", as shown in figure 6.

Figure 6 specify Database Configuration Options

• Specify "Global Database Name" and "Sid". The two parameters are generally the same, for example, snapshot T.
• You can also set "Global Database Name" to a domain name. Example: mongot.abc.com
• If you select "create database with Sample Scheme", oui will create HR, Oe, sh, and Other Sample Scheme (sample schema) in the database)

1.2.6. Next, go to "Oracle universal Installer: select database management option", as shown in figure 7.

Figure 7 selecting Database Management Options

1.2.7. Keep the default value. Next, go to "Oracle universal Installer: Specify database file storage options", as shown in figure 8.

Figure 8 specify database file storage options

1.2.8. Keep the default value. Next, go to "Oracle universal Installer: Specify backup and recovery options", as shown in figure 9.

Figure 9 backup and recovery options

1.2.9. Keep the default value and click "Next" to go to "Oracle universal Installer: password of the database solution", as shown in 10.

Figure 10 password of the database solution

• Set different passwords for different accounts.

1.2.10. Click "Next" to continue the installation and go to "Oracle universal Installer: Summary", as shown in 11.

Figure 11 Summary

1.2.11. Click "Install" to start the installation process. The installation process may take about 20 minutes depending on the machine performance.

1.2.12. When the database is created, the "Database Configuration assistant" window is displayed, as shown in 12.

Figure 12 Database Configuration Assistant

1.2.13. Click "password management" to enter the "password management" window, as shown in Figure 13.

Figure 13 password management

1.2.14. Unlock user HR, OE and Scott, enter the HR and OE passwords, and Scott's default password is Tiger.
1.2.15. Click OK to return to the "Database Configuration assistant" window.
1.2.16. Click "OK" in the window shown in Figure 15 to enter the "Oracle universal Installer: End of installation" window, as shown in figure 14.

Figure 14 Installation Complete

1.2.17. Check and click "exit" to complete the installation.
1.2.18. log on to the 10 Gb Enterprise Manager as sysdba of the sys account in the automatically opened browser.

To accept the license for the first time, click iagree.

 

1.3. view the installation status
1.3.1. directory structure

Figure 15 Oracle directory structure

• Oracle_base by default
  1. In Windows, the default oracle_base directory is: D: \ oracle \ product \ 10.1.0
  2. In UNIX, the default oracle_base directory is/PM/APP/Oracle/10.1.0.

All Oracle software files and database files are located in subdirectories under oracle_base.

• ORACLE_HOME by default
  1. In Windows, the default ORACLE_HOME directory is: D: \ oracle \ product \ 10.1.0 \ dbct.
  2. In UNIX, the default ORACLE_HOME directory is/PM/APP/Oracle/10.1.0/dbct.

ORACLE_HOME is the path to access all Oracle software.

• Admin folder to store Initialization Files and log files
• The oradata \ recovery t folder stores database data files. DBF, control files. CTL, and redo log files. Log

Figure 16 oradata \ release T folder

1.3.2. view the Oracle services in the Service Manager.

Figure 17 Oracle services

Oraclecsservice

Only 10 Gb RAC is available. CSS (cluster Synchronization Service)

1.3.3. Registry

Figure 18 Registry

Figure 19 key values of the Registry

 

Language settings

Name Data

Nls_lang simplified chinese_china.zhs16gbk

Where: Simplified Chinese indicates Simplified Chinese

China indicates the Chinese Date Format

Zhs16gbk indicates Encoding

1 nls_lang format: nls_lang = language_territory.charset
2 has three components (language, region, and Character Set), each of which controls the NLS subset features. Three components can be combined at any time, for example:
3 american_america.us7scii
4 jpanese_japan.ja16euc
5. language indicates the language of the server message.
6 Territory specifies the date and number format of the server.
7 charset specified Character Set

8. You can also define the nls_lang parameter in some subsets:
9 The default date format of nls_date_format
10 nls_date_language default language
11 nls_numberic_characters decimal characters are separated from the group
12 nls_currency local currency characters
13 nls_iso_currency ISO currency characters
14 nls_sort character sorting Sequence

If you use English, change the value of nls_lang:

American_america.we8iso8859p1 or englishi _ America. us7scii

1. In SQL/plus, run the following SQL statement to check the character set of the connected database:
2
3 SQL> select userenv ('language') from dual;
4 userenv ('language ')
5 ----------------------------------------------------
6 simplified chinese_china.zhs16gbk

1.3.4. Path Environment Variable

1 D: \ oracle \ product \ 10.1.0 \ dbct \ bin; D: \ oracle \ product \ 10.1.0 \ dbct \ JRE \ 1.4.2 \ bin \ Client; D: \ oracle \ product \ 10.1.0 \ dbct \ JRE \ 1.4.2 \ bin; % SystemRoot % \ system32; % SystemRoot % \ system32 \ WBEM

1.3.5. Start> Add the Oracle-oradb10g_home folder to all programs

1.3.6.oracle 10g change port 8080 (if needed)
Run the following command in sqlplus:

1 call dbms_xdb.cfg_update (updatexml (dbms_xdb.cfg_get ()
2, '/xdbconfig/sysconfig/protocolconfig/httpconfig/HTTP-Port/text ()'
(3, 9000 ))
4/
5 commit;

 

1.4. test whether the installed Oracle 10g can run properly
During the installation process, oui creates two files under <ORACLE_HOME> \ install:

• Readme.txt: records the URLs and ports of various Oracle Applications.
• Portlist. ini: record the port used by the Oracle application.

1.4.1. log on to Enterprise Manager 10g Database Control
Unlike earlier versions, Oracle Enterprise Manager only adopts the B/S mode. Enter the following URL in the Web browser:

1 http: // <Oracle/Server Name>: 5500/em

Example: http: // localhost: 5500/em

Enter the Enterprise Manager 10g logon window. Log on to the Oracle database as sysdba using the sys account.

Figure 20 system logon to Enterprise Manager 10g Database Control

If this is the first time you log on, first go to the Oracle 10g copyright page.

Figure 21 Oracle 10g copyright notice

Click the "I agree" button in the lower right to enter the Enterprise Manager 10g.

Figure 22 view database configuration information in Database Control

Now we can use it to manage Oracle databases.

1.4.2. Use iSQL * pls to log on to the Oracle database
ISQL * Plus is a client tool in B/S mode. Enter the following URL in the Web browser:

1 http: // <Oracle/Server Name>: 5560/isqlplus

Example: http: // localhost: 5560/isqlplus

Go to the iSQL * Plus logon window. Log on to the Oracle database with an HR account.

Figure 23 Oracle 10 Gb iSQL * Plus logon page

Note: If you do not know the HR password, log on with sys and change the HR password. For example, change the HR password to HR: Alter user HR identified by HR;

After logging on to the iSQL * Plus workspace, you can enter the SQL * Plus command, SQL statement, and PL/SQL statement in the workspace.

Figure 24 run the SELECT statement in the iSQL * Plus Workspace

Figure 25 view the execution result of the SELECT statement in iSQL * Plus

1.4.3. use SQL * pls to log on to the Oracle database
SQL * Plus is a client tool program in C/S mode.

• Choose Start> All Programs> Oracle-oracle10g_home> application development> SQL * Plus"
• Enter the HR account and password in the logon window

Figure 26 execute the SELECT statement in SQL * Plus

1.4.4. Use the command line SQL * pls to log on to the Oracle database
The traditional SQL * Plus is a command line client program. In the command window, enter the command shown in Figure 27 for testing.

Figure 27 execute the SELECT statement in command line SQL * Plus

 

1. 5. Attachment:
After Oracle 10 Gb database is installed in windows, the running speed of the computer is significantly reduced. Therefore, if you do not use the database, you can disable the Oracle 10 Gb Database Service, as shown in Figure 28.

Figure 28 stopping the Oracle service

To use the database, only the necessary services are started according to the application situation, as shown in Service 29 that must be started.

Figure 29 start required Oracle services

The default port of the Oracle Database Listener is 1521. You can:

View the listener port in the ORACLE_HOME \ Network \ admin \ listener. ora file.