Re: Openning/Shutting down Oracle database from the Client's SQL*Plus

Miori <cattorayye_at_yahoo.com> wrote in message news:<413ebeb7$0$559$e4fe514c_at_news.xs4all.nl>...
> 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

Of course. it is possible.

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

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

also you need set DB_SID in tnsnames.ora file on Client side. Received on Thu Sep 09 2004 - 06:01:36 CEST