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: 7065
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: 65169
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 message
EdStevens
Messages: 835
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.
Previous Topic: .bat file backup
Next Topic: oracle with asp.net error in vps
Goto Forum:
  


Current Time: Mon Sep 25 21:09:21 CDT 2017

Total time taken to generate the page: 0.02191 seconds