sky892012
奋斗ing的小白
采纳率0%
2020-03-10 10:01

linux6.9下配置oracle监听,windows下无法远程连接,请大神赐教

5

1.在linux6.9上安装了oracle 11g,linux下可以登录没问题。但是在其他电脑上无法连接,报连接超时。我linux的名称为mylinux,oracle sid为orcl。
2.listener.ora

   (SID_LIST=
    (SID_DESC=
            #BEQUEATH CONFIG
          (GLOBAL_DBNAME=mylinux)
          (SID_NAME=orcl)           
          (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
            #PRESPAWN CONFIG
         (PRESPAWN_MAX=20)
      (PRESPAWN_LIST=
           (PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))
         )
        )
       )

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


ADR_BASE_LISTENER = /u01/app/oracle

3.tnsnames.ora

ORCLE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = mylinux)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = mylinux)
    )
  )

4.windows客户端instantclient里的tnsnames.ora

  mylinux =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.11.137)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = mylinux)
    )
  )

请大神帮忙解答下吧,小白不胜感激

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

2条回答

  • songyundong1993 脑子进水养啥鱼 1年前

    4.windows客户端instantclient里的tnsnames.ora里的SERVICE_NAME改成orcl, HOST = 172.16.11.137,这个ip地址确认是 2.listener.ora (HOST = ip)这个ip,也就是数linux据库服务器的ip地址。

    点赞 评论 复制链接分享
  • caozhy 回答这么多问题就耍赖把我的积分一笔勾销了 1年前

    网络通没通
    防火墙关没关
    端口开没开
    服务运行没运行

    点赞 评论 复制链接分享

为你推荐