Chinaunix首页 | 论坛 | 博客
  • 博客访问: 238304
  • 博文数量: 23
  • 博客积分: 2262
  • 博客等级: 大尉
  • 技术积分: 872
  • 用 户 组: 普通用户
  • 注册时间: 2004-12-26 15:59
文章分类

全部博文(23)

文章存档

2009年(3)

2008年(20)

分类: Oracle

2008-04-20 22:56:41

×才开始学Oracle,遇到点问题,记录一下。×
 
ORA-12560: TNS: 协议适配器错误
ORA-12514: TNS: 协议适配器错误
 
首先保证服务正常起来。
 
在次去看$Oracle_home/network/admin/listener.ora
 
如果只是在sqlplus 中出现这样的问题。
win
set ORACLE_ID=DBname
 
管理工具编辑listenr.org
# listener.ora Network Configuration File: e:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = e:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
#add db name desc
     (SID_DESC =
       (GLOBAL_DBNAME = ebay)
       (ORACLE_HOME = e:\oracle\product\10.2.0\db_1)  
       (SID_NAME = ebay)
      )
#end
  )
#不同IP端口监听
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.8)(PORT = 1521))
    )
  )
#end
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))
    )
  )
阅读(1191) | 评论(0) | 转发(0) |
0

上一篇:没有了

下一篇:java.lang.Exception: Exception in sending Request

给主人留下些什么吧!~~