您的位置:首页 > 博客中心 > 数据库 >

Oracle 11g 配置方面的问题

时间:2022-03-14 01:51

# listener.ora Network Configuration File: d:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

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

ADR_BASE_LISTENER = d:\app\Administrator

 

监听配置中,要注意 Host=计算机名字 ,如果写成127.0.0.1,会导致远程的电脑无法连接,

因为1521端口跑到 127.0.0.1上了,远程的端口无法开启

 

注意:

D:\app\Administrator\product\11.2.0\dbhome_1\database\oradim.log 这个文件中保存有服务开启时的日志

报如下错误:
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name ‘LISTENER_ORCL‘

问题处理过程:
1、修改tnsnames.ora文件,添加下面的语句:
# tnsnames.ora Network Configuration File: d:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORA11 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME =ORA11)
    )
  )

LISTENER_ORA11 =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))

热门排行

今日推荐

热门手游