Oracle 10g Installation

Three parts in total

Part 1 Oracle 10g Installation

Part 2 ORACLE Express Installation

Part 3 ora-12514 troubleshooting

Part 1 Oracle 10g Installation

Http://www.jb51.net/article/18038.htm

People who have just been familiar with Oracle will feel helpless when they learn, how to learn, what tools are available, and what operations should they perform. So before learning to use Oracle, first install Oracle 10 Gb to master its basic tools. As the saying goes: to do good deeds, you must first sharpen your tools. Let's get started!
-
-
First, add the Oracle 10g installation CD to the optical drive. If it runs automatically, the installation interface 1 appears:

Figure 1

Click "Start installation" to install Oracle 10 Gb. Generally, check whether the system configuration meets the requirements. Then, the "Oracle Database 10 Gb installation" dialog box appears, as shown in Figure 2:

 

Figure 2

You can select "Basic installation" or "Advanced installation" when installing Oracle database at 10 Gb. When "Basic installation" is selected, "Oracle main directory location" is used to specify the storage location of the Oracle Database 10 Gb software; the "installation type" is used to specify the installation type (Enterprise, standard, and personal) of Oracle products ). If you select "create startup Database", you must specify the global database name and password of the database user.

Select "Advanced installation" and click "Next". The "specify file dialog box" is displayed, showing the disk path of the Installation Product in the source path; the target name is used to specify the environment variables corresponding to the Oracle Home directory, and the target path is used to specify the target installation path for installing the Oracle software. Set the target name to oradb10g_home1 and the target path to D: oracleproduct10.1.0db1. 3:

 

Figure 3

Click "Next" to load the Oracle product list. The "Select installation type" dialog box is displayed. 4:

 

Figure 4

When selecting the installation type, select "Enterprise Edition" and click "Next". The "select database configuration" dialog box appears. 5:

Figure 5

In the "select database configuration" dialog box, you can select whether to create and start a database. If you want to create a database, You must select the database creation type. Select "do not create start Database" and click "Next". The "summary" dialog box is displayed, as shown in 6:

 

Figure 6

Click "Install" to install the Oracle Database 10 Gb product. 7. Installation Process:

 

Figure 7

Figure 8 shows the installation completed.

 

Figure 8

After installing the Oracle database for 10 Gb, you must create a database.
The Database Configuration assistant is used to create databases, configure Database options, delete databases, and manage templates. If you have not created a database when installing Oracle database for 10 Gb, you can use the database configuration Assistant (dbca) to create a database after installation.

There are two ways to create a database: the first is to run dbca directly under the command line; the second is to click the Start Menu: start => program => Oracle => oradb10g_home1 => Configuration and migration tool => Database Configuration assistant. 1:

Figure 1

Then, follow these steps to see the welcome dialog box, 2:

 

Figure 2

Click "Next". The "operation" dialog box is displayed. This dialog box is used to perform database operations (Create a database, configure Database options, delete a database, and manage a template). 3:

 

Figure 3

If you create a database for the first time, you can only create a database and a management template. Select create database and click "Next". The database template dialog box is displayed. 4:

 

Figure 4

A database template is an XML file on a local hard disk used to store database configuration information.

Select "transaction processing" and click "Next". The database ID dialog box is displayed. This dialog box is used to set the global database name and routine name. 5:

 

Figure 5

The global database name in the format of db_name.db_domain. Db_name corresponds to the database name, And db_domain corresponds to the network domain name. Sid (routine) should be exactly the same as db_name. 5 are set to: demo.

Click "Next". The "manage options" dialog box is displayed. Used to set OEM management information. 6:

 

Figure 6

To manage all Oracle databases in a centralized manner, select "Grid Control Database Management". If you only manage local databases, select "Use Database Control to manage databases ".

Select "Use Database Control to manage databases" and click "Next". The "Database Authentication" dialog box is displayed, which is used to set the password of the initial database user account. 7:

 

Figure 7

To use the same password as sys, system, Dbsnmp, and sysman, select "all accounts use the same password ". Select "use different passwords" and set the User Password respectively: the password of SYS user is Oracle, the password of system user is manager, and the password of Dbsnmp user is Dbsnmp, the password of the sysman user is sysman.

After setting the password, click "Next". The "Storage Options" dialog box is displayed. This dialog box is used to specify the storage mechanism (file system, automatic storage management, and bare device) of the database:

 

Figure 8

Select "File System" and click "Next". The "database file location" dialog box is displayed, which is used to specify the storage location of database files. 9:

Figure 9

Select "use the database file location in the template" and click "Next". The "recovery configuration" dialog box is displayed. This dialog box is used to specify the database recovery options. 10:

Figure 10

The quick recovery area is used to recover data to avoid data loss when the system fails. archive is enabled to set the database to archivelog mode, so that the database data can be completely restored when the database fails.

Click "Next". The "database content" dialog box is displayed, which specifies whether to install the sample scheme and run the custom script. 11:

 

Figure 11

Click "Next". The "initialization parameters" dialog box is displayed. This dialog box configures initialization parameters, database character sets, and connection modes. 12:

Figure 12

The content here is more informative than for beginners.

Click "Next" to display the "database storage" dialog box, which uses the specified control file, data file, redo log file, name, and size. 13:

Figure 13

Click "Next". The "create option" dialog box is displayed. You can specify whether to create a database or save it as a database template. 14:

Figure 14

Click Finish. The OK dialog box is displayed, listing all information about the Oracle Installation option. 15:

Figure 15

Click OK to complete the database creation process. The database will be created, 16:

 

Figure 16

After the database is created, the following dialog box appears, 17:

Figure 17

After the database is created, the system locks all users except sys, system, Dbsnmp, and sysman. Scott user should be used in the future, so after clicking the "password management" button, unlock Scott user, 18:

Figure 18

Specify the user password as Tiger, click OK, and then click exit to complete the database creation process.
Detailed source reference: http://www.jb51.net/article/18038.htm

 

 

 

 

 

 

 

Part 2 ORACLE Express Installation

 

Oracle Database 10g quick edition (Oracle Database Xe) is a small entry-level database based on the Oracle Database 10g 2nd code base

 

 

 

 

 

Password: common password

 

 

 

 

 

Part 3 ora-12514 troubleshooting

Recently, I downloaded an Oracle 10 Gb installation package from the Oracle website. There is only one disk, and there is also a convenient option during installation, which is very convenient.
After the installation is complete, you may encounter problems when using it: If you only access sqlplus system/manager from the local machine, there is no problem.
However, if sqlplus system/manager @ orcl is used, an error with the ora-12514 is reported.

Solution:
1. Open the <oraclehome>/Network/admin/listener. ora file and find:

Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = plsextproc)
(ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1)
(Program = EXTPROC)
)
)
2. Add:
(Sid_desc =
(Global_dbname = Oracle)
(ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1)
(Sid_name = Oracle)
)
3. Finally changed:
Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = plsextproc)
(ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1)
(Program = EXTPROC)
)
(Sid_desc =
(Global_dbname = Oracle)
(ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1)
(Sid_name = Oracle)
)
)
4. Save the file and restart tnslistener in the service. OK!

PS: Oracle10g has a benefit: it no longer conflicts with Tomcat ports. After the original Oracle9i installation is complete, port 8080 will be occupied. Generally, you need to change the Tomcat port. Now it's easy.