Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2009
    Posts
    56

    Unanswered: Connecting to oracle using shell script

    Hello Friends ,

    I have a shell script that connects to database and calls a stored procedure..

    when I run the script I am getting the following

    error ..

    aggregation_shell_script.sh: sqlplus: not found


    Please let me know what's wrong.

    I don't find oraenv in either /var/opt/oracle or $ORACLE_HOME/bin



    #!/bin/ksh
    echo ""
    echo "********************************************"
    echo "*********** START OF THE PROCESS ********"
    echo "********************"
    echo ""
    echo "---------------------------------------------------------------------------"
    sqlplus -s scott/tiger << EOFSQL
    @proc_aggregation_upd_tbl.sql
    spool off
    exit;
    EOFSQL
    echo "**************************"
    echo "**************** END OF THE PROCESS **************"
    echo "***************"

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Wink Check out /usr/local/bin/oraenv

    Try this:
    Code:
    #!/bin/ksh
    echo ""
    echo "********************************************"
    echo "*********** START OF THE PROCESS ********"
    echo "********************"
    echo ""
    echo "---------------------------------------------------------------------------"
    ORAENV_ASK=NO
    export ORACLE_SID=orcl
    . /usr/local/bin/oraenv
    #
    sqlplus -s scott/tiger << EOFSQL
    # ... Etc ...
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •