By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,740 Members | 790 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,740 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.