oracle数据库用expdp命令报错,求解?? 连接不上实例orcl,看一下监听是否有问题 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 嗯!在linux中和windows中配置是一样的吗? lsnrctl status看一下orcl是否正常 [oracle@timran ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.1.0.6.0 - Production on 08-12月-2013 17:22:46Copyright (c) 1991, 2007, Oracle. All rights reserved.正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=timran.localdomain)(PORT=1521)))TNS-12541: TNS: 无监听程序 TNS-12560: TNS: 协议适配器错误 TNS-00511: 无监听程序 Linux Error: 111: Connection refused正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))TNS-12541: TNS: 无监听程序 TNS-12560: TNS: 协议适配器错误 TNS-00511: 无监听程序 Linux Error: 111: Connection refused listener.ora:LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = timran.localdomain)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME= timran11g) (ORACLE_HOME = /u01/oracle) (SID_NAME = timran11g) ))tnsnames.ora:LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = timran11g) (PRESENTATION = RO) ) )TIMRAN11 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = timran.localdomain)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = timran11g) ) ) expdp 使用于服务端,一般不需要tnsorcl 应该不存在 谢谢大家,我已经解决啦,方法如下这个报错跟权限相关,一番google,解决如下:# chmod 777 /var/tmp/.oracle 原因分析:应是Oracle卸载不干净,导致/var/tmp/.oracle目录权限不足,故而报错。 楼主,我在win7下遇到这个问题,请问怎么解决呢?查遍百度都没找到答案。 在oracle中如何查看在某一段时间内执行的sql语句所用的时间 请问sql查询中 那些数值类型的值需要加引号 哪些不用? oracle 对用户权限管理的一些问题(权限更改类) 缺失右括号???? 多对多查询 在线求助,,急。。。。。 我的程序调用ORACLE数据的时候一旦遇到空字段,就程序错误,退出,请问该如何解决? 非常简单问题!!!!! [初学ORACLE] C语言连接数据库程序编译不通过! 有人用过erwin吗,有个错误想问一下 win7运行pl/sql developer 登陆时弹出空白提示框? 这道oracl 题目怎么做??
看一下orcl是否正常
TNS-12541: TNS: 无监听程序
TNS-12560: TNS: 协议适配器错误
TNS-00511: 无监听程序
Linux Error: 111: Connection refused
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS: 无监听程序
TNS-12560: TNS: 协议适配器错误
TNS-00511: 无监听程序
Linux Error: 111: Connection refused
listener.ora:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = timran.localdomain)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME= timran11g)
(ORACLE_HOME = /u01/oracle)
(SID_NAME = timran11g)
)
)tnsnames.ora:LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = timran11g)
(PRESENTATION = RO)
)
)TIMRAN11 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = timran.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = timran11g)
)
)
这个报错跟权限相关,一番google,解决如下:
# chmod 777 /var/tmp/.oracle
原因分析:应是Oracle卸载不干净,导致/var/tmp/.oracle目录权限不足,故而报错。