svrmgr cannot perform parameter substitution : this is a feature from
sqlplus.
You should connect as internal ( or better connect / as SYSDBA ) with
sqlplus.
> ----------
> From: Bert van der Plas[SMTP:bvanderplas_at_hmc-heerema.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Tuesday, June 06, 2000 11:55
> To: Multiple recipients of list ORACLE-L
> Subject: Using parameters in Server Manager SQL-script.
>
> Hi,
>
> We have several NT 8.0.5.2 databases. We have made our own NT service
> which
> allows us to execute SQL-statements during startup and shutdown of the
> database. In order to be able to execute these statements we use svrmgr30
> (version 3.0.5). I want to make these SQL-scripts more generic by using
> parameters. I have the following question: What do I have to do in order
> to
> use parameters?
>
> I've tried a couple of things but I didn't get the result I want. I get
> some
> errors. This is the command I executed:
>
> svrmgr30 "@script param1 param2" -> error MGR-00143 - Variable "x" has
> not
> been defined.
>
> OR
>
> svrmgr30 @script param1 param2 -> error MGR-04545 - Too many parameters.
>
>
> What am I doing wrong?
>
>
> Thanks in advance,
>
> Bert van der Plas
>
> --
> Author: Bert van der Plas
> INET: bvanderplas_at_hmc-heerema.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).
Received on Tue Jun 06 2000 - 06:07:45 CDT
