前言

因为mac m系列芯片的底层arm架构未对oracle做适配，所以需要在虚拟机中安装其他系统，如linux或windows，再安装oracle，然后连接虚拟机中的oracle完成开发环境搭建。

正常安装好对应软件后，需做以下配置修改：

以下配置均位于 oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN

1. listener.ora --修改监听器配置

your windows ip 是windows的ip地址，替换原来默认的localhost

···
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = your windows ip)(PORT = 1521))
    )
  )
···

2. tnsnames.ora 修改服务配置, 同上，替换ip地址

···
LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = your windows ip)(PORT = 1521))

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = your windows ip)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

3. sqlnet.ora 修改网络 将SQLNET.AUTHENTICATION_SERVICES 的值NTC改为NONE

···
SQLNET.AUTHENTICATION_SERVICES= (NONE)
···

4. 使用Navicate/DBeaver连接数据库

注意服务名称是否正确，可以在oracle的sqlplus中使用

selece * from global_name 查询数据库名字