一台服务器上安装多个oralce

目前已经在运行了oralce 11g 安装目录/u01
计划安装19c,安装目录u02
环境:
OS:Centos 6.9

 

1.创建新的oracle01账号
[root@localhost oracle]# useradd -g oinstall -G dba oracleb
[root@localhost oracle]# passwd oracleb
[root@localhost oracle]# usermod -a -G oper oracleb
[root@11g /]# id oracleb
uid=503(oracleb) gid=500(oinstall) groups=500(oinstall),501(dba),502(oper)

 

2.创建安装目录
安装目录要与原来安装的数据库目录区分,这里设置为u02
mkdir -p /u02/app/oracle
mkdir -p /u02/app/oracle/product/19.3.0.0/db_1
修改权限
chown -R oracleb:oinstall /u02

 

3.设置环境变量
[oracle01@localhost ~]$ more .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs

export EDITOR=vi
export ORACLE_SID=ora19c
export ORACLE_BASE=/u02/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19.3.0.0/db_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export PATH=$ORACLE_HOME/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin:/bin
umask 022

 

4.修改limits.conf
vi /etc/security/limits.conf
添加如下项:
##### oracle parameter #####
oracleb soft nofile 131072
oracleb hard nofile 131072
oracleb soft nproc 131072
oracleb hard nproc 131072
oracleb soft core unlimited
oracleb hard core unlimited
oracleb soft memlock unlimited
oracleb hard memlock unlimited

 

5.解压安装介质到ORACLE_HOME目录
19c的安装介质需要直接解压到ORACLE_HOME目录下,然后才进行安装
[root@hxl /]# su - oracleb
[oracle@hxl ~]$ cd $ORACLE_HOME
[oracle@hxl db_1]$ unzip -q /soft/db/LINUX.X64_193000_db_home.zip

 

6.安装数据库软件
使用oracle01账号通过vnc登陆服务器
[oracle@emcc91c ~]$ cd $ORACLE_HOME
[oracle@emcc91c db_1]$ ./runInstaller

 

7.创建一个不同端口的监听器并修改数据库参数

[oracleb@11g ~]$ lsnrctl status listener01

SQL> alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=11g)(PORT=1522))' scope=both;

System altered.



[oracleb@11g ~]$ lsnrctl status listener01

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 17-OCT-2022 17:15:11

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=11g)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER01
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                17-OCT-2022 17:12:10
Uptime                    0 days 0 hr. 3 min. 1 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u02/app/oracle/product/19.3.0.0/db_1/network/admin/listener.ora
Listener Log File         /u02/app/oracle/diag/tnslsnr/11g/listener01/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=11g)(PORT=1522)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))
Services Summary...
Service "ora19c" has 1 instance(s).
  Instance "ora19c", status READY, has 1 handler(s) for this service...
Service "ora19cXDB" has 1 instance(s).
  Instance "ora19c", status READY, has 1 handler(s) for this service...
The command completed successfully