Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle backup scripts not working on W2K
<bgiesbre_at_shaw.ca> wrote in message
news:mfiagus43ucbi4f4e2t2f3s2nmiell4l5c_at_4ax.com...
> Try running the script on the console first and if it still fails, the
> ORACLE_SID variable isn't being fully recognized (as per Niall's
response). I
> would suspect though it should run.
>
> Under Terminal Server, you need to do two things in order to get Oracle to
> properly function:
>
> 1) set ORACLE_SID
> 2) if you are shutting down via svrmgrl (obsolete), run 'set instance ...'
Set ORACLE_SID does not work period. well it sets the environment variable but the connection doesn't work. Take it from someone who reinstalled oracle 817 twice on a machine before coming across a note in the readme re bequeath connections.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ******************************************Received on Tue Jun 11 2002 - 10:41:22 CDT