Installation and configuration of coexistence of Oracle10G and Oracle11G in Linux

InLinuxCan be implemented in the systemOracle10GAndOracle11Does the database of G dual version coexist? The answer is yes. In this article, we will introduce the installation and configuration of the coexistence of Oracle10G and Oracle11G databases in Linux. Next we will introduce it.

Environment

Wmware workstaion 7

OS OracleLinux-R6 32Bit 1g memory 30g hard drive 1 + 20G hard drive 2 (for storing installation software)

DATABASE

10201_database_linux32

Linux_11gR2

The reason why I chose OEL as the operating system is mainly for compatibility considerations. After all, this is Oracle's own stuff. The compatibility of my company's products must be better than that of other companies.

PS: But what makes me very depressing is that when I start the database installation program, why the same environment variable configuration can display Chinese normally when I use Red Hat Enterprise, however, OEL is a classic block, but the operating system is 5. x or 6.x, but the database is 10. x or 11.x.

The following is a simple record and summary of the installation process.

1. First install oracle10g

1. Create a group required for oracle Installation

Run the following command as the root user:

 
 

  
  
groupadd oinstall  
  
  
 
  
  
groupadd dba  
  
  
 
  
  
groupadd oper 
 
 

2. Create an oracle user

Run the following command as the root user:

 
 

  
  
useradd oracle -g oinstall -G dba,oper  
  
  
 
  
  
passwd oracle 
 
 

3. Modify the oracle configuration file

Oracle user execution

Add the following row to. bash_profile

 
 

  
  
Export EDITOR = vi # Set sqlplus's default EDITOR to vi
  
  
 
  
  
Alias sqlplus = 'rlwrap sqlplus '# A small tool that allows sqlplus to use direction keys like in windows
  
  
 
  
  
Export NLS_LANG = "SIMPLIFIED CHINESE_CHINA.UTF8 ″
  
  
 
  
  
Export ORACLE_SID = TEST10G
  
  
 
  
  
Export ORACLE_BASE =/opt/oracle/db/10g
  
  
 
  
  
Export ORACLE_HOME = $ ORACLE_BASE/product/10.2.0/db_1
  
  
 
  
  
Export LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/local/lib:
  
  
 
  
  
Export PATH = $ ORACLE_HOME/bin:/usr/ccs/bin:/etc:/bin:/usr/openwin/bin:/usr/local/bin: /usr/X11R6/bin:
  
  
 
  
  
Umask 022
 
 

4. Modify Kernel Parameters

Run the root user and add the following line to/etc/sysctl. conf.

 
 

  
  
kernel.shmmax = 2147483648 
  
  
 
  
  
kernel.shmmni = 4096 
  
  
 
  
  
kernel.shmall = 2097152 
  
  
 
  
  
kernel.sem = 250 32000 100 128  
  
  
 
  
  
fs.file-max = 65536 
  
  
 
  
  
net.ipv4.ip_local_port_range = 1024 65000  
  
  
 
  
  
net.core.rmem_default = 1048576 
  
  
 
  
  
net.core.rmem_max = 1048576 
  
  
 
  
  
net.core.wmem_default = 262144 
  
  
 
  
  
net.core.wmem_max = 262144 
 
 

5. Modify resource limits

Run the root user and add the following line to/etc/security/limits. conf.

 
 

  
  
oracle soft nofile 65536  
  
  
 
  
  
oracle hard nofile 65536  
  
  
 
  
  
oracle soft nproc 16384  
  
  
 
  
  
oracle hard nproc 16384 
 
 

4. Create related directories

Run the following command as the root user:

 
 

  
  
mkdir /opt/oracle  
  
  
 
  
  
chown oracle:oinstall /opt/oracle 
 
 

5. Format and mount the New Hard Disk

Run the following command as the root user:

 
 

  
  
[root@gtlions ~]# fdisk -l  
  
  
 
  
  
[root@gtlions ~]# fdisk /dev/sdb 
 
 

Input n p 1 w

 
 

  
  
[root@gtlions ~]# mkfs -t ext4 -c /dev/sdb1  
  
  
 
  
  
[root@gtlions ~]# mkdir /media/newdriver  
  
  
 
  
  
[root@gtlions ~]# mount /dev/sdb1 /media/newdriver/  
  
  
 
  
  
[root@gtlions ~]# mkdir /media/newdriver/ora  
  
  
 
  
  
[root@gtlions ~]# chown oracle:oinstall /media/newdriver/ora 
 
 

6. Upload and decompress the software.

Oracle user execution: unzip-q 10201_database_linux32.zip

7. Version Spoofing

Root User execution

 
 

  
  
Cp/etc/redhat-release/etc/redhat-release.bak
  
  
 
  
  
Change vi/etc/redhat-release
  
  
 
  
  
# Red Hat Enterprise Linux Server release 6.0 (Santiago)
  
  
 
  
  
Red Hat 4
 
 

8. garbled Problem

Run the command by the oracle user before./runInstaller: export LANG = en_US.

9. errors encountered during installation

9.1. libXp package missing

Root User execution

Exception in thread "main" java. lang. unsatisfiedLinkError:/tmp/OraInstall2011-07-30_01-41-36AM/jre/1.4.2/lib/i386/libawt. so: libXp. so.6: cannot open shared object file: No such file or directory

