Re: backup script

Niall,

I prefer to use:

SQL> @?/rdbms/admin/utlrp;

on both lin32 and win32 OSes.
sqlplus knows its home, provided that you run the correct version of sqlplus.

Paul

I think that I'm going to need some additional text to avoid the lameness filter.
Been running 10.1.0.4.0 for 3 days in production on w2k3 with no issues, but I won't really know until after month-end close is run.

Something that I noticed in 10.1 ... regarding keep, recycle and non-default db_blocksize pools is that the minimum amount of memory allocated to a pool is 4 MB * # of CPUs where the number of CPUs includes logical (hyperthreaded) units.

On Wed, 30 Mar 2005 20:01:03 +0100, Niall Litchfield <niall.litchfield_at_gmail.com> wrote:
> On Wed, 30 Mar 2005 13:37:08 -0500, Igor Neyman <ineyman_at_perceptron.com> wrote:
> > Why reading the registry?
> > You could just use %ORACLE_HOME% system variable in your script.
>
> I think you are thinking of a sqlplus script, the chances are that
> this environment variable isn't available directly from a command
> prompt.
>
> ***** proof that the envvar isn't set
> C:\TEMP>SET O
> OS=Windows_NT
> OSVER=winXPP
>
> C:\TEMP>SET ORA
> Environment variable ORA not defined
>
> ***** but available in sqlplus.
>
> C:\TEMP>SQLPLUS /
>
> SQL*Plus: Release 10.1.0.2.0 - Production on Wed Mar 30 19:54:21 2005
>
> Copyright (c) 1982, 2004, Oracle. All rights reserved.
>
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
> With the Partitioning, OLAP and Data Mining options
>
> SQL> @%ORACLE_HOME%\RDBMS\ADMIN\DEMO
>
> User created.
>
> Grant succeeded.
>
> Grant succeeded.
>
> User altered.
>
> User altered.
>
> Connected.
>
> etc etc
>
> Me, I'd go with the sqlplus version. I don't see why the ORACLE_HOME
> directory is required in an NT backup script anyway.
>
> actually I'd also go with vbscript and not dos scripting (unless
> Jared is watching - in which case of course there is no alternative to
> perl :) )
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.niall.litchfield.dial.pipex.com
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
#/etc/init.d/init.cssd stop
# f=ma, divide by 1, convert to moles.
--
http://www.freelists.org/webpage/oracle-l