报错:TNS-12545: Connect failed because target host or object does not exist
查看主机名:
#hostname
oracledb
步骤1:运行后立即生效(新会话生效),但是在系统重启后会丢失所做的修改
sysctl kernel.hostname=oracledb
步骤2:配置文件 ,添加hostname,重启后永久生效
vi /etc/sysconfig/network
NETWORKING=yes
HOSTNAME=oracledb
步骤3:修改了主机名,还需要修改host和监听listener.ora
vi /etc/hosts
#127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
#::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
127.0.0.1 localhost mwd
192.168.1.1 oracledb
修改listener.ora文件
#find / -name listener.ora
/data/app/oracle/product/11.2.0/network/admin/listener.ora
/data/app/oracle/product/11.2.0/network/admin/samples/listener.ora
vi /data/app/oracle/product/11.2.0/network/admin/listener.ora
listener.ora Network Configuration File: /data/app/oracle/product/11.2.0/network/admin/listener.ora
Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = oracledb
)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /data/app/oracle
重启机器
reboot