oralce无法远程连接

oralce 默认是无法进行远程连接的需要修改两个配置
我的配置文件目录是：/opt/oracle/product/19c/dbhome_1/network/admin

[oracle@localhostcd] /opt/oracle/product/19c/dbhome_1/network/admin
[oracle@localhost admin] ls
listener.ora  samples  shrept.lst  sqlnet.ora  tnsnames.ora

执行 vim listener.ora

# listener.ora Network Configuration File: /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
#      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.159.145)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )
SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =    (GLOBAL_DBNAME = globe)  (SID_NAME = globe)  ))

执行vim tnsnames.ora

# tnsnames.ora Network Configuration File: /opt/oracle/product/19c/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCLCDB =
  (DESCRIPTION =
 #   (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.159.145)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCLCDB)
    )
  )

LISTENER_ORCLCDB =
#  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.159.145)(PORT = 1521))

即可开启远程登录。