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

Home -> Community -> Usenet -> c.d.o.misc -> Re: svrmgr23 on NT

Re: svrmgr23 on NT

From: Dave Klinger <dklinger_at_bechtel.com>
Date: Tue, 22 Sep 1998 12:40:31 GMT
Message-ID: <36079ABF.ADDAC17C@bechtel.com>


Once you have called svrmgr23, that program will be executing. The next command in the batch file (your connect statement) will not get executed until you exit svrmgr23. If you want to have statements executed within svrmgr23 you need to create a seperate SQL script file and call that from the svrmgr23 statement.
Example : Batch file :

        set oracle_sid=dba
        svrmgr23 @test.sql

Example : SQL "test.sql" script file:

    connect internal/oracle
    select * from dual;
    exit

Dave

Luc Demanche wrote:

> I would like to use svrmgr23 on batch file. I can call svrmgr23 but I
> can't do any sql commands in svrmgr23.
>
> Example : I have in a batch file :
> set oracle_sid=dba
> svrmgr23
> connect internal/oracle
>
> The connect command don't work. WHY?
>
> Can you help me please ?
>
> Luc Demanche
> demanchel_at_icotech.com
Received on Tue Sep 22 1998 - 07:40:31 CDT

Original text of this message

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