Re: bouncing the database from the client's PL*SQL

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Thu, 09 Sep 2004 05:21:13 +1000
Message-Id: <413f5bb2$0$19871$afc38c87@news.optusnet.com.au>

Miori wrote:

> Dear all,
> Server machine running Oracle Database Server on Linux
> and a Client machine running Oracle Client on WIndows XP.
>
> HOw it is possible to shut down/start up the Oracle database
> on the server from SQL*Plus of the client. I know it can be done from
> SQL*Plus of the server but the point is that I want to do it from
> SQL*Plus of the Client.
> Many many thnx for any tips,
> Miori

Read the documentation on setting the parameter remote_login_passwordfile. And then also have a look at the syntax for SQL*Plus connections (clue: connect sys/password_at_SALES as sysdba is valid).

Regards
HJR Received on Wed Sep 08 2004 - 14:21:13 CDT