Install the Oracle database 10g_3 on Linux x86

Start the General Oracle Installation program.

$./Runinstaller

1. Welcome

O clickNext.

2. Specify the List Directory and Certificate

O if you have been following the steps in this Guide, use the default value. Otherwise, edit the path of the List Directory to point to the correct directory.

O OS group name should beOinstall.

3. If this is the first time oracle is installed on this machine, you will receive a pop-up window prompting you to run the orainstroot. Sh script as a root user. Log on as a root user, change to the directory specified in the window, execute the script, and continue the operation.

4. Specify the file location

O if you have been following the steps in this Guide, use the default value. Otherwise, make sure that the source path and target path are correct before proceeding.

5. Select the installation type

O accept default valuesEnterprise Edition.

6. Check the prerequisites related to specific products

O if you have been following the steps in this Guide, all checks should pass smoothly. If one or more checks fail, rectify the problem before continuing.

7. Select Database Configuration

O accept default valuesCreate a starter DatabaseAndGeneral Purpose.

8. Specify Database Configuration Options

O enter the global database name of the database. This name should contain oracle_sid and server domain name (for example, demo1.orademo.org, where demo1 is oracle_sid and orademo.org is a domain name ).

O when you enter the global database name, the SID box is automatically filled.

O accept the default database character set.

O SelectionCreate Database with sample Schemas.

9. Select Database Management Options

O SelectionUse Database Control for database management.

10. Specify database file storage options

O SelectionFile SystemAnd then enter the path name (/u02/oradata in this example) to be used for the database file ).

11. Specify backup and recovery options

O SelectionDo not enable automatic backups.

12. Specify the database mode password

O SelectionUse the same password for all the accounts.

O select a password and enter it twice for confirmation.

13. Summary

O displays the summary of installed products.

O clickInstall.

14. Installation

O this screen goes through several phases of installing and linking Oracle software.

O The configuration information is displayed in the pop-up window when the installation process ends. Write down the Enterprise Manager URL, and then clickOKClose this window.

O A "setup privileges" window pops up, prompting you to run the configuration script as the root user. Log on as a root user, switch to the directory indicated in this window, and then execute the root. Sh script. This script prompts you to enter the location of the local bin directory. PressEnterThe key accepts the default value. When the script is complete, return to the setup privileges window and clickOK. (As shown below .)

15. installation is complete

O write down the URL displayed in the summary, and clickExit.

16. Congratulations! Your new Oracle 10GThe database has been started and can be used.

Part 1: Configure Storage

The database we created in section 3rd uses a single file system (/u02/oradata) for disk storage. However, there are many ways to configure storage for Oracle databases.

Section 4th describes how to configure disk storage for this database. In particular, it describes how to create other file systems and how to use Automatic Storage Management (ASM ). How to use the original device and the Oracle Cluster File System (ocfs) will be introduced in another article in this series, this article describes how to use the Oracle Real Application cluster (RAC) create a cluster database.

File System

The file system is the most common method for storing data files, redo logs, and control files for Oracle databases. The file system is easy to implement and does not require third-party software for management.

In most cases, the file system is created during the initial installation of Linux. However, sometimes you must create a new file system after initial installation (such as after a new disk drive is installed.

This section describes how to build a new file system and how to use it in an Oracle database. Unless otherwise stated, all commands must be run as the root user.

Partitioning a disk

You must use an empty disk partition to create a file system. If you already have an empty available disk partition, skip to the next step.

The following is an example of creating a new partition for the Linux File System. (Warning: the error partition for the disk isDelete all content on the hard diskIs one of the most reliable and quick methods. If you are not sure about how to partition, stop and ask someone to help you; otherwise, you may be at risk of data loss .)

This example uses/dev/SDB (an empty SCSI disk without partitions) to create a single partition for the entire disk (36 GB.

For example:

# Fdisk/dev/SDB

Device contains neither a valid DOS partition table, Nor Sun, SGI or OSF disklabel

Building a new dos disklabel. changes will remain in memory only,

Until you decide to write them. After that, of course, the previous

Content won't be recoverable.

 

 

The number of cylinders for this disk is set to 4427.

There is nothing wrong with that, but this is larger than 1024,

And coshould in certain setups cause problems:

1) software that runs at boot time (e.g., old versions of lilo)

2) booting and partitioning software from other OSS

(E.g., DOS fdisk, OS/2 fdisk)

 

Command (M for help): p

 

Disk/dev/SDB: 255 heads, 63 sectors, 4427 Cylinders

Units = cylinders of 16065*512 bytes

 

