oracle10g-经常出现TNS-12505和TNS-12514错误 TNS-12505oracleTNS-12504 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 LZ需要把tnsname.ora, listener.ora的内容拿出来看看。应该是配置的问题。 listener.ora:# listener.ora Network Configuration File: E:\app\oracle11gr2\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration tools.ADR_BASE_LISTENER_XXXX = E:\app\oracle11gr2SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = E:\app\oracle11gr2\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:E:\app\oracle11gr2\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) (SID_DESC = (GLOBAL_DBNAME = orcl) (ORACLE_HOME = E:\app\oracle11gr2\product\11.2.0\dbhome_1) (SID_NAME = orcl) ) )LISTENER_XXXX2 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521)) ) )ADR_BASE_LISTENER_XXXX2 = E:\app\oracle11gr2LISTENER_XXXX = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521)) ) )SID_LIST_LISTENER_XXXX = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = E:\app\oracle11gr2\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:E:\app\oracle11gr2\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) ) # tnsnames.ora Network Configuration File: E:\app\oracle11gr2\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora# Generated by Oracle configuration tools.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 = HOSTNAME)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SID =orcl) ) ) Linux 下 SQLPLUS 中 上下箭头历史命令问题 . Oracle连接问题 设置列宽问题 请教:数据集显示方式重新排列 动态PL/SQL这样写可以吗????大侠指点 教你oracle数据库导入到SQL中实用的方法 Oracle10g isqlplus SYS登录问题 Oracle中哪个视图存放存储过程的输入参数、输出数值 刚刚接触oracle9i,一个简单的问题,有关存储过程。 PRO*C 动态sql UPDATE语句报1403错误 shell脚本报错,求大神帮忙解决 oracle report 10g web界面乱码;
# listener.ora Network Configuration File: E:\app\oracle11gr2\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.ADR_BASE_LISTENER_XXXX = E:\app\oracle11gr2SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = E:\app\oracle11gr2\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:E:\app\oracle11gr2\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = E:\app\oracle11gr2\product\11.2.0\dbhome_1)
(SID_NAME = orcl)
)
)LISTENER_XXXX2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521))
)
)ADR_BASE_LISTENER_XXXX2 = E:\app\oracle11gr2LISTENER_XXXX =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521))
)
)SID_LIST_LISTENER_XXXX =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = E:\app\oracle11gr2\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:E:\app\oracle11gr2\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
# Generated by Oracle configuration tools.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 = HOSTNAME)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID =orcl)
)
)