469,090 Members | 1,143 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

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

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
Jul 19 '05 #1
1 4106
Miori <ca********@yahoo.com> wrote in message news:<41*********************@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/****@DB_SID as sysdba
SQL> shutdown

also you need set DB_SID in tnsnames.ora file on Client side.
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Thierry B. | last post: by
1 post views Thread by Ruben Schoenefeld | last post: by
3 posts views Thread by Peter | last post: by
1 post views Thread by nkechifesie | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.