oracle安装成功后配置远程连接

Oracle安装成功后，本地通过PLSQL一般可以直接访问，但是要做到其它客户端plsql远程连接访问Oracle服务端，需要做些配置。
1、注意事项
--oracle服务端ip一定要明确；
--客户端tnsnames.ora和服务端tnsnames.ora里面(SERVER = DEDICATED或SHARED)配置保持一致；
--服务端可以配置成专有模式DEDICATED和共享模式SHARED，根据需要配置；
--服务端至少启动2个服务：OracleOraDB12Home1TNSListener和OracleServiceORCL；
2、Oracle服务端配置--DEDICATED
E:\oracle12c\home\product\12.1.0\dbhome_1\NETWORK\ADMIN目录下的3个文件：
listener.ora、tnsnames.ora、sqlnet.ora
2.1 listener.ora

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = orcl)
      (ORACLE_HOME = E:\oracle12c\home\product\12.1.0\dbhome_1)
      (ENVS = "EXTPROC_DLLS=ONLY:E:\oracle12c\home\product\12.1.0\dbhome_1\bin\oraclr12.dll")
    )
  )

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

ADR_BASE_LISTENER = E:\oracle12c\home

2.2 tnsnames.ora文件

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.10)(PORT = 1521))

ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = orcl)
      (PRESENTATION = RO)
    )
  )
#
ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.10)(PORT = 1521))
    )
    (CONNECT_DATA =
	  (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

3、客户端instantclient安装目录下--DEDICATED
对于F:\...\oracleInstantClient32\instantclient_11_2\network\admin路径下的1个文件：tnsnames.ora
文件

ORCL_1_10 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.10)(PORT = 1521))
    )
    (CONNECT_DATA =
	  (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )