连接不上实例orcl,看一下监听是否有问题
解决方案 »
- Plsql读取指定路径的文件名
- 急:关于bulk collect
- ORACLE中如何实现自增字段:
- 急急急,Oracle 9i客户端连接Oracle8i的服务器乱码问题。
- 请教LINUX下ORACLE的恢复问题?
- 把数据导入到oracle一个已存在的表,如何操作?
- ORACLE数据导出时间的问题
- 急问,在线等! oracle数据库中 表的主关键字 存储在系统的什么地方?
- 在字符到日期的类型转换中出现了错误,请问我怎么样才能找出是哪条记录出错。
- 救急!!!关于动态网站中遇到大文本的处理情况(愿意出500分)
- 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目录权限不足,故而报错。