Re: backup script
- From: Paul Drake <bdbafh@xxxxxxxxx>
- To: niall.litchfield@xxxxxxxxx
- Date: Wed, 30 Mar 2005 18:11:42 -0500
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@xxxxxxxxx> wrote:
> On Wed, 30 Mar 2005 13:37:08 -0500, Igor Neyman <ineyman@xxxxxxxxxxxxxx>
> 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
> --
> //www.freelists.org/webpage/oracle-l
>
--
#/etc/init.d/init.cssd stop
# f=ma, divide by 1, convert to moles.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
