mysql show varialbe_ORA-07217: sltln: environment variable cannot be evaluated.

dg备库mount报ORA-07217

在一次搭建dg过程中,备库无法mount,报ORA-07217: sltln: environment variable cannot be evaluated.错误

[oracle@localhost orcl]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Feb 13 22:27:31 2019

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter database mount;

alter database mount

*

ERROR at line 1:

ORA-07217: sltln: environment variable cannot be evaluated.

alert日志报错

Set as converted control file due to db_unique_name mismatch

Changing di2dbun from ORCL to ORCLDG

ORA-7217 signalled during: alter database mount...

Wed Feb 13 20:33:41 2019

alter database mount

ORA-7217 signalled during: alter database mount...

Wed Feb 13 20:36:11 2019

alter database mount

ORA-7217 signalled during: alter database mount...

根据mos排查

根据mos ORA-07217: sltln: environment variable cannot be evaluated (Doc ID 2487898.1)描述排查,确认不是该问题

SQL> show parameter diag;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

diagnostic_dest string /u01/app/oracle

[oracle@dg:/opt/app/oracle/arch]$env|grep ORA

ORACLE_SID=orcl

ORACLE_BASE=/opt/app/oracle

ORACLE_TERM=xterm

ORACLE_HOME=/opt/app/oracle/product/11.2.0/db_1

检查发现数据文件异常

SQL> select name from v$datafile where name like '%$%';

NAME

------------------------------------------------------

+DATA/orcl/datafile/ts_his$emr01

+DATA/orcl/datafile/ts_his$emr02

通过分析,注释掉db_file_name_convert=’+DATA/orcl/datafile/’,’/u01/app/oradata/orcl/’即可正常mount成功,数据文件命令一定要规范(不要有特殊符号),不然给后人和自己留下巨坑