4、安装监听
./netca
#临时解决乱码问题,以英文模式安装
LANG=en_US.UTF-8 ./netca
5、安装数据库实例
./dbca
#解决乱码问题,以英文模式安装
LANG=en_US.UTF-8 ./dbca
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