oracle监听器相关配置

来源：互联网发布：华中数控仿真软件编辑：程序博客网时间：2024/05/16 00:28

检查listener.ora和tnsnames.ora配置：示例如下：listener.oraSID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = F:\oracle\product\10.2.0\db_1) (PROGRAM = extproc) ) (SID_DESC = (ORACLE_HOME = F:\oracle\product\10.2.0\db_1) (SID_NAME = orcl(修改为实例名)) ) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1(修改为主机IP地址或主机名))(PORT = 1521)) ) )tnsnames.oramyORCL= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1(修改为主机IP地址或主机名))(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl（修改为实例名）) ) )配置好后tnsping myORCL 看通不通。登陆格式为 sqlplus username/password@myORCL myORCL为tnsnames.ora中配置的名称，名称可以随便取，不一定要与实例名一样，不是实例名,注意区别。开启监听服务：lsnrctl start