Refer to Oracle official installation documentation: http://www.oracle.com/technology/global/cn/pub/articles/smiley_10gdb_install.html 1> Installation preparation 1.1> download oracle Installation program on the oracle official website download oracle 10g for linux((10201_database_linux32.zip) Web site: http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201linuxsoft.html1.2> virtual machine memory: my pc only has 512 MB of memory and can only be allocated to the Virtual Machine MB of memory. Although the minimum RAM required in the oracle Installation documentation is MB, and the minimum swap space is 1 GB, it has been practiced, I can still use 320 M of memory and 1.3 M of swap space in the virtual machine;> the disk capacity of the virtual machine is linux AS4 + oracle 10g, at least 7 GB of disk space. Considering the installation of other applications, the available disk capacity should be 10 Gb or above; 2> install oracle 2.1>Create an Oracle group and User AccountMy linux AS4 is automatic partitioning of disks/Usr/sbin/groupadd oinstall
/Usr/sbin/groupadd dba
/Usr/sbin/useradd-m-g oinstall-G dba oracle
Id oracle2.2>Create directory Mkdir-p/oracle/appMkdir-p/oracle/dataChown-R oracle: oinstall/oracle/app/oracle/dataChmod-R 775/oracle/app/oracle/data2.3>Configure Linux Kernel Parameters
#Cat>/etc/sysctl. conf <EOF
Kernel. shmall = 2097152
Kernel. shmmax = 2147483648
Kernel. shmmni = 4096
Kernel. sem = 250 32000 100 128
Fs. file-max = 65536
Net. ipv4.ip _ local_port_range = 1024 65000
EOF
#/Sbin/sysctl-p2.4> Shell restrictions set by oracle users
cat >> /etc/security/limits.conf <<EOF oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 EOF cat >> /etc/pam.d/login <<EOF session required /lib/security/pam_limits.so EOF
Cat>/etc/profile <EOF
If [\ $ USER = "oracle"]; then
If [\ $ SHELL = "/bin/ksh"]; then
Ulimit-p 16384
Ulimit-n 65536
Else
Ulimit-u 16384-n 65536
Fi
Umask 022
Fi
EOF
Cat>/etc/csh. login <EOF
If (\ $ USER = "oracle") then
Limit maxproc 16384
Limit descriptors 65536
Umask 022
Endif
EOF 2.5> oracle user environment variables Add the following content to oracle user. bash_profile: ORACLE_BASE =/oracle; export ORACLE_BASE
ORACLE_HOME = $ ORACLE_BASE/app/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID = mydb1; export ORACLE_SID
PATH = $ PATH: $ ORACLE_HOME/bin; export PATH After that, use oracle to log on again to make the preceding variables take effect. 2.6> oracle Installation Use the graphical interface (X window) to log on as an oracle user; Currently, oracle installation is written in java, mainly to unify the installation interfaces of various systems; Decompress the installation package $ Unzip 10201_database_linux32.zip After decompression, go to the installation directory. $ Cd database Install $./RunInstaller 2.6.1> welcome
Click Next.
2.6.2> specify the List Directory and Certificate
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.
The operating system group name should be oinstall.
2.6.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.
2.6.4> specify the file location
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.
2.6.5> select the installation type
Accept the default Enterprise Edition.
2.6.6> check of prerequisites related to specific products
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.
2.6.7> select Database Configuration
Accept the default values Create a starter database and General Purpose.
Specify Database Configuration Options
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 ).
When you enter a global database name, the SID box is automatically filled.
Accept default database character sets
Select Create database with sample schemas.
2.6.9> select database management
Select Use Database Control for Database Management.
2.6.10> specify database file storage options
Select File System and enter the path name used by the database File (/u02/oradata in this example ).
2.6.11> specify backup and recovery options
Select Do not enable automatic backups.
2.6.12> password used to specify the database mode
Select Use the same password for all the accounts.
Select a password and enter it twice for confirmation.
2.6.13> Summary
Displays the summary of installed products.
Click Install.
2.6.14> Installation
This screen goes through several phases of installing and linking Oracle software.
When the installation process ends, a window is displayed, showing the configuration information. Write down the Enterprise Manager URL and click OK to close the window.
A "Setup Privileges" window is displayed, 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. Press Enter to accept the default value. When the script is complete, return to the Setup Privileges window and click OK. (As shown below .)
Installation Complete
Write down the URL displayed in the summary and click Exit when preparing.
Congratulations! Your new Oracle 10g Database has been started and can be used. 2.7> manually execute dbca During the installation process, oracle database configuration failed an (dbca) reports an error. Use the graphical interface (X window), log on with an oracle user, and execute dbca Then follow the prompts to create a database 2.7.1> welcome
Click Next.
2.7.2> operation
Select Create a Database.
2.7.3> database template
Select General Purpose.
2.7.4> Database ID
Enter the global database name.
2.7.5> Management Options
Select Configure the Database with Enterprise Manager.
Select Use Database Control for Database Management.
2.7.6> database Certificate
Select Use Same Password for All Accounts.
Enter and confirm the password.
2.7.7> storage options
Select File System
2.7.8> database file location
Select Use Oracle-Managed Files.
Make sure that you have set the Database Area as the disk group you created. It contains a leading plus sign, for example, + DATA1.
2.7.9> restore Configuration
Select Specify Flash Recovery Area.
-Quick recovery area-enter the ASM disk to be used for quick recovery.
-Fast Recovery zone size-Accept the default value of 2048.
If you want to use the archive log mode, select Enable Archiving. You can leave this option unselected for the evaluation database.
2.7.10> database content
Select Sample Schemas.
We do not use custom scripts, so click Next.
2.7.11> initialization parameters
Accept the default value and click Next.
2.7.12> database storage
Accept the default value and click Next.
2.7.13> Create Option
Select Create Database (default) and click Finish.
2.7.14> confirm
After checking the database details, click OK.
2.7.15> DBCA displays an operation list and a progress bar. Depending on the hardware, it may take several minutes to several hours to create a database.
2.7.16> when the database is created, a summary window is displayed. Write down the Enterprise Manager URL and click Exit.
