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) ) ) 觸發器的不知名錯誤 oracle根据导出.dmp文件进行恢复,出错了,帮忙看看 想写个SQL得到如下值,请教高手。 oracle tnsnames 文件中,大家帮个忙!!! 全文检索 搜索结果不准确(急) 拾到的财富 求一个测试job oracle自建job时间自动变更 一个关于ORACLE用户的问题? 这个SQL语句怎么写,请高手帮忙,高分相谢 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)
)
)