Chinaunix首页 | 论坛 | 博客
  • 博客访问: 2795359
  • 博文数量: 389
  • 博客积分: 4177
  • 博客等级: 上校
  • 技术积分: 4773
  • 用 户 组: 普通用户
  • 注册时间: 2008-11-16 23:29
文章分类

全部博文(389)

分类: Oracle

2014-08-10 17:12:45

                              ORACLE的ORA-07217原因

     ora-07217表示当进oracle进程在获取环境变量的定义时得不到信息,或是返回空
就提示指信息,


1,在rman脚本很常见.变量没有正确解析

[oracle@dg2 trace]$ oerr ora 7217
07217, 00000, "sltln: environment variable cannot be evaluated."
// *Cause:  getenv call returned a null pointer.
// *Action: Set the environment variable and try again.

 

RMAN> backup datafile 1 format '$BACKUP/%S';

Starting backup at 29-AUG-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=258 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/tt/DGTT/datafile/o1_mf_system_91xotmdb_.dbf
channel ORA_DISK_1: starting piece 1 at 29-AUG-13
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/29/2013 19:35:19
ORA-07217: sltln: environment variable cannot be evaluated.

定义了一个不存的$BACKUP变量,oracle无法获得此变量的值,报错

 


2,做物理备库时,定义了
db_file_name_convert='+DATA','/u01/app/oracle/oradata/tt'


sql statement: alter database mount standby database
released channel: c1
released channel: ac2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/29/2013 20:04:46
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of sql command on clone_default channel at 08/29/2013 20:04:46
RMAN-11003: failure during parse/execution of SQL statement: alter database mount standby database
ORA-07217: sltln: environment variable cannot be evaluated.

目前尚不清楚原因是什么,而log_file_name_convert参数受支持的.在11.2和11.1的版本中都不会出现类似的情况.

 

 

阅读(5912) | 评论(0) | 转发(0) |
0

上一篇: RAC到单实例SWITCHOVER

下一篇:DRBD部署实践

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