win2008安装oracle11g

最新推荐文章于 2024-10-19 15:43:33 发布

漫无目的行走的月亮

最新推荐文章于 2024-10-19 15:43:33 发布

阅读量1.6k

点赞数

本文链接：https://blog.csdn.net/catontower/article/details/46804589

版权

C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN

listener.ora：

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

SID_LIST_LISTENER =
(SID_LIST =
    (SID_DESC =
      (SID_NAME = gfdb)
      (ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)
      (PROGRAM = gfdb)
      (ENVS = "GFDB_DLLS=ONLY:C:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
)

LISTENER =
(DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = gfdb))
      (ADDRESS = (PROTOCOL = TCP)(HOST = dbserver)(PORT = 1521))
    )
)

ADR_BASE_LISTENER = C:\app\Administrator

tnsnames.ora：

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

LISTENER_GFDB =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbserver)(PORT = 1521))

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
)

GFDB =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = gfdb)
    )
)