Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle backup scripts not working on W2K

Re: oracle backup scripts not working on W2K

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 11 Jun 2002 16:41:22 +0100
Message-ID: <3d061a22$0$8508$ed9e5944@reading.news.pipex.net>


<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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US