RE: Spooler is not running

Thanks Stephane.

It was the .sql files were in the wrong directory ...

I should have figured that out by inspection but today I'm tired I had a long Friday night ... :)

I renamed the directory and everything ran good.

v/r

Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
stephen.wolfe_at_macdill.af.mil
(813) 827-9974 DSN 651-9974
> -----Original Message-----
> From: Stephane Faroult [mailto:sfaroult_at_oriole.com]
> Sent: Saturday, May 17, 2003 3:52 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Spooler is not running
>
>
> > Wolfe Stephen S GS-11 6 MDSS/SGSI wrote:
> >
> > SQL> @D:\Latest_Reference_Files\run_tpocs_303_scripts.sql
> > SP2-0332: Cannot create spool file.
> > SP2-0310: unable to open file
> > "d:\tpocs_303_scripts\add_columns_and_compile.sql"
> > SP2-0310: unable to open file
> > "d:\tpocs_303_scripts\i_ads_arc_general_ledger_trig_301.sql"
> > SP2-0310: unable to open file
> > "d:\tpocs_303_scripts\i_ais_arc_general_ledger_trig_301.sql"
> > SP2-0310: unable to open file
> > "d:\tpocs_303_scripts\i_aus_arc_general_ledger_trig_301.sql"
> > SP2-0310: unable to open file
> > "d:\tpocs_303_scripts\i_aus_arc_general_ledger_proc.sql"
> > SP2-0310: unable to open file
> > "d:\tpocs_303_scripts\i_post_bills_package_spec.sql"
> > SP2-0310: unable to open file
> > "d:\tpocs_303_scripts\i_post_bills_package_body.sql"
> > SP2-0310: unable to open file
> > "d:\tpocs_303_scripts\i_adhoc_views_table_data.sql"
> > SP2-0310: unable to open file
> > "d:\tpocs_303_scripts\ahq_i_interface_load_error_view.sql"
> > SP2-0310: unable to open file
> > "d:\tpocs_303_scripts\ahq_i_encounter_ndc_view_301.sql"
> > SP2-0310: unable to open file
> > "d:\tpocs_303_scripts\ahq_i_permanent_bill_ndc_view_301.sql"
> > SP2-0310: unable to open file
> > "d:\tpocs_303_scripts\ahq_i_general_ledger_301_view.sql"
> > not spooling currently
> >
> > How do I T/S the above problem. The MHS support center said the
> > script (which modifies the attributes of one database on a 9i
> > server running under Win2K) should take only 20 minutes to run.
> >
> > We are mainly a MSSQL2K shop, but recently we have gained two new
> > medical applications that uses 9i as the back end. I have a request
> > in for Oracle DBA training on site for myself and my other two
> > SQL DBAs, but the facility has yet to fund the request -- it is
> > approved,
> > not funded -- isn't the government wonderful ... <ggg>
> >
> > Any help would be greatly appreciated, I suspect this is a simple
> > problem.
> >
> > v/r
> >
> > Stephen S. Wolfe, GS-11, DAFC
> > Data Services Manager
> > stephen.wolfe_at_macdill.af.mil
> > (813) 827-9974 DSN 651-9974
>
>
> Stephen,
>
> Indeed likely to be simple. You have two distinct problems here :
>
> 1) Cannot create spool file
> It's simply that you cannot write in the current directory. 'not
> spooling currently' derives from this and is generated by a
> 'spool off'
> command.
> 2) Failure to read the various SQLfiles. Either the directory doesn't
> exist, or the file do not exist, in which case your installation was
> probably incomplete. Or you are not allowed to read it. In
> which case it
> may be the same as 1) - perhaps you are simply not logged in as the
> suitable user.
> Or you have shifted files around after the installation,in which case
> reinstalling from scratch is probably the safest thing to do.
>
> --
> Regards,
>
> Stephane Faroult
> Oriole Software
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stephane Faroult
> INET: sfaroult_at_oriole.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfe Stephen S GS-11 6 MDSS/SGSI
  INET: Stephen.Wolfe_at_macdill.af.mil

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).