Re: SQLPLUS question

Snehal Patel (snehal_at_acsc.com) wrote:

: Hi!
 

: I have a question with running SQLPLUS with an sql file from another machine using rsh.
 

: If I use
: rsh <hostname> /u/oracle/bin/sqlplus -s user/passwd _at_sqlfile

: I get an error saying "no message file for product=SQLPLUS facility=SP2 "

Oracle relies on having certain environment variables set, especially ORACLE_HOME, which it uses to resolve path names. It expects all messages to be in designated directories under this home directory. If Oracle cannot find a message catalog it will deliver the above message. You may want to change your command line to the following:

        rsh <hostname> ORACLE_HOME=/u/oracle /u/oracle/bin/sqlplus ...

		    Michael Leblanc, Support Engineer
                    Derby Associates, International
                    E-Mail: derby_at_teal.csn.org