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

Miori <cattorayye (AT) yahoo (DOT) com> wrote

Of course. it is possible.

Log on to DB using SQL*Plus as sysdba
and Shutdown.

C:\> sqlplus /nolog
SQL> connect sys/****@DB_SID as sysdba
SQL> shutdown

also you need set DB_SID in tnsnames.ora file on Client side.