Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Loopback in TNSNAMES.ORA
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_at_tns_tcp_alias
or
connect internal/manager_at_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_at_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
Received on Mon Feb 02 1998 - 00:00:00 CST