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

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Miori
    #1

    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
    Tags: None
    • Christine
      #2
      Re: Openning/Shutting down Oracle database from the Client's SQL*Plus

      Miori <cattorayye@yah oo.comwrote in message news:<413ebeb7$ 0$559$e4fe514c@ 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
      SQLconnect sys/****@DB_SID as sysdba
      SQLshutdown

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

        Comment

        Previous template Next
        Working...