Home » Infrastructure » Windows » Start database on Windows (split from hijacked topic)
Start database on Windows (split from hijacked topic) [message #665588] Mon, 11 September 2017 15:47 Go to next message
Blackhat
Messages: 1
Registered: September 2017
Junior Member

Quote:
c:\TEMP>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Jan 21 15:05:57 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

c:\TEMP>

This will work only when the database is up. But before that how to start the database from cmd.
Re: Start database on Windows (split from hijacked topic) [message #665589 is a reply to message #665588] Tue, 12 September 2017 00:33 Go to previous messageGo to next message
John Watson
Messages: 7150
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

I've split your message off from the ancient topic you appended to. Using

sqlplus / as sysdba

will certainly work, as long as the Windows service is running. To start the service for an instance named ORCL,

net start oracleserviceORCL
Re: Start database on Windows (split from hijacked topic) [message #665590 is a reply to message #665589] Tue, 12 September 2017 00:41 Go to previous messageGo to next message
Michel Cadot
Messages: 65201
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

or
oradim -STARTUP -SID sid [-SYSPWD pass] [-STARTTYPE srvc|inst|srvc,inst] [-PFILE filename | -SPFILE]
Re: Start database on Windows (split from hijacked topic) [message #665606 is a reply to message #665588] Tue, 12 September 2017 06:34 Go to previous messageGo to next message
EdStevens
Messages: 849
Registered: September 2013
Senior Member
On Windows, you have to have the windows service (OracleServiceXXXX - where 'xxxx' is the name of your database) started to support the database instance. Starting and stopping the service will also start/stop the instance. But also, if the service is started, you can still connect with sqlplus as sysdba and issue 'startup' and 'shutdown' commands. When you issue the 'shutdown' the db instance will be shut down but the windows service will remain running.
Re: Start database on Windows (split from hijacked topic) [message #666034 is a reply to message #665588] Mon, 09 October 2017 13:40 Go to previous message
Barbara Boehmer
Messages: 8751
Registered: November 2002
Location: California, USA
Senior Member
On Windows, you can use the Windows "services" menu to start and stop services manually or set them to start automatically when the computer is started. You may find the "services" menu in different ways, depending on your Windows version. They used to have a "control panel" with sub-sections. There is now a "computer management" menu with a sub-menu of "services and applications" under which you should find the "services" menu. You should see a list of services. Scroll down to the ones that have names that start with "Oracle" and start them. You will need to start the Oracle...Listener before the OracleService....

Previous Topic: .bat file backup
Next Topic: oracle with asp.net error in vps
Goto Forum:
  


Current Time: Tue Nov 21 13:01:02 CST 2017

Total time taken to generate the page: 0.01722 seconds