Oracle 配置远程访问教程

# listener.ora Network Configuration File: C:appAdministratorproduct11.2.0dbhome_1networkadminlistener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
 (SID_LIST =
 (SID_DESC =
  (SID_NAME = CLRExtProc)
  (ORACLE_HOME = C:appAdministratorproduct11.2.0dbhome_1)
  (PROGRAM = extproc)
  (ENVS = "EXTPROC_DLLS=ONLY:C:appAdministratorproduct11.2.0dbhome_1binoraclr11.dll")
 )
 )
LISTENER =
 (DESCRIPTION_LIST =
 (DESCRIPTION =
  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
 )
 )
ADR_BASE_LISTENER = C:appAdministrator

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

# tnsnames.ora Network Configuration File: C:appAdministratorproduct11.2.0dbhome_1networkadmintnsnames.ora
# Generated by Oracle configuration tools.
ORCL=
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
 (CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = orcl)
 )
 )
ORACLR_CONNECTION_DATA =
 (DESCRIPTION =
 (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
 )
 (CONNECT_DATA =
  (SID = CLRExtProc)
  (PRESENTATION = RO)
 )
 )
LISTENER_ORCL =
 (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORCL =
 (DESCRIPTION =
 (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 172.24.226.2)(PORT = 1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = 172.24.226.3)(PORT = 1521))
 )
 (SOURCE_ROUTE = yes)
 (CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = orcl)
 )
 )

OracleOraDb11g_homeTNSListener
OracleService*

install.bat all D:ProgramODAC12040x64 OracleHome true

DBORCL =
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))
 (CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = )
 )
 )