Detailed tutorial on installing and configuring Oracle databases on CentOS, centosoracle

Detailed tutorial on installing and configuring Oracle databases on CentOS, centosoracle

I. basic configuration

1. Remaining hard disk space: 10 Gb or above
Although the 10 Gb Installation File of Oracle is only over 800 MB, the installed oracle + oraInventory directory will use approximately 4 GB space, add the temporary file generated by Oracle during installation (the/tmp directory must be at least 400 MB ).
2. Memory above GB
The official documentation says the M memory can also be installed. To avoid unnecessary troubles, add more memory.
3. Swap Zone 2G

Ii. Install Oracle 10g on CenOS6

1. Prepare for Installation
Run the following command before installing Oracle:

yum install yum-fastestmirror -yyum install compat-db*yum install compat-libc*yum install compat-gcc*yum install libXp.so.6yum install libc-*yum install libaio*yum install openmotifyum install glibc-devel*yum install libgcc*yum install gnome-lib* 

2. Unzip the installation package

[root@localhost ~]# cpio -idmv > 10201_database_linux_x86_64.cpio

3. Create an Oracle group and User Account
Create an account for installing and maintaining the Oracle 10g software. User accounts are called oracle, while groups are referred to as oracleinstall and oracle. Run the following command as the root user:

[root@localhost ~]# groupadd oracleinstall[root@localhost ~]# groupadd oracle[root@localhost ~]# useradd -m -g oracleinstall-G oracle oracle[root@localhost ~]# id oracleuid=501(oracle) gid=501(oracleinstall) groups=501(oracleinstall),502(oracle)

Set the password for the oracle account

[root@localhost ~]# passwd oracleChanging password for user oracle.New password:Retype new password:passwd:all authentication tokens updated successfully.

4. Create a directory
Create the directory of Oracle 10 GB and its database files, and run the following command as the root user:

[root@localhost ~]# mkdir -p /oracledata/oracle[root@localhost ~]# mkdir -p /oracledata/oradata[root@localhost ~]# chown -R oracle:oracleinstall /oracledata/oracle /oracledata/oradata[root@localhost ~]# chmod -R 775 /oracledata/oracle /oracledata/oradata 

5. Modify Kernel Parameters
To install Oracle for 10 Gb, You need to modify the kernel parameters. Otherwise, a Failed is reported during installation detection, which may even cause an Error during installation. Run the following command as root:

cat >> /etc/sysctl.conf <<EOFkernel.shmall = 2097152kernel.shmmax = 2147483648kernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 65536net.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default = 262144net.core.rmem_max = 262144net.core.wmem_default = 262144net.core.wmem_max = 262144EOF

If there is no problem with the check, you can start to install Oralce 10g.

6. Install Oracle 10g
(1) log on to XWindow as an oracle user. The installation of oracle will pop up the interface for you to configure, if you use putty to log on to the installation, you can not operate the pop-up box, so be sure to log on to XWindow, and then start the installation program in Terminal.

(2) If your system language is Chinese, set it to English. Otherwise, garbled characters will appear during installation.

(3) Start the Oracle 10g installer in Terminal:

[oracle@www/]$ ./Oracle/database/runInstaller

 

If everything works properly, the following dialog box is displayed:
 
If you encounter a "Checking operating system version: must be redhat-2.1, redhat-3, SuSE-9, SuSE-8 or UnitedLinux-1.0 Failed" issue when you start runInstaller at Terminal, it indicates that oracle cannot identify your system kernel, you can solve this problem by modifying the Kernel configuration file as follows:

cat > /etc/redhat-release << EOFRed Hat Enterprise Linux AS release 3 (Taroon)EOF 

7. Oracle 10 Gb installation Configuration
Modify Oralce Home Localtion, enter the database password, and press "Next ".

8. Database Configuration
Modify Inventory directory, Specify Operating System group name: oracleinstall, and then "Next ",

9. Check Before Oracle Installation
Check whether the installation requirements are met and whether the configuration needs to be modified. If you follow the steps above, the warning here should be 0 and then "Next ". If there is a warning, you can find out what the problem is.
10. Install Oracle 10g
Directly press "Install ". After the software is installed, Configuration Assistant is automatically configured.
11. Run the script with root permission
When iSQL * Plus Configuration Assistant is configured, a dialog box is displayed, which contains two srcips that require you to run with the root permission.
Run the above two scripts with the root permission in Terminel:

[root@www oradata]# ./orainstRoot.shChanging permissions of /oracledata/oradata to 770.Changing groupname of /oracledata/oradata to oracleinstall.The execution of the script is complete[root@www oracle]# ./root.shRunning Oracle10 root.sh script...The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /oracledata/oracleEnter the full pathname of the local bin directory: [/usr/local/bin]:  Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ...Creating /etc/oratab file...Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed.

Then, press "OK" in the interface ".
So far, Oracle 10 Gb installation is complete. Press "Exit" to Exit the installation.

Iii. Common Errors
1. [INS-06101] IP address of localhost cocould not be determined
The figure is as follows:

Solution: Because your host name and IP address are different, you can match the host name in the/etc/hosts file.

Vim/etc/hosts IP address Host Name

2. at Oracle. install. ivwdb. dirver. DBinstaller. main (DBinstaller. java: 132)
The figure is as follows:

Solution: Execute xhost + on the root user terminal.
3. Error in invoking target 'client _ sharedlib 'of makefile'/oracle/u01/app/oracle/product/10.2.0/db_1/network/lib/ins_net_client.mk'
The figure is as follows:

Solution: Check the number of oracle Systems. Generally, 32-bit systems are installed with 32-bit oracle software, and 64-bit systems can be installed with 32-bit and 64-bit oracle. Open and download the oracle software package. There is a web page in it.
4. Check the listening (lsnrctl) or command (sqlplus) Prompt:

 -bash: lsnrctl: command not found

The figure is as follows:

Solution: Find the installation directory of oracle commands. Add (/home/oracle/app/oracle/product/11.2.0/dbhome_1/bin) to the environment variable.

vim ~/.bash_profile 

-- It is an oracle root directory file. modify this line.

    export PATH=$PATH:/home/oracle/app/oracle/product/11.2.0/dbhome_1/bin

source ~/.bash_profile 

-- The configuration file takes effect

Articles you may be interested in:

• How to solve Oracle garbled characters during Linux Installation
• Tutorial on installing and starting or disabling Oracle databases in Linux
• Installation of Oracle databases on Mac and solutions to some problems
• Introduction to some basic login operations after Oracle 11g Release 2 is installed
• How to solve Oracle 11g Installation Problems in Windows 7
• Install Oracle extension in PHP in CentOS
• Install the oracle client in Linux and configure php5.3
• How to solve the ins_ctx.mk problem when installing Oracle10g
• Installing Oracle 10g graphic tutorial in redhat 4
• Install apache in CentOS for Linux + php + Apache + oracle