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'
Posted by at

1 comment:

  1. sudheer.godgeri@rediffmail.com3 December 2016 at 12:22

    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

Subscribe to: Post Comments (Atom)