服务端配置如下：
[oracle@p3 admin]$ cat listener.ora # listener.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora# Generated by Oracle configuration tools.
#LISTENER =# (DESCRIPTION =# (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.81)(PORT = 1521))# )
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = partdb) (ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0/dbhome_1) (SID_NAME = partdb) ) (SID_DESC = (GLOBAL_DBNAME = nonpartdb) (ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0/dbhome_1) (SID_NAME = nonpartdb) ) )
LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.81)(PORT = 1521)) )
ADR_BASE_LISTENER = /home/oracle/app/oracle
[oracle@p3 admin]$ cat tnsnames.ora # tnsnames.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools.
LISTENER_NONPARTDB = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
PARTDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = partdb) ) )
NONPARTDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = nonpartdb) ) )
LISTENER_PARTDB = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))客户端tnsnames.ora 配置如下
NONPARTDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.81)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = nonpartdb) ) )
转载于:https://www.cnblogs.com/iyoume2008/p/5890152.html
相关资源：JAVA上百实例源码以及开源项目