oracle 监听无法注册

1.检查/etc/hosts文件

[oracle@oracle ~]$ cat /etc/hosts                                                                                                
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4                                                   
::1         localhost localhost.localdomain localhost6 localhost6.localdomai                                                     
192.168.5.207 emcc                                                                                                               
192.168.5.240 oracle

2.检查tnsnames.ora文件

# tnsnames.ora Network Configuration File: /opt/oracle/product/18c/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.145)(PORT = 1521))
ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.145)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

3.检查local_listener参数

SQL> show parameters listener
NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
forward_listener             string
listener_networks             string
local_listener                 string     LISTENER_ORCL
remote_listener              string
修改local_listener参数
alter system set local_listene=LISTENER_ORCL scope=both;
alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.145)(PORT = 1521))';