如下：只需将找到文件listener.ora修改ORACLE_HOME路径即可
# listener.ora Network Configuration File: E:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (PROGRAM = extproc)
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = E:\oracle\product\10.1.0\Db_1)
    )
  )

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

配置监听文件：C:\app\oracle\product\12.1.0\dbhome_1\NETWORK\ADMIN

需要修改的文件：listener和tnsnames
多台服务器一个端口号

listenner中：
listener.ora Network Configuration File: C:\app\oracle\product\12.1.0\dbhome_1\network\admin\listener.ora
Generated by Oracle configuration tools.
SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = CLRExtProc)

(ORACLE_HOME = C:\app\oracle\product\12.1.0\dbhome_1)

(PROGRAM = extproc)

(ENVS = “EXTPROC_DLLS=ONLY:C:\app\oracle\product\12.1.0\dbhome_1\bin\oraclr12.dll”)

)

(SID_DESC =

(GLOBAL_DBNAME = ORCL)

(ORACLE_HOME =  C:\app\oracle\product\12.1.0\dbhome_1)

(SID_NAME = ORCL)
)
  (SID_DESC =
  (GLOBAL_DBNAME = TESTDB)
  (ORACLE_HOME =  C:\app\oracle\product\12.1.0\dbhome_1)  
  (SID_NAME = TESTDB)

)

)
LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.134.132)(PORT = 1521))

)

)
tnsnames中：
tnsnames.ora Network Configuration File: \app\oracle\product\12.1.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
Generated by Oracle configuration tools.
LISTENER_ORCL =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
LISTENER_TESTDB =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORACLR_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

(CONNECT_DATA =

(SID = CLRExtProc)

(PRESENTATION = RO)

)

)

ORCL =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.134.132)(PORT = 1521))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = ORCL)

)

)
TESTDB =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.134.132)(PORT = 1521))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = TESTDB)

)

)
GLOBAL_DBNAME一定要等于SERVICE_NAME

HOST:本机IP地址

SERVICE_NAMEM:数据库服务名称

PORT:端口号

PROTOCOL：IP协议

ORACLE_HOME：orcle的安装路径C:\app\oracle\product\12.1.0\dbhome_1

GLOBAL_DBNAME：数据库名称

1、Oracle数据库在安装的过程中需要给数据库配置监听
配置监听通过netca来创建
1、配置监听用于(对应的文件为 listener.ora)

首先选择

listener configure

add

listener name  默认即可

TCP            协议默认即可

1521            使用端口，第一次创建默认的就是1521，后续添加监听需要用其他端口号。

no							不用测试
2、配置本地服务名（对应的文件为tnsnames.ora）

netca
local net server name config
add

service name       这个参数可以通过登录数据库用show parameter name 来查看服务名。

tcp								默认tcp即可

hostname           数据库所在的主机名或ip

no test

net service name   网络服务名自己随便填(第一次默认即可)

next

finish             即可。
此时plsql就可连接到数据库。

# listener.ora Network Configuration File: /usr/local/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.



LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.7)(PORT = 1521))

    )

  )



SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = orcl)

      (ORACLE_HOME = /usr/local/oracle/product/11.2.0/dbhome_1)

      (PROGRAM = extproc)

    )

    (SID_DESC =

      (GLOBAL_DBNAME = orcl)

      (ORACLE_HOME = /usr/local/oracle/product/11.2.0/dbhome_1)

      (SID_NAME = orcl)

    )

  )

ADR_BASE_LISTENER = /usr/local/oracle