473,396 Members | 2,061 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Oracle 9i Startup and Shutdown

Inbaraj
76
Hi,

I would like to know the EXE to startup and shutdown Oracle 9i database from command prompt (MS-DOS). I want to write 2 batch file one for startup the oracle9i and the other one is to stop the oracel 9i...

plz give me the solution for this query....

with reg
Inba
Dec 11 '07 #1
1 2794
amitpatel66
2,367 Expert 2GB
Hi,

I would like to know the EXE to startup and shutdown Oracle 9i database from command prompt (MS-DOS). I want to write 2 batch file one for startup the oracle9i and the other one is to stop the oracel 9i...

plz give me the solution for this query....

with reg
Inba
Create a Batch file:

Eg: start.bat:

Expand|Select|Wrap|Line Numbers
  1. sqlplus user/password@Server_Name
  2. STARTUP NOMOUNT
  3.  
Similarly for startup/shutdown refer here and here
Dec 11 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: KULJEET | last post by:
i face problem in oracle backup. i take oracle logical backup after 3-4 days. but now the database is run 24*7 days so i set the oracle on archive mode at last night i take the hot backup by...
4
by: susmita_ganguly | last post by:
Hi I am trying to upgrade from oracle 8i to oracle 9i on the same server ..I don't know much abt migration . Can anyone help me out. Thanks. Susmita
7
by: NTidd | last post by:
Since we have upgraded to oracle 9i every day or so we have to go in and shutdown oracle and restart it, here is what we do: sqlplus /nolog connect sys as sysdba password: connected to an idle...
0
by: DD | last post by:
Hi Guys! Just would like to share with you my experiense in this matter. I was trying to evaluate how suitable Oracle OLAP for our applications. As probably you did, I have downloaded from OTN...
0
by: ʹÃûÑï | last post by:
ORA-03114: not connected to ORACLE && MS's Bug?? DataBase:Oracle 817 using OracleClient,net framework 1.1 I'm using ADO.Net in C# with Oracle 817. and following is my public data access...
3
by: tbone | last post by:
In trying to improve the throughput of a classic ASP app I wrote a few years ago, I added monitoring to the application and session start and end methods. I'm counting the total number of sessions...
0
by: kyon | last post by:
Hi all, I have a problem: I had installed a oracle 8i to a microsoft server 2003. However, the database is not startup automatically if the machine is re-booted. I know the database can...
2
by: Vinod Sadanandan | last post by:
All, Below listed are the new features in Oracle 11g ,please join me in this discussion to generate a testcase and analyze each of the listed features . Precompilers:...
1
by: Vinod Sadanandan | last post by:
Cross Platform Migration An Unproblematic Approach (Windows-UNIX ) Oracle 10\11g The principal restriction on cross-platform transportable database is that the source and destination platform...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
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...
0
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...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.