Solution: If the libXp package is missing, find and install it on the Linux installation CD. The installation details are not described in detail.

Since I have never installed a database of 10 Gb in Linux6, I am afraid that there will be many problems at the beginning. Fortunately, everything went well. I believe there will be no problems in the next 11G version.

10. Install rlwrap

Root User execution

 
 

  
  
[root@gtlions ~]# tar zxvf rlwrap-0.37.tar.gz  
  
  
 
  
  
[root@gtlions ~]# cd rlwrap-0.37  
  
  
 
  
  
[root@gtlions rlwrap-0.37]# ./configure  
  
  
 
  
  
[root@gtlions rlwrap-0.37]# make  
  
  
 
  
  
[root@gtlions rlwrap-0.37]# make install 
 
 

11. Use the Startup Script

You need to make some changes before using the startup script, mainly to configure the ORACLE_HOME_LISTNER variable.

Vi $ ORACLE_HOME/bin/dbstart: Change ORACLE_HOME_LISTNER =/ade/vikrkuma_new/oracle in line 79 to ORACLE_HOME_LISTNER = $ ORACLE_HOME.

Otherwise, an error is returned:

 
 

  
  
[oracle@gtlions bin]$ ./dbstart  
  
  
 
  
  
Failed to auto-start Oracle Net Listene using /ade/vikrkuma_new/oracle/bin/tnslsnr 
 
 

12. Use the close script

Because the 10G version does not enable the function of disabling listening with the script configuration disabled, the script writes

# Oracle Net Listener is NOT shutdown using this script.

Therefore, we need to add a listener stop script. We can use the 11g closing script to copy the relevant part.

 
 

  
  
ORACLE_HOME_LISTNER=$ORACLE_HOME  
  
  
 
  
  
if [ ! $ORACLE_HOME_LISTNER ] ; then  
  
  
 
  
  
echo “ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net Listener”  
  
  
 
  
  
echo “Usage: $0 ORACLE_HOME”  
  
  
 
  
  
else  
  
  
 
  
  
LOG=$ORACLE_HOME_LISTNER/listener.log  
  
  
 
  
  
# Set the ORACLE_HOME for the Oracle Net Listener, it gets reset to  
  
  
 
  
  
# a different ORACLE_HOME for each entry in the oratab.  
  
  
 
  
  
export ORACLE_HOME=$ORACLE_HOME_LISTNER  
  
  
 
  
  
# Stop Oracle Net Listener  
  
  
 
  
  
if [ -f $ORACLE_HOME_LISTNER/bin/tnslsnr ] ; then  
  
  
 
  
  
echo “$0: Stoping Oracle Net Listener” >> $LOG 2>&1  
  
  
 
  
  
$ORACLE_HOME_LISTNER/bin/lsnrctl stop >> $LOG 2>&1 &  
  
  
 
  
  
else  
  
  
 
  
  
echo “Failed to auto-stop Oracle Net Listener using $ORACLE_HOME_LISTNER/bin/tnslsnr”  
  
  
 
  
  
fi  
  
  
 
  
  
fi 
 
 

13. Configure/etc/oratab

Add or modify the following content. Note that the last Y file will be written to this file by default when the installation is complete, but the last one is N/etc/oratab TEST10G: /opt/oracle/db/10g/product/10.2.0/db_1: Y

Ii. Install oracle11g

1. Modify the oracle configuration file

Note: First back up this file, because this file is a configuration file for the 10G version, only the corresponding configuration files of the two versions are saved at the same time, in the future, you can easily switch between them.

After the backup, modify the previous configuration as follows:

 
 

  
  
export NLS_LANG=”SIMPLIFIED CHINESE_CHINA.UTF8″  
  
  
 
  
  
export ORACLE_SID=TEST11G 
  
  
 
  
  
export ORACLE_BASE=/opt/oracle/db/11g/base  
  
  
 
  
  
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1  
  
  
 
  
  
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib:  
  
  
 
  
  
export PATH=$ORACLE_HOME/bin:/usr/bin:/usr/ccs/bin:/etc:/bin:/usr/openwin/bin:/usr/local/bin:/usr/X11R6/bin:  
  
  
 
  
  
umask 022 
 
 

2. The version is restored to its original state.

Change vi/etc/redhat-release to Red Hat Enterprise Linux Server release 6.0 (Santiago)

3. garbled Problem

Export LANG = en_US before executing./runInstaller

Iii. Configuration and use

Finally, how to use and use the two versions of the database separately.

Of course, it is implemented by using different configuration files. The focus is to switch to the corresponding environment variable every time you use different versions of the database.

There are multiple methods, such:

1. Set relevant variables one by one;

2. Back up two versions of the environment variable parameter file. bash_profile, and manually switch after login;

3. Here I use the SecureCRT ssh tool to configure two sessions for oracle and set different scripts to be executed after logon, in this case, we need to set the environment variables for us.

Iv. Final

Specifically, I checked the space occupied by the installation directories of the next two versions. The size of the data files is similar, 10 Gb occupies 1.1 GB, and 11 GB occupies 1.4 GB, however, the installation of software is greatly different. The 11g is almost three times the 10g, the former is 3.7g, and the latter is only 1.3g. Big guy, 11 GB.

The installation and configuration process for the coexistence of Oracle10G and Oracle11G databases on Linux systems is described here, and we hope to bring you some benefits.