Newsgroups: comp.databases.oracle.server Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!news.maxwell.syr.edu!newspeer.radix.net!news.er.usgs.gov!news From: Brian Peasland Subject: Re: calling sqlplus from unix shell script error X-Nntp-Posting-Host: edcxpw014.cr.usgs.gov Content-Type: text/plain; charset=us-ascii Message-ID: <3F5E0F6F.C5827A15@remove_spam.peasland.com> Sender: news@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739) Content-Transfer-Encoding: 7bit Organization: U.S. Geological Survey, Reston VA X-Accept-Language: en References: <3348214.1063120733@dbforums.com> Mime-Version: 1.0 Date: Tue, 9 Sep 2003 17:35:43 GMT X-Mailer: Mozilla 4.78 [en] (Windows NT 5.0; U) Lines: 32 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:242709 > The script: > > sqlplus< $CometsLog/create-tst92.log sys/system Note that you have "sys/system". This is probably not a valid userid/pswd combination. But then again, it may just be that you modified it so that I don't know your password. Why not just code your script as follows?: ======================================================= sqlplus /nolog < $CometsLog/create-tst92.log connect sys/pswd as sysdba exit EOF ======================================================= Make sure that the 'EOF' starts in column 1 of your text file. -- =================================================================== Brian Peasland dba@remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three"