Device boot start end blocks ID system

 

Command (M for help): n

Command action

E extended

P primary partition (1-4)

P

Partition Number (1-4): 1

First cylinder (1-4427, default 1 ):

Using default value 1

Last cylinder or + size or + sizem or + sizek (1-4427, default 4427 ):

Using default value 4427

 

Command (M for help): W

The partition table has been altered!

 

Calling IOCTL () to re-read partition table.

 

Warning: If you have created or modified any DOS 6.x

Partitions, please see the fdisk manual page for additional

Information.

Syncing disks.

Verify the new partition now:

For example:

# Fdisk/dev/SDB

 

The number of cylinders for this disk is set to 4427.

There is nothing wrong with that, but this is larger than 1024,

And coshould in certain setups cause problems:

1) software that runs at boot time (e.g., old versions of lilo)

2) booting and partitioning software from other OSS

(E.g., DOS fdisk, OS/2 fdisk)

 

Command (M for help): p

 

Disk/dev/SDB: 255 heads, 63 sectors, 4427 Cylinders

Units = cylinders of 16065*512 bytes

 

Device boot start end blocks ID system

/Dev/sdb1 1 4427 35559846 83 Linux

 

Command (M for help): Q

Create a File System

Use ext3 to create the new file system. You can also use other file systems, but ext3 can provide the fastest recovery when the system crashes.

For example:

# Mke2fs-J/dev/sdb1

Mke2fs 1.26 (3-feb-2002)

Filesystem label =

OS type: Linux

Block size = 4096 (log = 2)

Fragment size = 4096 (log = 2)

4447744 inodes, 8889961 Blocks

444498 blocks (5.00%) reserved for the Super User

First data block = 0

272 block groups

32768 blocks per group, 32768 fragments per group

16352 inodes per group

Superblock backups stored on blocks:

32768,983 04, 163840,229 376, 294912,819 200, 884736,160 5632,

2654208,409 7962624

 

Writing inode tables: Done

Creating Journal (8192 blocks): Done

Writing superblocks and filesystem accounting information: Done

 

This filesystem will be automatically checked every 23 mounts or

180 days, whichever comes first. Use tune2fs-C or-I to override.

Create a mount point

The file system must have a mount point, which is just an empty directory. The new file system is "connected" to the system directory tree ". The naming of mount points should follow the Oracle flexible structure (OFA) standard. For more information about the ofa standard, seeOracle 10gDatabase Installation GuideAppendix D.

Because you have used the/u01 and/u02 directory names in section 1st, use/U03 in this example.

For example:

# Mkdir/U03

Add the new file system to/etc/fstab

Therefore, the new file system will be automatically mounted when the system starts. You need to add a line to the/etc/fstab file describing the new file system and its installation location. Use the text editor to add the following line to/etc/fstab.

/Dev/sdb1/U03 ext3 defaults 1 1

Mount a New File System

After the file system is mounted, it can be used. Only when a file system is mounted can files be stored in the system. Run the following command to mount the file system and verify whether it is available.

Mount/U03

DF-H/U03

 

For example:

# Mount/U03

# DF-H/U03

Filesystem size used avail use % mounted on

/Dev/sdb1 33g 33 m   31G 1%/U03

Create an oracle directory and Set permissions

Now, create a directory for storing Oracle files. The directory name used in this example follows the database's ofa Naming Convention, that is, oracle_sid = demo1.

Mkdir-P/U03/oradata/demo1

Chown-r ORACLE: oinstall/U03/oradata

Chmod-r 775/U03/oradata

Create a new tablespace in The New File System

The new file system is available. Next, create a new tablespace in the file system to store database objects. Connect to the database as a system user, execute the create tablespace statement, and specify the data file in the new file system.

For example:

$ Sqlplus

 

SQL * Plus: Release 10.1.0 . 2.0-production on Sun Jun 13 15:01:08 2004

 

Copyright (c) 1982,200 4, Oracle. All rights reserved.

 

Enter user-Name: System

Enter password:

 

Connected:

Oracle Database 10g Enterprise Edition Release 10.1.0 . 2.0-Production

With the partitioning, OLAP and Data Mining options

 

SQL> Create tablespace data1

2 datafile '/U03/oradata/demo1/data1_01.dbf' size 100 m

3 extent management local

4 segment space management auto;

 

Tablespace created.

Now, you can use this new tablespace to store database objects, such as tables and indexes.

For example:

SQL> Create Table demotab (ID number (5) not null primary key,

2 Name varchar2 (50) not null,

3 amount number (9, 2 ))

4 tablespace data1;

 

Table created.