知道你的名字 听过你的声音

Oracle的监听配置

listener.ora的内容:

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 主机名)(PORT = 1521))
  )

ADR_BASE_LISTENER = D:\app\Administrator\product\11.2.0\dbhome_1\log

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
    )
   (SID_DESC =
      (SID_NAME = DBname)
      (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
      (GLOBAL_DBNAME= DBname)
  )
)

再使用

lsnrctl stop

lsnrctl start

tnsnames.ora的内容:

ORACLENAME =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 服务主机名或IP)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = DBname)
    )
  )

发表回复

textsms
account_circle
email

此站点使用Akismet来减少垃圾评论。了解我们如何处理您的评论数据

知道你的名字 听过你的声音

Oracle的监听配置
listener.ora的内容: LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 主机名)(PORT = 1521)) ) ADR_BASE_LISTENER = D:\app\Administrator\product\11.2…
扫描二维码继续阅读
2017-11-21