code error : sql EOF
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: code error : sql EOF

Threaded View

  1. #1
    Join Date
    Dec 2013
    Posts
    1

    Exclamation code error : sql EOF

    Hi ,

    iam using this script to connect to all db . first grep from oratab and use those sid as $dbname as alias ..

    where is the error : pls help

    egrep -i ":Y|:N" $ORATAB | egrep -v "9.2" | cut -d":" -f1 | grep -v "\#" | grep -v "\*" | while read dbname
    do
    echo $dbname
    export ORACLE_SID="$dbname"
    . /dba/scripts/.dba.profile
    $ORACLE_HOME/bin/sqlplus -S oracle/mysecretpassword!!!@"$dbname" <
    show user;
    EOF1
    done

    -------------------but getting error ----------------------
    SP2-0306: Invalid option.
    Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
    where ::= [/][@]
    ::= [][/][@]
    SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
    DV2ACT
    ERROR:
    ORA-12154: TNS:could not resolve the connect identifier specified


    ERROR:
    ORA-01017: invalid username/password; logon denied


    please help me on this..........
    Last edited by gandolf989; 12-31-2013 at 08:58 AM.

Posting Permissions

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


Click Here to Expand Forum to Full Width