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

Miori

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

Subscribe Post Reply

4292

Christine

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

by: Thierry B. | last post by:

Hi, Here is my query, ran from oracle sql*plus: SELECT mrbs_room.id, start_time, end_time, name, mrbs_entry.id, type FROM mrbs_entry, mrbs_room WHERE mrbs_entry.room_id = mrbs_room.id...

PHP

Oracle, PHP5, Apache2, oci_connect fails but sql*plus works

by: Ruben Schoenefeld | last post by:

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi - after I got sql*plus to work on my Linux box and I recompiled PHP 5 to include the oracle instant client, I run into a weird problem: I...

PHP

Strange behavious - inconsistencies between SQL in SQL*PLUS & SQL embedded in PL/SQL

by: Ethel Aardvark | last post by:

I have a query which runs fine in SQL*Plus but which will not compile into a packaged procedure (claiming that the table can not be found): SELECT DISTINCT Folder_ID INTO l_RootID -- remove...

Oracle Database

Passing a space as an argument to SQL*Plus

by: GP | last post by:

Consider the following: (extracted from a .bat) sqlplus toto/titi ^ @%pdl%\islqz033 ^ '1 ' ^ 'aaa' ^ ' ' ^ 'zzz' ^ ....

Oracle Database

SQL*Plus Parameters

by: Peter | last post by:

Has anyone seen this before? I start SQL*Plus, and login by typing sqlplus Quantum/Password@BPrd I type: select '&1' from dual; it responds

Oracle Database

Sql* Plus

by: nkechifesie | last post by:

Why cant I log on to Sql* plus using Sys and the password. It allows me to log on with System , then i tghen have to connect using Sys why?

Oracle Database

I am unable to login SQL plus 8.0 in Developer 2000

by: coolsub82 | last post by:

Hi Everybody! I have installed developer 2000 on my system. During installation, i choose complete as an option. During installation, there was no step to configure the user id and password. Now I...

Oracle Database

DB2 equivalent for ORACLE SQL*Plus BREAK???

by: DTV12345 | last post by:

Greetings! This is an excerpt from the Oracle documentation:"...ORACLE SQL*Plus BREAK command creates a subset of records and add space and/or summary lines after each subset. The column you...

DB2 Database

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

by: Miori | last post by:

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...

Oracle Database

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

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

Similar topics