Re: script problem solved, but I still don't understand ....

Ed Stevens wrote:
> sqlplus "/ as sysdba" @mysqlscript
>
>
> and the output looked like this. Note the successfull 'connected'
> just before the DELETE statement.
>
> SQL*Plus: Release 9.2.0.1.0 - Production on Wed Oct 13 14:42:00 2004
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> Connected.
> SQL> DELETE FROM mytable
> 2 WHERE sample_time < sysdate - &1
> 3 ;
> old 2: WHERE sample_time < sysdate - &1
> new 2: WHERE sample_time < sysdate - 15
> DELETE FROM mytable
> *
> ERROR at line 1:
> ORA-01034: ORACLE not available
>
>
> I'm sure this is something I should know. Maybe I do know it, but am
> just having a DSA (Dumb S*** Attack (tm)) I think my memory is maxed
> out, and everytime I have to remember something new, something else
> has to be tossed to make room. One of these days it will be my own
> name that gets thrown out to make room for the names of seven new
> databases to be created . . .

Personally I'd expect an 'Connected to an idle instance'. Try what you get if you do

export ORACLE_SID=foo
sqlplus "/ as sysdba"

since I don't have a Solaris at hand I can't check the outcome. But it should get you on the right track anyway.

HTH Holger Received on Thu Oct 14 2004 - 01:38:43 CDT