From: Jim Anderson <janderson@ci.lincoln.ne.us>
Subject: Re: Loopback in TNSNAMES.ORA
Date: 1998/02/02
Message-ID: <34D61F2D.4778F2E8@ci.lincoln.ne.us>#1/1
Content-Transfer-Encoding: 7bit
References: <886193377.600702981@dejanews.com>
Mime-Version: 1.0
Reply-To: janderson@ci.lincoln.ne.us
To: joe.story@foxinternet.net
Content-Type: text/plain; charset=us-ascii
Organization: City of Lincoln, Nebraska
Newsgroups: comp.databases.oracle.server



Create a TCP/IP or SPX entry in your tnsnames file on the Netware server
just as you would from a client. To startup/shutdown the database, after you
get into server manager type

set instance tns_tcp_alias

or

set instance tns_spx_alias

where tns_tcp_alias and tns_spx_alias are the SQL*Net aliases you created.
Then connect internal and issue the startup/shutdown commands. Or you can
type:

connect internal/password@tns_tcp_alias

or

connect internal/manager@tns_spx_alias

Then issue the startup/shutdown commands. You can create ncf files to
shutdown/startup the database automatically when the server is rebooted. You
can find documentation for doing this on the MetaLink pages on the
support.oracle.com web server. Get into the Novell area and it is under the
Technical Bulletins section.

Hope this helps,
Jim Anderson

joe.story@foxinternet.net wrote:

> We are running 2 instances (databases)  on our Oracle 7.3.2.3 server on
> Netware 4.11. The release notes state that Oracle no longer supports
> starting the instances (databases) using the single-task driver. How do
> you start multiple databases using the loopback? What should our
> TNSNAMES.ORA file look like? The 2 SID's are Pmax and Jpnt and our
> Netware Server name is PROD. Does this mean that NWDBMGR is no longer
> usable for startup/shutdown?
>
> We recently upgraded from 7.2 and had been using the single task-task
> driver to startup our databases.
>
> Regards,
>
> Joe
>
> -------------------==== Posted via Deja News ====-----------------------
>       http://www.dejanews.com/     Search, Read, Post to Usenet