Skip to content

Instantly share code, notes, and snippets.

@ThaddeusJiang

ThaddeusJiang/oracle_remote.md

Last active February 6, 2018 09:10
Show Gist options
  • Save ThaddeusJiang/ce0cc6d00216e35cffebafaa908a8da8 to your computer and use it in GitHub Desktop.
Save ThaddeusJiang/ce0cc6d00216e35cffebafaa908a8da8 to your computer and use it in GitHub Desktop.
Download ZIP
oracle 允许远程连接
Raw
oracle_remote.md

oracle 允许远程连接

如果希望自己的PC可以连接远程oralce的话，需要修改远程oracle的listener.ora的HOST部分。

默认情况下(HOST = localhost)，只允许本地连接。 修改为localhost 修改本地ip地址或者url，就可以远程连接了。

操作

0.切换用户

su - oracle

1.listener stop lsnrctl stop

2.listener.ora update $ vim /opt/oracle/product/12.1.0/network/admin/listener.ora

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = ip or url)(PORT = 1521))
      )
    )
  )

3.listener start lsnrctl start

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment