为何我新建的一个数据库打不开啊??? SERVICE_NAME 配错了 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 把tnsnames.ora和listener.ora的内容贴上来,应该是这里的问题 to ORARichard(没钱的日子......) : listener.org 文件: # LISTENER.ORA Network Configuration File: C:\oracle\ora90\network\admin\listener.ora# Generated by Oracle configuration tools.LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = aopen-d59bbef8a)(PORT = 1521)) ) ) )SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = C:\oracle\ora90) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = otest) (ORACLE_HOME = C:\oracle\ora90) (SID_NAME = otest) ) (SID_DESC = (GLOBAL_DBNAME = TEST1.AOPEN.COM) (ORACLE_HOME = C:\oracle\ora90) (SID_NAME = TEST1) ) )tnsnames.ora 文件:# TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora# Generated by Oracle configuration tools.EXTPROC_CONNECTION_DATA.AOPEN.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )EPS081.AOPEN.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.192.33.30)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ORC1) ) )INST1_HTTP.AOPEN.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = aopen-d59bbef8a)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = MODOSE) (PRESENTATION = http://HRService) ) )TEST1.AOPEN.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.192.33.200)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = TEST1) ) )OTEST.AOPEN.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = aopen-d59bbef8a)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = otest) ) )ORC1_10.192.33.30 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.192.33.30)(PORT = 1521)) ) (CONNECT_DATA = (SID = ORC1) (SERVER = DEDICATED) ) )##################################### Date..........: Fri Jan 28 11:06:07 CST 2005####################################EPS171.AOPEN.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.192.33.16)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ORC1) ) )EF2KWEB_10.192.37.45 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.192.37.45)(PORT = 1521)) ) (CONNECT_DATA = (SID = ef2kweb) (SERVER = DEDICATED) ) ) 感觉好乱哦你服务器上有几个实例。实例SID名分别是什么。你是在客户端上还是在服务器中连的数据库 我以前发现服务器名称中包含 "-" 字符容易出错.(Oracle7.3.x)所以我以后给服务器取名称时不使用字符"-" Oracle查询问题,求帮一下忙!感谢! 修改oracle8.17 监听端口语句报错 sqlplus算不算客户端呀 急 在线等 oracle创建2个表 觉得这样建表不对 但是又不知道怎么创建 请高手看下 谢谢 当我把数据导入到D盘后 我怎么做 才能使用这个数据库? 这个SQL语句中if end这种写法是什么意思 为什么我的这条sql语句执行这么慢,要40多秒 日期判断问题急```` 重分悬赏,大家进来看看.进都有分,而且问题很有趣味 oracle中日期的问题!!! sqlplus问题! 想更改oracle初始化参数,网上介绍说建立一个ora后缀的文件,但不知放哪里?
# LISTENER.ORA Network Configuration File: C:\oracle\ora90\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = aopen-d59bbef8a)(PORT = 1521))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora90)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = otest)
(ORACLE_HOME = C:\oracle\ora90)
(SID_NAME = otest)
)
(SID_DESC =
(GLOBAL_DBNAME = TEST1.AOPEN.COM)
(ORACLE_HOME = C:\oracle\ora90)
(SID_NAME = TEST1)
)
)tnsnames.ora 文件:
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.EXTPROC_CONNECTION_DATA.AOPEN.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)EPS081.AOPEN.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.192.33.30)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORC1)
)
)INST1_HTTP.AOPEN.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = aopen-d59bbef8a)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)TEST1.AOPEN.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.192.33.200)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TEST1)
)
)OTEST.AOPEN.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = aopen-d59bbef8a)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = otest)
)
)ORC1_10.192.33.30 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.192.33.30)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORC1)
(SERVER = DEDICATED)
)
)####################################
# Date..........: Fri Jan 28 11:06:07 CST 2005
####################################EPS171.AOPEN.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.192.33.16)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORC1)
)
)EF2KWEB_10.192.37.45 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.192.37.45)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ef2kweb)
(SERVER = DEDICATED)
)
)
你是在客户端上还是在服务器中连的数据库
所以我以后给服务器取名称时不使用字符"-"