Automic Community

Expand all | Collapse all

sqlplus: command not found

  • 1.  sqlplus: command not found

    Posted 08-26-2019 12:09 PM
    Submitted jobs are aborting

    starting sqlp Mon Aug 26 16:14:52 CEST 2019
    sqlplus -s @/erppoc/am/POC/sql/forecast A87.lis
    /erppoc/am/POC/exec/SQLP: line 31: sqlplus: command not found
    Could not login to sqlplus-

    Please suggest.

    #applicationsmanager


    ​​​

    ------------------------------
    Ansari
    ------------------------------


  • 2.  RE: sqlplus: command not found

    Posted 08-27-2019 07:50 AM
    Hi Ansari,

    sqlplus is located somewhere. So you will either have to add this location to your path variable or you will have to call it with this path.

    Best regards
    Juergen

    ------------------------------
    Senior Consultant
    setis GmbH
    ------------------------------



  • 3.  RE: sqlplus: command not found

    Posted 08-27-2019 08:15 AM
    @Juergen Lechner Thanks for your response. I am bit confused, when i login into server where  ​#applicationsmanager  has been installed I am able to do sqlplus with the enviroment in user profile. But when i login into #applicationsmanager client to submit the job it is aborting

    Thanks in advance!!!


    ===== LOGIN INFORMATION ============================================
    dbtype ORACLE
    login amprod
    netconnect
    dbtype2 ORACLE
    db_login2
    net_connect2
    sid Oracle sid of task is seperpt1.lindex.local

    parameter file
    define start_date='20190822125101'
    define end_date=''
    define max_depth=20
    define min_units=DAYS
    End of parameter file
    job pid 30120

    ORACLE_HOME = [/home/oracle] ? ORACLE_BASE environment variable is not being set since this
    information is not available for the current user ID ampoc.
    You can set ORACLE_BASE manually if it is required.
    Resetting ORACLE_BASE to its previous value or ORACLE_HOME
    The Oracle base remains unchanged with value /opt/oracle/base
    starting sqlp Thu Aug 22 12:51:01 CEST 2019
    sqlplus -s @/erppoc/am/POC/sql/forecast A11.lis
    /erppoc/am/POC/exec/SQLP: line 31: sqlplus: command not found
    Could not login to sqlplus
    no output from FORECAST
    exiting sqlp Thu Aug 22 12:51:01 CEST 2019
    *****************************
    * Finished on Thu Aug 22 12:51:01 CEST 2019 with status ABORTD (ABORTD)

    *****************************
    awprint PRINTSIZE -j 16.00 -n o16.00 -d /erppoc/am/POC/out
    Results from command:PRINTSIZE -j 16.00 -n /erppoc/am/POC/out/o16.00 -d /erppoc/am/POC/out
    Thu Aug 22 12:51:03 CEST 2019 Done with BODY



  • 4.  RE: sqlplus: command not found

    Posted 08-27-2019 10:38 AM
    Assuming you are running from a unix agent job,  make sure the shell selection has the dash prefix on the Unix tab.e
    example -bash and not just bash.

    The - tells it to run the users login profile which is likely where all the oracle dependent environment variables are set.



  • 5.  RE: sqlplus: command not found

    Posted 08-28-2019 02:29 AM
    If Richards suggestion below won't help:

    Login to the Unix server and type 'which sqlplus'. It will return the absolute path to where sqlplus is installed. You can then use this absolute path to start sqlplus. It might be still better to amend this in the PATH variable via Unix profiles - you should have a talk wirh your Unix admin then.

    ------------------------------
    Swisscom & WorkflowCommander
    ------------------------------



  • 6.  RE: sqlplus: command not found

    Posted 08-29-2019 11:46 AM
    It looks like you are missing the net_connect (TNS connect descriptor) on your amprod login object. This should have been specified during the awinstall process.
    If the net connect is missing, AM will try to run oraenv which will overwrite your your current oracle environment settings.
    This is visible in line "ORACLE_HOME = [/home/oracle] ". You will need to need to update the amprod login object. Since it is likely read-only, you will have to run awinstall again or work with support to manually update the so_ids table via SQL.