Linux中oracle多库监听配置

最新推荐文章于 2025-07-24 06:19:22 发布

iteye_18227

最新推荐文章于 2025-07-24 06:19:22 发布

阅读量194

点赞数

分类专栏： oracle 文章标签： oracle

oracle 专栏收录该内容

1 篇文章

订阅专栏

本文介绍如何在Linux环境下配置Oracle11g的listener.ora及tnsnames.ora文件，并展示了数据库启动、监听开启及远程登录的方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

os：Linux bogon 3.10.0-229.el7.i686 #1 SMP Sun May 17 14:06:40 UTC 2015 i686 i686 i386 GNU/Linux

数据库：oracle11g

listener.ora配置文件：


SID_LIST_LISTENER=
   (SID_LIST=
       (SID_DESC=
          (GLOBAL_DBNAME=yy)
          (SID_NAME=yy)
          (ORACLE_HOME=/oracle/product/11.2.0)
          (PRESPAWN_MAX=20)
          (PRESPAWN_LIST=
              (PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))
          )
        )
          (SID_DESC=
          (GLOBAL_DBNAME=orcl)
          (SID_NAME=orcl)
          (ORACLE_HOME=/oracle/product/11.2.0)
          (PRESPAWN_MAX=20)
          (PRESPAWN_LIST=
              (PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))
          )
        )
    )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.88.129)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

tnsnames.ora配置文件：


ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.88.129)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

YY =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.88.129)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = yy)
    )
  )

两个文件位置：/oracle/product/11.2.0/network/admin(我默认将oracle装到了/目录)

开启数据库：
$>sqlplus / as sysdba #以管理员身份登录
SQL>startup #启动
$>lsnrctl start #开启监听

启动非默认库
export ORACLE_SID=其他库名
启动/重启

远程登录命令：conn scott/oracle@192.168.88.129/orcl

配置数据库：dbca命令打开窗口

配置监听：netca命令打开窗口