AutoSys Workload Automation

  • Private Community

  • 1.  ORACLE_HOME to your Oracle software directory

    Posted Jul 31, 2012 01:49 PM
    Running UNIX job for the first time in R11.3 and receiving the following error message.
    Does anyone have any insight on how to fix this error?


    User getting following error message when job executes. Agent is for a UNIX box.

    The script failed on the step that invokes SQLPlUS. The corresponding error messages are as follows:
    ===============================
    importRefData.ksh STARTED
    Tue Jul 31 11:50:02 EDT 2012
    Resetting Stage Tables...
    Tue Jul 31 11:50:02 EDT 2012
    Error 6 initializing SQL*Plus
    SP2-0667: Message file sp1<lang>.msb not found
    SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
    ==============================================================================

    Thanks!!
    Christine


  • 2.  RE: ORACLE_HOME to your Oracle software directory
    Best Answer

    Broadcom Employee
    Posted Aug 01, 2012 02:18 PM
    The CA WA job is looking for same environment that a user profile exports. You can reproduce this on your UNIX by running the command as a user that does not have Oracle related profile setup.

    [root@oracle]# sqlplus / as sysdba
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
    Now, with profile setup
    [root@WAR53BWA bin]# export ORACLE_HOME=/opt/oracle/product/10.2.0/db_1
[root@WAR53BWA bin]# sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 1 14:11:01 2012

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

Enter user-name:
    [color=#ff021c]Note: [color]This is an example. Do not run sqlplus as root without consulting your DBA.

    Set the user in the CA WA job that can run sqlplus correctly (usually not root). You may also want to set this in the agentparm.txt:
    oscomponent.defaultshell.force=trueThe agent will then use the default shell to run UNIX scripts and to source the user's profile.


  • 3.  Re: ORACLE_HOME to your Oracle software directory

    Posted Aug 18, 2015 11:07 AM

    Hi Nitin,

    I am getting the same error in a UNIX job which calls sql*plus inside a shell. If i run the shell directly in the server, it calls the SQL*plus OK, just get the error when i made from CAWA DE. In both cases i used the same user, then i dont know why i am getting the problem. I also checked the ORACLE_HOME and it is OK.

     

    Could you please help me if I need any other configuration?

     

    Thanks a lot!

    Isaac