Thursday 29 November 2012

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




In Linux or Unix OS Use  export ORACLE_SID='SID_NAME'
                                           export ORACLE_HOME='HOME_PATH'


Permanent Fix in Linux OS 

                                  Edit  /home/oracle/.bash_profile
                     add the following entries

                    ORACLE_HOME=/u01/app/rdbms_9.2.0.5
                      ORACLE_SID=orcl1

                    export ORACLE_HOME
                    export ORACLE_SID


 if in windows
                                   set ORACLE_SID='SID_NAME'
                                   set ORACLE_HOME='HOME_PATH'

1 comment:

  1. I had similar frustrating experience when using rman format string like 'dbname_%U.rmn' . in spite of checking everywhere for syntex in shell -- it seemed ok! The error persisted!!

    Then -- I checked RMAN> show all
    The suspect configuration for device type disk --
    configure channel device type disk format '/backup/PROD/db_$d_%d.rmn'

    I used configure channel device type disk clear;

    There!!

    Then I re-ran the shell -- it started working ok!!

    ReplyDelete