Re: Stop/Start Oracle 7.3 on NT from remote NT machine

Check your tnsnames.ora file in your c:\ orant\network\administration directory. It must be present for your machine to find the oracle database. Your script has to tell it what instance (SID) to connect to. Your server and your remote machines must both have distinct tcp/ip addresses and the server's tcp/ip address needs to be defined in the listener.ora file in the orant\network\administration directory on the server. There are example files installed automatically in the before mentioned directories. Good luck.

Geoff Wild wrote:

> Hi!
>
> I'm trying to Stop/Start Oracle 7.3 on NT from a remote NT machine.
>
> What I do is:
>
> \\servername\e$\orant\bin\svrmgr23.exe @shutdown
>
> In the shutdown script I have:
>
> connect internal/oracle
> shutdown
> exit
>
> The script works when I execute it on the server, but not from the remote
> machine.
>
> I get an error message stating the "OracleService (SID) has not been
> started"
>
> I gather that this means I'm not running Oracle on the remote machine - That
> is, even though I executed svrmgr23.exe on the Oracle Server, it still looks
> to the machine I executed it from for Oracle.
>
> Is there a way around this?
> Is there a better way?
>
> This is part of a backup script using Arcserve.
>
> Thanks...Geoff
Received on Tue Dec 01 1998 - 21:40:25 CST