Re: Multiple Oracle databases on Windows NT

From: hazledid <david.hazledine_at_roche.com>
Date: Thu, 20 May 1999 16:57:02 GMT
Message-ID: <y9X03.6603$xa.59926@c01read02-admin.service.talkway.com>

On Wed, 19 May 1999 12:59:21 -0700 Vitaliy Mogilevskiy <vit100gain_at_earthlink.net> wrote:

> [...]
> 2. SET ORACLE_SID=PROD
> SET LOCAL=2:PROD
> SVRMGR23 @CRDB.SQL
> [...]
> Please note that to start newly created database you will have to
> set your ORACLE_SID and LOCAL to the corresponding instance. So if you have
> multiple databases you'll have to re set those ENV's before starting the databases.

You can skip setting ORACLE_SID and LOCAL if you do a CONNECT command after starting Server Manager:

C:\> SVRMGR23
SVRMGR> CONNECT INTERNAL_at_2:sid

David J. Hazledine
Roche Products Limited
40 Broadwater Road
Welwyn Garden City
AL7 3AY
United Kingdom
Registration Number 100674

E-mail: david.hazledine_at_roche.com
Fax: +44 (0)1707 325666
Tel: +44 (0)1707 366166
--
Posted via Talkway - http://www.talkway.com Exchange ideas on practically anything (tm). Received on Thu May 20 1999 - 11:57:02 CDT