Detailed tutorials for configuring Oracle databases on CentOS systems _oracle

I. BASIC configuration

1. Hard disk remaining space: above 10G
Although the Oracle 10g installation files are only more than 800 MB, the installed Oracle+orainventory directory will use almost 4G space, plus the temporary files generated by Oracle at installation (/tmp directory requires at least 400MB).
2. More than 1.5G of memory
The official documentation says 512M memory can also be installed. In order to avoid unnecessary trouble, please add more memory.
3.Swap Swap Area 2G

Two. Install Oracle 10g on CENOS6

1. Ready to install
execute the following command before installing Oracle:

Yum install yum-fastestmirror-y
yum install compat-db* yum install compat-libc* yum install compat-gcc*
Yum install libxp.so.6
yum install libc-* yum install libaio* yum
install
openmotif Yum Install glibc-devel*
yum Install libgcc*
yum Install 

2. Installation package Decompression

[Root@localhost ~]# CPIO-IDMV > 10201_database_linux_x86_64.cpio

3. Create Oracle groups and user accounts
Create an account for installing and maintaining Oracle 10g software. The user account will be called Oracle, and the group will be called Oracleinstall and Oracle. Execute 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 Oracle
uid=501 (Oracle) gid=501 (Oracleinstall) groups=501 (Oracleinstall), 502 (Oracle)

Set the password for an Oracle account

[Root@localhost ~]# passwd Oracle
changing password for user Oracle.
New Password:
Retype new Password:passwd:all authentication tokens updated.

4. Create a table of contents
Create a directory of Oracle 10g and its database files and execute the following commands as root:

[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
installation of Oracle 10g requires modification of kernel parameters, otherwise the installation of detection will be reported failed, and even caused the installation error. Execute the following command as root:

Cat >>/etc/sysctl.conf <<eof
kernel.shmall = 2097152
Kernel.shmmax = 2147483648
Kernel.shmmni = 4096
Kernel.sem = 32000 128 Fs.file-max
= 65536 net.ipv4.ip_local_port_range
= 102 4 65000
net.core.rmem_default = 262144
Net.core.rmem_max = 262144 Net.core.wmem_default
=
262144 Net.core.wmem_max = 262144
EOF

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

6. Install Oracle 10g
(1) first landing Xwindow as an Oracle user. Because the Oracle installation will eject the interface to let you configure, if you use Putty login installation, you are no way to operate the pop-up box, so be sure to log in Xwindow, and then in terminal to start the installation program.

(2) If your system language is Chinese, please set him to English, otherwise the installation will appear garbled.

(3) Start Oracle 10g installer in Terminal:

[oracle@www/]$./oracle/database/runinstaller

If everything works, the interface pops up the following dialog box:

If you encounter the Checking operating system version:must be redhat-2.1, redhat-3, SuSE-9, SuSE-8 or Unitedlin when terminal starts Runinstaller ux-1.0 Failed "This problem indicates that Oracle does not recognize your system kernel, a problem that can be resolved by modifying the kernel configuration file as follows:

Cat >/etc/redhat-release << EOF
Red Hat Enterprise Linux as Release 3 (Taroon)
EOF 

7.Oracle 10g Installation Configuration
Modify Oralce Home localtion, fill in the database password, and press "Next". As shown in figure:

8. Database Configuration
Modify Inventory directory,specify operating System group name: Oracleinstall, then "Next", as shown in figure:

9.Oracle Pre-installation check
Check to see what does not meet the installation requirements, look for the need to modify the configuration, if follow the above steps down, the warning here should be 0, then "Next". If there is a warning can search what is the problem.
10.Install Oracle 10g
Press "Install" directly. After the software installation is complete, the Configuration Assistant configuration is automatically performed.
11. Run Scripts with root privileges
when the Isql*plus Configuration Assistant configuration is complete, the box pops up and there are two srcipt in it that require you to run with root privileges.
The above two scripts are executed in Terminel with root permissions:

[Root@www oradata]#./orainstroot.sh
Changing permissions of/oracledata/oradata to 770.
Changing groupname of/oracledata/oradata to Oracleinstall.
The execution of the script is complete
[root@www oracle]#./root.sh Running Oracle10 root.sh
script ...

The following environment variables are set as:
 oracle_owner= ORACLE
 oracle_home=/oracledata/oracle

Enter The full pathname to 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'll be added to The/etc/oratab file as needed by
database Configuration Assistant When a the database is create D
finished running generic part of root.sh script.
Now product-specific root actions would be performed.

Then press "OK" in the interface.
This Oracle 10g installation is complete. Press "Exit" to exit the installation.

Third, some common mistakes
1. [INS-06101] IP address of localhost could is determined
The figure is as follows:

WORKAROUND: Because your host name and IP address are not the same, the/etc/hosts file corresponds to the line

    Vim/etc/hosts
     IP Address host name

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

Workaround: 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:

Workaround: Look at the number of systems Oracle has, typically 32-bit systems with 32-bit Oracle software, and 64-bit systems that can hold 32-bit and 64-bit Oracle. Open the download Oracle package, which has a Web page that opens the page to see.
4. View the Listener (LSNRCTL) or the command (sqlplus) prompt:

 -bash:lsnrctl:command not found

The figure is as follows:

WORKAROUND: Look for Oracle's command installation directory, and Mine is (/home/oracle/app/oracle/product/11.2.0/dbhome_1/bin) added to the environment variable.

--is a file for the Oracle user root directory, modify this line

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

--The configuration file takes effect