RE: sqlplus / svrmgrl & NT

From: Shaw, Glen <Glen.Shaw_at_BellSouth.com>
Date: Fri, 27 Oct 2000 11:56:43 -0400
Message-Id: <10662.120465@fatcity.com>

I recommend you take a look at the CygWin product from RedHat (www.redhat.com). It allows you to run a bash shell under windows. I used it on a couple of NT databases. There is also a telnet daemon you can set up that allows you to administer your databases remotely as if they were on a unix system.

I know this doesn't solve your immediate problem. I just thought you might want to consider this for later.

Regards,
Glen

-----Original Message-----
From: Jonathan Gennick [mailto:jonathan_at_gennick.com] Sent: Friday, October 27, 2000 11:12 AM
To: Multiple recipients of list ORACLE-L Subject: Re: sqlplus / svrmgrl & NT

I'm fairly certain that the <<EOF syntax is a UNIX feature, not a Server Manager feature. The Unix operating system makes that work transparently to Server Manager. NT simply doesn't support redirecting standard input to a .bat file.

Jonathan

Wednesday, October 25, 2000, 8:05:57 AM, you wrote:

nen> Hi All,

nen> In my scripts that do for instance offline backups I use the following nen> syntax (UNIX)

nen> svrmgrl  <<EOF
nen> connect / as sysdba
nen> shutdown immediate
nen> etc.. etc..
nen> EOF

nen> Anything between the <<EOF and the EOF is considered as individual nen> statements.

nen> How can I use the same syntax in SQL*Plus with Oracle8.1.6 on WinNT/2000

nen> I tried the exact same syntax but it complains about the <<EOF bit

nen> Jack

nen> ===================================================================

nen> De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor
nen> de geadresseerde. Gebruik van deze informatie door anderen dan de nen> geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding
nen> en/of verstrekking van deze informatie aan derden is niet toegestaan. nen> Ernst & Young staat niet in voor de juiste en volledige overbrenging van de

nen> inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.
nen> ===================================================================
nen> The information contained in this communication is confidential and may

be
nen> legally privileged. It is intended solely for the use of the individual or
nen> entity to whom it is addressed and others authorised to receive it. If you
nen> are not the intended recipient you are hereby notified that any disclosure,
nen> copying, distribution or taking any action in reliance on the contents of
nen> this information is strictly prohibited and may be unlawful. Ernst & nen> Young is neither liable for the proper and complete transmission of the

nen> information contained in this communication nor for any delay in its
nen> receipt.
nen> ===================================================================

--

Best regards,

 Jonathan                            mailto:jonathan_at_gennick.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jonathan Gennick
INET: jonathan_at_gennick.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 Received on Fri Oct 27 2000 - 10:56:43 CDT