【linux环境】Oracle11g以及Oracle19c基于centos7安装与优化

四、优化配置

---

1、部署目录

#部署目录，此处部署目录根据实际情况调整

/home/oracle/app/product/11.2.0/dbhome_1/bin/

#进入bin目录

cd /home/oracle/app/product/11.2.0/dbhome_1/bin/

#直接查看bin目录下的文件

ls /home/oracle/app/product/11.2.0/dbhome_1/bin/

2、设置主机名，重启服务器生效

#set hostname

vim /etc/hostname

3、设置监听服务

#set listener tnsnames

vim /home/oracle/app/product/11.2.0/dbhome_1/network/admin/listener.ora

vim /home/oracle/app/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

3.1、listener.ora 配置文件新增内容

listener.ora Network Configuration File: /home/oracle/app/product/11.2.0/dbhome_1/network/admin/listener.ora

Generated by Oracle configuration tools.

#listener.ora 配置文件新增内容，新增内容视具体情况修改

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = orcl)

(ORACLE_HOME = /home/oracle/app/product/11.2.0/dbhome_1/)

#(PROGRAM = extproc) //去掉PROGRAM = extproc，外部通道调用动态dll

(ENVS = “EXTPROC_DLLS=ONLY:/home/oracle/app/product/11.2.0/dbhome_1/bin/oraclr11.dll”)

)

)

#原始配置，HOST一般是主机名或者localhost或者127.0.0.1，个人推荐设置固定IP

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.245.147)(PORT = 1521))

)

)

ADR_BASE_LISTENER = /home/oracle/app

3.2、tnsnames.ora新增内容

tnsnames.ora Network Configuration File: /home/oracle/app/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

Generated by Oracle configuration tools.

#tnsnames.ora新增内容

ORACLR_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

(CONNECT_DATA =

(SID = CLRExtProc)

(PRESENTATION = RO)

)

)

#原始配置

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.245.147)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

4、切换用户

#切换到oracle用户

su oracle

5、配置oracle环境变量

#进入当前用户的home（家目录）

cd ~

5.1、设置oracle环境变量

#oracle home，设置oracle环境变量

vim .bash_profile

5.2、加入配置（仅供参考）

ORACLE_BASE=/home/oracle/app;

ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1;

PATH=$ORACLE$