外部机器无法连接到oracle数据库

1 IP配置

 

vi ./sysconfig/network-scripts/ifcfg-eth0

 

DEVICE="eth0"

BOOTPROTO=none

NM_CONTROLLED="yes"

ONBOOT=yes

TYPE="Ethernet"

UUID="db0c10e4-c821-4a0e-85eb-da98f7d288d7"

IPADDR=172.20.32.191

NETMASK=255.255.248.0

GATEWAY=172.20.39.251

#PREFIX=24

#DEFROUTE=yes

#IPV4_FAILURE_FATAL=yes

IPV6INIT=no

NAME="System eth0"

HWADDR=8C:89:A5:21:E8:AB

DNS1=172.20.0.11

DNS2=172.20.0.12

 

 

 

如果是自动获取IP

BOOTPROTO=dhcp

 

 

保存后，执行

ifconfig eth0 down

ifconfig eth0 up

 

2 修改/etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

# Single Client Access Name (SCAN IP)

 

#add

172.20.32.191   bogon

 

2.你修改一下/u01/app/oracle/11.2.0/db_1/network/admin/listener.ora中的：

 Host=主机名

 

 

修改前是127.0.0.1，修改为主机名

 

# listener.ora Network Configuration File: /u01/app/oracle/11.2.0/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

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

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

    )

  )