网上看的头都大了,试了几个好像都没什么反应C:\Documents and Settings\Administrator>tnsping orclTNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 26-11月-
2010 15:00:34Copyright (c) 1997, 2005, Oracle. All rights reserved.已使用的参数文件:
E:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.
1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (20 毫秒)
这个挺正常的。
然后在sqlplus中登录
用户名 密码 和主机字符串
输入用户名system然后密码挺好。
可是输入主机字符串orcl的时候就会出现如题错误
这是我tnsnames.ora的配置
来个大拿 把这个问题拿下 SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(SID_NAME = orcl)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = orcl))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
2010 15:00:34Copyright (c) 1997, 2005, Oracle. All rights reserved.已使用的参数文件:
E:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.
1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (20 毫秒)
这个挺正常的。
然后在sqlplus中登录
用户名 密码 和主机字符串
输入用户名system然后密码挺好。
可是输入主机字符串orcl的时候就会出现如题错误
这是我tnsnames.ora的配置
来个大拿 把这个问题拿下 SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(SID_NAME = orcl)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = orcl))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
解决方案 »
- PL/SQL Developer登录时,connect as 选项有什么作用。
- sql程序员经典怎么都是不完整版的,那位知道完整版得在哪儿下载吗?
- 关于建表的问题
- 求助!请问在虚拟机下的xp系统里装oracle要如何配置?
- 一个挺菜的触发器问题
- 新手求一条简单查询语句
- 定义number类型的字段时,指定长度和不指定长度在性能上有区别吗?
- 请教写一个金额大小写转换的函数
- 视图生成成功,但是查看视图的数据时报错:无法在没有键值保存表的连接视图中选择rowid
- 请教:用简单的查询来说明分布式数据库是怎么实现的?
- oracle统计中总计小计显示的问题
- 如何在oracle数据库表的字段名定义中建立公式?
(SID_DESC =
(GLOBAL_DBNAME = 数据库名)
(ORACLE_HOME = /opt/oracle/product/9.2.0)
(SID_NAME = 数据库id)
)重新启动lsnrctl即可
连接命令可以不加服务名看看,这样:CONN system/密码
试试
用了最笨的方法。 我把oracle重装了。