在oracle11 做rman命令时出现错误为:
恢复管理器: Release 11.1.0.6.0 - Production on 星期三 10月 14 11:39:04 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
连接到目标数据库: ORCL (DBID=1226118012)
使用目标数据库控制文件替代恢复目录
RMAN> shutdown immediate
数据库已关闭
数据库已卸装
Oracle 实例已关闭
RMAN> startup mount;
DBGANY: Mismatched message length! [11:39:58.296] (krmiduem)
DBGANY: Mismatched message length! [11:39:58.296] (krmiduem)
RMAN-03002: startup 命令 (在 10/14/2009 11:39:58 上) 失败
ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务
解决:
修改\oracle\product\11.1.0\db_1\network\admin\listener.ora文件
原来:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rickLiu)(PORT = 1521))
)
)
添加:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = E:\oracle\product\11.1.0\db_1)
)
)
保存后用命令:lsnrctl restart listener
OK
转载连接:http://falchion.iteye.com/blog/487802
恢复管理器: Release 11.1.0.6.0 - Production on 星期三 10月 14 11:39:04 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
连接到目标数据库: ORCL (DBID=1226118012)
使用目标数据库控制文件替代恢复目录
RMAN> shutdown immediate
数据库已关闭
数据库已卸装
Oracle 实例已关闭
RMAN> startup mount;
DBGANY: Mismatched message length! [11:39:58.296] (krmiduem)
DBGANY: Mismatched message length! [11:39:58.296] (krmiduem)
RMAN-03002: startup 命令 (在 10/14/2009 11:39:58 上) 失败
ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务
解决:
修改\oracle\product\11.1.0\db_1\network\admin\listener.ora文件
原来:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rickLiu)(PORT = 1521))
)
)
添加:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = E:\oracle\product\11.1.0\db_1)
)
)
保存后用命令:lsnrctl restart listener
OK
转载连接:http://falchion.iteye.com/blog/487802